Re: [GENERAL] problem with grant all privileges

2014-01-28 Thread Susan Cassidy
It turns out IT screwed something up when they installed 9.2. The actual server/client running is still pointing to 8.4. Thanks, guys. Susan On Mon, Jan 27, 2014 at 4:48 PM, Tom Lane wrote: > Susan Cassidy writes: > > This is 9.2 > > I'd bet a very good dinner that it isn't --- maybe your p

Re: [GENERAL] problem with grant all privileges

2014-01-28 Thread Rob Sargent
On 01/28/2014 10:33 AM, Bruce Momjian wrote: On Mon, Jan 27, 2014 at 07:48:33PM -0500, Tom Lane wrote: Susan Cassidy writes: This is 9.2 I'd bet a very good dinner that it isn't --- maybe your psql is, but your server has to be pre-9.0. Try "select version();" to see the actual version of th

Re: [GENERAL] problem with grant all privileges

2014-01-28 Thread Bruce Momjian
On Tue, Jan 28, 2014 at 02:40:47PM -0300, Alvaro Herrera wrote: > Bruce Momjian escribió: > > On Mon, Jan 27, 2014 at 07:48:33PM -0500, Tom Lane wrote: > > > Susan Cassidy writes: > > > > This is 9.2 > > > > > > I'd bet a very good dinner that it isn't --- maybe your psql is, > > > but your serve

Re: [GENERAL] problem with grant all privileges

2014-01-28 Thread Alvaro Herrera
Bruce Momjian escribió: > On Mon, Jan 27, 2014 at 07:48:33PM -0500, Tom Lane wrote: > > Susan Cassidy writes: > > > This is 9.2 > > > > I'd bet a very good dinner that it isn't --- maybe your psql is, > > but your server has to be pre-9.0. Try "select version();" to > > see the actual version of

Re: [GENERAL] problem with grant all privileges

2014-01-28 Thread Bruce Momjian
On Mon, Jan 27, 2014 at 07:48:33PM -0500, Tom Lane wrote: > Susan Cassidy writes: > > This is 9.2 > > I'd bet a very good dinner that it isn't --- maybe your psql is, > but your server has to be pre-9.0. Try "select version();" to > see the actual version of the server you're connected to. You

Re: [GENERAL] problem with grant all privileges

2014-01-27 Thread Tom Lane
Susan Cassidy writes: > This is 9.2 I'd bet a very good dinner that it isn't --- maybe your psql is, but your server has to be pre-9.0. Try "select version();" to see the actual version of the server you're connected to. regards, tom lane -- Sent via pgsql-general mai

Re: [GENERAL] problem with grant all privileges

2014-01-27 Thread Susan Cassidy
This is 9.2 On Mon, Jan 27, 2014 at 4:16 PM, Tom Lane wrote: > Adrian Klaver 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 mis

Re: [GENERAL] problem with grant all privileges

2014-01-27 Thread Tom Lane
Adrian Klaver 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

Re: [GENERAL] problem with grant all privileges

2014-01-27 Thread Adrian Klaver
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" LINE 1: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO te... also the same thing for tables, with the same resul

[GENERAL] problem with grant all privileges

2014-01-27 Thread Susan Cassidy
I tried: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser; and I get: ERROR: syntax error at or near "ALL" LINE 1: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO te... also the same thing for tables, with the same results. Am I misinterpreting the syntax for this?