Re: Maintenance PK bug

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of 
> Alexander Kirpa
> Sent: 25 August 2006 13:26
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Maintenance PK bug
> 
> In pgAdmin V 1.4.3(Jul 19 2006)
> 
> 1. Select DB Server
> 2. Select DB:your_DB_with_PK_in_any_table
> 3. Select Schemas:public
> 4. Select Tables:table_with_PK
> 5. Select Constraints:some_pk
> 6. Highlight 'some_pk'
> 7. Press right button on mouse during select 'some_pk'
> 8. Press 'Maintenance'
> 9. Select REINDEX and press 'OK'
> and receive 'ERROR:  syntax error at or near "PRIMARY" at character 9'
> or see serverlog
> ----------------------
> ERROR:  syntax error at or near "PRIMARY" at character 9
> STATEMENT:  REINDEX PRIMARY KEY some_pk
> ------------------------------

Thanks for the report - this has been fixed in SVN for version 1.6.

Regards, Dave