| 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: | Whole Thread | Raw Message | 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'');';
| 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 |