| From: | Alan Gutierrez <ajglist(at)izzy(dot)net> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, will trillich <will(at)serensoft(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: History |
| Date: | 2003-02-03 01:09:18 |
| Message-ID: | 200302021909.18300.ajglist@izzy.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday 02 February 2003 06:41, Oliver Elphick wrote:
> On Sun, 2003-02-02 at 05:07, will trillich wrote:
> > but -- is there some way to tell which offspring table the delta
> > record came from? now THAT would be useful.
There is no good way.
> junk=# select c.relname, d.* from delta as d, pg_class as c where
> d.tableoid = c.oid;
See what I mean?
> relname | id | created
> ---------+----+------------
> delta | 2 | 2002-05-18
> loc | 1 | 2003-02-02
> loc | 3 | 2003-02-02
> (3 rows)
--
Alan Gutierrez - ajglist(at)izzy(dot)net
http://khtml-win32.sourceforge.net/ - KHTML on Windows
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2003-02-03 02:18:11 | DBI driver and transactions |
| Previous Message | Alan Gutierrez | 2003-02-03 01:07:42 | Re: History |