Re: DELETE permission problems on table with long name after upgrade to 7.3.1 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: DELETE permission problems on table with long name after upgrade to 7.3.1
Date
Msg-id 10651.1043387330@sss.pgh.pa.us
Whole thread Raw
In response to DELETE permission problems on table with long name after upgrade to 7.3.1  (Andreas Lange <anlan@ida.liu.se>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #883: explain analyze causes postgres to die
Next
From: Tom Lane
Date:
Subject: Re: