Re: [pgadmin-hackers] Re: 答复: [pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: [pgadmin-hackers] Re: 答复: [pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence
Дата
Msg-id CAECtzeVEtyqaJLy=F9HxVfj2-AxKU8vzUynxFMC2ahTSdbtw4A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 答复: [pgadmin-hackers] pgAdmin III commit: Fix SQL for GRANT on a sequence  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
2014-07-15 9:21 GMT+02:00 Dave Page <dpage@pgadmin.org>:



On Tue, Jul 15, 2014 at 2:45 AM, liuyuanyuan <liuyuanyuangogo@gmail.com> wrote:

Thanks for your attention to this topic!

In fact, none pgadmin can be compatible with all  versions of the database.


We've done pretty well so far, supporting right back to 7.3, through we don't officially support the much older versions now, but that's mostly due to the amount of testing it requires.
 

Although earlier versions of PG don't support GRANT ON SEQUENCE,

but new versions support. So I think this adjustment is necessary .


Old versions supported GRANT ON TABLE for sequences iirc, (as sequences are members of pg_class). This change is only necessary if newer versions of PostgreSQL dropped that syntax. It may be desirable, if we no longer support any versions of PostgreSQL that needed the old syntax.
 

It's still better to use the new syntax when it's available (ie, since 8.3).


--

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

Предыдущее
От: Ashesh Vashi
Дата:
Сообщение: Re: PATCH: new feature for Query tool: Favourites injection
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgAdmin III commit: Fix SQL for GRANT on a sequence