[GENERAL] alter table schema in 8.0

the oid of the public namespace. I didn't found any other reference to pg_catalog.pg_namespace.oid. Did anybody try something like this? I examined the sources of AlterTableNamespace() defined in tablecmds.c but it wasn't realy helpful. I will appreciate any help. Best regards,

Re: [GENERAL] Finding uniques across a big join

query? I guess I should take consirerably less time than the first one. Usualy I do "these things" like this... This is the only possibility for the planner to use indexes. The query plan you send us shows that are mostly seq scans are used. Regards, Marcin Inkielman ---

Re: [GENERAL] table count limitation

wife's grandparents emigrated from around > Lodz in 1904~06 and settled in Winnipeg, Manitoba in Western Canada. /mt I live near Warsaw. LÓdź (Lodz - if your e-mail reader do not support iso-8859-2 ;) ) is ~100km from here. You must be a very happy man if your wife is partially from Poland. Polish women are really beautifull! ;)) regards, Marcin Inkielman

Re: [GENERAL] table count limitation

cts is characterised by other number of features) and I dont have to compare (select) products having other types (i.e. cars and computers in 1 querry). If i could have 1 tables - one table for each type of products this queries would be a lot simplier - don't you think? PS. sorry for my English - I hope I was understood -- Marcin Inkielman

[GENERAL] vacuumdb problem

Hi! I have a problem with vacuumdb on one of my tables. (spiral:3)-[~]$vacuumdb -t osoby -v dziekanat NOTICE: --Relation osoby-- NOTICE: Pages 229: Changed 0, reaped 16, Empty 0, New 0; Tup 4427: Vac 5, Keep/VTL 0/0, Crash 0, UnUsed 70, MinLen 64, MaxLen 616; Re-using: Free/Avail. Space 18176/

[GENERAL] index problem

tent my question is: ~~~~~~~ how may i delete this index in my original database??? thanks for any help.. marcin inkielman

Re: [GENERAL] PG 7.0 vacuum problem

On Thu, 25 May 2000, Tom Lane wrote: > Date: Thu, 25 May 2000 19:49:00 -0400 > From: Tom Lane <[EMAIL PROTECTED]> > To: Marcin Inkielman <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] PG 7.0 vacuum problem > > Marcin Inkielman <[EMAIL

[GENERAL] PG 7.0 vacuum problem

HI! i rescently upgraded my system from PG6.53 to PG7.0. after a few days of work i am unable to do a vacuum on one of tables: nat=# VACUUM verbose analyze osoby; NOTICE: --Relation osoby-- NOTICE: Pages 189: Changed 0, reaped 24, Empty 0, New 0; Tup 3436: Vac 29, Keep/VTL 0/0, Crash 0, UnUsed

Re: [GENERAL] row numbering

Hi! thanks for your respose! sorry if i was not very clear with my question... On Wed, 10 May 2000, Peter Eisentraut wrote: > Marcin Inkielman writes: > > > how may i easyly obtain row numbers in a query: > > In the SQL data model, rows don't have numbers, because row

[GENERAL] logs

hi! sorry for my stupid question... is it possible to view logs of postmaster? i remarked a file named pg_log - what is it for? Marcin Inkielman .~. /V

[GENERAL] logs

hi! sorry for my stupid question... is it possible to view logs of postmaster? i remarked a file named pg_log - what is it for? Marcin Inkielman .~. /V

[GENERAL] a problem with single char recoding

ost iso -- i think files iso-win.tab/win-iso.tab are ok. thanks for any hint... Marcin Inkielman

Re: [GENERAL] Postgres concurrency : urgent

> Thanks and regards, > > Kimi I 'm using : LOCK <> IN ACCESS EXCLUSIVE MODE; to control concurrent transactions - it works for me (postgres 6.5.2) Marcin Inkielman .~.

Re: [GENERAL] ERROR: nodeRead: Bad type 0

atabase: pr pr=> create table "Jêzyk_obcy"(a text); CREATE pr=> select * from "Jêzyk_obcy"; a - (0 rows) pr=> create view "Jêzyk_obcy1" as select * from "Jêzyk_obcy"; CREATE pr=> select * from "Jêzyk_obcy1"; a - (0 rows) just a killing space?? -- Marcin Inkielman sibi omino similis?