"Devinder K Rajput" <Devinder.Rajput@ipaper.com> writes:
>> CREATE TABLE table (serial_no VARCHAR[16] PRIMARY KEY, date date DEFAULT
>> current_date)
>> ERROR: Can't find a default operator class for type 1015
> use VARCHAR(16) and not VARCHAR[16].
Also, consider updating to a more recent version of Postgres. It's been
a very long time since that error message gave a numeric type OID. In
7.2 and later I get
regression=# CREATE TABLE ztable (serial_no VARCHAR[16] PRIMARY KEY);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ztable_pkey' for table 'ztable'
ERROR: data type character varying[] has no default operator class for access method "btree"
You must specify an operator class for the index or define a
default operator class for the data type
which at least gives you some shot at realizing that you've specified an
array type ...
regards, tom lane