This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi There seem to be a problem between the case between the ORM entities and the Postgresql DB. Is there a version that caters for this problem or what is the best resolution under the current version . Thank you Hermanus Smalman |
|
|
Hi Hermanus, Could you please provide us with a little more information please? What is missing on case? Entity names not matching table names, something in a query etc? Is it a designer or core product issue? Thanks! John-Daniel Trask |
|
|
Hi John OK what happened was that we migrated from MySQL to PostgreSQL 8.4, the Migration wizard created the Tables with the field names in double quotes "RowID", by doing this Postgresql see the field as case sensitive and Lightspeed create entity fields as lower case according to the CLR standards, I manage to fixed this by removing the double quotes in the script, by doing this the table fields were created in lower case, so is working correct now. Regards Stiaan vd Westhuizen |
|
|
I have a new issue exactly as Thread http://www.mindscape.co.nz/forums/Thread.aspx?ThreadID=2558 I'm using a Postgresql 8.4 database. I use the LightSpeed designer to Update Database and create all of the tables ect.
When I try to insert into a Entity that has the Identity Method set to IdentityColumn I get a error back from Postgresql "ERROR: 23502: null value in column "protocoltypeid" violates not-null constraint"
Do I have to do any thing additional to Postgre to have it support Identity Colums for LightSpeed? Regards
Stiaan vd Westhiuzen
|
|
|
If the table was created using the designer, the designer does not currently set the identity / autoincrement flag. So you must set this manually using pgAdmin or your favourite PostgreSQL admin tool after the designer creates the table. |
|