Support for Amazon Redshift

Support for Amazon Redshift

Postby srivera » Tue 14 Jan 2014 21:17

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.
srivera
 
Posts: 3
Joined: Tue 14 Jan 2014 21:11

Re: Support for Amazon Redshift

Postby MariiaI » Wed 15 Jan 2014 14:00

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/?MappingKinds.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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Support for Amazon Redshift

Postby srivera » Wed 15 Jan 2014 15:02

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?
srivera
 
Posts: 3
Joined: Tue 14 Jan 2014 21:11

Re: Support for Amazon Redshift

Postby srivera » Wed 15 Jan 2014 15:03

Have you tested against a Redshift databse?
srivera
 
Posts: 3
Joined: Tue 14 Jan 2014 21:11

Re: Support for Amazon Redshift

Postby MariiaI » Fri 17 Jan 2014 06:08

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)