Re: Problem with insert - 1.12.0 RC1

Le 02/09/2010 00:41, Erwin Brandstetter a écrit :
> On Aug 31, 7:19 pm, sid(dot)the(dot)technic(dot)(dot)(dot)(at)gmail(dot)com (Sid) wrote:
>> Hi,
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~
>> Local installation:
>> Windows 7 / Polish
>> PgAdmin III: V. 1.12.0 RC1
>> PostgreSQL: 8.4.4
>> ~~~~~~~~~~~~~~~~~~~~~~~
>>
>> Table should have some constraints (not null for instance) .
>> Open table to edit rows.
>> Put a value into any field and try to move from a row (now I assume that
>> field with constraint have some wrong value, null in this case).
>> In previous versions PgAdmin shows error message and returns to edit mode.
>> In 1.12 it stays in some weird state and all values are lost.
>>
>> I reported this bug on pgadmin-supp(dot)(dot)(dot)(at)postgresql(dot)org (on 1.12 beta4) but
>> there was no response.
>> Can anyone just confirm if it is a bug or I am doing something wrong.
>
> I can confirm the problem for v1.12RC1 and v1.12beta4. I found it just
> yesterday but did not have the time to report. All values of a row
> vanish after running into an error on save.
> The problem is not present in v1.10.5, where the you can keep editing
> the row.
> It is also noteworthy that it only happens with INSERTs. UPDATEs that
> run into an error are not affected.

You mean it feels like it added an empty line, right? if this is it, I
can reproduce it. Unfortunately, I didn't find any differences in the
source code between 1.10 and 1.12 that would have this behaviour. If you
confirm me this is the bug you've found, I'll take a deeper look at this.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com