I did a CVS checkout today, and the following database creation fails.

In psql:-

You are now connected to database template1 as user postgres.
template1=# select version();
                                version
------------------------------------------------------------------------

 PostgreSQL 7.1devel on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

template1=# create database test;
CREATE DATABASE
template1=# \c test
FATAL 1:  Database "test" does not exist in the system catalog.
Previous connection kept

>> Now restart the postmaster

template1=# \c test
You are now connected to database test.

Is it just me?

Regards,
Grant

--
> Poorly planned software requires a genius to write it
> and a hero to use it.

Grant Finnemore BSc(Eng)  (mailto:gaf@ucs.co.za)
Software Engineer         Universal Computer Services
Tel  (+27)(11)712-1366    PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536    20th Floor, 209 Smit St., Braamfontein
Fax  (+27)(11)339-3421    Johannesburg, South Africa



Fri, 17 Nov 2000 08:37:33 +0200
Grant Finnemore <gaf@ucs.co.za>
Failure to recognise new database
> Is it just me?

I'm pretty sure I saw something similar on a newly initialized database.

The sequence was:

initdb
postmaster -i -o -F
createdb
psql
(database "thomas" not found)
psql template1
\d
(see "thomas")
psql
(database "thomas" found just fine)

                    - Thomas

Fri, 17 Nov 2000 07:17:39 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: Failure to recognise new database
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>> Is it just me?

> I'm pretty sure I saw something similar on a newly initialized database.

Are you guys running with WAL enabled?  If so, this is probably the
BufferSync issue that Hiroshi thought I broke a couple days ago.
Let me know...

			regards, tom lane

Fri, 17 Nov 2000 02:35:08 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Failure to recognise new database 
Tom Lane wrote:

> Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> >> Is it just me?
>
> > I'm pretty sure I saw something similar on a newly initialized database.
>
> Are you guys running with WAL enabled?  If so, this is probably the
> BufferSync issue that Hiroshi thought I broke a couple days ago.
> Let me know...

Yes, I am running WAL enabled.

>
>
>                         regards, tom lane

Regards,
Grant

--
> Poorly planned software requires a genius to write it
> and a hero to use it.

Grant Finnemore BSc(Eng)  (mailto:gaf@ucs.co.za)
Software Engineer         Universal Computer Services
Tel  (+27)(11)712-1366    PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536    20th Floor, 209 Smit St., Braamfontein
Fax  (+27)(11)339-3421    Johannesburg, South Africa



Fri, 17 Nov 2000 11:05:34 +0200
Grant Finnemore <gaf@ucs.co.za>
Re: Failure to recognise new database
> Are you guys running with WAL enabled?  If so, this is probably the
> BufferSync issue that Hiroshi thought I broke a couple days ago.
> Let me know...

Yes, I too am running with WAL enabled.

                  - Thomas

Fri, 17 Nov 2000 13:47:49 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: Failure to recognise new database
Grant Finnemore <gaf@ucs.co.za> writes:
> Tom Lane wrote:
>> Are you guys running with WAL enabled?  If so, this is probably the
>> BufferSync issue that Hiroshi thought I broke a couple days ago.
>> Let me know...

> Yes, I am running WAL enabled.

OK, I put back the BufferSync call.  Sorry 'bout that, chief...

			regards, tom lane

Fri, 17 Nov 2000 22:45:38 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Failure to recognise new database 