Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aL31c-0007QG-Hm for pgsql-docs@arkaria.postgresql.org; Mon, 18 Jan 2016 06:10:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aL31b-0000zK-Lz for pgsql-docs@arkaria.postgresql.org; Mon, 18 Jan 2016 06:10:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aL31b-0000zE-Cu for pgsql-docs@postgresql.org; Mon, 18 Jan 2016 06:10:47 +0000 Received: from mail-wm0-x230.google.com ([2a00:1450:400c:c09::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aL31X-0007h3-Pz for pgsql-docs@postgresql.org; Mon, 18 Jan 2016 06:10:46 +0000 Received: by mail-wm0-x230.google.com with SMTP id r129so37380864wmr.0 for ; Sun, 17 Jan 2016 22:10:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=dUlSMucaL+GJeRHNtfcu7CMXEGw+aiab39o6CQjFAx8=; b=t9PTuALarfhY6vD0ijPbNoXNwH4xkrxN4WeXs+kpmw0EQ9hDVIflq4JjSkq711Wg1k MiNwQt4uIjyz2W9THICk6KeRPvRO+Zzuuhj47RndMuyia6GdlBD4+HOk79DhSbm1CLe5 5HEWXMQUdFi0bx3fJVHGXwib4pelulgjadqvhidPdIOSUl5F9oG/HxXpiMn8oNSDjYon P6Rqx1pYx5pdOlnhmYXrwzwGwlIoWENdQjtQ2LPoZKbvSuvwC5Hwnd98CzRDMKTiJ/Nn y9i88GUA5OvpgPehwQXG8dcmkQOEINoYk2zAvkfllO/kXAZlazCA23KIECXxbrEaOOPb zPag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=dUlSMucaL+GJeRHNtfcu7CMXEGw+aiab39o6CQjFAx8=; b=XDP3h+WyIVuhORdGUQRUdrT7vyagxxanhFmnFnm5M4VLeX2JwHEcoZs3yWyp41Nnqb Q1CW++RnST7pypmWrM28oTg/qfeH4cReGURXd+AbROqa1Do3Ahdvo0pts5k3v6G4hCWr MFhYVlxtj2g5dlzkWKOLSSU7OqdOrhaTCGMmOfeOM0MVXLR+NgPEan5yy38gE4WpM9e3 F+Uww6PuFr0j/0YguTrPereLTXxF+1MSCDn77P+LfnKUV562bwCmKPqbLXRfwT3QU30l vYNN4RNnZFj27wyVbBKl5pya02CY6P8GjrG29repHfuuMOr7vc/gks3R29bI69Y6Q1cV +2tA== X-Gm-Message-State: ALoCoQkKpQ9vPaOAGeaKwX9glP1WZyxFbjeu+ZpZ7a8p2Y2DnW4gh347jYRlWJLnpDmw7iMy00Pv5Adft8omt5QWSW+mpFUIFg== MIME-Version: 1.0 X-Received: by 10.194.78.175 with SMTP id c15mr22614235wjx.16.1453097442350; Sun, 17 Jan 2016 22:10:42 -0800 (PST) Received: by 10.27.8.19 with HTTP; Sun, 17 Jan 2016 22:10:42 -0800 (PST) In-Reply-To: <568C27BD.8030402@free.fr> References: <568C27BD.8030402@free.fr> Date: Mon, 18 Jan 2016 15:10:42 +0900 Message-ID: Subject: Re: pg_extension_config_dump() function and sequences From: Michael Paquier To: Philippe BEAUDOIN Cc: pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=047d7bfcf874e055a00529959c6d X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --047d7bfcf874e055a00529959c6d Content-Type: text/plain; charset=UTF-8 On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN wrote: > The page "Packaging Related Objects into an Extension" has a third chapter > dealing with "Extension Configuration Tables". A final paragraph would be > useful to explain that: > > The pg_extension_config_dump() function can also register sequences, so that > the current properties of the registered sequences are saved by pg_dump and > later restored. The function can support sequences either explicitely > created with an ALTER SEQUENCE statement or implicitely created when a table > contains SERIAL or BIGSERIAL columns. Note that the sequences associated to > SERIAL or BIGSERIAL columns of a configuration table need to be registered > using the pg_extension_config_dump() function if one wants to restore the > properties they had at pg_dump time. Instead of a single paragraph, perhaps we could make things more generic like in the attached? -- Michael --047d7bfcf874e055a00529959c6d Content-Type: binary/octet-stream; name="extension-mark-seq-v1.patch" Content-Disposition: attachment; filename="extension-mark-seq-v1.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ijjkoixs0 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9leHRlbmQuc2dtbCBiL2RvYy9z cmMvc2dtbC9leHRlbmQuc2dtbAppbmRleCA0YTg4MzgxLi5mZjljNzQ5IDEw MDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvZXh0ZW5kLnNnbWwKKysrIGIvZG9j L3NyYy9zZ21sL2V4dGVuZC5zZ21sCkBAIC02NzcsMTcgKzY3NywyMSBAQCBT RVQgTE9DQUwgc2VhcmNoX3BhdGggVE8gQGV4dHNjaGVtYUA7CiAKICAgICA8 cGFyYT4KICAgICAgVG8gc29sdmUgdGhpcyBwcm9ibGVtLCBhbiBleHRlbnNp b24ncyBzY3JpcHQgZmlsZSBjYW4gbWFyayBhIHRhYmxlCi0gICAgIGl0IGhh cyBjcmVhdGVkIGFzIGEgY29uZmlndXJhdGlvbiB0YWJsZSwgd2hpY2ggd2ls bCBjYXVzZQotICAgICA8YXBwbGljYXRpb24+cGdfZHVtcDwvPiB0byBpbmNs dWRlIHRoZSB0YWJsZSdzIGNvbnRlbnRzIChub3QgaXRzCi0gICAgIGRlZmlu aXRpb24pIGluIGR1bXBzLiAgVG8gZG8gdGhhdCwgY2FsbCB0aGUgZnVuY3Rp b24KKyAgICAgb3IgYSBzZXF1ZW5jZSBpdCBoYXMgY3JlYXRlZCBhcyBhIGNv bmZpZ3VyYXRpb24gcmVsYXRpb24sIHdoaWNoIHdpbGwKKyAgICAgY2F1c2Ug PGFwcGxpY2F0aW9uPnBnX2R1bXA8Lz4gdG8gaW5jbHVkZSB0aGUgdGFibGUn cyBvciB0aGUgc2VxdWVuY2UncworICAgICBjb250ZW50cyAobm90IGl0cyBk ZWZpbml0aW9uKSBpbiBkdW1wcy4gIFRvIGRvIHRoYXQsIGNhbGwgdGhlIGZ1 bmN0aW9uCiAgICAgIDxmdW5jdGlvbj5wZ19leHRlbnNpb25fY29uZmlnX2R1 bXAocmVnY2xhc3MsIHRleHQpPC8+IGFmdGVyIGNyZWF0aW5nIHRoZQotICAg ICB0YWJsZSwgZm9yIGV4YW1wbGUKKyAgICAgdGFibGUgb3IgdGhlIHNlcXVl bmNlLCBmb3IgZXhhbXBsZQogPHByb2dyYW1saXN0aW5nPgogQ1JFQVRFIFRB QkxFIG15X2NvbmZpZyAoa2V5IHRleHQsIHZhbHVlIHRleHQpOworQ1JFQVRF IFNFUVVFTkNFIG15X2NvbmZpZ19zZXE7CiAKIFNFTEVDVCBwZ19jYXRhbG9n LnBnX2V4dGVuc2lvbl9jb25maWdfZHVtcCgnbXlfY29uZmlnJywgJycpOwor U0VMRUNUIHBnX2NhdGFsb2cucGdfZXh0ZW5zaW9uX2NvbmZpZ19kdW1wKCdt eV9jb25maWdfc2VxJywgJycpOwogPC9wcm9ncmFtbGlzdGluZz4KLSAgICAg QW55IG51bWJlciBvZiB0YWJsZXMgY2FuIGJlIG1hcmtlZCB0aGlzIHdheS4K KyAgICAgQW55IG51bWJlciBvZiB0YWJsZXMgb3Igc2VxdWVuY2VzIGNhbiBi ZSBtYXJrZWQgdGhpcyB3YXkuIFNlcXVlbmNlcworICAgICBhc3NvY2lhdGVk IHdpdGggPHR5cGU+c2VyaWFsPC8+IG9yIDx0eXBlPmJpZ3NlcmlhbDwvPiBj b2x1bW5zIGNhbgorICAgICBiZSBtYXJrZWQgYXMgd2VsbC4KICAgICA8L3Bh cmE+CiAKICAgICA8cGFyYT4KQEAgLTcwOSw2ICs3MTMsMTEgQEAgU0VMRUNU IHBnX2NhdGFsb2cucGdfZXh0ZW5zaW9uX2NvbmZpZ19kdW1wKCdteV9jb25m aWcnLCAnV0hFUkUgTk9UIHN0YW5kYXJkX2VudHIKICAgICA8L3BhcmE+CiAK ICAgICA8cGFyYT4KKyAgICAgRm9yIHNlcXVlbmNlcywgdGhlIHNlY29uZCBh cmd1bWVudCBvZiA8ZnVuY3Rpb24+cGdfZXh0ZW5zaW9uX2NvbmZpZ19kdW1w PC8+CisgICAgIGhhcyBubyBlZmZlY3QuCisgICAgPC9wYXJhPgorCisgICAg PHBhcmE+CiAgICAgIE1vcmUgY29tcGxpY2F0ZWQgc2l0dWF0aW9ucywgc3Vj aCBhcyBpbml0aWFsbHktcHJvdmlkZWQgcm93cyB0aGF0IG1pZ2h0CiAgICAg IGJlIG1vZGlmaWVkIGJ5IHVzZXJzLCBjYW4gYmUgaGFuZGxlZCBieSBjcmVh dGluZyB0cmlnZ2VycyBvbiB0aGUKICAgICAgY29uZmlndXJhdGlvbiB0YWJs ZSB0byBlbnN1cmUgdGhhdCBtb2RpZmllZCByb3dzIGFyZSBtYXJrZWQgY29y cmVjdGx5LgpAQCAtNzMyLDYgKzc0MSwxMiBAQCBTRUxFQ1QgcGdfY2F0YWxv Zy5wZ19leHRlbnNpb25fY29uZmlnX2R1bXAoJ215X2NvbmZpZycsICdXSEVS RSBOT1Qgc3RhbmRhcmRfZW50cgogICAgICBvdXQgYnV0IHRoZSBkdW1wIHdp bGwgbm90IGJlIGFibGUgdG8gYmUgcmVzdG9yZWQgZGlyZWN0bHkgYW5kIHVz ZXIKICAgICAgaW50ZXJ2ZW50aW9uIHdpbGwgYmUgcmVxdWlyZWQuCiAgICAg PC9wYXJhPgorICAgIAorICAgIDxwYXJhPgorICAgICBTZXF1ZW5jZXMgYXNz b2NpYXRlZCB3aXRoIDx0eXBlPnNlcmlhbDwvPiBvciA8dHlwZT5iaWdzZXJp YWw8Lz4gY29sdW1ucworICAgICBuZWVkIHRvIGJlIGRpcmVjdGx5IG1hcmtl ZCB0byBkdW1wIHRoZWlyIHN0YXRlLiBNYXJraW5nIHRoZWlyIHBhcmVudAor ICAgICByZWxhdGlvbiBpcyBub3QgZW5vdWdoIGZvciB0aGlzIHB1cnBvc2Uu CisgICAgPC9wYXJhPgogICAgPC9zZWN0Mj4KIAogICAgPHNlY3QyPgo= --047d7bfcf874e055a00529959c6d Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --047d7bfcf874e055a00529959c6d--