On Mon, Sep 26, 2005 at 03:26:48AM -0400, sean finney wrote: > it should only be attempting to chown if the app was configured to > install via "ident sameuser", which currently is the default (because > by default this is the only method that will work out of the box). of > course, if there's no system user, that won't work either. Why not login as postgres, get that user to add the tables then get them to be owned by the other user? ALTER TABLE blah OWNER TO newuser
> it definitely shouldn't be doing that. the only time it should be > connecting to template one is when it is testing the connection or > creating the database user. i think there's some variable polution > going on somewhere, i'll look into that. Looking into it more, the database name is initially correct before the create user but becomes template1 after it. I'm guessing you have a missing local somewhere, but it was nowhere obvious. - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 Eye-Net Consulting http://www.enc.com.au/ MIEE Debian developer csmall at : enc.com.au ieee.org debian.org -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
