Hi !
I discovered this particular feature in "createdb" tool 8.0.0beta4
running on Win32 Platform:
-------------------- Cut And Paste ---------------------------
c:\windows> createdb testdb;
CREATE DATABASE
c:\windows> psql testdb
psql: FATAL: database "testdb" does not exist
c:\windows> psql testdb;
Welcome to psql 8.0.0beta4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
Warning: Console codepage (850) differs from windows codepage (1252)
8-bit characters will not work correctly. See PostgreSQL
documentation "Installation on Windows" for details.
testdb;=# \l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
testdb; | silvio | SQL_ASCII
(4 rows)
testdb;=#
-------------------- Cut And Paste ---------------------------
As you can see, createddb doesn't skip the semicolon after the
database's name, so you have a db name ending with semicolon. This is
not a problem really, but this happens only in this version/platform.
Thanks you all guys.
Regards,
Silvio Scarpati
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
