Re: [libdbi-users] Finding inserted rows

2006-06-02 Thread Mike Rylander
On 6/1/06, Toby Thain <[EMAIL PROTECTED]> wrote: > > OT from the original post, but pertinent to the discussion... > > > > On 5/27/06, Markus Hoenicka <[EMAIL PROTECTED]> wrote: > > > Martin Kutschker writes: > > > > Have the systems which use sequences some nameing schemes, > > which build the

Re: [libdbi-users] Finding inserted rows

2006-06-01 Thread Toby Thain
> OT from the original post, but pertinent to the discussion... > > On 5/27/06, Markus Hoenicka <[EMAIL PROTECTED]> wrote: > > Martin Kutschker writes: > > > Have the systems which use sequences some nameing schemes, > which build the sequence > name from the table name? > > > > > > > SQL

Re: [libdbi-users] Finding inserted rows

2006-05-29 Thread Christian M. Stamgren
Hi, Have you looked at the sequence API included in libdbi? unsigned long long dbi_conn_sequence_next(dbi_conn Conn, const char *name); and unsigned long long dbi_conn_sequence_last(dbi_conn Conn, const char *name); Regards, Christian On Friday 26 May 2006 19:33, Andrew Sidwell wrote: > Hi

Re: [libdbi-users] Finding inserted rows

2006-05-28 Thread Martin Kutschker
"Markus Hoenicka" <[EMAIL PROTECTED]> writes on Sat, 27 May 2006 22:46:22 +0200 (METDST): > Martin Kutschker writes: > > Have the systems which use sequences some nameing schemes, which > > build the sequence name from the table name? > > > > SQLite and MySQL don't use sequences, so I can speak

Re: [libdbi-users] Finding inserted rows

2006-05-27 Thread Mike Rylander
OT from the original post, but pertinent to the discussion... On 5/27/06, Markus Hoenicka <[EMAIL PROTECTED]> wrote: Martin Kutschker writes: > Have the systems which use sequences some nameing schemes, which build the sequence name from the table name? > SQLite and MySQL don't use sequences

Re: [libdbi-users] Finding inserted rows

2006-05-27 Thread Markus Hoenicka
Martin Kutschker writes: > Have the systems which use sequences some nameing schemes, which build the > sequence name from the table name? > SQLite and MySQL don't use sequences, so I can speak only of PostgreSQL (don't know about Oracle, Sybase et al.). If you use the Serial type in PostgreS