From: Thomas Seeber <thomas.seeber@gmail.com>
To: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Wierd Error on update
Date: Wed, 11 Aug 2004 15:21:09 -0500
Message-ID: <578aa3f7040811132151bb6f41@mail.gmail.com> (raw)
Hi All,
I am relative PostGres newbie, so if there is a simple answer to this
question, please feel free to send me a link or explaination.
I am running Postgres 7.3 on a intel Linux Redhat 7.3 base.
I am getting two errors which are a bit confounding.
ERROR: pg_class_aclcheck:relation 474653086 not found
on one table within a large SQL file update (+5000 lines with
documentation) that needs to be run from the command line.
Both statements are multiline Update statements. This is straight
SQL, not function code.
Now I can guareentee that the queries refer to an existing table, but
the table is being rebuilt in the core of the long SQL update.
The table in question now has all permissions (my attempt to get
fixed, but that did not help).
Interesting aspect to this problem is that if your run the large
update in one file, and then run the two update statements in a second
file it works fine.
Now I placed the erroring statements at the end of the large file to
make sure it was not a ordering error, but that didnt help.
Any ideas?
Thank you
Thomas Seeber
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: thomas.seeber@gmail.com
Subject: Re: Wierd Error on update
In-Reply-To: <578aa3f7040811132151bb6f41@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox