Re: Relation 0 does not exist

On Wed, Sep 25, 2002 at 05:49:17PM -0400, Tom Lane wrote:
> Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> > One thing which bugs me: I have a currval in there, and that is the very
> > first query which reaches the database, so it won't be "set", will it, but
> > then, how could it have worked for months with the other version of server?
>
> Good question. Do you have any ON INSERT rules on that table?

No

> Could you try setting a breakpoint at elog() to capture the stack trace
> leading up to the error?

#0 elog (lev=15, fmt=0x821133b "statement: %s") at elog.c:114
#1 0x81812db in elog (lev=20, fmt=0x8196b02 "Relation %u does not exist")
at elog.c:438
#2 0x80791a2 in relation_open (relationId=0, lockmode=2) at heapam.c:474
#3 0x8079329 in heap_open (relationId=0, lockmode=2) at heapam.c:602
#4 0x816d94b in RI_FKey_check (fcinfo=0xbfbfc884) at ri_triggers.c:212
#5 0x816dee1 in RI_FKey_check_ins (fcinfo=0xbfbfc884) at ri_triggers.c:506
#6 0x80d4d2b in ExecCallTriggerFunc (trigdata=0xbfbfc9ac, finfo=0x82dd01c,
per_tuple_context=0x83342d8) at trigger.c:974
#7 0x80d5852 in DeferredTriggerExecute (event=0x833801c, itemno=0,
rel=0x82f5494, finfo=0x82dd01c, per_tuple_context=0x83342d8)
at trigger.c:1497
#8 0x80d5a5f in deferredTriggerInvokeEvents (immediate_only=1 '\001')
at trigger.c:1620
#9 0x80d5c29 in DeferredTriggerEndQuery () at trigger.c:1775
#10 0x8136d57 in finish_xact_command () at postgres.c:894
#11 0x8136c25 in pg_exec_query_string (query_string=0x82d701c, dest=Remote,
parse_context=0x82818ac) at postgres.c:827
#12 0x8137e19 in PostgresMain (argc=6, argv=0xbfbfccb4,
username=0x825f925 "root") at postgres.c:1924
#13 0x811cad2 in DoBackend (port=0x825f800) at postmaster.c:2276
#14 0x811c3f9 in BackendStartup (port=0x825f800) at postmaster.c:1908
#15 0x811b5af in ServerLoop () at postmaster.c:993
#16 0x811b132 in PostmasterMain (argc=4, argv=0x825a040) at postmaster.c:774
#17 0x80f4ee5 in main (argc=4, argv=0xbfbfd4c0) at main.c:209
#18 0x8069880 in ___start ()

The definition of trans had:
Triggers: RI_ConstraintTrigger_14413070,
RI_ConstraintTrigger_14413073

I was inserting meter_id=411, stats_id=currval('stats_id_seq')
meter.id=411 exists. Hard to tell about the other one.. Still don't see
why this ever worked..

Cheers,

Patrick