Skip site navigation (1) Skip section navigation (2)

Re: Altering column collation

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Altering column collation
Date: 2011-07-21 20:58:53
Message-ID: 1311281934.19329.29.camel@laptop (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Thu, 2011-07-21 at 22:54 +0200, Guillaume Lelarge wrote:
> On Thu, 2011-07-21 at 21:44 +0200, Guillaume Lelarge wrote:
> > On Wed, 2011-07-20 at 10:56 +0100, Thom Brown wrote:
> > > On 19 July 2011 21:04, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> > > > On Tue, 2011-07-19 at 20:43 +0100, Thom Brown wrote:
> > > >> On 19 July 2011 08:32, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> > > >> > On Tue, 2011-07-19 at 00:48 +0100, Thom Brown wrote:
> > > >> >> [...]
> > > >> >> Attached is a patch which fixes #328.  Currently if you change a
> > > >> >> column's collation, it actually drops the column.  This changes it so
> > > >> >> that it issues an ALTER TYPE to adjust the collation instead.
> > > >> >>
> > > >> >
> > > >> > Pushed on master. Thanks for yet another patch :)
> > > >> >
> > > >> > I didn't push it on 1.14 yet. The patch doesn't work here, and I guess
> > > >> > it's because I didn't push your previous patch. I'm not sure on the best
> > > >> > move here. Should we simply remove the bug (no change detected when
> > > >> > changing collation on the column properties dialog)? or should we apply
> > > >> > both patches (which will give us bugfix, and better handling of
> > > >> > columns)? Any ideas?
> > > >>
> > > >> Why can't we apply the patch to 1.14?  I don't recall making any
> > > >> previous changes to dlgColumn.cpp.  I just switched to 1.14,
> > > >> fast-forwarded all updates, applied the patch, built it, and it
> > > >> behaves correctly.
> > > >>
> > > >
> > > > We could apply it, but it doesn't work. I guess you did changes on
> > > > "Prevent duplicate members' names in a composite type" that are needed
> > > > for "Fix weird behaviour when changing column's collation" to make it
> > > > work.
> > > 
> > > It seems to work if you go to the table properties and edit the
> > > columns from there, but not if you go into the column directly.  I
> > > tried making a change to detect the collation drop-down change, but
> > > for some reason it either still doesn't pick it up at all, or doesn't
> > > show the initial "-- nothing to change" in the SQL tab, but in that
> > > latter case it does show the correct SQL when changing collation.  I'm
> > > not sure what's going on there.
> > > 
> > 
> > Same problem here. Both on 1.14 and master. Seems like I commit a wrong
> > patch. My bad. Trying to fix it now.
> > 
> 
> Fixed.
> 

And thanks, Thom, for the original patch :)


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


In response to

Responses

pgadmin-hackers by date

Next:From: Thom BrownDate: 2011-07-21 21:03:54
Subject: Re: Altering column collation
Previous:From: pgAdmin TracDate: 2011-07-21 20:55:44
Subject: Re: [pgAdmin III] #328: Column collation change has no effect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group