Re: Maintenance PK bug

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Alexander Kirpa
> Sent: 25 August 2006 13:26
> To: pgadmin-support@postgresql.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