Hello, is it possible that GDL2 names a sequence as <tablename_seq>, while postgresl names a sequence as <tablename_fieldname_seq>?
Whith psql, I get psql (9.3.6) Type "help" for help. MultiDB=> \d List of relations Schema | Name | Type | Owner --------+----------------+----------+---------- public | persons | table | postgres public | persons_id_seq | sequence | postgres (2 rows) MultiDB=> When adding a record to the table persons, with a sequence defined on the field 'id' I got the following error: 2015-06-21 16:37:18.150 Crud2[10423:10423] clicked to add an item in channel 2015-06-21 16:37:18.151 Crud2[10423:10423] EAN -- PostgreSQLAdaptor.m -- createPGconn --localhost 5432 MultiDB edwin edwin 2015-06-21 16:37:18.233 Crud2[10423:10423] localhost 5432 MultiDB edwin edwin 2015-06-21 16:37:18.359 Crud2[10423:10423] File NSKeyValueCoding.m: 915. In -[NSObject(KeyValueCoding) valuesForKeys:] This method is deprecated, use -dictionaryWithValuesForKeys: 2015-06-21 16:37:18.360 Crud2[10423:10423] EAN -- PostgreSQLAdaptor.m -- createPGconn --localhost 5432 MultiDB edwin edwin 2015-06-21 16:37:18.462 Crud2[10423:10423] localhost 5432 MultiDB edwin edwin 2015-06-21 16:37:18.471 Crud2[10423:10423] <NSException: 0xa456ec8> NAME:PostgreSQLException REASON:SQL expression 'SELECT nextval('persons_SEQ')' caused ERROR: relation "persons_seq" does not exist LINE 1: SELECT nextval('persons_SEQ') ^ INFO:(null) (SQL expression 'SELECT nextval('persons_SEQ')' caused ERROR: relation "persons_seq" does not exist LINE 1: SELECT nextval('persons_SEQ') Is there a way to influence the naming of the sequence in GDL2? Kind regards, Edwin Ancaer
_______________________________________________ Discuss-gnustep mailing list Discuss-gnustep@gnu.org https://lists.gnu.org/mailman/listinfo/discuss-gnustep