Re: [GENERAL] Sequences in transaction context

2001-06-05 Thread Neil Conway
On Tue, Jun 05, 2001 at 10:33:08PM -0500, Erik Pearson wrote: > One last followup question -- what's MVCC? http://www.postgresql.org/idocs/index.php?mvcc.html Cheers, Neil ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] Sequences in transaction context

2001-06-05 Thread Stephan Szabo
On Tue, 5 Jun 2001, Erik Pearson wrote: > I searched through mailing list archives but was unable to find full > coverage of this question -- my apologies if this is a reposted question. > > As in the FAQ, I am trying to retrieve the value of a sequence value from a > newly inserted row. So, fi

Re: [GENERAL] Sequences in transaction context

2001-06-05 Thread Eric G. Miller
On Tue, Jun 05, 2001 at 09:22:43PM -0500, Erik Pearson wrote: > I searched through mailing list archives but was unable to find full > coverage of this question -- my apologies if this is a reposted question. > > As in the FAQ, I am trying to retrieve the value of a sequence value from a > newly

[GENERAL] Sequences in transaction context

2001-06-05 Thread Erik Pearson
I searched through mailing list archives but was unable to find full coverage of this question -- my apologies if this is a reposted question. As in the FAQ, I am trying to retrieve the value of a sequence value from a newly inserted row. So, first I call something like: insert into foobar