Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Thomas LindenDate: 2000-11-01 22:56:46
Subject: RPM install weirdness & BugreportPage Bug
Previous:From: Dirk LutzebaeckDate: 2000-11-01 10:05:30
Subject: Re: ERROR: btree: index item size 3048 exceeds maximum 2717

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group