Hi,
> I think most of your confusion stems from using an ancient psql ---
Oh, instead of
bash-2.05a$ psql xxx
bash-2.05a$ /usr/local/pgsql/bin/psql xxx
Welcome to psql 7.4.1, the PostgreSQL interactive terminal.
Aha, and thanks again, I see something, hmm ...
BR,
Aarni
On Friday 23 January 2004 18:15, you wrote:
> Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni.ruuhimaki@kymi.com> writes:
> > Just noticed that 7.4.1 template1 has 40 views / tables in it and copies
> > all of them to new databases.
>
> It's supposed to.
>
> > Tried to DROP them in template1 and in a dummy db
> > but got an error e.g. 'table "sql_features" does not exist'
>
> information_schema isn't in your search path by default.
>
> I think most of your confusion stems from using an ancient psql ---
> since it's not showing a version number in the welcome banner,
> it must be older than 7.3, which means it does not know about schemas.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com