At 21:13 21-9-00 -0700, Stephan Szabo wrote:
>This is a one line patch that will throw a notice with
>what relation name it's trying to open and what it
>got back in RI_FKey_keyequal_upd. It should say
>the name of your table and a number, but I expect
>the number will be 0.
Yes, it is. So I als
Hi,
I encountered the following problem:
./configure --enable-debug --prefix=/opt/postgres
Edit config.h: BLCKSZ 32768
postgres=# select version();
version
---
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compi
At 10:18 21-9-00 -0700, Stephan Szabo wrote:
>Odd, it looks like it had trouble doing the heap_openr
>on the relation, although I don't immediately see why...
>
>What does
> select * from pg_trigger where
> tgconstrname='fk_folders__parent'
>give you?
First it didn't give me anything (0 rows).
Hi,
Following my bug report yesterday about a bug in RI, I'll first show a
reproducible example:
create table t1 ( a int4 primary key, b varchar(5) );
create table t2 ( b varchar(5) primary key );
alter table t1 add constraint fk_t1__b foreign key (b) references t2 (b);
insert into t2 values (
At 10:58 22-9-00 -0400, Tom Lane wrote:
>This oversight (lack of check for heap_open failure) was already fixed
>in another way for 7.1 --- heap_open itself always checks now.
Cool, I'll wait eagerly for 7.1 ;-)
Jeroen
At 22:27 9/29/00 -0400, you wrote:
>Jeroen, not sure if you were involved in this, but standard deviation is
>in the current development tree, and will be released in 7.1 in a few
>months.
Yes, I noticed. And I'm happy to see it has been implemented without my
help, as I'm desperately running ou
