| From: | <kaiq(at)realtyideas(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Stan Jacobs <jacobs(at)jtek(dot)com>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Simple problem? |
| Date: | 2000-03-02 17:21:07 |
| Message-ID: | Pine.LNX.4.10.10003021109310.11416-100000@picasso.realtyideas.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2 Mar 2000, Peter Eisentraut wrote:
> On Wed, 1 Mar 2000, Stan Jacobs wrote:
>
> > 2. How do I get the order_id from the record I just wrote?
>
> You have to select it back out. A select on max(order_id) might do, but
> you might get caught if someone else does updates on your table as well. I
> am personally not so fond of serial columns because of this problem.
what? if you serial type, you can get it by curval(seqname) (see doc for
details). Peter, how can You make such a mistake :-) no sleep for a week?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Wolfe | 2000-03-02 18:18:01 | Re: [GENERAL] Re: "LockRelease: locktable lookup failed, no lock" |
| Previous Message | Ross J. Reedstrom | 2000-03-02 17:09:15 | Re: [GENERAL] Simple problem? |