Skip site navigation (1) Skip section navigation (2)

segfault using pg_options_to_table(), v9.0.4

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: segfault using pg_options_to_table(), v9.0.4
Date: 2011-09-13 12:48:55
Message-ID: (view raw or flat)
Lists: pgsql-bugs

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();
 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 

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




pgsql-bugs by date

Next:From: Merlin MoncureDate: 2011-09-13 14:03:45
Subject: Re: [GENERAL] Problem with the 9.1 one-click installer Windows7 64bit
Previous:From: Thomas KellererDate: 2011-09-13 06:44:54
Subject: Re: Problem with the 9.1 one-click installer Windows7 64bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group