Re: Violation of non existing reference

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: js(at)deriva(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Violation of non existing reference
Date: 2008-03-07 13:20:44
Message-ID: 11640.1204896044@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

js(at)deriva(dot)de 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-03-07 14:18:55 Re: shared_buffers and shmmax what are the max recommended values?
Previous Message Anton Melser 2008-03-07 10:26:14 shared_buffers and shmmax what are the max recommended values?