Yes, and yes -- although I completely forgot about pg_dump which would
have been amusing to see the comments of someone moving a db with
domains ;)
Can I assume it'll be safe for pgdump to output the domains near the
top?
I'm going to implement Toms requests -- take a long nap -- and see
about regressions and pg_dump tomorrow.
I love having sequence lookups in a domain used across several tables.
That one feature (in my case for a 'global' transaction id) has made
the whole thing worth while. 50 some tables, one serial. Typing
nextval all the time in CREATE TABLE was getting annoying.
BTW, Toronto is full of nuts. The hockey game ended many hours ago
and they're still running up and down the streets cheering. It's also
getting annoying.
--
Rod Taylor
This message represents the official view of the voices in my head
----- Original Message -----
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Rod Taylor" <rbt@zort.ca>; <pgsql-patches@postgresql.org>
Sent: Sunday, February 24, 2002 10:32 PM
Subject: RE: [PATCHES] Basic DOMAIN Support
> Your tests look pretty good - maybe you should make them into a
proper
> regression test as well? Also, shouldn't there be some modification
to
> pg_dump to all DOMAINs to be dumped?
>
> Chris
>
>
> > -----Original Message-----
> > From: pgsql-patches-owner@postgresql.org
> > [mailto:pgsql-patches-owner@postgresql.org]On Behalf Of Rod Taylor
> > Sent: Monday, 25 February 2002 7:35 AM
> > To: pgsql-patches@postgresql.org
> > Subject: [PATCHES] Basic DOMAIN Support
> >
> >
> > I intend to add other parts of domain support later on (no reason
to
> > hold up committing this though) but would appreciate some feedback
> > about what I've done.
> >
> > What's there works, however I intend to finish it off with CHECK
> > and -- if I can figure out a good way -- REFERENCES.