| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Getting OID in psql of recent insert |
| Date: | 1999-11-19 01:12:18 |
| Message-ID: | 199911190112.UAA20026@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
In writing the book, I see the serious limitation that there is no way
in psql to access the most recently inserted oid. Without it, there
seems to be no way to use the oid value as a foreign key in another
table.
Should I add a function to return the most recently assigned oid to the
backend, or is there a better way?
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 1999-11-19 01:14:56 | Hash Join is very slooow in some cases |
| Previous Message | Bruce Momjian | 1999-11-19 00:58:40 | Re: [HACKERS] psql & regress tests |