Subject Re: [firebird-support] Problem with renaming a column
Author Sławek Cabaj
All field names in the table are in upper case. I tried to change other column
names and they changed succesfully. The only one is so vicious.

In the table rdb$relation_fields it's visible and uppercase
select * from rdb$relation_fields where rdb$field_name = 'INVOICE_DATE' and
rdb$relation_name = 'VEHICLES'

it looks like there were at the begining triggered a phantom not commited
transaction and then a second one which doesn't see the field

From: Svein Erling Tysvær <svein.erling.tysvaer@...>
To: "" <>
Sent: Mon, December 13, 2010 11:49:23 AM
Subject: RE: [firebird-support] Problem with renaming a column

Hi Slawek!

A wild guess: Maybe your table is defined case sensitive? If it is created like

CREATE TABLE Vehicles(Invoice_Date Date);

then it is case insensitive, the column name is stored in upper case and your
alter statement should work. However, if it is created like this:

CREATE TABLE Vehicles("Invoice_Date" Date);

then it is case sensitive and you have to modify your alter statement to:

alter table VEHICLES alter column "Invoice_Date" to INVOICE_DATE_2; commit;


-----Original Message-----
From: []
On Behalf Of Sławek Cabaj
Sent: 13. desember 2010 10:47
To: firebird-support
Subject: [firebird-support] Problem with renaming a column

Hello again,
One more, perhaps not complicated :) problem

When I want to change a column name

alter table VEHICLES alter column INVOICE_DATE to INVOICE_DATE_2; commit;


column INVOICE_DATE is not defined in table VEHICLES

But it is still there
I've recreated the database from a copy but it did not help :(
The table is empty.




Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links

[Non-text portions of this message have been removed]