> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Nash > Sent: 10 March 2006 14:02 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Edit grid crashes adding new > rows to table with autoincrement primary key. > > >> Interesting. Out of interest (if you still have it), what > does pg_dump > >> think the schema looks like? It sounds like pgAdmin is > misreading the > >> schema somehow, causing the crash - most likely when it > tries to detect > >> the primary key. One thought - in the edit grid, did the > int8 column > >> have [PK] in the column header? > > In fact, the edit grid does show [PK] in the column header -- > it reads: > > heritages_id > [PK] int8 > > ... and here's the output from pg_dump -s -t Heritages :
Seems it gets that right then - it would also be interesting to see what query pgAdmin used to do the update if you still have the log around. Thanks, Dave ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
