default value giving me errors

[keak]

Hi there,
I have set the default value of my "corss_ref" table's "id" field to

nextval(('cross_ref_id_seq'::text)::regclass)

However, when I try to do an insert on this corss_reff table, its givning me the error, saying that relation cross_ref_id_seq doesn't exist.

Is there anything that I am doing wrong here?
I am trying to autoincrement this id field.....

Thanks!

 

[ceco]

and are you sure it really exists?

why don't you create it as SERIAL, thus it will create automaticly the sequence and the default value (or you are using old version)