On Fri, Aug 23, 2013 at 3:39 PM, Yong Zhang wrote:
> 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
>
If that is the name of the database, then it probably is because o
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 pg
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:
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
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
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 gen
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 eit
Hi
Is it possible to restore pg db with the same oids
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++ buil
