[ADMIN] vacuum full again

2003-02-04 Thread Gaetano Mendola
Hi all, I'm tryng to do a vacuum full of my db without succes ( the process hang), I tryed with only a table and hang too, the funny is that also the process that are using that table hangs if I perform the vacuum process ( seems like ad deadlock! ). Is it possible see with Postgres 7.2.3 who is

[ADMIN] ERROR: Parent tuple was not found

2003-02-04 Thread Gaetano Mendola
During a vacuum full in a couple of tables I obtain: ERROR: Parent tuple was not found and in another table: NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag time ago TOM told me that is not a problem, what does mean exactly "is not a problem". Ciao Gaetan

[ADMIN] Large objects - SOS

2003-02-04 Thread mjoseph
Hi, I need to create a large object - a photograph and work with it. I would be using ODBC (application on Windows NT , db server on Linux) The doc at http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52 suggests creating a custom type like this. create type lo ( internallength=4,

[ADMIN] 7.3.1 update gives PHP libpq.so.2 problem

2003-02-04 Thread Jules Alberts
Hello everyone, After upgrading to pg 7.3.1 on a RH 7.3 box with php 4.1.2 PHP won't work anymore, it misses libpq.so.2. This is a known issue, but the only solution I could google was compiling a recent PHP from source or creating a softlink from libpq.so.3 to libpq.so.2. I read that the link

Re: [ADMIN] ERROR: Parent tuple was not found

2003-02-04 Thread Tom Lane
"Gaetano Mendola" <[EMAIL PROTECTED]> writes: > During a vacuum full in a couple of tables I obtain: > ERROR: Parent tuple was not found > and in another table: > NOTICE: Child itemid in update-chain marked as unused - can't continue > repair_frag > time ago TOM told me that is not a problem, what

Re: [ADMIN] ERROR: Parent tuple was not found

2003-02-04 Thread Gaetano Mendola
"Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Gaetano Mendola" <[EMAIL PROTECTED]> writes: > > During a vacuum full in a couple of tables I obtain: > > ERROR: Parent tuple was not found > > and in another table: > > NOTICE: Child itemid in update-c

[ADMIN] Script Trigger

2003-02-04 Thread Yudha Setiawan
Dear Master;   How do i find the script of trigger's Description Like "Create Trigger tr_bi_podtl Before Insert On d_temporary.t_podtl For Each Row Execute Procedure fn_tr_bi_podtl();"   Yudha Setiawan.VoIP     No.    : 01119311223344