Re: alter column appears to work, but doesn't?

On Monday, September 05, 2011 1:48:58 pm Ron Peterson wrote:
> 2011-09-05_16:14:00-0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> > Ron Peterson <rpeterso(at)mtholyoke(dot)edu> writes:
> > > I just dropped my logging rules, stopped the database and restarted it,
> > > put my rules back in place, and now it works. Not sure why. Cached
> > > query plan?
> >
> > Maybe. We'd need a reproducible test case to do more than speculate
> > though.
>
> Hi Tom,
>
> I was able to reproduce this. DDL below. Probably more DDL than
> necessary, but not sure what is or isn't relevant.
>
> postgres=# drop rule attribute_insert_rule on attributes;
> postgres=# drop rule attribute_update_rule on attributes;
> postgres=# drop rule attribute_delete_rule on attributes;
> postgres=# alter table attributes_log alter column attribute_name type
> varchar(50); ...then recreate rules below
> postgres=# insert into attributes values ( repeat( 'x', 49 ) );
> ERROR: value too long for type character varying(48)
>
>

I am not seeing where you change the varchar length in the table attributes.
That is where the error is coming from.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com