Re: [RDBO] PK columns and sequences in PG

2006-05-24 Thread John Siracusa
On 5/24/06, Ethan Rowe <[EMAIL PROTECTED]> wrote: # I added this sequence_names call. __PACKAGE__->meta->primary_key()->sequence_names([ 'orders_id_seq' ]); Just to clarify, with the fix, this line is no longer necessary at all and (still) does not appear in the generated Perl code. -John --

Re: [RDBO] PK columns and sequences in PG

2006-05-24 Thread John Siracusa
On 5/24/06, Ethan Rowe <[EMAIL PROTECTED]> wrote: For a class created by the loader, I found that I needed to go in and adjust the configuration by hand (this isn't a big deal as long as I know it's a necessary step). It shouldn't be necessary. The loader should detect and configure the sequenc

[RDBO] PK columns and sequences in PG

2006-05-24 Thread Ethan Rowe
Hi. If this question has been asked and answered in the past, I apologize in advance; my searches through the archives have been thus far unenlightening. I'm finding that for Postgres relations that artificial primary keys (but defined, for example, as "column_name INTEGER PRIMARY KEY DEFAULT NE