Ken Winter wrote:
How can a column’s default be set to ‘now’, meaning ‘now’ as of when each row is inserted?For example, here’s a snip of DDL:create table personal_data (… effective_date_and_time TIMESTAMP WITH TIME ZONE not null default 'now',…
try with now(), instead of now ... effective_date_and_time TIMESTAMPTZ not null default now()... ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
