On Tue, Mar 20, 2012 at 2:48 PM, Tom Lane t...@sss.pgh.pa.us wrote:
I think Tom's correct about what the right behavior would be if
composite types supported defaults, but they don't, never have, and
maybe never will. I had a previous argument about this with Tom, and
lost, though I am not
On Wed, Mar 7, 2012 at 3:49 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Mar 7, 2012 at 2:31 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell mike.blackw...@rrd.com
wrote:
alter table a add column
Robert Haas robertmh...@gmail.com writes:
On Wed, Mar 7, 2012 at 3:49 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Mar 7, 2012 at 2:31 PM, Tom Lane t...@sss.pgh.pa.us wrote:
It is not a bug. The ALTER ADD ... DEFAULT ... form implies rewriting
every existing tuple of the rowtype to
On Tue, Mar 20, 2012 at 12:16 PM, Robert Haas robertmh...@gmail.com wrote:
I think Tom's correct about what the right behavior would be if
composite types supported defaults, but they don't, never have, and
maybe never will. I had a previous argument about this with Tom, and
lost, though I am
On Wed, Mar 7, 2012 at 2:49 PM, Merlin Moncure mmonc...@gmail.com wrote:
On a practical level, the error blocks nothing -- you can bypass it
trivially. It's just an annoyance that prevents things that users
would like to be able to do with table row types. So I'd argue to
remove the check,
Not a bad idea. I'd need to convert existing data, but it'd be an excuse
to try out hstore. ^_^
Mike
* mike.blackw...@rrd.com*
On Thu, Mar 8, 2012 at 11:08, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Mar 7, 2012 at 2:49 PM, Merlin Moncure mmonc...@gmail.com wrote:
On a practical
Merlin Moncure mmonc...@gmail.com writes:
On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell mike.blackw...@rrd.com
wrote:
alter table a add column even_more_stuff boolean not null default false;
aha! that's not what you posted last time. you appended 'not null
default false'; which
Excerpts from Tom Lane's message of mié mar 07 17:31:32 -0300 2012:
This probably could be done for rowtype columns as well, but nobody has
collected the necessary round tuits. I think there was some fear of
locking/deadlock issues, too.
It's probably easy to do if you require it to be
On Wed, Mar 7, 2012 at 2:31 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
On Wed, Mar 7, 2012 at 11:45 AM, Mike Blackwell mike.blackw...@rrd.com
wrote:
alter table a add column even_more_stuff boolean not null default false;
aha! that's not what you posted