Is this a bug?

As demonstrated below, a table can be created with data type "timestamp" as a column name.

This causes a subsequent issue when creating triggers.

Shouldn't the table create throw a "ORA-00904: : invalid identifier" error?

create sequence seq;

create table test (

   col1 number,
   timestamp timestamp
 )
/

create or replace trigger trg

   before insert on test
   for each row
   begin

      select seq.nextval into :new.col1 from dual;    end;
/

alter table test rename column timestamp to ts
/

create or replace trigger trg

   before insert on test
   for each row
   begin

      select seq.nextval into :new.col1 from dual;    end;
/
Received on Wed Jan 03 2007 - 13:46:13 CST