Re: [Info-Ingres] alter table alter column weirdness
This is a discussion on Re: [Info-Ingres] alter table alter column weirdness within the Ingres forums, part of the Database Server Software category; --> Martin, Was the ingres version different between the two? Is there data in one? Have you done previous alters ...
| |||||||
![Re: [Info-Ingres] alter table alter column weirdness](http://www.unixadmintalk.com/iconimages/ingres/re-info-ingres-alter-table-alter-column-weirdness_ltr.gif)
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 10:57 PM
| ||||
| ||||
 Re: [Info-Ingres] alter table alter column weirdness Martin, Was the ingres version different between the two? Is there data in one? Have you done previous alters on one or both? Robert On Thu, 2007-07-19 at 14:55 +0100, martin.bowes@ctsu.ox.ac.uk wrote: > Hi Robert > > What was the column originally? > In both cases it was: varchar(20) not null not default > > > > At present it is not permissible to amend the column's default or > > nullness after it has been created, so if it wasn't already "not > null > > not default" then you would get that error. > > > Then why did it work on one table and not the other? > > > Furthermore the manual explicitly states that the alter > column will 'Change a column from not null to null' > > > Marty      |
 |
« Re: [Info-Ingres] alter table alter column weirdness
|
[Info-Ingres] Lydia_document_28021_1892.pdf »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:23 AM.
