On Mon, Jan 27, 2014 at 4:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Adrian Klaver <adrian.klaver@gmail.com> writes: > On 01/27/2014 01:45 PM, Susan Cassidy wrote: >> I tried: >> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser; >> and I get: >> ERROR: syntax error at or near "ALL" >> Am I misinterpreting the syntax for this?
> Depends on what version of Postgres you are working with. The syntax of > commands changes with time.
That syntax works for me back to 9.0, but 8.4 gives the described error; which is unsurprising when you examine the respective documentation.