From rmelendo@teltronic.es Mon Mar 2 10:05:17 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSNDx-0001rq-NN for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 10:05:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YSNDw-00030Q-9o for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 10:05:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YSNDv-0002zx-3s for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 10:05:15 +0000 Received: from correo.teltronic.es ([93.92.233.233] helo=teltronic.es) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSNDo-00039N-23 for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 10:05:13 +0000 Received: from RMELENDOW7 (unknown [192.168.9.71]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by correo.teltronic.es (Postfix) with ESMTP id 68FAB44E3DE; Mon, 2 Mar 2015 11:05:06 +0100 (CET) From: "Ruth Melendo" To: "'Technical Doubts'" , Subject: PostgreSQL with BDR. Problems when adding a sequence in a table column Date: Mon, 2 Mar 2015 11:05:09 +0100 Message-ID: <001001d054d0$5dcbea40$1963bec0$@teltronic.es> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0011_01D054D8.BF935F80" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdBU0BBobxOzNYDzSzSxaIsVi38sng== Content-Language: es X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_0011_01D054D8.BF935F80 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0012_01D054D8.BF935F80" ------=_NextPart_001_0012_01D054D8.BF935F80 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, =20 How can I fix this in a database with BDR? =20 ... ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. DEFAULT may only affect = UNLOGGED or TEMPORARY tables when BDR is active; test_table is a regular table =20 This error happens when trying to add a column to a table with a = sequence. =20 Thanks in advance! =20 Ruth Patricia Melendo Ventura Software Engineer TELTRONIC, S.A.U. T: +34 976 465656 Ext. 179 F: +34 976 465722=20 www.teltronic.es Logo40 =20 ------=_NextPart_001_0012_01D054D8.BF935F80 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,

 

How can I fix this in a database with BDR?

 

... = ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. DEFAULT may only affect = UNLOGGED or TEMPORARY

tables = when BDR is active; test_table is a regular = table

 

This error happens when trying to add a column to a table with a = sequence.

 

Thanks in advance!

 

Ruth Patricia = Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.=

T: +34 976 465656=C2=A0=C2=A0 Ext. 179

F: +34 976 465722

www.teltronic.es

=

3DLogo40

 

------=_NextPart_001_0012_01D054D8.BF935F80-- ------=_NextPart_000_0011_01D054D8.BF935F80 Content-Type: image/jpeg; name="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh3k dlcZx64NZt/Fb6suLnTPPEZ27jKgKn0yDU0VrcNbrvjxITh8vy4+o7Z59TQtjK9pIjxJuDkoucA9 vw46VnaSd4ya+7/IpqMlaSuRW0MmnQrHYafbWqM2Pnk5Y/hnP51YNle3GRc3gVD/AAwrjP4mg2cz TIjRxiGMqyEN93HbFaNZyo87vOTfz/ysVGXKrRSRVtdNtrQ5ij+b+83Jq1RRVwhGC5YqyE5OTuwp oRVLEAAsck+tFFWIdRRRQAUUUUAFFFFAH//Z ------=_NextPart_000_0011_01D054D8.BF935F80-- From gspiegelberg@gmail.com Mon Mar 2 12:53:26 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSPqf-0002MH-Tw for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 12:53:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YSPqf-0006OI-CO for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 12:53:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YSPqd-0006L2-9s for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 12:53:23 +0000 Received: from mail-ig0-x232.google.com ([2607:f8b0:4001:c05::232]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YSPqS-0005pc-4G for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 12:53:21 +0000 Received: by igkb16 with SMTP id b16so16769405igk.1 for ; Mon, 02 Mar 2015 04:53:11 -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=yNxmJNxHtMYSLgGbvykDBtA69PFRNUmZRps4/OARVt0=; b=JpSnL70npniIzMEMcoGDEWamgbZCN8rWxHgmKEiW9X3LzdctFMAgv3O+N8fF9S+snO coJMd8oA9PH2vLN/tvD1z5+8NnDvKSeNYt4aJhPmCqOlt3fXMWWz+bm4lUetnrW2xPGI cvb4sH2uf3RzXCn7Hd44Nqsj9GtPci0C5XLGcEncVAx+BpAVMNnjs5Xwm140iOS4pNRl cPitNeoeXa8fljXw5pX3LA5KF9izU2TwQmHa7T1Z9R56xE7rrGZMNFmm3LkOPccVHZi5 v1nXR5ceNxDSnlp3GrA5uHhyL2LxF4N/IKKkgdMs3s7MCtKMLU58GtfP4GZkGHgLIZTJ Yncw== MIME-Version: 1.0 X-Received: by 10.107.7.93 with SMTP id 90mr36712796ioh.69.1425300791102; Mon, 02 Mar 2015 04:53:11 -0800 (PST) Received: by 10.36.91.70 with HTTP; Mon, 2 Mar 2015 04:53:10 -0800 (PST) In-Reply-To: <001001d054d0$5dcbea40$1963bec0$@teltronic.es> References: <001001d054d0$5dcbea40$1963bec0$@teltronic.es> Date: Mon, 2 Mar 2015 05:53:10 -0700 Message-ID: Subject: Re: PostgreSQL with BDR. Problems when adding a sequence in a table column From: Greg Spiegelberg To: Ruth Melendo Cc: Technical Doubts , "[ADMIN]" Content-Type: multipart/related; boundary=001a113ec45a5a786305104db3eb X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a113ec45a5a786305104db3eb Content-Type: multipart/alternative; boundary=001a113ec45a5a786005104db3ea --001a113ec45a5a786005104db3ea Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Ruth, You need to create the sequence first USING BDR then alter the table setting DEFAULT nextval('..._seq'). CREATE SEQUENCE my_id_seq USING BDR; Make sure your table has a primary key for BDR. HTH. -Greg On Mon, Mar 2, 2015 at 3:05 AM, Ruth Melendo wrote: > Hi, > > > > How can I fix this in a database with BDR? > > > > ... ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. DEFAULT may only affect U= NLOGGED or > TEMPORARY > > tables when BDR is active; test_table is a regular table > > > > This error happens when trying to add a column to a table with a sequence= . > > > > Thanks in advance! > > > > *Ruth Patricia Melendo Ventura* > > *Software Engineer* > > TELTRONIC, S.A.U. > > T: +34 976 465656 Ext. 179 > > F: +34 976 465722 > > www.teltronic.es > > [image: Logo40] > > > --001a113ec45a5a786005104db3ea Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Ruth,

You need to create the sequenc= e first USING BDR then alter the table setting DEFAULT nextval('..._seq= ').

CREATE SEQUENCE my_id_seq USING BDR;
=

Make sure your table has a primary key for BDR.

HTH.
-Greg

On Mon, Mar 2, 2015 at 3:05 AM, Ruth Melen= do <rmelendo@teltronic.es> wrote:

Hi,<= /span>

= =C2=A0

How can I fix this in a database with BDR?

=C2=A0

... ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. DEFAULT may only= affect UNLOGGED or TEMPORARY

ta= bles when BDR is active; test_table is a regular table=

= =C2=A0

This error happens when trying to add a column to a ta= ble with a sequence.

=C2=A0

Thanks in advance!=

=C2=A0

Ruth Patricia Melendo Ventura

Software Engineer<= span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calibri&quo= t;,"sans-serif";color:#3366ff">

<= p class=3D"MsoNormal">TELTRONIC, S.A.U= .

T: +34 976 465656=C2=A0=C2=A0 Ext. 179

F: +34 976 465722

www.teltronic.es<= /p>

3D"Log=<= /p>

=C2=A0


--001a113ec45a5a786005104db3ea-- --001a113ec45a5a786305104db3eb Content-Type: image/jpeg; name="image001.jpg" Content-Disposition: inline; filename="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: e5bb1ae733ead89e_0.1 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh3k dlcZx64NZt/Fb6suLnTPPEZ27jKgKn0yDU0VrcNbrvjxITh8vy4+o7Z59TQtjK9pIjxJuDkoucA9 vw46VnaSd4ya+7/IpqMlaSuRW0MmnQrHYafbWqM2Pnk5Y/hnP51YNle3GRc3gVD/AAwrjP4mg2cz TIjRxiGMqyEN93HbFaNZyo87vOTfz/ysVGXKrRSRVtdNtrQ5ij+b+83Jq1RRVwhGC5YqyE5OTuwp oRVLEAAsck+tFFWIdRRRQAUUUUAFFFFAH//Z --001a113ec45a5a786305104db3eb-- From rmelendo@teltronic.es Mon Mar 2 13:27:29 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSQNc-00040a-QM for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 13:27:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YSQNc-0005Mh-7q for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 13:27:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YSQNb-0005Ma-0d for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 13:27:27 +0000 Received: from correo.teltronic.es ([93.92.233.233] helo=teltronic.es) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSQNW-0006s4-D1 for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 13:27:25 +0000 Received: from RMELENDOW7 (unknown [192.168.9.71]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by correo.teltronic.es (Postfix) with ESMTP id 5AADA343A1C; Mon, 2 Mar 2015 14:27:20 +0100 (CET) From: "Ruth Melendo" To: "'Greg Spiegelberg'" Cc: "'Technical Doubts'" , "'[ADMIN]'" References: <001001d054d0$5dcbea40$1963bec0$@teltronic.es> In-Reply-To: Subject: Re: PostgreSQL with BDR. Problems when adding a sequence in a table column Date: Mon, 2 Mar 2015 14:27:23 +0100 Message-ID: <002e01d054ec$9e419ea0$dac4dbe0$@teltronic.es> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_002F_01D054F5.000913E0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQFDOu99WYh4znpYDL1aX0i9/ZysHwKv46yhng3jjaA= Content-Language: es X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_002F_01D054F5.000913E0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0030_01D054F5.000913E0" ------=_NextPart_001_0030_01D054F5.000913E0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, =20 Tried but same error appeared: =20 ERROR: ALTER TABLE ... ADD COLUMN ... DEFAULT may only affect UNLOGGED = or TEMPORARY tables when BDR is active; test_table is a regular table ********** Error ********** =20 I created the sequence using BDR and after that tried to alter table = adding the column =20 CREATE SEQUENCE test_serial_bdr2 USING BDR; =20 ALTER TABLE test_table add column sec2 INTEGER PRIMARY KEY NOT NULL = DEFAULT nextval('test_serial_bdr2'); =20 =20 =20 Ruth Patricia Melendo Ventura Software Engineer TELTRONIC, S.A.U. T: +34 976 465656 Ext. 179 F: +34 976 465722=20 www.teltronic.es Logo40 =20 De: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] En nombre de Greg Spiegelberg Enviado el: lunes, 02 de marzo de 2015 13:53 Para: Ruth Melendo CC: Technical Doubts; [ADMIN] Asunto: Re: [ADMIN] PostgreSQL with BDR. Problems when adding a sequence = in a table column =20 Hi Ruth, =20 You need to create the sequence first USING BDR then alter the table = setting DEFAULT nextval('..._seq'). =20 CREATE SEQUENCE my_id_seq USING BDR; =20 Make sure your table has a primary key for BDR. =20 HTH. -Greg =20 On Mon, Mar 2, 2015 at 3:05 AM, Ruth Melendo = wrote: Hi, =20 How can I fix this in a database with BDR? =20 ... ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. DEFAULT may only affect = UNLOGGED or TEMPORARY tables when BDR is active; test_table is a regular table =20 This error happens when trying to add a column to a table with a = sequence. =20 Thanks in advance! =20 Ruth Patricia Melendo Ventura Software Engineer TELTRONIC, S.A.U. T: +34 976 465656 = Ext. 179 F: +34 976 465722 =20 www.teltronic.es Logo40 =20 =20 ------=_NextPart_001_0030_01D054F5.000913E0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,

 

Tried but same error appeared:

 

ERROR:=C2=A0 ALTER TABLE ... ADD COLUMN ... DEFAULT may only affect = UNLOGGED or TEMPORARY tables when BDR is active; test_table is a regular = table

********** Error **********

 

I created the sequence using BDR and after that tried to alter table = adding the column

 

CREATE SEQUENCE test_serial_bdr2 USING BDR;

 

ALTER TABLE test_table add column sec2 INTEGER PRIMARY KEY NOT NULL = DEFAULT nextval('test_serial_bdr2');

 

 

 

Ruth Patricia = Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.=

T: +34 976 465656=C2=A0=C2=A0 Ext. 179

F: +34 976 465722

www.teltronic.es

=

3DLogo40

 

De: = pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] En nombre de Greg = Spiegelberg
Enviado el: lunes, 02 de marzo de 2015 = 13:53
Para: Ruth Melendo
CC: Technical Doubts; = [ADMIN]
Asunto: Re: [ADMIN] PostgreSQL with BDR. Problems when = adding a sequence in a table column

 

Hi = Ruth,

 

You need to create the sequence first USING BDR then = alter the table setting DEFAULT = nextval('..._seq').

 

CREATE SEQUENCE my_id_seq USING = BDR;

 

Make sure your table has a primary key for = BDR.

 

HTH.

-Greg

 

On Mon, = Mar 2, 2015 at 3:05 AM, Ruth Melendo <rmelendo@teltronic.es> = wrote:

Hi,

 

How can I fix this in a database with BDR?

 

... ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. = DEFAULT may only affect UNLOGGED or TEMPORARY

tables when BDR is active; test_table is a regular = table

 

This error happens when trying to add a column to a table with a = sequence.

 

Thanks in advance!

 

Ruth Patricia = Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.

T: +34 976 465656   Ext. = 179

F: +34 976 = 465722

www.teltronic.es

=

3DLogo40

 

 

------=_NextPart_001_0030_01D054F5.000913E0-- ------=_NextPart_000_002F_01D054F5.000913E0 Content-Type: image/jpeg; name="image002.jpg" Content-Transfer-Encoding: base64 Content-ID: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh3k dlcZx64NZt/Fb6suLnTPPEZ27jKgKn0yDU0VrcNbrvjxITh8vy4+o7Z59TQtjK9pIjxJuDkoucA9 vw46VnaSd4ya+7/IpqMlaSuRW0MmnQrHYafbWqM2Pnk5Y/hnP51YNle3GRc3gVD/AAwrjP4mg2cz TIjRxiGMqyEN93HbFaNZyo87vOTfz/ysVGXKrRSRVtdNtrQ5ij+b+83Jq1RRVwhGC5YqyE5OTuwp oRVLEAAsck+tFFWIdRRRQAUUUUAFFFFAH//Z ------=_NextPart_000_002F_01D054F5.000913E0 Content-Type: image/jpeg; name="image003.jpg" Content-Transfer-Encoding: base64 Content-ID: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh3k dlcZx64NZt/Fb6suLnTPPEZ27jKgKn0yDU0VrcNbrvjxITh8vy4+o7Z59TQtjK9pIjxJuDkoucA9 vw46VnaSd4ya+7/IpqMlaSuRW0MmnQrHYafbWqM2Pnk5Y/hnP51YNle3GRc3gVD/AAwrjP4mg2cz TIjRxiGMqyEN93HbFaNZyo87vOTfz/ysVGXKrRSRVtdNtrQ5ij+b+83Jq1RRVwhGC5YqyE5OTuwp oRVLEAAsck+tFFWIdRRRQAUUUUAFFFFAH//Z ------=_NextPart_000_002F_01D054F5.000913E0-- From ville.rantamaula@gmail.com Wed Mar 4 11:01:41 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YT73c-0002ep-On for pgsql-admin@arkaria.postgresql.org; Wed, 04 Mar 2015 11:01:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YT73c-0000sG-5A for pgsql-admin@arkaria.postgresql.org; Wed, 04 Mar 2015 11:01:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YT73a-0000s9-M8 for pgsql-admin@postgresql.org; Wed, 04 Mar 2015 11:01:39 +0000 Received: from mail-ig0-x236.google.com ([2607:f8b0:4001:c05::236]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YT73V-0007GL-5C for pgsql-admin@postgresql.org; Wed, 04 Mar 2015 11:01:36 +0000 Received: by igal13 with SMTP id l13so35778712iga.0 for ; Wed, 04 Mar 2015 03:01:32 -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=kJX0ONwqmyeEE/l8f34WuczBWoLI3+3xTOwPPK7qlxc=; b=PR2AW5xkyqP4vijh6DUeHa4VPx3ULDDHCBMZ711LKG3LfEtLIUfWbxc0KBSsd1DSDj 5eXcDyXYh7pHoHdqrkfIFtzZcwgroIQxIR1GfXhAHbqScAqs3s/FoItSvYlOmG0MzjQA dhNliQfNFXHvXUq8lbEPzOQJ7y4LxtmAlVKUSAQqkmMjPAsC/dlLvWKRX5PCMYmlhb2A 4eDeUsAsFyim+WEkGA8HYG993zD5HeP+pzQTkf3i2QoKdXJ7Jj9FxGagIBv9IO47qDSS ZNJ3BMyjcsb1T0DCRzwlnuHEXFNmd7K+hHpU/7vVeAm3Q5fnlZ588p0zBdhHUxLDVyPy T9CQ== MIME-Version: 1.0 X-Received: by 10.50.50.233 with SMTP id f9mr36060829igo.38.1425466892202; Wed, 04 Mar 2015 03:01:32 -0800 (PST) Received: by 10.107.148.203 with HTTP; Wed, 4 Mar 2015 03:01:32 -0800 (PST) In-Reply-To: <002e01d054ec$9e419ea0$dac4dbe0$@teltronic.es> References: <001001d054d0$5dcbea40$1963bec0$@teltronic.es> <002e01d054ec$9e419ea0$dac4dbe0$@teltronic.es> Date: Wed, 4 Mar 2015 13:01:32 +0200 Message-ID: Subject: Re: PostgreSQL with BDR. Problems when adding a sequence in a table column From: Ville Rantamaula To: Ruth Melendo Cc: "[ADMIN]" Content-Type: multipart/related; boundary=047d7bd76b5ac02d9c0510745f2e X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --047d7bd76b5ac02d9c0510745f2e Content-Type: multipart/alternative; boundary=047d7bd76b5ac02d990510745f2d --047d7bd76b5ac02d990510745f2d Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Ruth, You can make it work, if you split the ALTER TABLE statement to two parts like this: CREATE SEQUENCE test_serial_bdr2 USING BDR; ALTER TABLE test_table add column sec2 bigint primary key not null; ALTER TABLE test_table alter column sec2 SET DEFAULT nextval('test_serial_bdr2'); Yours, Ville 2015-03-02 15:27 GMT+02:00 Ruth Melendo : > Hi, > > > > Tried but same error appeared: > > > > ERROR: ALTER TABLE ... ADD COLUMN ... DEFAULT may only affect UNLOGGED o= r > TEMPORARY tables when BDR is active; test_table is a regular table > > ********** Error ********** > > > > I created the sequence using BDR and after that tried to alter table > adding the column > > > > CREATE SEQUENCE test_serial_bdr2 USING BDR; > > > > ALTER TABLE test_table add column sec2 INTEGER PRIMARY KEY NOT NULL > DEFAULT nextval('test_serial_bdr2'); > > > > > > > > *Ruth Patricia Melendo Ventura* > > *Software Engineer* > > TELTRONIC, S.A.U. > > T: +34 976 465656 Ext. 179 > > F: +34 976 465722 > > www.teltronic.es > > [image: Logo40] > > > > *De:* pgsql-admin-owner@postgresql.org [mailto: > pgsql-admin-owner@postgresql.org] *En nombre de *Greg Spiegelberg > *Enviado el:* lunes, 02 de marzo de 2015 13:53 > *Para:* Ruth Melendo > *CC:* Technical Doubts; [ADMIN] > *Asunto:* Re: [ADMIN] PostgreSQL with BDR. Problems when adding a > sequence in a table column > > > > Hi Ruth, > > > > You need to create the sequence first USING BDR then alter the table > setting DEFAULT nextval('..._seq'). > > > > CREATE SEQUENCE my_id_seq USING BDR; > > > > Make sure your table has a primary key for BDR. > > > > HTH. > > -Greg > > > > On Mon, Mar 2, 2015 at 3:05 AM, Ruth Melendo > wrote: > > Hi, > > > > How can I fix this in a database with BDR? > > > > ... ALTER TABLE =E2=80=A6 ADD COLUMN =E2=80=A6. DEFAULT may only affect U= NLOGGED or > TEMPORARY > > tables when BDR is active; test_table is a regular table > > > > This error happens when trying to add a column to a table with a sequence= . > > > > Thanks in advance! > > > > *Ruth Patricia Melendo Ventura* > > *Software Engineer* > > TELTRONIC, S.A.U. > > T: +34 976 465656 Ext. 179 > > F: +34 976 465722 > > www.teltronic.es > > [image: Logo40] > > > > > --047d7bd76b5ac02d990510745f2d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Ruth,

You can make it work, if you s= plit the ALTER TABLE statement to two parts like this:

=
CREATE SEQUENCE test_serial_bdr2 USING BDR;
ALTER TABLE = test_table add column sec2 bigint primary key not null;
ALTER= TABLE test_table alter column sec2 SET DEFAULT nextval('test_serial_bd= r2');

Yours,
Ville

2015-03-02 15:27 GM= T+02:00 Ruth Melendo <rmelendo@teltronic.es>:

Hi,

=C2=A0=

Tried but same error appeared:

=C2=A0

ERROR:= =C2=A0 ALTER TABLE ... ADD COLUMN ... DEFAULT may only affect UNLOGGED or T= EMPORARY tables when BDR is active; test_table is a regular table=

**********= Error **********

=C2=A0

I created the sequence using BDR and = after that tried to alter table adding the column

<= p class=3D"MsoNormal">=C2= =A0

CREATE SEQUENCE test_serial_bdr2 USING BDR;=

=C2=A0

ALTER TABLE test_table add column sec2 INTEGER PRIMARY KEY = NOT NULL DEFAULT nextval('test_serial_bdr2');<= /p>

=C2=A0

=C2=A0

=C2=A0

Ruth Patricia M= elendo Ventura

=

Soft= ware Engineer

TELTRONIC, S.A.U.

T: +34 976 465656=C2=A0=C2=A0 E= xt. 179

F: = +34 976 465722

www.teltronic.= es

3D"Logo40"

=C2=A0

De: pgsql-admin-owner@postgresql.org= [mailto:pgsql-admin-owner@postgresql.org] En nombre de Greg Spiegelb= erg
Enviado el: lunes, 02 de marzo de 2015 13:53
Para: = Ruth Melendo
CC: Technical Doubts; [ADMIN]
Asunto: Re: = [ADMIN] PostgreSQL with BDR. Problems when adding a sequence in a table col= umn

<= u>=C2=A0

Hi Ruth,

=C2=A0

You need to create the sequence first USING BDR then alter t= he table setting DEFAULT nextval('..._seq').

=C2=A0

CREATE SEQUENCE my_id_seq USING BDR;

=C2=A0

Make sure your table has a primary key for BDR.

=C2=A0

HTH.

-Gre= g

=C2=A0=

On Mon, Mar 2, 2015 at 3:05 AM, Ruth Me= lendo <rmelen= do@teltronic.es> wrote:

Hi,

=C2=A0

How can I fix this in a database with BDR?=

=C2=A0=

... ALTER TABLE =E2=80=A6 ADD COLUMN =E2= =80=A6. DEFAULT may only affect UNLOGGED or TEMPORARY<= /p>

ta= bles when BDR is active; test_table is a regular table=

= =C2=A0

This error happens when trying to add a column to a ta= ble with a sequence.

=C2=A0

Thanks in advance!=

=C2=A0

Ruth Patricia Melendo Ventura

= TELTRONIC, S.A.U.=

T: += 34 976 465656=C2=A0=C2=A0 Ext. 179

F: +34 976 465722

www.teltronic.es

3D"Logo40"<= /u>

=C2=A0

=C2=A0<= /p>


--047d7bd76b5ac02d990510745f2d-- --047d7bd76b5ac02d9c0510745f2e Content-Type: image/jpeg; name="image002.jpg" Content-Disposition: inline; filename="image002.jpg" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f696bdc5928ecf15_0.1 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh3k dlcZx64NZt/Fb6suLnTPPEZ27jKgKn0yDU0VrcNbrvjxITh8vy4+o7Z59TQtjK9pIjxJuDkoucA9 vw46VnaSd4ya+7/IpqMlaSuRW0MmnQrHYafbWqM2Pnk5Y/hnP51YNle3GRc3gVD/AAwrjP4mg2cz TIjRxiGMqyEN93HbFaNZyo87vOTfz/ysVGXKrRSRVtdNtrQ5ij+b+83Jq1RRVwhGC5YqyE5OTuwp oRVLEAAsck+tFFWIdRRRQAUUUUAFFFFAH//Z --047d7bd76b5ac02d9c0510745f2e Content-Type: image/jpeg; name="image003.jpg" Content-Disposition: inline; filename="image003.jpg" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f696bdc5928ecf15_0.2 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh3k dlcZx64NZt/Fb6suLnTPPEZ27jKgKn0yDU0VrcNbrvjxITh8vy4+o7Z59TQtjK9pIjxJuDkoucA9 vw46VnaSd4ya+7/IpqMlaSuRW0MmnQrHYafbWqM2Pnk5Y/hnP51YNle3GRc3gVD/AAwrjP4mg2cz TIjRxiGMqyEN93HbFaNZyo87vOTfz/ysVGXKrRSRVtdNtrQ5ij+b+83Jq1RRVwhGC5YqyE5OTuwp oRVLEAAsck+tFFWIdRRRQAUUUUAFFFFAH//Z --047d7bd76b5ac02d9c0510745f2e--