On Mar 18, 2008, at 7:17 AM, Joris Dobbelsteen wrote:
I believe the CREATE DATABASE was because of the way postgresql creates a database. I thought it just copied the template database (but are not completely sure).Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE are very usefull but it would be great to have such a feature on themid-level too. I mean something CREATE SCHEMA LIKE that would copy allthe template schema relations, etc... What do you think about it ? Would it be hard to implement ? Is it worth the effort
You are correct. This is why the database used as a template can't have anyone connected to it; if somebody was, we can't get a consistent filesystem-level copy of the database.
-- Decibel!, aka Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828
<<attachment: smime.p7s>>
