dbTalk Databases Forums  

modify template1 (or maybe 0) help

comp.databases.postgresql comp.databases.postgresql


Discuss modify template1 (or maybe 0) help in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Didier
 
Posts: n/a

Default modify template1 (or maybe 0) help - 08-28-2010 , 11:32 AM






Hello,

I have by error, modify database template (create tables when connect on
the template database)), now when i create a database this database
contain tables that I want not.

How repair ? , I have delete directory where I had do initdb, but
when i do again initdb, this tables are create !

can you help me ?

thanks

vincent

sorry my english is not very good, i hope you understand me

Reply With Quote
  #2  
Old   
Bob Badour
 
Posts: n/a

Default Re: modify template1 (or maybe 0) help - 08-28-2010 , 02:10 PM






Didier wrote:

Quote:
Hello,

I have by error, modify database template (create tables when connect on
the template database)), now when i create a database this database
contain tables that I want not.

How repair ? , I have delete directory where I had do initdb, but
when i do again initdb, this tables are create !

can you help me ?

thanks

vincent

sorry my english is not very good, i hope you understand me
Have you tried dropping the tables when connected to the template database?

Reply With Quote
  #3  
Old   
Jasen Betts
 
Posts: n/a

Default Re: modify template1 (or maybe 0) help - 08-29-2010 , 06:13 AM



On 2010-08-28, Didier <ae-info-pasdespam (AT) obtuli (DOT) fr> wrote:
Quote:
Hello,

I have by error, modify database template (create tables when connect on
the template database)), now when i create a database this database
contain tables that I want not.

How repair ? , I have delete directory where I had do initdb, but
when i do again initdb, this tables are create !

can you help me ?

thanks

vincent

sorry my english is not very good, i hope you understand me
this is usually enopugh:

drop schema public cascade; create schema public ;



--
¡spuɐɥ ou 'ɐꟽ ʞooꞀ

--- news://freenews.netfront.net/ - complaints: news (AT) netfront (DOT) net ---

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.