[Info-Ingres] alter table alter column weirdness

Hi Everyone,

I'm running II 9.0.4 (a64.lnx/105)NPTL + p12125

I have two databases, one being a test version of the other. These are
copies of each other and both exist on the same Ingres installation.

In one table within each database I wish to change a column from not
null to nullable. The column is not part of any key on the table, there are
no secondary indexes on the table, there are no constraints on the
table.

So I did:
alter table odin_postal_reply alter column dob_str varchar(20) with
null not default;

This worked without a problem on the test version of the database. But
fails on the production version with error:
E_US0F13 ALTER TABLE: invalid change of attributes on an ALTER
COLUMN

I have confirmed the table has 4k page size in both, it is a journaled
table in both databases.

Anyone got any ideas what I've done wrong?

Martin Bowes
--
Random Farscape Quote #32:
John - I don't believe I've left a Nuclear bomb on an elevator.
Chiana - You've done worse.


Relevant Pages

  • Re: [Info-Ingres] alter table alter column weirdness
    ... the databases are both in the same Ingres Installation. ... My suspicion is now that someone has altered the table in the test ... alter table x alter column a varcharwith null not default\g ...
    (comp.databases.ingres)
  • Re: changing collations
    ... > We have around 150 databases as case sensitive, ... If you want to use ALTER TABLE, I think you still need to script all ... ALTER TABLE ALTER COLUMN command. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Field msrepl_tran_version added
    ... ALTER TABLE Client ... > immediate updating or queued updating publications. ... >> I've create transacional replication from two databases. ...
    (microsoft.public.sqlserver.replication)
  • RE: stored proc to access multiple databases
    ... > The problem I have is I cannot figure out how to insert a return character ... > the structure the same across all databases. ... > use dynamic SQL and alter the views. ... I would like to create one procedure that would alter all of the ...
    (microsoft.public.sqlserver.programming)