From: Rod Taylor <rbt@rbt.ca>
To: chester c young <chestercyoung@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Domains and Joins
Date: 08 Jun 2003 08:23:39 -0400
Message-ID: <1055075018.23997.43.camel@jester> (raw)
In-Reply-To: <20030605213807.40591.qmail@web12701.mail.yahoo.com>
References: <20030605213807.40591.qmail@web12701.mail.yahoo.com>
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.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rbt@rbt.ca, chestercyoung@yahoo.com
Subject: Re: Domains and Joins
In-Reply-To: <1055075018.23997.43.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox