Date: Tue, 3 Jan 2017 13:48:29 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has
 wrong type
Message-ID: <20170103194829.GS32031@telsasoft.com>
References: 
 <CALcU3kLseKzasSpnAhA7zQgd6Oebhqmb3SS-dPWA2R-K=TbGgw@mail.gmail.com>
 <20161012152505.GD12747@telsasoft.com>
 <20170102225618.GA10071@telsasoft.com>
 <20170103003240.GM32031@telsasoft.com>
 <CA+TgmoY9W99m3cW9-4Kjnw4KO+PRqF8Lh_AqWh8Qoop9ZhnUdw@mail.gmail.com>
 <20170103165903.GP32031@telsasoft.com>
 <CA+TgmobAT992nxV=6kqnpF=LK493oNdf2dzXJX-Yz+=LWZ-_AA@mail.gmail.com>
 <20170103185742.GQ32031@telsasoft.com>
 <28476.1483471956@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <28476.1483471956@sss.pgh.pa.us>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On Tue, Jan 03, 2017 at 02:32:36PM -0500, Tom Lane wrote:
> 3. It's pretty hard to see how you'd reach any of these places for an
> ALTER COLUMN TYPE on a simple table.  Has the table got rules, triggers,
> default values?  Could we see "\d+" output for it?

I really meant to do \d+..

                                       Table "public.eric_umts_rnc_utrancell_metrics"
                   Column                    |           Type           | Modifiers | Storage  | Stats target | Description 
---------------------------------------------+--------------------------+-----------+----------+--------------+-------------
 sect_id                                     | integer                  | not null  | plain    | 400          | 
 start_time                                  | timestamp with time zone | not null  | plain    | 400          | 
 site_id                                     | integer                  | not null  | plain    | 400          | 
 interval_seconds                            | smallint                 | not null  | plain    | 200          | 
 utrancell                                   | text                     | not null  | extended | 200          | 
 nedn                                        | text                     | not null  | extended | 200          | 
 rnc_id                                      | integer                  | not null  | plain    | 400          | 
 device_id                                   | integer                  | not null  | plain    | 200          | 
 pmcelldowntimeauto                          | smallint                 |           | plain    | 10           | 
 pmcelldowntimeman                           | smallint                 |           | plain    | 10           | 
[...]

Justin


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers