segfault using pg_options_to_table(), v9.0.4 - Mailing list pgsql-bugs

From Frank van Vugt
Subject segfault using pg_options_to_table(), v9.0.4
Date
Msg-id 201109131448.55823.ftm.van.vugt@foxi.nl
Whole thread Raw
Responses Re: segfault using pg_options_to_table(), v9.0.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi,

Reading up on the release notes of v9.1 I noticed an 'add documentation for
pg_options_to_table()'. Since I didn't know of this function yet and the entry
implied that it would be there in earlier versions, I was tempted to try in
our current version:

postgres=# select version();
                                        version
---------------------------------------------------------------------------------------
 PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.3.3, 64-bit
(1 row)

the following:

postgres=# select pg_options_to_table('article');
ERROR:  array value must start with "{" or dimension information
LINE 1: select pg_options_to_table('article');
                                   ^

=> ok, so let's make it an array:

postgres=# select pg_options_to_table(ARRAY['article']);

=> which led to a segfault, from the logs:

--3262-2011-09-13 14:28:18 CESTLOG:  server process (PID 7427) was terminated
by signal 11: Segmentation fault
--3262-2011-09-13 14:28:18 CESTLOG:  terminating any other active server
processes


I know, should have read the docs first to see that it expects something else
as an argument, but still ;)





--
Best,




Frank.

pgsql-bugs by date:

Previous
From: Jerome Schulteis
Date:
Subject: Re: BUG #6201: Windows User Log Off Causes Backend Exception 0xC0000142
Next
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] Problem with the 9.1 one-click installer Windows7 64bit