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

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of David Nash
> Sent: 09 March 2006 17:09
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Edit grid crashes adding new
> rows to table with autoincrement primary key.
>
> >> Are you editting the table as user postgres?
>
> Yes ... I am editing the table as the user postgres. I also
> created the table with that identity.
>
> >> Is the table you've shown one that you can recreate the
> error with, or a
> >> cut-down and untested version of the real table definition?
>
> The table definition that I included was the actual,
> unmodified version. Editing the table produced by this
> definition gives rise to the error. I have several other
> tables in the same database for which the error occurs or
> does not, according to whether or not they have primary keys
> with an autoincrement data type.

Hmm, OK. If you recreate that table in a scratch database do you then
get the same error when editting, or is the problem confined to the
original tables?

Another thing to try - please switch the log level to debug under File
-> Options, and capture the error in the most minimal test case possible
(to avoid generating a 40GB logfile!). I'd be a little surprised if I'm
honest, but there might just be a clue in it. It might also be worth
checking the server logs.

Regards, Dave.