Page 1 of 1
Permission denied for relation pg_shadow (Creating EDMX)
Posted: Tue 11 Aug 2009 16:53
by ephillipe
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
---------------------------
Posted: Tue 11 Aug 2009 19:22
by ephillipe
My database is in a shared server, this not in local server.
Posted: Wed 12 Aug 2009 08:42
by AndreyR
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.
Posted: Fri 14 Aug 2009 13:01
by ephillipe
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?
Posted: Fri 14 Aug 2009 14:09
by AndreyR
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.
Posted: Fri 14 Aug 2009 16:40
by ephillipe
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.
Posted: Tue 18 Aug 2009 12:03
by AndreyR
We have fixed this problem for Microsoft EDM Wizard. The fix will be included in the nearest build.
Posted: Mon 24 Aug 2009 11:48
by ephillipe
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?
Posted: Tue 25 Aug 2009 08:18
by Shalex
We plan to make a new build next week.
Posted: Sat 29 Aug 2009 14:00
by ephillipe
Shalex wrote:We plan to make a new build next week.
Thanks. I'm wainting.
Posted: Fri 04 Sep 2009 02:37
by ephillipe
Shalex wrote:We plan to make a new build next week.
The Build is too late.
Do you have a date for that?
Posted: Fri 04 Sep 2009 14:32
by ephillipe
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]
Posted: Fri 04 Sep 2009 14:40
by Shalex
Welcome!