Thread: get_rels_with_domain() redone

get_rels_with_domain() redone

From
Rod Taylor
Date:
Tom,

I've been unable to time a difference here on a DB with 20 tables -- but
perhaps you will be able to on whatever box you ran the first one on.  I
didn't notice the initial version was slow -- but can certainly see how
it would be on a large db.

Scan of pg_depend for attributes using the domain.  Each resulting
attribute is double checked.


I'll work out the locking aspect shortly.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment