Re: [GENERAL] Non-unique values problem after 'add column'

2007-11-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > I've encountered a very strange problem with Postgresql 7.3. 7.3.what? FWIW, I cannot replicate your problem using 7.3.20. It doesn't sound like any bug I can remember, but certainly there have been a lot of bugs fixed over the past five years.

Re: [GENERAL] Non-unique values problem after 'add column'

2007-11-27 Thread Scott Marlowe
On Nov 26, 2007 3:06 AM, <[EMAIL PROTECTED]> wrote: > Hello! > > I've encountered a very strange problem with Postgresql 7.3. > I have the following set of queries running in transaction, using > libpqxx 2.6.9: 7.3 is getting pretty old. I can't say anything though, I've still got a 7.4 db hangi

[GENERAL] Non-unique values problem after 'add column'

2007-11-27 Thread dima . kagan
Hello! I've encountered a very strange problem with Postgresql 7.3. I have the following set of queries running in transaction, using libpqxx 2.6.9: ALTER TABLE my_table ADD new_column TEXT UPDATE my_table SET new_column = 'disable' ALTER TABLE my_table ALTER COLUMN new_column SET DEFAULT 'disabl