[BUGS] BUG #8393: ERROR: failed to locate grouping columns on grouping by varchar returned from function
The following bug has been logged on the website: Bug reference: 8393 Logged by: Evan Martin Email address: postgre...@realityexists.net PostgreSQL version: 9.2.4 Operating system: Windows 7 x64 SP1 Description: version(): PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit Run the following: CREATE OR REPLACE FUNCTION test_group_by() RETURNS TABLE (my_col varchar(5)) AS $BODY$ SELECT 'hello'::varchar(5); $BODY$ LANGUAGE sql STABLE; SELECT my_col FROM test_group_by() GROUP BY 1; Expected result: 'hello' Actual result: ERROR: failed to locate grouping columns Interestingly, if the function is marked VOLATILE it works. Casting the result to text also makes it work. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] PG_restore
Hi Is it possible to restore pg db with the same oids
[BUGS] BUG #8394: SQL command REINDEX doesn't work
The following bug has been logged on the website: Bug reference: 8394 Logged by: Yz Primus Email address: yzh...@trinityusa.com PostgreSQL version: 9.1.3 Operating system: Windows 7 64-bit Description: I always received error when trying to run SQL command REINDEX either from pgAdmin III or psql. If I ran REINDEX DATABASE it threw error: ERROR: syntax error at end of input LINE 1: REINDEX DATABASE If I ran REINDEX DATABASE mydb it threw error: ERROR: can only reindex the currently open database -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8395: empty aclitem arrays are considered 1-dimensional
The following bug has been logged on the website: Bug reference: 8395 Logged by: Alexey Bashtanov Email address: bashta...@imap.cc PostgreSQL version: 9.1.9 Operating system: Ubuntu linux 12.04 Description: Empty aclitem arrays are considered 1-dimensional, but in general empty arrays are 0-dimensional. It leads to the following problems: STEPS TO REPRODUCE 1) install fresh postgres, connect to it 2) select relacl, relacl = '{}'::aclitem[], (select aclexplode(relacl)), array_length(relacl, 1) from pg_class where oid::regclass = 'pg_largeobject'::regclass; 3) select aclexplode('{}'::aclitem[]); EXPECTED 2) {}, false, null, null 3) no error, zero-lines table GOT 2) relacl | ?column? | ?column? | array_length +--+--+-- {} | f| |0 3) ERROR: ACL arrays must be one-dimensional also it can be reproduced on some 9.2 version -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8394: SQL command REINDEX doesn't work
yzh...@trinityusa.com wrote on 23.08.2013 18:00: The following bug has been logged on the website: Bug reference: 8394 Logged by: Yz Primus Email address: yzh...@trinityusa.com PostgreSQL version: 9.1.3 Operating system: Windows 7 64-bit Description: I always received error when trying to run SQL command REINDEX either from pgAdmin III or psql. If I ran REINDEX DATABASE it threw error: ERROR: syntax error at end of input LINE 1: REINDEX DATABASE If I ran REINDEX DATABASE mydb it threw error: ERROR: can only reindex the currently open database Quote from the manual: Presently, REINDEX DATABASE and REINDEX SYSTEM can only reindex the current database, so their parameter must match the current database's name. So you need to specify the name of the current database even though it's not really needed. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8393: ERROR: failed to locate grouping columns on grouping by varchar returned from function
postgre...@realityexists.net writes: CREATE OR REPLACE FUNCTION test_group_by() RETURNS TABLE (my_col varchar(5)) AS $BODY$ SELECT 'hello'::varchar(5); $BODY$ LANGUAGE sql STABLE; SELECT my_col FROM test_group_by() GROUP BY 1; ERROR: failed to locate grouping columns Fixed in our git tree; thanks for the report! As a workaround in this particular case, you could just not bother with marking the specific length of the varchar constant. The function definition essentially ignores the length, storing only varchar as the result column type, and it's the discrepancy between that and the declaration of the constant that's tickling the bug. 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
Re: [BUGS] BUG #7652: Documentation index lacks functions from Additional Supplied Modules
On Sun, Nov 11, 2012 at 06:35:35PM +, andreas.hei...@web.de wrote: The following bug has been logged on the website: Bug reference: 7652 Logged by: Andreas H. Email address: andreas.hei...@web.de PostgreSQL version: 9.2.1 Operating system: any Description: It seems, that none of the functions in the section Additional Supplied Modules are listed in the index. I checked both the intagg module and the dblink module. To bad if you are looking the documentation of a function but don't know which module provides it (if any at all). FYI, this will be corrected in 9.3. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8394: SQL command REINDEX doesn't work
Thanks for the prompt response. But that's what I tried and it didn't work. I tried following command in both pgAdmin III and psql: REINDEX DATABASE PremierIEX Then I got error ERROR: can only reindex the currently open database PremierIEX is my current database. In pgAdmin III it threw extra info: SQL state: 0A000 Thanks, Yong -Original Message- From: Thomas Kellerer [mailto:spam_ea...@gmx.net] Sent: Friday, August 23, 2013 3:13 PM To: Yong Zhang Cc: Yong Zhang Subject: Re: BUG #8394: SQL command REINDEX doesn't work yzh...@trinityusa.com mailto:yzh...@trinityusa.com wrote on 23.08.2013 18:00: The following bug has been logged on the website: Bug reference: 8394 Logged by: Yz Primus Email address: yzh...@trinityusa.com mailto:yzh...@trinityusa.com PostgreSQL version: 9.1.3 Operating system: Windows 7 64-bit Description: I always received error when trying to run SQL command REINDEX either from pgAdmin III or psql. If I ran REINDEX DATABASE it threw error: ERROR: syntax error at end of input LINE 1: REINDEX DATABASE If I ran REINDEX DATABASE mydb it threw error: ERROR: can only reindex the currently open database Quote from the manual: Presently, REINDEX DATABASE and REINDEX SYSTEM can only reindex the current database, so their parameter must match the current database's name. So you need to specify the name of the current database even though it's not really needed.