pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas Good <tomg@admin.nrnet.org>
To: Diehl, Jeffrey <jdiehl@sandia.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: Issues w/ 7.1 to 7.2 upgrade.
Date: Wed, 20 Feb 2002 08:11:11 -0500 (EST)
Message-ID: <Pine.LNX.4.05.10202200807540.18761-100000@admin.nrnet.org> (raw)
In-Reply-To: <B51F0C636E578A4E832D3958690CD73E0130C20A@es04snlnt>

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
------------------------------------------------------------------------
 






view thread (3+ messages)

Message-ID: <Pine.LNX.4.05.10202200807540.18761-100000@admin.nrnet.org>
Permalink:  ../Pine.LNX.4.05.10202200807540.18761-100000@admin.nrnet.org/
Also on:    postgresql.org/message-id/Pine.LNX.4.05.10202200807540.18761-100000@admin.nrnet.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tomg@admin.nrnet.org, jdiehl@sandia.gov
  Subject: Re: Issues w/ 7.1 to 7.2 upgrade.
  In-Reply-To: <Pine.LNX.4.05.10202200807540.18761-100000@admin.nrnet.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox