Thread: PGadmin 'erases' row I want to add to database...
When I enter data to the database trough pgadmin, and I do a mistake (for instance, don't provide a value to NOT NULL column, break foreign key constraint or check constraint od primary key constraint), PgAdmin informs me of the mistake I made, and then 'cancels' the row I wanted to add. It would be realy nice just to show you an error, and then retain the row in the grid so one could easily just fix the mistake, and with hiting ENTER save the data to the database. Mike -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of > Mario Splivalo > Sent: 31 May 2006 11:07 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] PGadmin 'erases' row I want to add > to database... > > When I enter data to the database trough pgadmin, and I do a mistake > (for instance, don't provide a value to NOT NULL column, break foreign > key constraint or check constraint od primary key constraint), PgAdmin > informs me of the mistake I made, and then 'cancels' the row > I wanted to > add. > > It would be realy nice just to show you an error, and then retain the > row in the grid so one could easily just fix the mistake, and with > hiting ENTER save the data to the database. > > Mike Hi Mike, Yes, I agree. This is something I'm working on, however it's not as straight forward as you might think :-( Regards, Dave.
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Page > Sent: 31 May 2006 14:04 > To: mario.splivalo@mobart.hr; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] PGadmin 'erases' row I want to > add to database... > > > > It would be realy nice just to show you an error, and then > retain the > > row in the grid so one could easily just fix the mistake, and with > > hiting ENTER save the data to the database. > > > Yes, I agree. This is something I'm working on, however it's not as > straight forward as you might think :-( But it's amazing how much a couple of cups of coffee and a quick blast of the Red Hot Chilli Peppers can help :-) Patch committed to SVN implementing this change, and also preventing loss of updated data on refresh or window-close-when-the-save-fails(!). Regards, Dave.