Maintenance PK bug - Mailing list pgadmin-support

From Alexander Kirpa
Subject Maintenance PK bug
Date
Msg-id 44EF1698.29139.B112324@localhost
Whole thread Raw
Responses Re: Maintenance PK bug  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
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



pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Create database/password problem
Next
From: Vivek Khera
Date:
Subject: update using OID instead of PKEY?