Re: Foreign key bugs + other problems

Bruce Momjian wrote:
> > > Or, you might be able to make a case that you CANNOT shadow a table
> > > that is referenced by a constraint (due to the permanent table constraints
> > > cannot reference a temporary table restriction). Since the creation of
> > > the temp table would break the restriction, it is illegal.
> >
> > Good point. What does the standard say about it? Can a table,
> > referred to by foreign key constraints or referential
> > actions, be shadowed by a temp table?
>
> Maybe we should prevent shadowing of a table that is used as a foreign
> key.

And open another DOS attack possibility? Each user could
potentially create a permanent table of a name used as a temp
table somewhere inside of an application. Then create another
referencing it and boom - the application goes down. Not that
good IMHO.

I think we need to hand OID's to the RI triggers and have
some special syntax to tell the parser that a table or
attribute is named by OID in the actual query.

Will cause alot of headaches for the next pg_dump/restore
cycle.

(Bruce: still waiting for your call)

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #