Re: pgsql: Allow units to be specified in relation option setting value.

On Thu, Aug 28, 2014 at 9:28 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> Oh,, will check.

That's a problem with pg_dump not able to put quotes where for a
reloption units are used.
For example this table:
create table test (a int) with (autovacuum_vacuum_cost_delay = '80ms');
Results in the following dump:
CREATE TABLE test (
    a integer
)
WITH (autovacuum_vacuum_cost_delay=80ms);

Because of how reloptions is registered in pg_class:
=# select relname,reloptions from pg_class where relname = 'test';
 relname |             reloptions
---------+-------------------------------------
 test    | {autovacuum_vacuum_cost_delay=80ms}
(1 row)
Regards,
--
Michael