Thread

  1. Is it just me...?

    Marc Fournier <scrappy@hub.org> — 1998-03-08T22:59:29Z

    \connect template1
    select datdba into table tmp_pguser       from pg_database where datname =
    'temp
    late1';
    delete from pg_user where usesysid <> tmp_pguser.datdba;
    drop table tmp_pguser;
    copy pg_user from stdin;
    root    0       f       t       f       t
    acctng  103     f       t       f       t
    nobody  65534   f       t       f       t
    \.
    ~
    
    This dump from v6.2.1 fails to reload into v6.3...my guess being, of
    course, because of the field(s)...have we compensated pg_dump in v6.3 for
    this?