Re: foreign key constraint not being respected with type created by CREATE TYPE

From: H Hale <hhale21(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: foreign key constraint not being respected with type created by CREATE TYPE
Date: 2005-06-10 19:59:26
Message-ID: 20050610195926.9343.qmail@web52303.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It is likely if the foreign key was in a base table.
:)

Fairly new with PG and missed this minor but
significant detail (keys not inherited)

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> H Hale <hhale21(at)yahoo(dot)com> writes:
> > I have created a new data type using CREATE TYPE.
> > Foreign keys constaints are not being respected
> with
> > columns using the new type.
>
> That hardly seems likely. I'd look for bugs in your
> comparison
> functions ;-)
>
> regards, tom lane
>


__________________________________
Discover Yahoo!
Use Yahoo! to plan a weekend, have fun online and more. Check it out!
http://discover.yahoo.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Parker 2005-06-10 20:08:25 Re: index xyz is not a btree
Previous Message Ian Harding 2005-06-10 19:57:41 PostgreSQL Certification