Received: from mail1.panix.com (mail1.panix.com [166.84.0.212]) by postgresql.org (8.11.6/8.11.4) with ESMTP id g1KDBqF11824 for ; Wed, 20 Feb 2002 08:11:53 -0500 (EST) (envelope-from tomg@admin.nrnet.org) Received: from mailhost.nrnet.org (unknown [166.84.192.39]) by mail1.panix.com (Postfix) with ESMTP id D940548787; Wed, 20 Feb 2002 08:11:54 -0500 (EST) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.11.4/8.11.4) with UUCP id g1KD2hH18140; Wed, 20 Feb 2002 08:02:43 -0500 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id IAA18942; Wed, 20 Feb 2002 08:11:11 -0500 Date: Wed, 20 Feb 2002 08:11:11 -0500 (EST) From: Thomas Good To: "Diehl, Jeffrey" Cc: pgsql-sql@postgresql.org Subject: Re: Issues w/ 7.1 to 7.2 upgrade. In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200202/253 X-Sequence-Number: 6677 On Tue, 19 Feb 2002, Diehl, Jeffrey wrote: > Hi all. > > 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... Hi Mike, I'm anxiously awaiting DROP COLUMN (rather than using the workaround of SELECTing desired attributes into a new relation, dropping the old rel and renaming the new...) I was hoping it would be in 7.2 but not yet. :-( > 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. I found this in using 7.2 beta - it mimics Oracle's response to a string that exceeds the len of the attribute. I kinda liked the unstated substr() behaviour. But I guess it was a bit sloppy. ------------------------------------------------------------------------ Thomas Good tomg@admin.nrnet.org Programmer/Analyst thomas@sqlclinic.net Residential Services, Behavioral Health Services Saint Vincent Catholic Medical Centers -- SQL Clinic - An Open Source Clinical Record www.sqlclinic.net ------------------------------------------------------------------------