Re: pgAdmin III commit: Lots of work on domains, and check constraints

Поиск
Список
Период
Сортировка
От Timon
Тема Re: pgAdmin III commit: Lots of work on domains, and check constraints
Дата
Msg-id CAAeC-StXeevU4N05LRzULgJyLm55QbOfiuHhSv_D_pntbBePSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgAdmin III commit: Lots of work on domains, and check constraints  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: pgAdmin III commit: Lots of work on domains, and check constraints  (Timon <timosha@gmail.com>)
Список pgadmin-hackers
I tested this patch. It fixes my problem.
Also it fixes one annoying crash when you click on indexes list.
thanks for you work :)

2012/7/21 Guillaume Lelarge <guillaume@lelarge.info>:
> On Wed, 2012-06-06 at 10:50 +0600, Timon wrote:
>> seems that this commit broke reindexing of selected index. steps to reproduce:
>> 1) create table
>> 2) create index
>> 3) select index in object inspector
>> 4) try to reindex it via maintenance menu item
>> 5) got error : ERROR:  schema "table_name" does not exist
>>
>> and one more crash here
>> .. same steps as before
>> 4) try to CLUSTER index
>> 5) pgadmin simply crashed
>>
>
> OK, I finally got some time to work on this. As Timon said, these bugs
> come from the patch "Lots of work on domains, and check constraints". In
> this patch, I changed some objects parent class from pgTableObject to
> pgSchemaObject. Due to this change, the GetTable() method returns NULL,
> which segfaults all statements that try to use the return value without
> checking. The two examples above from Timon are exactly this.
>
> I don't see many ways to get out of this issue.
>
> We could use GetSchema() instead of GetTable(). It works, it's an easy
> and small patch. But it'll certainly be a maintenance nightmare (at
> least without any comments)
>
> We could also revert my patch. It's simple, we loose the feature of
> adding as many check constraints as we want to a domain, we loose the
> feature of renaming and validating constraints, and we gain a few bugs.
>
> I don't see any other options. My own personal choice would be the first
> one (see attached patch). But it's a tough call.
>
> Comments?
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com



--
All bugs reserved


В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Evan Smith
Дата:
Сообщение: new
Следующее
От: Timon
Дата:
Сообщение: Re: pgAdmin III commit: Lots of work on domains, and check constraints