Bug report for 7.0beta1 in 'CREATE FUNCTION...'

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Bug report for 7.0beta1 in 'CREATE FUNCTION...'
Date: 2000-03-01 01:11:45
Message-ID: Pine.BSF.4.21.0002292110250.434-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Can someone look into this, and followup with Don? :)

====================
From: Don Baccus <dhogaza(at)pacifier(dot)com>

Slightly less minor bug. Forward this to the right place, too.

acs=# create function foo() returns integer as '
acs'# begin
acs'# create table bar(i integer);
acs'# return 1;
acs'# end;' language 'plpgsql';
CREATE
acs=# select foo();
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.
!#

DML statements apparently aren't meant to be supported in plpgsql,
since any I try crash. This, again, is PG7.0 beta.
=====================

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-03-01 01:14:01 minor bug in 7.0: casting
Previous Message Jan Wieck 2000-02-29 23:52:58 Re: [HACKERS] Re: NOT {NULL|DEFERRABLE} (was: bug in 7.0)