Re: [BUGS] ecpg -D SYMBOL

2004-07-22 Thread Luke McFarlane
Defining things twice - once in 'SQL' space and once in 'C' space is something I struggled with when using Informix ESQL/C. I like the idea of having it apply to both. Although if you are to support INFORMIX or INFORMIX_SE mode in ecpg you will need limit it to 'SQL' space (for these modes anyw

Re: [BUGS] adding a primary key column to a temporary table fails

2004-07-22 Thread Frank van Vugt
> The issue here is the not-nullness of a new column which isn't supported > in 7.4 (it appears to be in 7.5). I grok. > > By the way, I noticed that the todo-list does not mention 'alter table > > alter column set/drop primary key'. I'm wondering whether it should? > > ALTER TABLE ADD CONSTRAINT

Re: [BUGS] adding a primary key column to a temporary table fails

2004-07-22 Thread Stephan Szabo
On Thu, 22 Jul 2004, Frank van Vugt wrote: > (verify whether temporary tables do support primary keys) > # create temp table f_test (id int primary key, value varchar(20)); > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "f_test_pkey" > for table "f_test" > CREATE TABLE > > # drop

[BUGS] adding a primary key column to a temporary table fails (v7.4.3)

2004-07-22 Thread Frank van Vugt
Hi, I guess this might not be the appropriate thing to be happening: # select version(); version - PostgreSQL 7.4.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 (1 row) (verify whether temp