| From: | Luke Tudor - RSG <ltt(at)pml(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Function Missing? |
| Date: | 2001-03-05 11:05:33 |
| Message-ID: | 3AA372FD.DA3EA2B1@unixmail.npm.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Dear Team,
I wrote recently describing a problem backing up my database. I believe
that I have
found the reason why the error is occurring, but i'm unsure how to fix
it. Any help would be
appreciated.
I have the error;
gettable(): relation 'genuser': cannot find function with oid 773217 for
trigger check_user
I think I may have found the answer. I have tried to list the functions
that the database has, using
\df, and the check_foriegn_key function, which I believe is part of the
Postgres database does not appear.
If I delete the trigger which is causing a problem, a new error with
another trigger appears. This trigger also
calls check_foreign_key.
Should this function 'check_foreign_key' appear on the list? Is this the
way to display it?
If it is missing, I would have to reinstall it. Is it possible to
reinstall just specific functions?
and lastly, Am I correct in thinking that functions have oid's as well
as field rows. Or could this error actually
be due to missing some data from a table? (This backup program has
worked before, but has just stopped working!?)
I know I have recently been asking lots of questions, and I do
apologize.
Take Care ~ Keep Smiling,
Luke Tudor.
luke(at)luketudor(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-05 15:44:49 | Re: Function Missing? |
| Previous Message | John Draper | 2001-03-05 07:28:34 | Re: I can't even get started..... HELP!!! |