Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> I get the following error while trying to create a table:
> JC=# create table test (t timestamp[0] default current_timestamp(0));
> ERROR: Column "t" is of type timestamp without time zone[] but default
> expression is of type timestamp with time zone You will need to rewrite
> or cast the expression
Square brackets mean an array. I think you meant timestamp(0).
regards, tom lane