Hi,
I upgraded recently DB and found that some columns with type "timestamp"
changed default values from now() to:
receipt_date | timestamp with time zone | not null default
'2004-09-29 09:58:03.010678+10'::timestamp with time zone
,where time is a time when psql -U postgres template1 <
Thank you very much.
This works:
UPDATE
test
SET
code=T2.code
FROM
test T2
WHERE
test.code=0 AND
test.master=T2.name;
Igor
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
I have table:
# \d category;
category_id | integer| not null default
nextval('public.category_category_id_seq'::text)
category_name | character varying(100) | not null
Indexes: category_pkey primary key btree (category_id)
My goal is to remove sequence from category_id
