Thread: PGadmin 'erases' row I want to add to database...

PGadmin 'erases' row I want to add to database...

From
Mario Splivalo
Date:
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."




Re: PGadmin 'erases' row I want to add to database...

From
"Dave Page"
Date:

> -----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.


Re: PGadmin 'erases' row I want to add to database...

From
"Dave Page"
Date:

> -----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.