> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Nash > Sent: 09 March 2006 17:09 > To: pgadmin-support@postgresql.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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
