Re: serial types, pg_depend, permissions

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: serial types, pg_depend, permissions
Дата
Msg-id 4347FD78.9070900@pse-consulting.de
обсуждение исходный текст
Ответ на serial types, pg_depend, permissions  (Christopher St John <ckstjohn@gmail.com>)
Список pgadmin-support
Christopher St John wrote:
> i'm using pgadmin3 v1.2.2 on os x against a postgres 8.0.3 server to
> add a bigserial column to a table. i'm getting the error:
> 
>   ERROR: permission denied for relation pg_depend

Ok, you're missing write privileges on pg_depend; we didn't check that.
I added code to svn to support this, thanks for reporting.

Apparently, after the initial implementation of pgAdmin's add column 
code (for 7.3), adding serial and bigserial to existing tables has been 
implemented; formerly, this didn't work.
Dave, I only have 8.0+ servers running, can you check when ALTER TABLE 
xxx ADD COLUMN xxx serial was introduced, for 7.4 or 8.0?

In the meanwhile, dlgColumn.cpp:285 assumes pgsql>= 8.0.

Regards,
Andreas


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

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: serial types, pg_depend, permissions
Следующее
От: "Chris Saringolis"
Дата:
Сообщение: Backup / Restore not working