Setting a default for nextval sequence

From: Robert Lakes <robertl(at)propaas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Setting a default for nextval sequence
Date: 2017-11-27 19:13:08
Message-ID: CAHnqRj0_nsLQDitnF1_66ExfsKFCfNcDH0k_4nEeKFw_-O3Xzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm attempting to set the default value for a serial column. I created a
generic function that I am passing a table name as the only parameter. I
had it working correctly, however, it does not seem to like the sequence
name being the same name for each audit table that is created through the
function.
So I changed the code to include the table name as part of the naming
convention. Now, I need help on how to alter the serial column the new
value

EXECUTE 'CREATE SEQUENCE '|| t_name ||'tab_id_seq'|| ' OWNED BY '|| t_name
|| '_cdc'||'.table_id';

EXECUTE 'ALTER TABLE ' || quote_ident(t_name || '_cdc') || ' ALTER
COLUMN table_id SET DEFAULT nextval(''tab_id_seq'');';

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-11-27 19:16:25 Re: ERROR: too many dynamic shared memory segments
Previous Message Thomas Munro 2017-11-27 18:53:46 Re: ERROR: too many dynamic shared memory segments