Op 19-12-09 22:20, Jaime Casanova schreef:
are you planning to run this many times? what is wrong with making
this manually?
doesn't seem like something to make automatic...
but if you insist in plpgsql you can execute "select version() into
some_text_var" and act acordingly
No, this is don
On Sat, Dec 19, 2009 at 4:07 PM, Antonio Goméz Soto
wrote:
> Hi,
>
> is there a way in sql to dynamically test for version 7.3, so I can run the
>
are you planning to run this many times? what is wrong with making
this manually?
doesn't seem like something to make automatic...
but if you insist
Hi,
is there a way in sql to dynamically test for version 7.3, so I can run the
alter table add column
update table set column = .. where column IS NULL;
alter table alter column set not null
on 7.3, and on newer versions:
alter table add column ... not null default '';
Maybe I can cr
Op 17-12-09 23:46, Tom Lane schreef:
This is just one of many many things that could be improved by getting
off of 7.3. In general, complaining about performance (or features)
of a seven-year-old, long since EOL'd release is not a productive use of
anybody's time.
I'm sorry, didn't mean to
Thomas Kellerer writes:
> What's wrong with:
> alter table person add column address varchar(64) not null default '';
This:
regression=# alter table person add column address varchar(64) not null default
'';
ERROR: Adding columns with defaults is not implemented.
Add the column, then u
Antonio Goméz Soto wrote on 17.12.2009 22:26:
Hi,
I am regularly altering tables, adding columns setting default values etc.
This very often takes a very long time and is very disk intensive, and this
gets pretty annoying.
Things are hampered by the fact that some of our servers run PG 7.3
Sup
On Thursday 17 December 2009, Antonio Goméz Soto
wrote:
> Hi,
>
> I am regularly altering tables, adding columns setting default values
> etc. This very often takes a very long time and is very disk intensive,
> and this gets pretty annoying.
>
> Things are hampered by the fact that some of our s
Hi,
I am regularly altering tables, adding columns setting default values etc.
This very often takes a very long time and is very disk intensive, and this
gets pretty annoying.
Things are hampered by the fact that some of our servers run PG 7.3
Suppose I have a table and I want to add a non NUL
