Hi,
I encountered an odd behaviour when I tried to delete a record.
I have two tables "z_base" and "z_ul". z_base's primary key is "isin"
which is referenced by z_ul.
select count(*) from z_base where isin = 'DE000DB3BTR9';
count
---
1
select count(*) from z_ul where isin = 'DE000DB3BT
It's Version 8.3.
Both columns are of a user defined datatype which is a varchar(12)
with a special check.
I already did a REINDEX but it didn't help.
On 6 Mrz., 18:27, [EMAIL PROTECTED] (Tom Lane) wrote:
> What PG version is this? Are the two columns of identical datatypes?
> (I'm wondering abo
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
Hi,
I am not sure about the right place to post this question so I'm
trying here first:
We are using Postgres in our company successfully since 2001 but now
we arrived at the conclusion that we really need "Materialized Views"
for our further business. Also we decided that we should try to pay
so
