| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)fr> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net> |
| Subject: | Re: pg_dumping extensions having sequences with 9.6beta3 |
| Date: | 2016-07-23 04:40:01 |
| Message-ID: | CAB7nPqRvEbS2=kQ+8s_f3fEejz+DWMU5YNYLr7CD7af5g_NPVQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, Jul 22, 2016 at 6:27 PM, Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)fr> wrote:
> I am currently playing with extensions. And I found a strange behaviour
> change with 9.6beta2 and 3 when pg_dumping a database with an extension
> having sequences. This looks like a bug, ... unless I did something wrong.
> [...]
> => as expected, with latest minor versions of postgres 9.1 to 9.5, the
> sequences associated to the t1.c1 and t1.c3 columns are not dumped,
> while the sequence associated to t2.c1 is dumped.
> => with 9.6beta3 (as with beta2), the 3 sequences are dumped.
Thanks for the report! I haven't looked at the problem in details yet,
but my guess is that this is owned by Stephen Frost. test_pg_dump does
not cover sequences yet, it would be visibly good to get coverage for
that. I am adding an open item as well.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-07-23 14:29:36 | Re: yum repo, pgloader |
| Previous Message | Jim Nasby | 2016-07-23 02:10:00 | Re: Array value from table as parameter |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2016-07-23 07:55:55 | Re: Reviewing freeze map code |
| Previous Message | Noah Misch | 2016-07-23 03:04:39 | Re: fixes for the Danish locale |