Subject: Re: Domains and Joins
From: Rod Taylor <rbt@rbt.ca>
To: chester c young <chestercyoung@yahoo.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20030605213807.40591.qmail@web12701.mail.yahoo.com>
References: <20030605213807.40591.qmail@web12701.mail.yahoo.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-Q+yrR2uCicFSi2/mvIFh"
Organization: 
Message-Id: <1055075018.23997.43.camel@jester>
Mime-Version: 1.0
Date: 08 Jun 2003 08:23:39 -0400

--=-Q+yrR2uCicFSi2/mvIFh
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Thu, 2003-06-05 at 17:38, chester c young wrote:
> -- standard setup:
> create table t1( c1 int primary key, data text );
> create domain dom_c1 int references t1 on delete cascade;

This won't work. Domains support NOT NULL, and CHECK constraints.

Foreign keys are not allowed on domains at this time in PostgreSQL or in
the SQL99 spec.

> create table t2( c2 int primary key, c1 dom_c1, moredata text );

> -- will not work with "using"
> create view v1 as select t1.*, t2.moredata
> from t1 join t2 using( c1 );

It appears to be a complaint about mis-matched datatypes, which is
partially true.  It's also a problem in 7.4.  I'll see what I can do to
fix it.

--=20
Rod Taylor <rbt@rbt.ca>

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

--=-Q+yrR2uCicFSi2/mvIFh
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA+4yrK6DETLow6vwwRAjKyAJ9dMn/XkQ2VhH/5DTpXOFuFB8w1EACdFYGt
v3arPdBeDLIpUUyXshqxf/M=
=XqHC
-----END PGP SIGNATURE-----

--=-Q+yrR2uCicFSi2/mvIFh--