* 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 Lane||Date: 2005-06-09 22:03:12|
|Subject: Re: How not to display system tables? |