From: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Funky template1 problem? |
Date: | 2005-12-21 23:41:47 |
Message-ID: | docp5o$7ll$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Jerry LeVan" <jerry(dot)levan(at)eku(dot)edu> wrote in message
news:DF90ADCC-643E-4EA7-AB6C-423815301EF5(at)eku(dot)edu(dot)(dot)(dot)
> Hi,
>
> I have a bunch of small dbs (levan, pictures, and a couple of others).
>
> I have had these db's over many upgrades and I have just noticed that
> template1 seems to be a bit munged...
>
> testuser=> \c template1
> You are now connected to database "template1".
> template1=> \d
> List of relations
> Schema | Name | Type | Owner
> --------+----------------+----------+-------
> public | lo_shadow | table | levan
> public | my_description | table | levan
> public | person | table | levan
> public | person_id_seq | sequence | levan
> public | pics | table | levan
> public | pics_ident_seq | sequence | levan
> (6 rows)
>
Can you show the relfilenode (the physical file name of the relation) of
these tables like this:
select relname, relfilenode from pg_class, pg_namespace where relnamespace =
pg_namespace.oid and nspname = 'public';
And check if they are really in the template1?
Regards,
Qingqing
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-22 00:02:58 | Re: Funky template1 problem? |
Previous Message | Chris Browne | 2005-12-21 23:33:28 | Re: Indices for select count(*)? |