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