Short and simple: I'm trying to do the following:
postgres@master-db01:~$ psql pnssi_profiles_bench
psql (9.0.3)
Type "help" for help.
pnssi_profiles_bench=# drop SCHEMA _pnssi_slony_bench_profiles_01_110 cascade;
ERROR: could not find tuple for trigger 37463634
As you can see, this is a s
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] De la part de mdione@orange.com
> I don't have the rest of the info (the entry in pg_class with OID 1259)
> because right now I'm running a preventive VACUUM, which it's taking ages.
Ok, the vacuum finishe
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] De la part de mdione@orange.com
> What I understand is that it seems that somehow I got some references to
> objects
> that do not exist anymore, so I think I should run the equivalent of fsck I
> this
> da
De : Tom Lane [mailto:t...@sss.pgh.pa.us]
> > pnssi_profiles_bench=# drop SCHEMA _pnssi_slony_bench_profiles_01_110
> cascade;
> > ERROR: could not find tuple for trigger 37463634
>
> You might try reindexing pg_trigger before doing anything more invasive,
> just in case the tuple is there but it