ddl - how to create a new column in postgresql UDR database -
i need able create new column in existing table in database has been set use postgresql udr. i've read, cannot run ddl commands in bdr unless write syntax in specific way... example, found post on stackoverflow:
django 1.8 migration postgres bdr 9.4.1
i've tried follow similar udr setup... it's not working me.
specifically, i've tried following:
mydatabase=# alter table mytable add column newcolumn character varying(50) not null default 'boo'; error: alter table ... add column ... default may affect unlogged or temporary tables when bdr active; mytable regular table
and this:
mydatabase=# alter table mytable add column newcolumn character varying(50); error: no peer nodes or peer node count unknown, cannot acquire ddl lock hint: bdr still starting up, wait while mydatabase=#
are allowed run ddl commands in udr setup? if has tips, i'd appreciate it. thanks.
Comments
Post a Comment