Postgres Pro
Downloads
Home   >   mailing lists

BUG #8394: SQL command REINDEX doesn't work - Mailing list pgsql-bugs

From yzhang@trinityusa.com
Subject BUG #8394: SQL command REINDEX doesn't work
Date
Msg-id E1VCtmT-00086w-8g@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8394: SQL command REINDEX doesn't work
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      8394
Logged by:          Yz Primus
Email address:      yzhang@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

pgsql-bugs by date:

Previous
From: Valdas Dienas
Date:
Subject: PG_restore
Next
From: bashtanov@imap.cc
Date:
Subject: BUG #8395: empty aclitem arrays are considered 1-dimensional