Re: Backend crash in 8.2.3 with plpgsql function

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Backend crash in 8.2.3 with plpgsql function
Date: 2007-03-15 14:52:47
Message-ID: 45F95DBF.80007@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:
> SM <sm(at)resistor(dot)net> writes:
>> I got a backend crash in Postgresql 8.2.3 with the plpgsql function.
>> The following statement in psql causes a signal 11:
>> psql=# create function testpl() returns void as 'begin return;
>> end;'language 'plpgsql';
>
> Worksforme ...

For me too.

$ psql
Welcome to psql 8.2.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

kalman=# create function testpl() returns void as 'begin return; end;'language 'plpgsql';
CREATE FUNCTION
kalman=# select version();
version
- --------------------------------------------------------------------------------------------------------
PostgreSQL 8.2.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-51)
(1 row)

Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF+V2/7UpzwH2SGd4RAk29AJ44FZFMnsFHJV+uOcQZpuD0cGN/YACgjxjY
4lVP/g+/PLs2+RfOFtpBJtE=
=/Vae
-----END PGP SIGNATURE-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Reece Hart 2007-03-15 16:03:40 Re: Backend crash in 8.2.3 with plpgsql function
Previous Message Alvaro Herrera 2007-03-15 14:40:35 Re: Backend crash in 8.2.3 with plpgsql function

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-03-15 14:55:11 Re: CLUSTER and MVCC
Previous Message Gaetano Mendola 2007-03-15 14:47:20 Re: UPDATE using sub selects