Skip site navigation (1) Skip section navigation (2)

Re: How not to display system tables?

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How not to display system tables?
Date: 2005-06-09 23:18:19
Message-ID: 20050609231819.GA9950@deby.ei.hnet (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [090605, 18:03]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> > thanks for the quick answer. AAMOF I did try pgAdmin months ago (when I
> > was running pg 7.2). Now I'm using 7.4.7-6sarge1 version and
> > occasionally pgAccess. Might this one be responsible for that also?
> > Can I simply cancel those pga*'s?
> Very possibly it's pgAccess that made them.  You could drop those tables
> from psql and then see which tool recreates them when you start it ...
> 			regards, tom lane

I dropped the pga_* tables as suggested, started pgAccess, viewed some
tables on the various databases, closed pgAccess, went to psql mydb and
could see that no pga_* table had been created (for the time being :-)
); so the 'culprit' must have been pgAdmin. May be pgAccess is
responsible for creating some sql_* tables, however these are not listed
by the \d command.
Should I find out something differewnt in the future I'll advise the
Thanks again, Tom.

[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]

In response to

pgsql-novice by date

Next:From: Havasvölgyi OttóDate: 2005-06-10 21:12:56
Subject: need suggestion for server sizing
Previous:From: Tom LaneDate: 2005-06-09 22:03:12
Subject: Re: How not to display system tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group