Received: from lists.unixathome.org (lists.unixathome.org [210.48.103.158]) by postgresql.org (Postfix) with ESMTP id C5859476148; Mon, 4 Mar 2002 15:50:46 -0500 (EST) Received: from wocker (lists.unixathome.org [210.48.103.158]) by lists.unixathome.org (8.11.6/8.11.6) with ESMTP id g24Kogk80096; Tue, 5 Mar 2002 09:50:42 +1300 (NZDT) (envelope-from dan@lists.unixathome.org) Message-Id: <200203042050.g24Kogk80096@lists.unixathome.org> From: "Dan Langille" Organization: DVL Software Limited To: Tom Lane Date: Mon, 4 Mar 2002 15:50:39 -0500 MIME-Version: 1.0 Subject: Re: Uniqueness of rule, constraint, and trigger names Reply-To: dan@langille.org Cc: pgsql-hackers@postgreSQL.org, pgsql-sql@postgreSQL.org References: <200203042043.g24Khek80028@lists.unixathome.org> In-reply-to: <7683.1015274872@sss.pgh.pa.us> X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Archive-Number: 200203/44 X-Sequence-Number: 6926 On 4 Mar 2002 at 15:47, Tom Lane wrote: > "Dan Langille" writes: > > It would be easily detected at load time. Then you direct the user to > > the tool mentioned above. > > But if the user has already dumped and flushed his old installation, > he's still in need of a time machine. Agreed. I had that same problem with upgrading to 7.2. My solution was to install 7.1.3 on another box, load, massage, dump. Next time, I'll keep the old version around a bit longer. > Hmm, maybe what we need is a tool that can be applied during load. > Essentially, alter incoming constraint names as needed to make them > unique. We could have this enabled by a SET switch... I think that is an eloquent solution. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples