At 04:05 AM 2/10/2003 +0100, Dirk Olmes wrote:
>>Just curious, were there any DbAdapter re-architecture involved, or was
>>it sufficient to implement the current API in PostgeSQL-friendly fashion?
>
>As Holger said: just implement a few hooks, that's all. Note that the
>adaptor uses (for now) the AUTO_PK_TABLE for PK generation, although
>PostgreSQL can do sequences. I've had a look at the OraclePkGenerator and
>it seems that the bulk of that code could be reused for the
>PostgresPkGenerator that uses Sequences.
>
>So I'd like to split the Oracle PK generator to an abstract
>SequencePkGenerator class that both OraclePkGenerator and
>PostgresPkGenerator can extend. I can come up with a proposal if we decide
>to go that way.
I am for it, lets discuss the details. Having a db-agnostic
SequencePkGenerator is a good start. I was thinking about moving in this
direction for some time, since mechanism for PK generation ideally should
take into account 2 things - database support for a particular feature and
user preference to use a particular mechanism.
Currently we are only taking the former into account (EOF way of thinking I
guess :-)). Eventually we must support the later too.
Andrus
This archive was generated by hypermail 2.0.0 : Sun Feb 09 2003 - 22:14:31 EST