Re: Bug in ALTER COLUMN SET DATA TYPE ?
Pavan Deolasee <pavan.deolasee@gmail.com>
From: Pavan Deolasee <pavan.deolasee@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nikhil Sontakke <nikkhils@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-11-02T15:58:34Z
Lists: pgsql-hackers
On Fri, Nov 2, 2012 at 9:09 PM, Pavan Deolasee <pavan.deolasee@gmail.com>wrote: > > > I also though that for a moment, but the commit that I mentioned did not > move that error message from somewhere else. I also tested by resetting > to commit 1f0363001166ef6a43619846e44cfb9dbe7335ed (previous to the > offending commit) and don't see any error. > > But since you're seeing it, may it was taken out by some other older > commit and then added back again. Will look more into it > > Here is more trace: The error message was first added by: commit cd902b331dc4b0c170e800441a98f9213d98b46b Author: Tom Lane <tgl@sss.pgh.pa.us> Date: Fri May 9 23:32:05 2008 +0000 It was then removed by: commit 61d81bd28dbec65a6b144e0cd3d0bfe25913c3ac Author: Alvaro Herrera <alvherre@alvh.no-ip.org> Date: Mon Dec 5 15:10:18 2011 -0300 And then again added back by: commit 09ff76fcdb275769ac4d1a45a67416735613d04b Author: Alvaro Herrera <alvherre@alvh.no-ip.org> Date: Fri Apr 20 23:46:20 2012 -0300 So coming back to the issue, do you think it's a good idea to teach ATAddCheckConstraint() that the call is coming from a late phase of ALTER TABLE ? Thanks, Pavan
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Recast "ONLY" column CHECK constraints as NO INHERIT
- 09ff76fcdb27 9.2.0 cited
-
Adjust join_search_one_level's handling of clauseless joins.
- 1f0363001166 9.2.0 cited
-
Allow CHECK constraints to be declared ONLY
- 61d81bd28dbe 9.2.0 cited
-
Change the rules for inherited CHECK constraints to be essentially the same
- cd902b331dc4 8.4.0 cited