From: | "Vasileiadis Spyros" <ace(at)northlink(dot)gr> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | |
Date: | 2000-11-01 11:38:54 |
Message-ID: | 048f01c043f8$509953b0$64898cd5@northlink.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I use postgres v.7.0 and I access through libzeos v.1.4.4
while testing an application I got the message
pq_recvbuf: unexpected EOF on client connection
there are two tables involved:
create table thtm (
htmid serial primary key,
htmname varchar(256) not null,
next int4 not null);
create table lekt (
lek_id int4 not null references thtm(htmid) on update cascade on delete
cascade,
lek_num int4 not null,
lek varchar(256),
primary key (lek_id,lek_num));
and one function:
create function "nextid"(int4) returns int4 as'
lock table thtm in share row exclusive mode;
update thtm set next=next+1 where htmid = $1;
select next-1 as result from thtm where htmid = $1;
' language 'SQL';
the application perfomrs a huge number of insert's like this:
insert into lekt (1000,nextid(100),"something");
I wonder if this is a known problem and an upgrade to v.7.0.2 would solve
the problem or if this is really an unknown bug
thanks in advance
SV
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Linden | 2000-11-01 22:56:46 | RPM install weirdness & BugreportPage Bug |
Previous Message | Dirk Lutzebaeck | 2000-11-01 10:05:30 | Re: ERROR: btree: index item size 3048 exceeds maximum 2717 |