Re: postgres 7.1 -> 7.2 ... sigh

2002-04-21 Thread Oliver Elphick
On Mon, 2002-04-22 at 03:17, Andreas Goesele wrote: ... > You are now connected to database template1 as user postgres. > CREATE DATABASE "accounts" WITH TEMPLATE = template0 ENCODING = 'LATIN1'; > ERROR: CREATE DATABASE: database "accounts" already exists > You are now connected to database accou

Re: postgres 7.1 -> 7.2 ... sigh

2002-04-21 Thread Andreas Goesele
Jason Chambers <[EMAIL PROTECTED]> writes: > > CREATE USER "user" WITH SYSID 1 CREATEDB CREATEUSER; > > ERROR: CREATE USER: sysid 1 is already assigned > ^^^ > > Sysid 1 is probably assigned to the user postgres created by the > install. To get you

Re: postgres 7.1 -> 7.2 ... sigh

2002-04-20 Thread Jason Chambers
Andreas Goesele wrote: I had big problems going from 6.5 to 7.1 and now going from 7.1.3-7 again doesn't go smooth. (On an up do date woody.) The problem seems to be related to the fact that I call myself "user" (fanciful name, isn't it?), but shouldn't one be free to call the users as one likes