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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
