| From: | Silvio Scarpati <silvio(dot)scarpati(at)customsolutions(dot)it> | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | minor issue in createdb 8.0.0beta4 | 
| Date: | 2004-11-01 08:39:27 | 
| Message-ID: | jhtbo0tq3502qbbkg0c9673glk63mjuq4h@4ax.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edgars | 2004-11-01 09:42:07 | postgres getting slow in the latest version | 
| Previous Message | Martin Pitt | 2004-11-01 08:17:38 | Re: Some patches to enhance the contrib build |