Support for GreenPlum
Posted: Fri 25 Jan 2013 22:28
I'm trying to use dotConnect for PostgreSQL to connect to EMC's GreenPlum implementation, which has some limitations.
For example it doesn't support the "RETURNING value" clause on an INSERT statement, which is commonly used to return the new primary key value on a automatically sequentially numbered record.
Calling the .AddObject method on an entity that has such a primary key defined gives me an error: "The RETURNING clause of the INSERT statement is not supported in this version of Greenplum Database."
Presumably dotConnect could generate SQL that didn't rely on the RETURNING clause to get .AddObjeect to work here.
For example it doesn't support the "RETURNING value" clause on an INSERT statement, which is commonly used to return the new primary key value on a automatically sequentially numbered record.
Calling the .AddObject method on an entity that has such a primary key defined gives me an error: "The RETURNING clause of the INSERT statement is not supported in this version of Greenplum Database."
Presumably dotConnect could generate SQL that didn't rely on the RETURNING clause to get .AddObjeect to work here.