8.0.0beta2 and plpgsql

From: "Stefano Bonnin" <stefano(dot)bonnin(at)comai(dot)to>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: 8.0.0beta2 and plpgsql
Date: 2004-09-16 15:05:09
Message-ID: 031f01c49bfe$8eef9180$0501a8c0@comai04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a problem with plpgsql and postgres8.0.0beta2

When I execute an insert on "mytable" the psql client returns me the following:

****
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed
***

on the server side (logfile)

2004-09-16 16:57:51 CEST postgres crs LOG: statement: INSERT INTO "SNS_DATA"
("Cod_Par","Cod_Ana","Valore","Descriz","Un_Mis","Cod_Luogo", "Data_Arrivo_Campione",site_id,hash) VALUES ('24359','2004-09-11 03:00:0057',19.8,'Temperatura media []','°C','57',timestamp '2004-09-11 03:00:00',1,-574156802);

2004-09-16 16:57:51 CEST LOG: server process (PID 794) was terminated by signal 11
2004-09-16 16:57:51 CEST LOG: terminating any other active server processes
2004-09-16 16:57:51 CEST LOG: all server processes terminated; reinitializing
2004-09-16 16:57:51 CEST LOG: database system was interrupted at 2004-09-16 16:57:46 CEST
2004-09-16 16:57:51 CEST LOG: checkpoint record is at 0/895B80C4
2004-09-16 16:57:51 CEST LOG: redo record is at 0/895B80C4; undo record is at 0/0; shutdown TRUE
2004-09-16 16:57:51 CEST LOG: next transaction ID: 12802; next OID: 11837631
2004-09-16 16:57:51 CEST LOG: database system was not properly shut down; automatic recovery in progress
2004-09-16 16:57:51 CEST LOG: record with zero length at 0/895B8100
2004-09-16 16:57:51 CEST LOG: redo is not required
2004-09-16 16:57:52 CEST LOG: database system is ready

that is a segfault error.
The error is generated by a plpgsql function that it was correct on the 7.4.2 engine.
Are there any changes in the plpgsql environment of the 8.0.0beta version?
The *terrible* problem is that postgres doesn't give me any line reference of the error.
Obviously, if I drop the plpgsql function the isert goes right.

Could be a bug?
Thanks in advance.

Reds.

PS. If this is not the right place where to post this problem please give me a more appropriated list.

Browse pgsql-general by date

  From Date Subject
Next Message ruben 2004-09-16 15:26:26 Re: Postgres memory usage
Previous Message Dennis Gearon 2004-09-16 14:57:10 Not even JPEGs are safe?