Re: Bug in Dependencies Code in 7.3.x? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Bug in Dependencies Code in 7.3.x?
Date
Msg-id 200212311804.gBVI4h324893@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug in Dependencies Code in 7.3.x?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I get it, mutual dependency because they are both droppable. Added to
TODO:
* Have DEFAULT dependency track use of sequence, for DROP DEFAULT check

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom Lane wrote:
> >> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >>> Seems this is already a TODO:
> >>> * Have sequence dependency track use of DEFAULT sequences, seqname.nextval
> >> 
> >> That's related but not the same issue.
> 
> > Related in that ALTER TABLE DROP DEFAULT _doesn't_ see a dependancy for
> > sequences in a DEFAULT?
> 
> Even if the dependency generator understood about nextval, it would
> generate a dependency from the expression to the sequence, not vice
> versa --- ie, the system would prevent you from dropping the sequence
> without dropping the default expression.  It would not prevent ALTER
> TABLE DROP DEFAULT, which is what's at issue here.
> 
>             regards, tom lane
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL Password Cracker
Next
From: Oliver Elphick
Date:
Subject: Re: PostgreSQL Password Cracker