From: | Danny Aldham <danny(at)aldham(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Numeric user ID invalid in 7.3 ? |
Date: | 2003-04-12 22:21:04 |
Message-ID: | 200304122221.h3CML42D003244@lennon.postino.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am moving a postgres database onto an new machine, running the
current stable version of Postgres7.3 . I am finding broken application
software, and seem to have narrowed it down to a user id of 1001 .
That is one-thousand and one. I can create the user fine, put it
into a group, can grant all the permissions, but when the programs run,
or even if I try to execute : psql -d db -U 1001 , I am getting an
error message : ERROR: pg_class_aclcheck invalid user id 1001 .
If i create a new user id that is not numeric it seems to work fine,
but I am worried about having to convert the user ID used in all
the programs.
--
Danny Aldham Providing Certified Internetworking Solutions to Business
www.postino.com E-Mail, Web Servers, Security, Web Databases, SQL PHP & Perl
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffrey Melloy | 2003-04-13 16:25:55 | search_path in SQL script? |
Previous Message | Josh Berkus | 2003-04-12 18:10:35 | Re: Stored Procedures |