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

Bug #701: pqReadData() -- backend closed the channel unexpectedly.

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #701: pqReadData() -- backend closed the channel unexpectedly.
Date: 2002-06-29 11:23:42
Message-ID: 20020629112342.CCB7C475FB3@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Amit Mishra (amit(dot)mishra(at)myrealbox(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pqReadData() -- backend closed the channel unexpectedly.

Long Description
i have to fire a trigger whenever insertion is done on a table users
that calls the postgres function which inturn calls a c function .
wheever i am doing the insertion in the table it gives the followng error & terminates the backend:

pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

i cannot find the solution to this problem .please help.

Sample Code
the c file that contains function is as follows:

#include <stdio.h>
#include "pgsql/postgres.h"
void users();

int main()
{
users();
}

void users()
{
        FILE *fp;
        fp = fopen("/home/suresh/trigger/test.txt","w");
        fputs("Hello this is c function",fp);
}


the postgres function that calls the c function is as follows:

create FUNCTION users() returns opaque as '/var/lib/pgsql/test.so' language 'C';

the trigger that calls the postgres function is as follows:

CREATE TRIGGER users_trg before insert on users for each row execute procedure users();




No file was uploaded with this report




Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2002-06-29 21:21:02
Subject: Re: Bug #701: pqReadData() -- backend closed the channel
Previous:From: pgsql-bugsDate: 2002-06-29 11:22:39
Subject: Bug #700: pqReadData() -- backend closed the channel unexpectedly.

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