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

2014-07-15 0:27 GMT+02:00 Dave Page : > Minor brain failure, but I believe the same comment applies. > > Yeah, the code checks the version. If less than 8.3, it uses the old syntax (GRANT ON TABLE). Otherwise, it uses the new syntax (GRANT ON SEQUENCE). > On 14 Jul 2014, at 22:13, Guillaume Lela

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

Minor brain failure, but I believe the same comment applies. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 14 Jul 2014, at 22:13, Guillaume Lelarge wrote: > > 2014-07-14 23:09 GMT+02:00 Dave

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

2014-07-14 23:09 GMT+02:00 Dave Page : > That syntax was (once) intentional, and was not a bug, as earlier versions > of PG don't support ALTER SEQUENCE. Did you check the version compatibility? > > I'm not sure I understand what you mean. We're not talking about ALTER SEQUENCE. We're talking abou

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

That syntax was (once) intentional, and was not a bug, as earlier versions of PG don't support ALTER SEQUENCE. Did you check the version compatibility? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company