Mikheev, Vadim writes:
> > You cannot change data twice within a transaction if there's a RI
> > constraint on the table. This is per SQL, nothing we can do about it.
> ^^^
> Is it true?!
Actually, it's not. Jan Wieck first explained this on July 23 in "
> > create table t1
> > (
> > f1 integer,
> > f2 integer
> > );
> >
> > create table t2
> > (
> > f1 integer references t1(f1),
> > f2 integer
> > );
>
> > begin transaction;
> > insert into t1(f1,f2) values(1,1);
> > delete from t1 where f1=1;
>
> > ERROR: trig
Sergey Mavrinsky writes:
> create table t1
> (
> f1 integer,
> f2 integer
> );
>
> create table t2
> (
> f1 integer references t1(f1),
> f2 integer
> );
> begin transaction;
> insert into t1(f1,f2) values(1,1);
> delete from t1 where f1=1;
> ERROR: triggered da
Applied. Thanks.
>
> This is a stupid garden variety bug and I'm not sure why I didn't catch
> it previously. The patch included is against fairly current sources, but
> it may apply cleanly against 7.0.2 as well.
>
> On Fri, 6 Oct 2000, Vilson farias wrote:
>
> > I found a irregular behavio
This is a stupid garden variety bug and I'm not sure why I didn't catch
it previously. The patch included is against fairly current sources, but
it may apply cleanly against 7.0.2 as well.
On Fri, 6 Oct 2000, Vilson farias wrote:
> I found a irregular behavior with constraints.
>
> I can only
Pascale Thomas <[EMAIL PROTECTED]> writes:
> "select nom_soc from societe where event_ok[1]=1"
> The error message is : Unable to locate type name 'event_ok' in catalog
In 6.5.* this only works if you write out the fully qualified name:
select nom_soc from societe where societe.even
Hello,
My name : Pascale Thomas
My E-mail: [EMAIL PROTECTED]
Configuration : PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc
pgcc-2.91.66
I have problems with an array in a table.
The name of the table is "societe", the name of the array is "event_ok",
declared in m
