Re: Drop database/create database broken in 7.4?

On Thu, 2006-01-05 at 13:09, John Wells wrote:
> Guys,
>
> I'm running PG 7.4 on Ubuntu Breezy for Ruby on Rails development. One of
> the things I ofter have to do is rebuild the database...for which I have a
> script that I've created to do it in one step.
>
> I've noticed some oddities. The script connects to template1, drops the
> target database, creates the target database, and the rebuilds the tables.
> However, two specific tables and sequences are not dropped, although the
> drop command completes successfully.
>
> For example, here's the error reproduced manually:
>
> dailystatus=> \d
> List of relations
> Schema | Name | Type | Owner
> --------+-----------------+----------+--------
> public | garages | table | wellsj
> public | garages_id_seq | sequence | wellsj
> public | trucks | table | wellsj
> public | trucks_id_seq | sequence | wellsj
> public | sites | table | wellsj
> public | sites_id_seq | sequence | wellsj
> public | statuses | table | wellsj
> public | statuses_id_seq | sequence | wellsj
> public | users | table | wellsj
> public | users_id_seq | sequence | wellsj
> (10 rows)
>
> dailystatus=> \c template1
> You are now connected to database "template1".
> template1=> drop database dailystatus;
> DROP DATABASE
> template1=> create database dailystatus;
> CREATE DATABASE
> template1=> \c dailystatus
> You are now connected to database "dailystatus".
> dailystatus=> \d
> List of relations
> Schema | Name | Type | Owner
> --------+--------------+----------+--------
> public | sites | table | wellsj
> public | sites_id_seq | sequence | wellsj
> public | users | table | wellsj
> public | users_id_seq | sequence | wellsj
> (4 rows)
>
> dailystatus=>
>
> Anyone know what might be happening? I'm at a loss.

Yep, somewhere along the lines you accidentally created those tables in
template1