Skip site navigation (1) Skip section navigation (2)

Re: Basic DOMAIN Support

From: "Rod Taylor" <rbt(at)zort(dot)ca>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>,<pgsql-patches(at)postgresql(dot)org>
Subject: Re: Basic DOMAIN Support
Date: 2002-02-25 03:48:32
Message-ID: 013101c1bdaf$4cee32d0$8001a8c0@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
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

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(at)familyhealth(dot)com(dot)au>
To: "Rod Taylor" <rbt(at)zort(dot)ca>; <pgsql-patches(at)postgresql(dot)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
> regression test as well?  Also, shouldn't there be some modification
> pg_dump to all DOMAINs to be dumped?
> Chris
> > -----Original Message-----
> > From: pgsql-patches-owner(at)postgresql(dot)org
> > [mailto:pgsql-patches-owner(at)postgresql(dot)org]On Behalf Of Rod Taylor
> > Sent: Monday, 25 February 2002 7:35 AM
> > To: pgsql-patches(at)postgresql(dot)org
> > Subject: [PATCHES] Basic DOMAIN Support
> >
> >
> > I intend to add other parts of domain support later on (no reason
> > 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.

In response to


pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-02-25 03:51:55
Subject: Re: hashing improvements
Previous:From: Bruce MomjianDate: 2002-02-25 03:46:56
Subject: Re: Fix for non-blocking connections in libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group