Sorry, I was wrong. It's a charachter(12) not a varchar and it's a domain. The isins in z_ul either start with 'DE000' or with 'CH003'. PG seems to compare only the first few charachters because when I set the reference to CASCADE all z_ul entries that start with 'DE000' are deleted. I tested it in another 8.3 database with the same effect but it works well with our old 8.2.6 db.
On 6 Mrz., 22:54, [EMAIL PROTECTED] (Tom Lane) wrote: > You mean a DOMAIN, or you mean a special datatype with custom C code? > If the latter, I'd suspect the C code. 8.3 has more stringent coding > rules for variable-length datatypes than prior releases did. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
