| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "rob" <rob(at)cabrion(dot)com> |
| Cc: | "Florent Guillaume" <efgeor(at)noos(dot)fr>, "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: Re: is PG able to handle a >500 GB Database? |
| Date: | 2001-01-20 16:22:01 |
| Message-ID: | 1555.980007721@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"rob" <rob(at)cabrion(dot)com> writes:
> currval returns error unless nextval has been called at least once in the
> session.
> I use <seq>.last_value
> Perhaps I'm fooling myself
Yes, you are, unless you never have more than one client attached to
your database. last_value will return whatever value was last assigned
by any backend, therefore you might not get the value that was inserted
into your tuple, but someone else's.
The point about currval being initially undefined seems moot if what
you're using it for is to recover the serial number that was assigned to
a tuple you just inserted ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-20 16:24:15 | Re: pg_sendmail function compile problem |
| Previous Message | Richard Seymour | 2001-01-20 16:17:06 | Re: couple of general questions |