Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

crash while adding primary key


  • From: Eric Haszlakiewicz <erh(at)nimenees(dot)com>
  • To: pgadmin-support(at)postgresql(dot)org
  • Subject: crash while adding primary key
  • Date: Mon, 01 Oct 2007 03:43:33 -0600
  • Message-id: <4700C145.4020504@nimenees.com> <text/plain>

I just tried to add a primary key to a table and pgadmin crashed. I am using:

pgadmin 1.8.0 beta 5, binary distribution downloaded today, english.
Running on Windows XP Home
Postgres 8.2.4 on the server.

I get the same problem whether I am adjusting an existing table, or creating a new one.

- view the properties for a table (or create a new table)
- click on the "Constraints" tab
- click the "Add" button ("Primary key" is selected in the dropdown)
- type a name for the constraint (optional, doesn't seem to make a difference) (tablespace is pg_default)
- click on the "Columns" tab.
- select a column
- click "Add"
- click "Ok"  <--- crashes here.

I ended up running a "alter table" sql statement to add the primary key.

eric



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group