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

Reply via email to