BUG #9085: Server segfault from psql

Started by Hardy Falkabout 12 years ago2 messagesbugs
Jump to latest
#1Hardy Falk
hardy.falk@blue-cable.de

The following bug has been logged on the website:

Bug reference: 9085
Logged by: Hardy Falk
Email address: hardy.falk@blue-cable.de
PostgreSQL version: 9.3.2
Operating system: Linux ubuntu 2.6.32-55-generic #117-Ubuntu SMP Tue
Description:

create table foo ( x int ) ;
CREATE TABLE
alasys=> create function zzz( v foo ) returns void as
alasys-> $$
alasys$> insert into foo(x) values (v.*)
alasys$> $$ language SQL ;
The connection to the server was lost. Attempting reset: Failed.

Server log:
LOG: server process (PID 4995) was terminated by signal 11: Segmentation
fault
DETAIL: Failed process was running: create function zzz( v foo ) returns
void as
$$
insert into foo(x) values (v.*)
$$ language SQL ;
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command. ( true :-) )

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Hardy Falk (#1)
Re: BUG #9085: Server segfault from psql

hardy.falk@blue-cable.de writes:

create table foo ( x int ) ;
CREATE TABLE
alasys=> create function zzz( v foo ) returns void as
alasys-> $$
alasys$> insert into foo(x) values (v.*)
alasys$> $$ language SQL ;
The connection to the server was lost. Attempting reset: Failed.

Hm, looks like sql_fn_post_column_ref() fails to allow for A_Star nodes.
Will fix, thanks for the report!

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs