Обсуждение: problem setting security on sequence when serial type used

Поиск
Список
Период
Сортировка

problem setting security on sequence when serial type used

От
teknokrat
Дата:
If I create a new table and define a serial type in it, the 
corresponding sequence lacks the security that was defined for the 
table. This of course leads to security errors when you try to access 
the sequence.

Not sure if this is a bug or not, but it would be helpful if the 
sequence was created with the same security permissions as the table.

thanks


Re: problem setting security on sequence when serial

От
Andreas Pflug
Дата:
teknokrat wrote:
> If I create a new table and define a serial type in it, the 
> corresponding sequence lacks the security that was defined for the 
> table. This of course leads to security errors when you try to access 
> the sequence.

This is a backend issue (serial is handled implicitely), maybe you 
should discuss that on pgsql-sql or so.

Regards,
Andreas