js@xxxxxxxxx writes: > 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. Can you put together a self-contained test case? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
