Horton

Re: History

Oliver Elphick <olly@lfix.co.uk>

View thread View on postgr.es
From: Oliver Elphick <olly@lfix.co.uk>
To: will trillich <will@serensoft.com>
Cc: pgsql-general@postgresql.org
Date: 2003-02-02T12:41:36Z
Lists: pgsql-general 
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.

junk=# select c.relname, d.* from delta as d, pg_class as c where
d.tableoid = c.oid;
 relname | id |  created
---------+----+------------
 delta   |  2 | 2002-05-18
 loc     |  1 | 2003-02-02
 loc     |  3 | 2003-02-02
(3 rows)

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Love not the world, neither the things that are in the
      world. If any man love the world, the love of the 
      Father is not in him...And the world passeth away, and
      the lust thereof; but he that doeth the will of God 
      abideth for ever."             I John 2:15,17