[GENERAL] pg_dump on view

up of attribute 0 in relation 54498 failed '. what does it mean? How to get rid of it, any hints? maz Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

Re: [GENERAL] pg_dump on view

of it, any hints? > I'd guess this means that the underlying table has been deleted... it's a view and working one but what i noticed: mtldb=# \d zadania_wykonane ERROR: cache lookup of attribute 0 in relation 59299 failed mtldb=# Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

[GENERAL] plpgsql, insert with wariables in function triggered

AME; tabb :=tab || ''_do_zablokowania''; ... if (NEW.stan=ids1) then INSERT INTO tabb (zlecenie) VALUES ( OLD.id); --line that casues the trouble end if; ... tia Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

[GENERAL] finding dependencies with altered table

Hi, lets say I'm changing a table with alter. Of course related views etc are broken, how can I find all tables etc. depended on that table ? tia mazek Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

[GENERAL] order of trigger sequence

Hi, is there a way to set up an order in which triggers are fired up on same table? tia mazek Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

[GENERAL] explain results in pg logs

HI, I couldn't find an answer in doc, so here's the question. Is it possible to to have result similar to explain command in postgres log. I've turned on plan in pg_options but results are not to readable for me (anyone has a doc about it?). I need it to find queries which I can optimize by using

[GENERAL] Large objects + JDBC

Hi, I'm put several gifa into a table. I did as a exercise:) form psql using: INSERT INTO images (id, data) VALUES (3, lo_import('/usr/local/apache/servlets/images/a.gif')); but I have a problem with creating Java stream to read these data. Here serveral lines of code I was using: PreparedSta

Re: [GENERAL] Problem in pg_hba.conf

On Mon, 13 Dec 1999, Mark Alliban wrote: > Postgres$ createdb test > Connection to database 'template1' failed. do initdb You just don't have "default" database. mazek

Re: [GENERAL] Problem in pg_hba.conf

On Mon, 13 Dec 1999, Mark Alliban wrote: > I have already done this, and it completed successfully. > There is a /usr/local/pgsql/data/base/template1 directory with a lot of pg_ > files in it. You may chceck if postmaster is running... mazek

Re: [GENERAL] Problem in pg_hba.conf

On Mon, 13 Dec 1999, Mark Alliban wrote: > Yes the postmaster process is running. > nohup postmaster -i >pgserver.log 2>&1 & > The log file is empty until I try to create the database, then it gives the > error. then the last thing I can think of, is location of data files:) chceck enviromant var

Re: [GENERAL] It works now :)

On Sun, 23 Jan 2000, Jeff Davis wrote: > Thanks very much to the people that helped me write > those C functions. Can You send a solution to the list. It may help somebody in the future. It would be good to get to the archiveres at least:). mazek