Permission denied for relation pg_shadow (Creating EDMX)

ephillipe · Post by **ephillipe** » Tue 11 Aug 2009 16:53

When I try create a ADO.NET Entity Data Model, after conect I give this error:

---------------------------
Microsoft Visual Studio
---------------------------
An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.EntityCommandExecutionException' occurred. The error message is: 'Erro ao executar a definição do comando. Consulte a exceção interna para obter mais detalhes.

The inner exception caught was of type 'Devart.Data.PostgreSql.PgSqlException', with this error message: 'permission denied for relation pg_shadow'.'.
---------------------------
OK
---------------------------

ephillipe · Post by **ephillipe** » Tue 11 Aug 2009 19:22

My database is in a shared server, this not in local server.

AndreyR · Post by **AndreyR** » Wed 12 Aug 2009 08:42

Thank you for the report, we will investigate the situation.
As a temporary workaround, I recommend you either to connect via superuser to have the permission
for this table, or to use Devart Entity Developer to generate Devart Entity model.
In this case the problem will not be arised.

ephillipe · Post by **ephillipe** » Fri 14 Aug 2009 13:01

AndreyR wrote:Thank you for the report, we will investigate the situation.
As a temporary workaround, I recommend you either to connect via superuser to have the permission
for this table, or to use Devart Entity Developer to generate Devart Entity model.
In this case the problem will not be arised.

Hello,
unfortunally, I cannot login with superuser because server is shared, in web host.

Devart Entity Developer generate standard EDMX files?

AndreyR · Post by **AndreyR** » Fri 14 Aug 2009 14:09

Devart Entity Developer generates a .edml file the structure of which is similar to that of a .edmx file.
There are also some code generation differences.
To try this you can add Devart Entity Model to your project, just like ADO.NET Entity Data Model.

ephillipe · Post by **ephillipe** » Fri 14 Aug 2009 16:40

AndreyR wrote:Devart Entity Developer generates a .edml file the structure of which is similar to that of a .edmx file.
There are also some code generation differences.
To try this you can add Devart Entity Model to your project, just like ADO.NET Entity Data Model.

Why "Generate from database" works on "Devart Entity Model" and do not work on Visual Studio? The error refer about denied access at view pg_shadow, but when generate from devart tool, everything works fine.

AndreyR · Post by **AndreyR** » Tue 18 Aug 2009 12:03

We have fixed this problem for Microsoft EDM Wizard. The fix will be included in the nearest build.

ephillipe · Post by **ephillipe** » Mon 24 Aug 2009 11:48

AndreyR wrote:We have fixed this problem for Microsoft EDM Wizard. The fix will be included in the nearest build.

Thanks, for it.
Do you known when this build will be released?

Shalex · Post by **Shalex** » Tue 25 Aug 2009 08:18

We plan to make a new build next week.

ephillipe · Post by **ephillipe** » Sat 29 Aug 2009 14:00

Shalex wrote:We plan to make a new build next week.

Thanks. I'm wainting.

ephillipe · Post by **ephillipe** » Fri 04 Sep 2009 02:37

Shalex wrote:We plan to make a new build next week.

The Build is too late.

Do you have a date for that?

ephillipe · Post by **ephillipe** » Fri 04 Sep 2009 14:32

ephillipe wrote:
Shalex wrote:We plan to make a new build next week.
The Build is too late.
Do you have a date for that?

The latest version is 4.55.42 (04-Sep-2009).

Thanks for new version

[/quote]

Shalex · Post by **Shalex** » Fri 04 Sep 2009 14:40

Welcome!