Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 specific that needs to be
done so that columns using the new type can be used as
foreign keys? 
Thanks

CREATE TYPE X (
	INTERNALLENGTH = 16,
	INPUT          = X_in,
	OUTPUT         = X_out,
   RECEIVE        = X_recv,
   SEND           = X_send,
   alignment      = CHAR
);

CREATE OPERATOR CLASS X_ops
DEFAULT FOR TYPE uuid USING btree 
AS
        OPERATOR        1       < ,
        OPERATOR        2       <= ,
        OPERATOR        3       = ,
        OPERATOR        4       >= ,
        OPERATOR        5       > ,
        FUNCTION        1       X_cmp(X, X);



		
__________________________________ 
Discover Yahoo! 
Find restaurants, movies, travel and more fun for the weekend. Check it out! 
http://discover.yahoo.com/weekend.html 


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux