Re: 7.4.1 template1

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(dot)ruuhimaki(at)kymi(dot)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