| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: different column orders in regression test database |
| Date: | 2017-05-19 02:02:45 |
| Message-ID: | f5e0a577-b007-6b75-6deb-9bd0bc0e4765@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 5/18/17 19:07, Thomas Munro wrote:
> To make normal dump/restore preserve the order, we could either make
> it *always* write create-then-attach, or do it only if required. I'd
> vote for doing it only if required because of different column order,
> because I don't want to see 1,000 partitions dumped in "long format"
> when the short and sweet CREATE... PARTITION OF ... syntax could
> usually be used.
Doing it the long way only when necessary makes sense. Maybe never
doing it the long way also makes sense, as long as we're clear that
that's what we want.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2017-05-19 02:05:45 | Re: Race conditions with WAL sender PID lookups |
| Previous Message | Tsunakawa, Takayuki | 2017-05-19 02:01:32 | Re: [bug fix] PG10: libpq doesn't connect to alternative hosts when some errors occur |