Re: Crash in a specific situation while adding constraints

Le 01/01/2011 19:30, Eric Ongerth a écrit :
> Hi, I think this is the first time pgAdmin III has actually crashed for me,
> so it has a very good record over several years!
>
> I'm running Windows 7 32-bit, and pgAdmin 1.12.0. This was an unusual
> situation, not very typical usage, but I suppose it still should not cause a
> crash.
>
> To replicate: create a table, do not create the primary key yet. Give this
> table an id column, and a "parent_id" column. Now open a window to create a
> new foreign key for this table. Leave that window open but do not complete
> it yet. Now open a window to create the primary key for the table, complete
> the primary key form and click OK to finish. Now go back to the remaining
> open window to finish creating the foreign key, which should be parent_id
> referencing id. The point is to make it a self-referential table. Anyway,
> when you complete the foreign key creation window and click OK on it,
> pgAdminIII crashes.
>

OK, I'm able to reproduce it in different ways. I have a strange cold
feeling this won't be easy to fix. Anyway, I'll work on this.

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