Re: Bootstrap DATA is a pita - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Bootstrap DATA is a pita
Date
Msg-id CA+TgmoYGE-XGKuJQFWVWVQ0ch=oeetpB1nkeqUc-SFfC4CWX+w@mail.gmail.com
Whole thread Raw
In response to Re: Bootstrap DATA is a pita  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Bootstrap DATA is a pita  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
>> Even this promises to vastly increase the number of lines in the file,
>> and make it harder to compare entries by grepping out some common
>> substring.  I agree that the current format is a pain in the tail, but
>> pg_proc.h is >5k lines already.  I don't want it to be 100k lines
>> instead.
>
> Do you have a better suggestion? Sure it'll be a long file, but it still
> seems vastly superiour to what we have now.

Not really.  What had occurred to me is to try to improve the format
of the DATA lines (e.g. by allowing names to be used instead of OIDs)
but that wouldn't allow defaulted fields to be omitted, which is
certainly a big win.  I wonder whether some home-grown single-line
format might be better than using a pre-existing format, but I'm not
too sure it would.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: POLA violation with \c service=
Next
From: Andres Freund
Date:
Subject: Re: Bootstrap DATA is a pita