[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Using Postgres sequences for the admin interface
patrick.bennett@ccgenesis.com writes:
> As the subject indicates, my database is PostgreSQL and
> I have some tables which have a primary key which should
> be gotten from a sequence. I have added the table to
> the "Tables" interface and used the Meta data to make
> a nice form for entering things into the table. The
> problem is that when I try to save the item, it isn't
> actually saved and my suspicion is that I'm not setting
> the primary key. I looked in the 'products' directory
> and there is a file called <tablename>.autonumber, which
> seems to be keeping track of the ID's.
>
> Is there any way to make IC use the sequence out of the
> database, or to keep them in sync? I could just drop
> the sequence in Postgres but my DBA may soundly thrash
> me for it.
Presumably,
Database <tablename> AUTO_SEQUENCE 1
will help here.
Ciao
Racke
--
Racke happily hacks Interchange and maintains Debian packages like Courier.
For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users