You need to user is a reserved word so you need to quote it (ie:
"user" rather than user) whenever you reference it.Does group reader exist?
If it does then it might be a case issue as presumably you must have quoted
user user to create it which also preserves case, so if you did the same
Can anyone suggest, what is wrong with the following
sql file? SOmehow the semicolon causes error?
Jari
class=# \i pg-def-group-grant.sql
Granting ALL to ROOT
CHANGE
Granting ALL to USER
psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user"
Granting SELECT t
[Please keep CC]
Can anyone suggest, what is wrong with the following
sql file? SOmehow the semicolon causes error?
Jari
class=# \i pg-def-group-grant.sql
Granting ALL to ROOT
CHANGE
Granting ALL to USER
psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "
Jari Aalto writes:
> class=# \i pg-def-group-grant.sql
> Granting ALL to ROOT
> CHANGE
> Granting ALL to USER
> psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user"
You need to double quote "user". It's a reserved word.
> Granting SELECT to READER
> psql:pg-def-group-g
Jari Aalto wrote:
>
>Can anyone suggest, what is wrong with the following
>sql file? SOmehow the semicolon causes error?
...
>Granting ALL to USER
>psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user
>"
...
>32:GRANT ALL ON
>33: bonus
>34: ,
Can anyone suggest, what is wrong with the following
sql file? SOmehow the semicolon causes error?
Jari
class=# \i pg-def-group-grant.sql
Granting ALL to ROOT
CHANGE
Granting ALL to USER
psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user"
Granting SELECT t