Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1K3c1E98380 for ; Tue, 19 Feb 2002 22:38:01 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 698098; Tue, 19 Feb 2002 19:38:03 -0800 From: "Josh Berkus" Subject: Re: Issues w/ 7.1 to 7.2 upgrade. To: "Diehl, Jeffrey" , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Tue, 19 Feb 2002 19:38:03 -0800 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/247 X-Sequence-Number: 6671 Mike, > I just upgraded from 7.1 to 7.2, mainly because of the facts that > vacuum > doesn't do table locks and I thought that "replace into" would be in > 7.2. > > Anyway, I don't see that "replace into" is there... Nope. I hadn't had the impression from the list traffic that the developers ever considered letting in this bit of non-standard SQL. While it's undoubtedly useful, it's not in the SQL 92 spec and a *lot* of extra programming would be required to support it (for example, those of us who use UPDATE and INSERT triggers might find ourselves re-writing them all). Remember: If you really, really want "replace into", Postgres *is* an open-source database. You are always welcome to hack your own "replace into" patch. > Also, I noticed a slight difference that caught me off guard: > > If I try to insert '1234567890' into a varchar(5) under 7.1, the > value of > the field will be '12345'. > > If I try it under 7.2, I get an error. Another annoying change per the spec, I believe. Personally, this change made me happy because unexpected truncations had previously escaped my notice. But it did lead to a spate of emergency bug fixes in my code. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco