CREATE TABLE "ad" (
"id" int4 NOT NULL,
"owner" int4 NOT NULL,
"value1" int4 DEFAULT 0,
"value2" int4 DEFAULT 0,
"kind" int2 DEFAULT 0,
"filename" character varying(300),
"target" int8 DEFAULT 0,
"mask" int8 DEFAULT 0,
"freq" int2 DEFAULT 0,
"cond" int2 DEFAULT 0,
"register" date,
"resign" date,
"sign" date,
"max" int2 DEFAULT 0,
"enable" bool DEFAULT 0,
"name" character varying(50),
"ad_url" character varying(50));
ERROR: Attribute 'enable' is of type 'bool' but default expression is of type '
int4'
You will need to rewrite or cast the expression
|