From: Pentilian <pentilian@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: Wierd Error on update
Date: Fri, 13 Aug 2004 11:05:39 -0500
Message-ID: <fd475ca90408130905439c5413@mail.gmail.com> (raw)
> Original 7.3 release, or (I hope) 7.3.something?
7.3
> > I am getting two errors which are a bit confounding.
> > ERROR: pg_class_aclcheck:relation 474653086 not found
>
> Are there any views involved?
No views.
Is the statement invoking any functions?
The statement is not invoking any fuctions
However heres the statements,
UPDATE school_info_l SET ind_default_data = 't';
UPDATE school_info_l SET sis_system_id = 9 where school_id IN (492, 434, 436);
which are amazingly simple.
Both queries return the same exact error, same error.
not your
> How about triggers? Foreign keys? Rules?
Neither of the updates touch any rules.
sis_system_id is a foreign key to another table (but the first isnt
touching anything that has a trigger or foreign key constraint
attached to the column.
The table school_info_l has many contraints that affect other tables however
> Also, is it always the same number in the error, or does that change
> from run to run?
The number is the same for each time I run the update file on the same
database. with this two queries having the same error.
Same result to, if I run these two after the first update file
finishes there is no problem, but if I try to run it at the end of hte
first file, choke.
Very Odd problem to me, since the update statemenets are so simple.
-Tom
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: pentilian@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Wierd Error on update
In-Reply-To: <fd475ca90408130905439c5413@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