[EMAIL PROTECTED] 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to