Re: How not to display system tables?
От | Ennio-Sr |
---|---|
Тема | Re: How not to display system tables? |
Дата | |
Msg-id | 20050609231819.GA9950@deby.ei.hnet обсуждение исходный текст |
Ответ на | Re: How not to display system tables? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-novice |
* Tom Lane <tgl@sss.pgh.pa.us> [090605, 18:03]: > Ennio-Sr <nasr.laili@tin.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 list. Thanks again, Tom. Regards, Ennio. -- [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) ]
В списке pgsql-novice по дате отправления: