Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx> writes: > In a PL/PgSQL function I have the following: > ---- > execute $l2$ > alter table $l2$||ct||$l2$ add check( > data>=$1::timestamp and data<$2::timestamp and maga=$3 ) > $l2$ using rec.d0,rec.d1,rec.maga; > ---- > which yields to this error messsge: > ERROR: there is no parameter $1 You can't use a parameter of the function in a CHECK constraint on a table. The CHECK constraint is permanent and can't refer to transient state like that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
