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

2005-06-10 Thread H Hale
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 <[EMAIL PROTECTED]> wrote: > H Hale <[EMAIL PROTECTED]> writes: > > I have created a new data type using CREATE TYPE. > > Foreign keys const

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

2005-06-10 Thread Tom Lane
H Hale <[EMAIL PROTECTED]> 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

[GENERAL] foreign key constraint not being respected with type created by CREATE TYPE

2005-06-10 Thread H Hale
Hello, I have created a new data type using CREATE TYPE. Foreign keys constaints are not being respected with columns using the new type. As far as I can tell the new type is working correctly except for foreign keys. May be I have missed something when defining the new type. Is there something sp