Strange think with DROP DATABASE
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
Ok... I found bug, it was me ;)))
In some strange moment I add this tables to template1 instead of
test. Maybe I must go sleep more ;)).
regards
Robert
Show quoted text
I dont know if I do something wrong or it is normal for PG :)
Sotemplate1=# 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