Skip site navigation (1) Skip section navigation (2)

Strange think with DROP DATABASE

From: Partyka Robert <bobson(at)saturn(dot)alpha(dot)pl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Strange think with DROP DATABASE
Date: 2001-01-04 10:06:07
Message-ID: Pine.LNX.4.21.0101041050440.1072-100000@saturn.alpha.pl (view raw or flat)
Thread:
Lists: pgsql-hackers
I dont know if I do something wrong or it is normal for PG :)
So

template1=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.0.3 on i486-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)

And now:
template1=# drop database test;
DROP DATABASE
template1=# create database test;
CREATE DATABASE
template1=# \c test
You are now connected to database test.
test=# \d
          List of relations
     Name      |   Type   |  Owner
---------------+----------+----------
 test1         | table    | postgres
 test1_seq     | sequence | postgres
...
and so on and so on
...
(21 rows)
test=#

It is normal that after drop and recreate I get old structure of database
?

regards 
Robert


Responses

pgsql-hackers by date

Next:From: Partyka RobertDate: 2001-01-04 10:56:03
Subject: Re: Strange think with DROP DATABASE
Previous:From: Bruce MomjianDate: 2001-01-04 08:25:34
Subject: Re: Please review TODO list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group