Обсуждение: Backing up with Postgres

Dear Postgres Users,

I am currently having great difficulty working out the reason for an
unexpected error message!
The message occurs when a unix cshell script runs to backup the
database.
The script pipes in the user name and password to pgdump which does
work, and then tries to backup
to a specific filename.

When the script runs, the error "getTables(): relation 'genuser': cannot
find function with oid 773217 for trigger check_user" appears.

(1) Insufficient Permissions? :The first thing I thought is that the
user may not have permissions: This still happens
    running as superuser, and defiantly no permission restraints.

(2) Faulty Trigger? : I have dropped and recreated the trigger, still no
joy. It solves the problem, but then another
    trigger appears with the same message.
    The Trigger takes the form below (Trigger check_user, attached to
genuser table)


-----------------------------------------------------------------------------
    CREATE TRIGGER check_user
        BEFORE DELETE ON genuser
        FOR EACH ROW EXECUTE PROCEDURE
            check_foreugn_key(1,'cascade','userid','webuser','userid');


-----------------------------------------------------------------------------

What puzzles me, because Im not really that good at SQL yet is; what is
an oid?

Any pointers or answers with why this is happening, and maybe a way
forward greatfuly received!
I have tried looking at the manuals, but so far unsuccessfully.

--

Thanks for your ongoing support, -- Take Care and until next time Keep
Smiling!
Luke.

Justin Hayward "That's the way, that's the way of the world".

On Thu, Mar 01, 2001 at 05:15:15PM +0000, some SMTP stream spewed forth:
> Dear Postgres Users,
>
*snip*

>What puzzles me, because Im not really that good at SQL yet is; what is
> an oid?

An oid is basically a (mostly) globally unique identifier tagged on
to every row in every table -- and on to large objects (etc.).

These are usually unique across an entire server installation, but
the counter will eventually wrap around (which is not a big problem).


Cheers,
dan

Yes, I know that this is not a solution to your problem, but that I
cannot provide as I am unfamiliar with triggers.

> Any pointers or answers with why this is happening, and maybe a way
> forward greatfuly received!
> I have tried looking at the manuals, but so far unsuccessfully.
>
> --
>
> Thanks for your ongoing support, -- Take Care and until next time Keep
> Smiling!
> Luke.
>
> Justin Hayward "That's the way, that's the way of the world".