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!<br/><br />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.<br /><br />To replicate: create a table, do not create the
primarykey yet. Give this table an id column, and a "parent_id" column. Now open a window to create a new foreign key
forthis 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
creatingthe 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.<br /><br />I think
thisis probably related to some data or state that was associated with the Foreign Key window being open before the
primarykey was ever added. Either a standard error should be shown to the user informing him that Add Foreign Key
cannotbe completed and needs to be closed and started over... or pgAdmin should be changed to make the Add FK window
operatein a stateless manner. But I am making assumptions here, I don't know for sure why the crash happens.<br /><br
/>Thanks!<br/>--Eric<br />