BUG #15185: pg_dump doesn't include statistics when specifying a table
От | PG Bug reporting form |
---|---|
Тема | BUG #15185: pg_dump doesn't include statistics when specifying a table |
Дата | |
Msg-id | 152536018283.23581.1186978081424966318@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15185: pg_dump doesn't include statistics when specifying atable
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15185 Logged by: Josha Foust Email address: postgresql@lightn.org PostgreSQL version: 10.3 Operating system: Windows Description: After using the CREATE STATISTICS command to create multi-column statistics on a table, calling pg_dump with the -t option doesn't include that definition, but it does include things like indexes. I see this note in the documentation: "When -t is specified, pg_dump makes no attempt to dump any other database objects that the selected table(s) might depend upon. Therefore, there is no guarantee that the results of a specific-table dump can be successfully restored by themselves into a clean database." I don't think that applies here, but please tell me if I'm wrong. Here is a simple test case, created in a database named "test": create table Events ( EventDt timestamp(6) with time zone not null, EventId integer not null, ProjectId smallint not null, LoggerId integer, Message text ); create index IX_Events_ProjectId_LoggerId on Events (ProjectId, LoggerId); create statistics Events_ProjectLogger (dependencies) ON ProjectId, LoggerId FROM Events; pg_dump.exe -U postgres --schema-only test pg_dump.exe -U postgres -t public.events --schema-only test The first pg_dump command output shows the "CREATE STATISTICS" line, while the second one does not. It seems like it should.
В списке pgsql-bugs по дате отправления: