> > A user was setup and had GRANT permissions on individual tables in a database.
>After the user was dropped, using the /z from psql command line showed the user ID
>still existing in the individual table permissions. After the drop, several other
>users then were unable to execute SELECT or INSERT on this table. These users would
>get a -601 error when trying to do a SELECT or INSERT. Also, trying to REVOKE
>permissions on the user ID that belonged to the dropped user resulted in a parse
>error.
> What is a "-601 error"? There's surely no such message in Postgres.
There surely is in ecpg:
ecpgerrno.h:#define ECPG_WARNING_QUERY_IGNORED -601
These error codes are typically chosen to conform to SQL9x or to
Oracle's conventions, though I haven't looked into this one in a
while...
- Thomas
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
