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

Browse pgsql-bugs by date

  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