On 4/2/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:> I have many many instances of these two problems in pg_dump's output:> 1) function code don't seem to be taken into account for dependencies
No, it isn't, and t
The following bug has been logged online:
Bug reference: 2369
Logged by: Jonathan Ellis
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: linux
Description:pg_dump function dependencies
Details:
I have many many instances of these two
> > Would manually
> > removing it from pg_trigger cause Bad Things to happen?
>
> Yes, and you'll need to double quote the trigger name.
> try
> drop trigger "RI_ConstraintTrigger_44349" on users;
That worked. Why was that?
> How did you drop the table? Did you reload a dump file (like the on
This is in 7.1.1:
I was playing around with a table called user_comments and then dropped it.
One of its columns referenced the user_id column of another table, users.
Now whenever I try to update users, I get results like this:
bf2-new=# update users set last_visit=sysdate() where user_id=4; ERR
