help postgres

Hy,



I need some help in Postgres, my problem :

I've got a script in which there is :

create sequence num_fa;

create table hst_fa(
id_ori__nom text,
id_ori char(12),
nom char(32),
number int4 not null default nextval('num_fa'),
comment text,
id_f char(8),
gr char(1),
type char(8),
date_app timestamp,
date_cor timestamp,
corrige text,
primary key(id_ori__nom,date_app)
);


I must have date_app in primary key because number is not enought.


Postgres message is :

NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'hst_fa_pkey' for table 'hst_fa'
ERROR: Can't find a default operator class for type 1296.


I've got for example many queries with "INSERT INTO ...." for the database.
If I already had the same queries I want to stop the "INSERT ..." and read the following queries to apply it on the
database.


should I use �cast� to write this in the script :


create table hst_fa(
id_ori__nom text,
id_ori char(12),
nom char(32),
number int4 not null default nextval('num_fa'),
comment text,
id_f char(8),
gr char(1),
type char(8),
date_app timestamp,
date_cor timestamp,
corrige text,
primary key(id_ori__nom, select d (cast date_app as text))
);



thanks

Pe

____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap.