Resent-From: alvherre@dcc.uchile.cl
Resent-Date: Wed, 2 Feb 2005 22:09:43 -0300
Resent-Message-ID: <20050203010943.GA16075@dcc.uchile.cl>
Resent-To: pgsql-hackers@postgresql.org
Message-ID: <42016727.3020107@commandprompt.com>
Date: Wed, 02 Feb 2005 15:49:59 -0800
From: "Joshua D. Drake" <jd@commandprompt.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@dcc.uchile.cl>
Subject: Re: pg_dump bug in 7.3.9 with sequences
References: <42013187.7040806@commandprompt.com>
	<6686.1107379308@sss.pgh.pa.us>
	<42014C28.1070300@commandprompt.com>
	<20050202220404.GC1967@dcc.uchile.cl>
In-Reply-To: <20050202220404.GC1967@dcc.uchile.cl>
Content-Type: multipart/mixed; boundary="------------040604080101030907050502"

This is a multi-part message in MIME format.
--------------040604080101030907050502
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Alvaro Herrera wrote:

>On Wed, Feb 02, 2005 at 01:54:48PM -0800, Joshua D. Drake wrote:
>
>  
>
>>It is not pilot error if PostgreSQL allows it. There is
>>nothing "illegal" about the above commands in their execution.
>>The pg_dump application should recognize that the object has
>>changed and react accordingly.
>>    
>>
>
>ISTM this is a bug, but it's not clear to me what is the solution.
>I can think of two:
>
>1. Changing the default is forbidden
>2. When the default is changed, the dependency on the sequence is
>dropped, and the sequence itself is dropped.
>  
>
3. When the default is changed, the dependency is updated
to reflect the new sequence. The old sequence is left intact
as an independent object.

Sincerely,

Joshua D. Drake


>Which one do you think is best?  Why?  (I'd say "less bad" instead of
>"best", but I'm not sure if that's a correct choice of words.)
>
>  
>


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


--------------040604080101030907050502
Content-Type: text/x-vcard; charset=utf-8;
 name="jd.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="jd.vcf"

begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard


--------------040604080101030907050502--