discuss-gnustep
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[GDL2] Postgres95 adaptor, primaryKeySequenceNameFormat


From: Dirk Lattermann
Subject: [GDL2] Postgres95 adaptor, primaryKeySequenceNameFormat
Date: Wed, 09 Feb 2005 21:13:48 +0100

Hello,

since around v7.2, PostgreSQL supports the serial data type using
implicit sequences which have a better integration with tables than
the older way of doing things with an explicit sequence and a nextval
default of the table column.

The sequence implicitly created by PostgreSQL has a name like
table_col_seq
where table is the table name and col is the column name (seq is
literal).

I think it would be great if the Postgres Adaptor supported this
somehow via the primaryKeySequenceNameFormat entry in the connection
dictionary. Right now, this it replaces %@ with the table name via
simple call to stringWithFormat.

Has someone an idea how this mechanism can nicely be augmented to also
add the column name (I guess it needs to be backward compatible)?
Parsing the sequence name string in the dictionary for tokens like %T,
%C and %% come to mind, for instance, but maybe there are other
solutions?

Greetings, Dirk





reply via email to

[Prev in Thread] Current Thread [Next in Thread]