Re: Edit grid crashes adding new rows to table with autoincrement primary key.

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of David Nash
> Sent: 10 March 2006 14:02
> To: pgadmin-support(at)postgresql(dot)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