Unable to create PostgreSQL database

[advis0r]

i uninstalled my old postgresql and now installed the 8.3 final version that came out yesterday.

getting the same problem:
[codek0d]2008/02/05 15:58:52.234: [- Main -][PostgresConnection (Error)] Unable to execute query: CREATE DATABASE "PT3_beta3" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII'; ALTER DATABASE "PT3_beta3" OWNER TO postgres;; Reason: Fatal Error (ERROR: CREATE DATABASE cannot be executed from a function or multi-command string )[/codek0d]

maybe do "create database" and "alter database" in two seperate statements?

or use the same single-statement syntax that pgAdmin uses when creating a new database
[codek0d]CREATE DATABASE test
WITH OWNER = postgres
ENCODING = 'UTF8';[/codek0d]

and add the TEMPLATE thing

[Josh]

We will be doing tests with PostgreSQL 8.3 to make PT3 compatible with it. I'd recommend waiting until we are able to do this before upgrading yourself.

[advis0r]

[quote="Josh"27p]We will be doing tests with PostgreSQL 8.3 to make PT3 compatible with it. I'd recommend waiting until we are able to do this before upgrading yourself.[/quote27p]

thx for the hint ...

did you read my whole post?

[code27p]CREATE DATABASE cannot be executed from a function or multi-command string[/code27p]
so use the right syntax!

[Josh]

Yes, I read your post. I am using the correct syntax, it's just that 8.3 isn't accepting it. We will need to find out why.

[advis0r]

this is the correct syntax:

[codej0w]CREATE DATABASE "PT3_beta3"
WITH OWNER = postgres
TEMPLATE = template0
ENCODING = 'SQL_ASCII';[/codej0w]

http://www.postgresql.org/docs/8.3/inte ... abase.html

i tried it in the psql console of my 8.3 installation and it works.

PT beta3 seems to be using two seperate statements:
[codej0w]CREATE DATABASE "PT3_beta3" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';
ALTER DATABASE "PT3_beta3" OWNER TO postgres;[/codej0w]

are you sure that this is not the reason for this error?

[Josh]

I'm not disagreeing with you that the problem is with the way PT3 is doing it.

[APerfect10]

Its not the syntax its the method of sending the queries to the database. This will be resolved in the next beta release. Furthermore, I am [bw0h][iw0h]hoping[/iw0h][/bw0h] to have 8.3 available for new installations in beta 4.

Best regards,

Derek

[wwonka]

Question I did the syntax and created the database. but it still cant find it in the directory.

Where is the PT database supposed to be?

I am usining 8.3



postgres=# ALTER DATABASE "PT3_beta3" OWNER TO postgres;
ALTER DATABASE
postgres=# CREATE DATABASE "PT3_beta3" WITH TEMPLATE = template0 ENCODING = 'SQL
_ASCII';
ERROR: database "PT3_beta3" already exists
postgres=#

[APerfect10]

[quote="wwonka"vmx]Question I did the syntax and created the database. but it still cant find it in the directory.

Where is the PT database supposed to be?

I am usining 8.3

postgres=# ALTER DATABASE "PT3_beta3" OWNER TO postgres;
ALTER DATABASE
postgres=# CREATE DATABASE "PT3_beta3" WITH TEMPLATE = template0 ENCODING = 'SQL
_ASCII';
ERROR: database "PT3_beta3" already exists
postgres=#[/quotevmx]

That simply creates a blank database. You will need to execute the query to create the schema for PT3 then under Database->Database Management, you will need to enter the database name and check "This is an existing database".

Running the schema may be a little advanced. We will be releasing beta 4 within the next few days which will support PostgreSQL 8.3. I advise waiting for this release.

Best regards,

Derek