Re: DELETE permission problems on table with long name after upgrade to 7.3.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DELETE permission problems on table with long name after upgrade to 7.3.1
Дата
Msg-id 10651.1043387330@sss.pgh.pa.us
обсуждение исходный текст
Ответ на DELETE permission problems on table with long name after upgrade to 7.3.1  (Andreas Lange <anlan@ida.liu.se>)
Список pgsql-bugs
Andreas Lange <anlan@ida.liu.se> writes:
> After the upgrade the calls to the table didn't truncate the name any
> longer (as expected), and thus didn't find the table. So I renamed the
> table to it's full length name, and now the scripts did find the table
> again. But - deletes were no longer allowed! Selects are ok, and so are
> inserts and updates, but delete gives "permission denied".

I think this is probably pilot error --- are you sure you don't have a
table laying about with the truncated name?

The example you give does not work as-is (many references to tables not
included) and when I remove the undefined references, I see no failure.
So it doesn't persuade me that there's any bug.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #883: explain analyze causes postgres to die
Следующее
От: Tom Lane
Дата:
Сообщение: Re: