No. The controlling table is owned by postgres. This is why you had to use postgres. The database isn't owned by anyone, it is the tables who are owned by different users.
Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Tue, 17 Sep 2002, Lee Hughes wrote: > Yes -- but turns out the Update routine must be run by the postgres user > even if another user created the database. > > Thanks for your help. > > Steve Doerr wrote: > > Did you update the correct dataset? > > > > per the FAQ: > > > > > > "Incorrect Dataset version > > > > The dataset you are trying to use is not compatible with the version. > > When you upgrade datasets use the same database user in the "Connect to" > > field as the one listed in the Database section for the user." > > > > So if user "Joe" uses db "acctglive", then those would go in the User > > and Connect To fields. > > > > That script doesn't create a database. > > > > Good luck, > > Steve > > > > Lee Hughes wrote: > > > >> More background on this: I tried it on a test server where I have > >> superuser rights and it worked fine. Could the Update Dataset routine > >> be failing but giving me a bogus status message because my PostgreSQL > >> account does not have CreateDatabase rights? > >> > >> Thanks much for any help, I need to get this resolved quickly... > >> > >> Lee Hughes wrote: > >> > >>> I moved my 1.8.0 data onto a new server with a fresh install of > >>> 1.8.7. I did the Update Dataset operation but got "All Datasets up to > >>> date!" However when I try to log in I get "Error! Incorrect Dataset > >>> version!" > >>> > >>> Please help! > >>> > >>> Thanks, Lee > >>> > >>> > >>> > >>> ------------------------------------------------------- > >>> Sponsored by: AMD - Your access to the experts on Hammer Technology! > >>> Open Source & Linux Developers, register now for the AMD Developer > >>> Symposium. Code: EX8664 http://www.developwithamd.com/developerlab > >>> ------------------------------------------------------- > >>> (un)subscribe: > >>> http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>> Archive: http://www.mail-archive.com/[email protected]/ > >> > >> > >> > >> > >> > >> ------------------------------------------------------- > >> Sponsored by: AMD - Your access to the experts on Hammer Technology! > >> Open Source & Linux Developers, register now for the AMD Developer > >> Symposium. Code: EX8664 http://www.developwithamd.com/developerlab > >> ------------------------------------------------------- > >> (un)subscribe: > >> http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> Archive: http://www.mail-archive.com/[email protected]/ > >> > > > > > > > > > > > > ------------------------------------------------------- > > This SF.NET email is sponsored by: AMD - Your access to the experts > > on Hammer Technology! Open Source & Linux Developers, register now > > for the AMD Developer Symposium. Code: EX8664 > > http://www.developwithamd.com/developerlab > > ------------------------------------------------------- > > (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > Archive: http://www.mail-archive.com/[email protected]/ > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: AMD - Your access to the experts > on Hammer Technology! Open Source & Linux Developers, register now > for the AMD Developer Symposium. Code: EX8664 > http://www.developwithamd.com/developerlab > ------------------------------------------------------- > (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive: http://www.mail-archive.com/[email protected]/ > ------------------------------------------------------- This SF.NET email is sponsored by: AMD - Your access to the experts on Hammer Technology! Open Source & Linux Developers, register now for the AMD Developer Symposium. Code: EX8664 http://www.developwithamd.com/developerlab ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
