Postgres Pro
Downloads
Home   >   mailing lists

Thread: Maintenance PK bug

Maintenance PK bug

From
"Alexander Kirpa"
Date:
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
------------------------------

Best regards,Alexander Kirpa

Re: Maintenance PK bug

From
"Dave Page"
Date:

> -----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