Devart Forums

Amazon has introduced redshift which is based on Postgres 8.0.2.

I've tried to generate a model from the database but I can't. I get the tables but no attributes. I also get an error

'function pg_has_role(integer, character varying) does not exist'

Client = .NET 4.5 using latest trial version of linqConnect to postgres.

I get the tables but no attributes.

Please specify the template you are working with ( expand the Templates node in Model Explorer - there should be at least one template, e.g. 'LinqConnect' or 'POCO Entities'). Also, please open the Model Settings by double-clicking on the diagram and check that the Mapping Mode is set to Attributes.

For more information please refer to http://www.devart.com/linqconnect/docs/ ... Kinds.html and in the Entity Developer documentation: ORM Support-> LinqConnect->Concepts-> Model Generation Templates.

I also get an error 'function pg_has_role(integer, character varying) does not exist'

We have fixed this issue. The fix will be included in the next public build of LinqConnect. We will inform you when it is available for download.

I'm using LinqConnect. I did "Add" -> "Class" -> "LynqConnect Model". Also the .edps config file indicates the template is "LinqConnect".

I' believe that the model is failing to generate due to the other issue. Recall that the model generation process also gives me 2 errors. 1 - "pg_has_role" does not exist and 2 - "you must be superuser to examine max_index_keys".

Is there a beta copy of the fix that I can try?

Have you tested against a Redshift databse?

New build of LinqConnect 4.4.418 is available for download now!
It can be downloaded from http://www.devart.com/linqconnect/download.html (trial version) or from Registered Users' Area (for users with active subscription only)
For more information, please refer to http://forums.devart.com/viewtopic.php?f=31&t=28731.

Please try it and tell us whether the issues still persist or not.