ERROR:&= nbsp; missing FROM-clause entry for table "new"

There is nothing wrong with the resulting c= ode from sql because if I output the string and put it in as static SQL in m= y trigger it works.

How do I build the string within the trigger and execute it with a refe= rence to NEW?

Thanks in advance for the help,

James

--B_3430413633_2009253-- From polobo@yahoo.com Fri Sep 14 01:06:13 2012 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCKMH-0007aL-ED for pgsql-sql@postgresql.org; Fri, 14 Sep 2012 01:06:13 +0000 Received: from nm1.bullet.mail.ac4.yahoo.com ([98.139.52.198]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TCKME-0008Fe-Sm for pgsql-sql@postgresql.org; Fri, 14 Sep 2012 01:06:12 +0000 Received: from [98.139.52.191] by nm1.bullet.mail.ac4.yahoo.com with NNFMP; 14 Sep 2012 01:06:10 -0000 Received: from [98.139.52.128] by tm4.bullet.mail.ac4.yahoo.com with NNFMP; 14 Sep 2012 01:06:10 -0000 Received: from [127.0.0.1] by omp1011.mail.ac4.yahoo.com with NNFMP; 14 Sep 2012 01:06:10 -0000 X-Yahoo-Newman-Id: 31320.76673.bm@omp1011.mail.ac4.yahoo.com Received: (qmail 85693 invoked from network); 14 Sep 2012 01:06:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:Subject:Date:To; b=oaAL696zNdoLLz8Q8qrTv5VqI9wqbraqMpFmhMXb3dja/mFOehSixerXeOtmuNZuZ4SqMTVfcsaDoJeGXMOn9kRe2/m9GbPt4ocqh0rN3Y4FKwtWj9kHPRNcV9ABi/glA72kQyy9jmoyGeG8DUDI0pwG3V9OCjxhKrjB5nywTxA= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1347584769; bh=kY814riqDyU9fkXcrZ14ImHbfxX8X8nbi+Xliy+1uBw=; h=X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:Subject:Date:To; b=qeU8UxjUra+ObXS1g7SEBX1QHli5EBsMhNejKoLa3GyfHhL/o22HoxHVnOTcWkHdwC4WxM2RIHu6ORp6yDKyFe7VhovqaHt3+V0AzcADzN43/jeZNs/VTR7AFGAA4JMoCJhmtFNPhVV3RsO4S/uU3EDADOPTz8nGnBuFE+sLsvU= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: k0BENYIVM1nyO2GPzY4yTq0HiZ51FpTLjgRStSG.AwXxS6W RcqN7k_NOk40grld_JFexuJv2ny0QBRO_h1yYnwO3Dud9jIeQ3d.lEcRP5r. 0W0IYYIE.iaVbGhExV7Es4O029gBsOG5bVvKkxm8gsh2oS4BMw0l2uga.8ZR Qas9YX6Ta_BFR1ZgpRfhaYJtcBhLTmTqmn8EC2FnJnIXmK.Ox3PIzT0gfd5r 4vWZVUxmBAE1OfttVKFv3SjX8ebjAHovUPsfHUlJPZCOS1Q00Dg36VmDygTP StUmmK0JpiEpZiQ9X0lcYt.k9vx71niTLNIzvhLBeJZmyTXkcLB9ufo0y8Ab qc1RFly3aNxGxYEObPD1Ujg0EScuEKS_AfMhei_61XBEKNj5l4eA89Zj0AXY C7s5IiU0Gfc5f0ywgQnaaFDrci0uAFMynIQ0knwmrxDGerzRs352GLLF7ojE t6pZJsN5F5tpqgMo8tQ7mbZPAv.VfD_US_4ozkiWYK7HMEm6soH6X0L8DuB0 mWvFGsOXX2h8SfYzDeTQhksvji3gtiEi7VUsRrJf9CiS54AGuBCfgWTL.tCC jqFsAom3QL6_Cyl8sRFvqmx_r3gjHj8E4TxFDhMsBKQXX X-Yahoo-SMTP: mpGJl6eswBD2IBufoVEg0Pa8gg-- Received: from [192.12.17.101] (polobo@24.93.23.188 with xymcookie) by smtp108-mob.biz.mail.ac4.yahoo.com with SMTP; 13 Sep 2012 18:06:09 -0700 PDT References: In-Reply-To: Mime-Version: 1.0 (1.0) Content-Type: multipart/alternative; boundary=Apple-Mail-36D7E737-FB94-42BA-8828-3130ECFE56D1 Content-Transfer-Encoding: 7bit Message-Id: <4A8E4483-31D7-437C-8D4E-6D0DD2AF1B02@yahoo.com> Cc: "" X-Mailer: iPad Mail (9B206) From: David Johnston Subject: Re: ERROR: missing FROM-clause entry for table "new" Date: Thu, 13 Sep 2012 21:06:10 -0400 To: James Sharrett X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201209/39 X-Sequence-Number: 36841 --Apple-Mail-36D7E737-FB94-42BA-8828-3130ECFE56D1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On Sep 13, 2012, at 20:40, James Sharrett wrote: > I'm trying to define a trigger function that looks for changes in table A (= table the trigger for the function is on) and write a delta record into tabl= e B. So if a record has a value of 100 in table A, and it is updated to 50,= the function should write =E2=80=9350 in table B. I can get the trigger to w= ork with static SQL statements but for the actual code, I need to use dynami= c SQL because I need to alter the insert statement to B depending on what co= lumn in table A is altered. I can get the correct SQL generated but when I e= xecute the string inside the trigger function I get an error because it does= n't seem to be able to see the NEW table when it's run with EXECUTE.=20 >=20 > So, this works in the trigger function: >=20 > Insert into A (col1,col2,=E2=80=A6colN) > Select new.col1,new.co2=E2=80=A6new.colN) >=20 > This doesn't: >=20 > sql :=3D 'Insert into A (col1,col2,=E2=80=A6colN) '; > sql :=3D sql || 'Select new.col1,new.co2=E2=80=A6new.colN)'; > Execute sql; >=20 > ERROR: missing FROM-clause entry for table "new" >=20 > There is nothing wrong with the resulting code from sql because if I outpu= t the string and put it in as static SQL in my trigger it works. >=20 > How do I build the string within the trigger and execute it with a referen= ce to NEW? >=20 > Thanks in advance for the help, > James >=20 Please read all of: http://www.postgresql.org/docs/9.2/interactive/plpgsql-statements.html#PLPGS= QL-STATEMENTS-EXECUTING-DYN But especially 39.5.4 You want to make use of format and/or USING to pass in the values to a param= eterized dynamic statement. Note I linked to 9.2 but any recent version should have the behavior, if dif= ferent section numbers. In short the whole "NEW.name" is a variable and you need to build the statem= ent the same way you would with any user-defined variable. David J. --Apple-Mail-36D7E737-FB94-42BA-8828-3130ECFE56D1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

On Sep 13, 2012, at 2= 0:40, James Sharrett <jsharrett= @tidemark.net> wrote:

I'm trying to define a trigger function that looks for changes i= n table A (table the trigger for the function is on) and write a delta recor= d into table B. So if a record has a value of 100 in table A, and it i= s updated to 50, the function should write =E2=80=9350 in table B. I can get= the trigger to work with static SQL statements but for the actual code, I n= eed to use dynamic SQL because I need to alter the insert statement to B dep= ending on what column in table A is altered. I can get the correct SQL= generated but when I execute the string inside the trigger function I get a= n error because it doesn't seem to be able to see the NEW table when it's ru= n with EXECUTE.

So, this works in the trigger= function:

Insert into A (col1,col2,=E2=80=A6colN)<= /div>
Select new.col1,new.co2=E2=80=A6new.colN)

This doesn't:

sql :=3D 'Insert into A (col1,col2,=E2= =80=A6colN) ';
sql :=3D sql || 'Select new.col1,new.co2=E2=80=A6ne= w.colN)';
Execute sql;

ERROR: missing FROM-cla= use entry for table "new"

There is nothing wrong with the resulting code from sql becau= se if I output the string and put it in as static SQL in my trigger it works= .

How do I b= uild the string within the trigger and execute it with a reference to NEW?

Thanks in advance for the help,
James<= /div>

Please read all of:

http://www.postgresql.org/docs/9.2/interactive/plp= gsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

But especially 39.5.4

You want to make= use of format and/or USING to pass in the values to a parameterized dynamic= statement.

Note I linked to 9.2 but any recent ver= sion should have the behavior, if different section numbers.

<= /div>

In short the whole "NEW.name" is a variable and you need to build t= he statement the same way you would with any user-defined variable.

David J.

= --Apple-Mail-36D7E737-FB94-42BA-8828-3130ECFE56D1-- From jsharrett@tidemark.net Fri Sep 14 14:07:02 2012 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCWXu-0006fd-G5 for pgsql-sql@postgresql.org; Fri, 14 Sep 2012 14:07:02 +0000 Received: from mail-pz0-f46.google.com ([209.85.210.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCWXq-0007MA-5H for pgsql-sql@postgresql.org; Fri, 14 Sep 2012 14:07:01 +0000 Received: by dady13 with SMTP id y13so2441730dad.19 for ; Fri, 14 Sep 2012 07:06:56 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=user-agent:date:subject:from:to:cc:message-id:thread-topic :in-reply-to:mime-version:content-type:x-gm-message-state; bh=nMikbbgrDjX4yaB1Af0D+HgbNWn/7gzAWS3dqMv7TNU=; b=F8uAxeWsYiBKgd39XAecZBziE21hHWkCgm9J9xCo15T0oVAvBY6149o9CqCoOyUUMk 7xz2u//VE0w5zl9aXdStpbp94uIlUG+G4TKCrVWnpWV3HEAG/oEW0RH3vhdShSprHvXq EA5zOs4P0ZuZMuor5dZqASiss4I9MFhY4oc4WXQhM35Dnq1AadbNEjZ/iRmylxm2POrb p7dLvBPVxrsu+fhDWAfTzusKaxLgKSU5CwVC5PiOlAwXX2vhzN7TIHVpWLYZikrV5Wq0 /2hFWHC+DZu6b/WQ+HCb4nykObTFmwDxqS7a5F1FkuGGU7VPFIhiC0mIu2e2dkcaYjrC kldA== Received: by 10.68.218.100 with SMTP id pf4mr5156370pbc.122.1347631616017; Fri, 14 Sep 2012 07:06:56 -0700 (PDT) Received: from [10.150.155.213] ([12.177.140.2]) by mx.google.com with ESMTPS id kj10sm1027493pbc.72.2012.09.14.07.06.53 (version=SSLv3 cipher=OTHER); Fri, 14 Sep 2012 07:06:55 -0700 (PDT) User-Agent: Microsoft-MacOutlook/14.2.3.120616 Date: Fri, 14 Sep 2012 10:06:50 -0400 Subject: Re: ERROR: missing FROM-clause entry for table "new" From: James Sharrett To: David Johnston CC: "" Message-ID: Thread-Topic: [SQL] ERROR: missing FROM-clause entry for table "new" In-Reply-To: <4A8E4483-31D7-437C-8D4E-6D0DD2AF1B02@yahoo.com> Mime-version: 1.0 Content-type: multipart/alternative; boundary="B_3430462014_73772" X-Gm-Message-State: ALoCoQkQKrRDv+LyA3VO/3bi/X/OgQVDv+RHEHp4mCZ79vQwUI0iE2s7UorFERiE6UYm/b5++/Tz X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201209/41 X-Sequence-Number: 36843 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3430462014_73772 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable > I'm trying to define a trigger function that looks for changes in table A > (table the trigger for the function is on) and write a delta record into = table > B. So if a record has a value of 100 in table A, and it is updated to 50= , the > function should write =AD50 in table B. I can get the trigger to work with > static SQL statements but for the actual code, I need to use dynamic SQL > because I need to alter the insert statement to B depending on what colum= n in > table A is altered. I can get the correct SQL generated but when I execu= te > the string inside the trigger function I get an error because it doesn't = seem > to be able to see the NEW table when it's run with EXECUTE. >=20 > So, this works in the trigger function: >=20 > Insert into A (col1,col2,=8AcolN) > Select new.col1,new.co2=8Anew.colN) >=20 > This doesn't: >=20 > sql :=3D 'Insert into A (col1,col2,=8AcolN) '; > sql :=3D sql || 'Select new.col1,new.co2=8Anew.colN)'; > Execute sql; >=20 > ERROR: missing FROM-clause entry for table "new" >=20 >=20 >=20 > There is nothing wrong with the resulting code from sql because if I outp= ut > the string and put it in as static SQL in my trigger it works. >=20 >=20 >=20 > How do I build the string within the trigger and execute it with a refere= nce > to NEW? >=20 >=20 > Thanks in advance for the help, > James >=20 Please read all of: http://www.postgresql.org/docs/9.2/interactive/plpgsql-statements.html#PLPG= S QL-STATEMENTS-EXECUTING-DYN But especially 39.5.4 You want to make use of format and/or USING to pass in the values to a parameterized dynamic statement. Note I linked to 9.2 but any recent version should have the behavior, if different section numbers. In short the whole "NEW.name" is a variable and you need to build the statement the same way you would with any user-defined variable. David J. --------------------------------- Thanks for the reference David. I'm now able to get the sql statement to run as dynamic sql with the following syntax > sql :=3D 'Insert into A (col1,col2,=8AcolN) '; > sql :=3D sql || 'values($1,$2,=8A$N )'; > Execute sql USING new.col1,new.col2=8Anew.colN But that still leaves me with the problem that new.col1 =AD colN aren't known till runtime. My list of columns could vary from 5 to 50 depending on the specific update scenario. Inside the sql string I can dynamically build $1 - $N using a counter in my loop that gets the appropriate column list but how do I dynamically build the USING list? I tried put in a text variable that contained a delimited list of columns as such: list =3D new.col1,new.col2=8Anew.colN > sql :=3D 'Insert into A (col1,col2,=8AcolN) '; > sql :=3D sql || 'values($1,$2,=8A$N )'; > Execute sql USING list >=20 > But that gives the error: > ERROR: there is no parameter $2 LINE 1: ...endcategory_id,time_id,metric,amount) values ($1,$2,$3,$4,$... --B_3430462014_73772 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable <= div>

I'm trying= to define a trigger function that looks for changes in table A (table the t= rigger for the function is on) and write a delta record into table B. = So if a record has a value of 100 in table A, and it is updated to 50, the f= unction should write –50 in table B. I can get the trigger to work wit= h static SQL statements but for the actual code, I need to use dynamic SQL b= ecause I need to alter the insert statement to B depending on what column in= table A is altered. I can get the correct SQL generated but when I ex= ecute the string inside the trigger function I get an error because it doesn= 't seem to be able to see the NEW table when it's run with EXECUTE.

So, this works in the trigger function:
Insert into A (col1,col2,…colN)
Select new.col1,= new.co2…new.colN)

This doesn't:
sql :=3D 'Insert into A (col1,col2,…colN) ';
sql := =3D sql || 'Select new.col1,new.co2…new.colN)';
Execute sql;

ERROR: missing FROM-clause entry for table "new"

There is nothing wrong wi= th the resulting code from sql because if I output the string and put it in = as static SQL in my trigger it works.

How do I build the string within the trigger and exec= ute it with a reference to NEW?

Thanks in advan= ce for the help,
James

Please read all of:

http://www.postgresql.org/docs/9.2/interactive/plpgsql-statements.html#PLPG= SQL-STATEMENTS-EXECUTING-DYN

But especially 39.= 5.4

You want to make use of format and/or USI= NG to pass in the values to a parameterized dynamic statement.

Note I linked to 9.2 but any recent version should have the beha= vior, if different section numbers.

In short the wh= ole "NEW.name" is a variable and you need to build the statement the same wa= y you would with any user-defined variable.

David J= .

---------------= ------------------

Thanks for the reference David. = I'm now able to get the sql statement to run as dynamic sql with the f= ollowing syntax

sql :=3D= 'Insert into A (col1,col2,…colN) ';
sql :=3D sql || 'values($= 1,$2,…$N )';
Execute sql USING new.col1,new.col2…= new.colN

But that still leaves me with the problem that new.col= 1 – colN aren't known till runtime. My list of columns could var= y from 5 to 50 depending on the specific update scenario. Inside the s= ql string I can dynamically build $1 - $N using a counter in my loop that ge= ts the appropriate column list but how do I dynamically build the USING list= ? I tried put in a text variable that contained a delimited list of co= lumns as such:

list =3D new.c= ol1,new.col2…new.colN

sql = :=3D 'Insert into A (col1,col2,…colN) ';
sql :=3D sql || 'values= ($1,$2,…$N )';
Execute sql USING list

But that gives the error:
ERROR: there is no parameter $2

LINE 1: ...e= ndcategory_id,time_id,metric,amount) values ($1,$2,$3,$4,$...

--B_3430462014_73772-- From giantmetfan@comcast.net Tue Apr 30 13:41:32 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLT0y-0006qu-4x for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 13:41:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLT0w-0003Hq-Bp for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 13:41:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLT0v-0003BX-EX for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 13:41:42 +0000 Received: from resqmta-po-11v.sys.comcast.net ([2001:558:fe16:19:96:114:154:170]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLT0r-00008O-JU for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 13:41:39 +0000 Received: from resomta-po-14v.sys.comcast.net ([96.114.154.238]) by resqmta-po-11v.sys.comcast.net with ESMTP id LSTVhXj00VIRHLT0phvpIN; Tue, 30 Apr 2019 13:41:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1556631695; bh=6O5BE/VmITL114VHXuBXrkVODYK2/PBlFdZX2ZEQ4xo=; h=Received:Received:Date:From:Reply-To:To:Message-ID:Subject: MIME-Version:Content-Type; b=agL79HIpCQrZpnBsa+71/OHB/njfA9Ep1aHIsbkmzTwT4qY7mqpVeDezS1/RJvs+M 2JkqnVkRrByslPGwKIySO0wQ3f15FLa+QEXaeva9gTVqxPT4vleVCUIzGyRVog0lNU HWO40NVi+SsTXHHPDiiwQVHD4lrHJJy3fh8vtOAi75a5Mik8jYbaJje4t2a/MglEmi 1h4Y425SuHlYKSm8AmjwVTpk6zDNqT8qS/mWw8lf1PYjWU5xWwHwo7F9iylW9vc7MU ggOp8koaPp2BnSauUYkWKrNS6TvkMobOUUiEMa6IGlQkrdWZZKm2ZmtUIKhbjjBrhJ p/SwvDamAf+5Q== Received: from oxapp-asd-17o.email.comcast.net ([96.115.233.255]) by resomta-po-14v.sys.comcast.net with ESMTPS id LT0ohJiQ8wpUALT0ohoKp4; Tue, 30 Apr 2019 13:41:34 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduuddrieehgddtiecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddtnecuogfthfevqddquegrugfkmhhpohhrthgrnhgtvgculddvtddmnecujfgurhepfffhrhfvkffugggtrfgkofhisegrtdgssgertdejnecuhfhrohhmpefoihhkvgcunfetkgfnqfcuoehgihgrnhhtmhgvthhfrghnsegtohhmtggrshhtrdhnvghtqeenucfkphepleeirdduudehrddvfeefrddvheehpdduheehrddujeekrddukedtrdduudenucfrrghrrghmpehhvghlohepohigrghpphdqrghsugdqudejohdrvghmrghilhdrtghomhgtrghsthdrnhgvthdpihhnvghtpeeliedrudduhedrvdeffedrvdehhedpmhgrihhlfhhrohhmpehgihgrnhhtmhgvthhfrghnsegtohhmtggrshhtrdhnvghtpdhrtghpthhtohepphhgshhqlhdqshhqlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptd X-Xfinity-VMeta: sc=20;st=legit Date: Tue, 30 Apr 2019 09:41:32 -0400 (EDT) From: Mike LAZLO Reply-To: Mike LAZLO To: pgsql-sql@lists.postgresql.org Message-ID: <625497565.102576.1556631694006@connect.xfinity.com> Subject: ERROR: missing FROM-clause entry for table "new" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_102575_17423103.1556631694001" X-Priority: 3 Importance: Medium X-Mailer: Open-Xchange Mailer v7.8.4-Rev38 X-Originating-IP: ::ffff:155.178.180.11 X-Originating-Client: open-xchange-appsuite List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_102575_17423103.1556631694001 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit What is wrong with this picture: --trigger function: CREATE OR REPLACE FUNCTION populateAircraft() RETURNS TRIGGER AS $populateAircraft$ BEGIN INSERT INTO AIRCRAFT VALUES (NEW.ev_id , NEW.NEW.aircraft_key::int , NEW.NEW.regis_no , NEW.NEW.ntsb_no , NEW.acft_missing , NEW.far_part , NEW.flt_plan_filed , NEW.flight_plan_activated , NEW.damage , NEW.acft_fire , NEW.acft_expl , NEW.acft_make , NEW.acft_model , NEW.acft_series , NEW.acft_serial_no , NEW.cert_max_gr_wt::int , NEW.acft_category , NEW.acft_reg_cls , NEW.homebuilt , NEW.fc_seats::int , NEW.cc_seats::int , NEW.pax_seats::int , NEW.total_seats::smallint , NEW.num_eng::smallint , NEW.fixed_retractable , NEW.type_last_insp , TO_TIMESTAMP(NEW.date_last_insp,'MM/DD/YY HH24:MI:SS') , NEW.afm_hrs_last_insp::real , NEW.afm_hrs::real , NEW.elt_install , NEW.elt_oper , NEW.elt_aided_loc_ev , NEW.elt_type , NEW.owner_acft , NEW.owner_street , NEW.owner_city , NEW.owner_state , NEW.owner_country , NEW.owner_zip , NEW.oper_individual_name , NEW.oper_name , NEW.oper_same , NEW.oper_dba , NEW.oper_addr_same , NEW.oper_street , NEW.oper_city , NEW.oper_state , NEW.oper_country , NEW.oper_zip , NEW.oper_code , NEW.certs_held , NEW.oprtng_cert , NEW.oper_cert , NEW.oper_cert_num , NEW.oper_sched , NEW.oper_dom_int , NEW.oper_pax_cargo , NEW.type_fly , NEW.second_pilot , NEW.dprt_pt_same_ev , NEW.dprt_apt_id , NEW.dprt_city , NEW.dprt_state , NEW.dprt_country , NEW.dprt_time::smallint , NEW.dprt_timezn , NEW.dest_same_local , NEW.dest_apt_id , NEW.dest_city , NEW.dest_state , NEW.dest_country , NEW.phase_flt_spec::int , NEW.report_to_icao , NEW.evacuation , TO_TIMESTAMP(NEW.lchg_date,'MM/DD/YY HH24:MI:SS') , NEW.lchg_userid , NEW.afm_hrs_since , NEW.rwy_num , NEW.rwy_len::int , NEW.rwy_width::int , NEW.site_seeing , NEW.air_medical , NEW.med_type_flight , NEW.acft_year::int , NEW.fuel_on_board , NEW.commercial_space_flight::bit , NEW.unmanned::bit , NEW.ifr_equipped_cert::bit , NEW.elt_mounted_aircraft::bit , NEW.elt_connected_antenna::bit , NEW.elt_manufacturer , NEW.elt_model , NEW.elt_reason_other::text); RETURN NULL; -- result is ignored since this is an AFTER trigger END; $populateAircraft$ LANGUAGE plpgsql; -- Trigger: CREATE TRIGGER UTR_AI_STAGE_AIRCRAFT AFTER INSERT ON STAGE_AIRCRAFT FOR EACH ROW EXECUTE PROCEDURE populateAircraft(); --Insert: INSERT INTO ntsbdata.ssa.stage_aircraft (ev_id, aircraft_key, regis_no, ntsb_no, acft_missing, far_part, flt_plan_filed, flight_plan_activated, damage, acft_fire, acft_expl, acft_make, acft_model, acft_series, acft_serial_no, cert_max_gr_wt, acft_category, acft_reg_cls, homebuilt, fc_seats, cc_seats, pax_seats, total_seats, num_eng, fixed_retractable, type_last_insp, date_last_insp, afm_hrs_last_insp, afm_hrs, elt_install, elt_oper, elt_aided_loc_ev, elt_type, owner_acft, owner_street, owner_city, owner_state, owner_country, owner_zip, oper_individual_name, oper_name, oper_same, oper_dba, oper_addr_same, oper_street, oper_city, oper_state, oper_country, oper_zip, oper_code, certs_held, oprtng_cert, oper_cert, oper_cert_num, oper_sched, oper_dom_int, oper_pax_cargo, type_fly, second_pilot, dprt_pt_same_ev, dprt_apt_id, dprt_city, dprt_state, dprt_country, dprt_time, dprt_timezn, dest_same_local, dest_apt_id, dest_city, dest_state, dest_country, phase_flt_spec, report_to_icao, evacuation, lchg_date, lchg_userid, afm_hrs_since, rwy_num, rwy_len, rwy_width, site_seeing, air_medical, med_type_flight, acft_year, fuel_on_board, commercial_space_flight, unmanned, ifr_equipped_cert, elt_mounted_aircraft, elt_connected_antenna, elt_manufacturer, elt_model, elt_reason_other) VALUES ('20001208X07734','1','N6172C','LAX97FA143 ','N','091 ','IFR ',NULL,'DEST','NONE','NONE','Cessna ','T210N ','T210N ','210-63820 ','3800','AIR ','USUS','N',NULL,NULL,NULL,'6','1','RETR','ANNL','11/16/96 00:00:00','3.40000000e+01','1.64300000e+03','Y','U','U',NULL,'JAMES E. ELDREDGE ','4039 KNOLL RIDGE AVE. ','LAS VEGAS ','NV',' ','89030 ',NULL,' ','Y','RANGER ENTERPRISES ','Y',' ',' ',' ',' ',' ',' ','N','N ','UNK',NULL,NULL,NULL,NULL,'PERS','N','N','LVS ','LAS VEGAS ','NM',' ','1750','MST','LOCL','VGT ',' ','NV',' ','540',NULL,NULL,'01/02/01 10:34:39','dbo',NULL,'0',NULL,NULL,'N','N',NULL,NULL,NULL,'0','0','0','0','0',NULL,NULL,NULL) was aborted: ERROR: missing FROM-clause entry for table "new" Where: PL/pgSQL function populateaircraft() line 26 at SQL statement ? The only thing I can find related to this error with NEW variables is dynamic pl/pgsql which this is not. Thanks in advanced ------=_Part_102575_17423103.1556631694001 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

What is wrong with this picture:

--trigger function:
=

CREATE OR REPLACE FUNCTION populateAircraft() RETURNS TRIGGER AS $populateAircraft$
BEGIN

INSERT INTO A= IRCRAFT
VALUES (NEW.ev_id
, NEW.NEW.aircraft_key::int
, NEW.NE= W.regis_no
, NEW.NEW.ntsb_no
, NEW.acft_missing
, NEW.far_part<= br> , NEW.flt_plan_filed
, NEW.flight_plan_activated
, NEW.damage , NEW.acft_fire
, NEW.acft_expl
, NEW.acft_make
, NEW.acft_m= odel
, NEW.acft_series
, NEW.acft_serial_no
, NEW.cert_max_gr_w= t::int
, NEW.acft_category
, NEW.acft_reg_cls
, NEW.homebuilt , NEW.fc_seats::int
, NEW.cc_seats::int
, NEW.pax_seats::int
= , NEW.total_seats::smallint
, NEW.num_eng::smallint
, NEW.fixed_re= tractable
, NEW.type_last_insp
, TO_TIMESTAMP(NEW.date_last_insp,&#= 39;MM/DD/YY HH24:MI:SS')
, NEW.afm_hrs_last_insp::real
, NEW.af= m_hrs::real
, NEW.elt_install
, NEW.elt_oper
, NEW.elt_aided_lo= c_ev
, NEW.elt_type
, NEW.owner_acft
, NEW.owner_street
, N= EW.owner_city
, NEW.owner_state
, NEW.owner_country
, NEW.owner= _zip
, NEW.oper_individual_name
, NEW.oper_name
, NEW.oper_same=
, NEW.oper_dba
, NEW.oper_addr_same
, NEW.oper_street
, NE= W.oper_city
, NEW.oper_state
, NEW.oper_country
, NEW.oper_zip<= br> , NEW.oper_code
, NEW.certs_held
, NEW.oprtng_cert
, NEW.op= er_cert
, NEW.oper_cert_num
, NEW.oper_sched
, NEW.oper_dom_int=
, NEW.oper_pax_cargo
, NEW.type_fly
, NEW.second_pilot
, N= EW.dprt_pt_same_ev
, NEW.dprt_apt_id
, NEW.dprt_city
, NEW.dprt= _state
, NEW.dprt_country
, NEW.dprt_time::smallint
, NEW.dprt_= timezn
, NEW.dest_same_local
, NEW.dest_apt_id
, NEW.dest_city<= br> , NEW.dest_state
, NEW.dest_country
, NEW.phase_flt_spec::int , NEW.report_to_icao
, NEW.evacuation
, TO_TIMESTAMP(NEW.lchg_da= te,'MM/DD/YY HH24:MI:SS')
, NEW.lchg_userid
, NEW.afm_hrs_s= ince
, NEW.rwy_num
, NEW.rwy_len::int
, NEW.rwy_width::int
= , NEW.site_seeing
, NEW.air_medical
, NEW.med_type_flight
, NEW= .acft_year::int
, NEW.fuel_on_board
, NEW.commercial_space_flight::= bit
, NEW.unmanned::bit
, NEW.ifr_equipped_cert::bit
, NEW.elt_= mounted_aircraft::bit
, NEW.elt_connected_antenna::bit
, NEW.elt_ma= nufacturer
, NEW.elt_model
, NEW.elt_reason_other::text);
RETUR= N NULL; -- result is ignored since this is an AFTER trigger
END;
$pop= ulateAircraft$ LANGUAGE plpgsql;

-- Trigger:

CREATE TRIGGER UTR_A= I_STAGE_AIRCRAFT
AFTER INSERT ON STAGE_AIRCRAFT
FOR EACH ROW
E= XECUTE PROCEDURE populateAircraft();

--Insert:

INSERT INTO ntsbdat= a.ssa.stage_aircraft (ev_id, aircraft_key, regis_no, ntsb_no, acft_missing,= far_part, flt_plan_filed, flight_plan_activated, damage, acft_fire, acft_e= xpl, acft_make, acft_model, acft_series, acft_serial_no, cert_max_gr_wt, ac= ft_category, acft_reg_cls, homebuilt, fc_seats, cc_seats, pax_seats, total_= seats, num_eng, fixed_retractable, type_last_insp, date_last_insp, afm_hrs_= last_insp, afm_hrs, elt_install, elt_oper, elt_aided_loc_ev, elt_type, owne= r_acft, owner_street, owner_city, owner_state, owner_country, owner_zip, op= er_individual_name, oper_name, oper_same, oper_dba, oper_addr_same, oper_st= reet, oper_city, oper_state, oper_country, oper_zip, oper_code, certs_held,= oprtng_cert, oper_cert, oper_cert_num, oper_sched, oper_dom_int, oper_pax_= cargo, type_fly, second_pilot, dprt_pt_same_ev, dprt_apt_id, dprt_city, dpr= t_state, dprt_country, dprt_time, dprt_timezn, dest_same_local, dest_apt_id= , dest_city, dest_state, dest_country, phase_flt_spec, report_to_icao, evac= uation, lchg_date, lchg_userid, afm_hrs_since, rwy_num, rwy_len, rwy_width,= site_seeing, air_medical, med_type_flight, acft_year, fuel_on_board, comme= rcial_space_flight, unmanned, ifr_equipped_cert, elt_mounted_aircraft, elt_= connected_antenna, elt_manufacturer, elt_model, elt_reason_other) VALUES (&= #39;20001208X07734','1','N6172C','LAX97FA143 ',= 'N','091 ','IFR ',NULL,'DEST','NONE'= ;,'NONE','Cessna ','T210N ','T210N ','2= 10-63820 ','3800','AIR ','USUS','N',NUL= L,NULL,NULL,'6','1','RETR','ANNL','11/1= 6/96 00:00:00','3.40000000e+01','1.64300000e+03','Y= ','U','U',NULL,'JAMES E. ELDREDGE ','4039 K= NOLL RIDGE AVE. ','LAS VEGAS ','NV',' ','89= 030 ',NULL,' ','Y','RANGER ENTERPRISES ','Y= ',' ',' ',' ',' ',' ',' = 9;,'N','N ','UNK',NULL,NULL,NULL,NULL,'PERS'= ;,'N','N','LVS ','LAS VEGAS ','NM',= ' ','1750','MST','LOCL','VGT ','= ; ','NV',' ','540',NULL,NULL,'01/02/01 10:3= 4:39','dbo',NULL,'0',NULL,NULL,'N','N',= NULL,NULL,NULL,'0','0','0','0','0',= NULL,NULL,NULL) was aborted: ERROR: missing FROM-clause entry for table = 4;new"

Where: PL/pgSQL function populateaircra= ft() line 26 at SQL statement

The only thing I can find related = to this error with NEW variables is dynamic pl/pgsql which this is not.
=

Thanks in advanced<= br>

=20 ------=_Part_102575_17423103.1556631694001-- From tgl@sss.pgh.pa.us Tue Apr 30 13:47:38 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLT6p-0007DM-79 for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 13:47:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLT6n-0000km-HY for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 13:47:45 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLT6n-0000jX-8S for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 13:47:45 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLT6l-0007Ru-6C for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 13:47:44 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x3UDlcpv026224; Tue, 30 Apr 2019 09:47:38 -0400 From: Tom Lane To: Mike LAZLO cc: pgsql-sql@lists.postgresql.org Subject: Re: ERROR: missing FROM-clause entry for table "new" In-reply-to: <625497565.102576.1556631694006@connect.xfinity.com> References: <625497565.102576.1556631694006@connect.xfinity.com> Comments: In-reply-to Mike LAZLO message dated "Tue, 30 Apr 2019 09:41:32 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <26221.1556632058.1@sss.pgh.pa.us> Date: Tue, 30 Apr 2019 09:47:38 -0400 Message-ID: <26223.1556632058@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Mike LAZLO writes: > What is wrong with this picture: Hm, the error message is pretty unhelpful, but I think the root problem is too many "NEW"s in several places: > , NEW.NEW.aircraft_key::int ^^^^^^^ regards, tom lane From Jean-Marc.Voillequin@moodys.com Tue Apr 30 13:53:44 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLTLp-0007z6-CF for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 14:03:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLTLl-0000gH-FM for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 14:03:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLTLk-0000ez-R1 for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 14:03:13 +0000 Received: from esa1.moodyscorp.iphmx.com ([68.232.147.194]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLTLf-0000cc-Ak for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 14:03:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=moodys.com; i=@moodys.com; q=dns/txt; s=moodys; t=1556632987; x=1588168987; h=from:to:subject:date:message-id:references:in-reply-to: mime-version; bh=RSoorc9gDqxJQqvrRVueiy3AU+tXWOcbyXAUc5nfdHA=; b=LOiyj1ccITtB5lWmhzATxHekkpfebaDBlMnlblUxukJv27gUa+NipFDm RM9M0eARFO1mfrnkBIbXXDUa1jLnkEaLKaBtyNhw0ITbiV4z/X8EFBWsB 8JxWnu1PoGlLx0vdlbn/tB2mCN9zgjxvBQ4t1gz70SjczN4MyOjTfzIrd Y=; Authentication-Results: esa1.moodyscorp.iphmx.com; dkim=none (message not signed) header.i=none X-IronPort-AV: E=Sophos;i="5.60,413,1549951200"; d="scan'208,217";a="176368076" Received: from mdyptcvmlrly102.moodys.com (HELO ptc-lbemlrly702.mcoz.tld) ([141.160.13.56]) by esa1.moodyscorp.iphmx.com with ESMTP/TLS/DHE-RSA-AES256-GCM-SHA384; 30 Apr 2019 08:53:48 -0500 Received: from LON-WGCAS702.ad.moodys.net ([10.0.100.58]) by ptc-lbemlrly702.mcoz.tld (8.14.7/8.14.7) with ESMTP id x3UDrhse016262 (version=TLSv1/SSLv3 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=FAIL); Tue, 30 Apr 2019 09:53:46 -0400 Received: from LON-WGMSX712.ad.moodys.net ([169.254.4.251]) by LON-WGCAS702.ad.moodys.net ([10.0.100.58]) with mapi id 14.03.0439.000; Tue, 30 Apr 2019 14:53:44 +0100 From: "Voillequin, Jean-Marc" To: Mike LAZLO , "pgsql-sql@lists.postgresql.org" Subject: RE: ERROR: missing FROM-clause entry for table "new" Thread-Topic: ERROR: missing FROM-clause entry for table "new" Thread-Index: AQHU/1ugAYX6PgSAZEa+nksxNsH+x6ZUuTAQ Date: Tue, 30 Apr 2019 13:53:44 +0000 Message-ID: <1EC8157EB499BF459A516ADCF135ADCE3A2476A1@LON-WGMSX712.ad.moodys.net> References: <625497565.102576.1556631694006@connect.xfinity.com> In-Reply-To: <625497565.102576.1556631694006@connect.xfinity.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.0.114.121] Content-Type: multipart/alternative; boundary="_000_1EC8157EB499BF459A516ADCF135ADCE3A2476A1LONWGMSX712admo_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_1EC8157EB499BF459A516ADCF135ADCE3A2476A1LONWGMSX712admo_ Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGVsbG8sDQoNCllvdSB3cm90ZSBORVcgdHdpY2U6IE5FVy5ORVcNCg0KSU5TRVJUIElOVE8gQUlS Q1JBRlQNClZBTFVFUyAoTkVXLmV2X2lkDQosIE5FVy5ORVcuYWlyY3JhZnRfa2V5OjppbnQNCiwg TkVXLk5FVy5yZWdpc19ubw0KLCBORVcuTkVXLm50c2Jfbm8NCg0KDQpGcm9tOiBNaWtlIExBWkxP IFttYWlsdG86Z2lhbnRtZXRmYW5AY29tY2FzdC5uZXRdDQpTZW50OiBUdWVzZGF5LCBBcHJpbCAz MCwgMjAxOSAzOjQyIFBNDQpUbzogcGdzcWwtc3FsQGxpc3RzLnBvc3RncmVzcWwub3JnDQpTdWJq ZWN0OiBFUlJPUjogbWlzc2luZyBGUk9NLWNsYXVzZSBlbnRyeSBmb3IgdGFibGUgIm5ldyINCg0K DQpDQVVUSU9OOiBUaGlzIGVtYWlsIG9yaWdpbmF0ZWQgZnJvbSBvdXRzaWRlIG9mIE1vb2R5J3Mu IERvIG5vdCBjbGljayBsaW5rcyBvciBvcGVuIGF0dGFjaG1lbnRzIHVubGVzcyB5b3UgcmVjb2du aXplIHRoZSBzZW5kZXIgYW5kIGtub3cgdGhlIGNvbnRlbnQgaXMgc2FmZS4NCg0KDQpXaGF0IGlz IHdyb25nIHdpdGggdGhpcyBwaWN0dXJlOg0KDQoNCg0KLS10cmlnZ2VyIGZ1bmN0aW9uOg0KDQpD UkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwb3B1bGF0ZUFpcmNyYWZ0KCkNClJFVFVSTlMgVFJJ R0dFUiBBUyAkcG9wdWxhdGVBaXJjcmFmdCQNCkJFR0lODQoNCg0KSU5TRVJUIElOVE8gQUlSQ1JB RlQNClZBTFVFUyAoTkVXLmV2X2lkDQosIE5FVy5ORVcuYWlyY3JhZnRfa2V5OjppbnQNCiwgTkVX Lk5FVy5yZWdpc19ubw0KLCBORVcuTkVXLm50c2Jfbm8NCiwgTkVXLmFjZnRfbWlzc2luZw0KLCBO RVcuZmFyX3BhcnQNCiwgTkVXLmZsdF9wbGFuX2ZpbGVkDQosIE5FVy5mbGlnaHRfcGxhbl9hY3Rp dmF0ZWQNCiwgTkVXLmRhbWFnZQ0KLCBORVcuYWNmdF9maXJlDQosIE5FVy5hY2Z0X2V4cGwNCiwg TkVXLmFjZnRfbWFrZQ0KLCBORVcuYWNmdF9tb2RlbA0KLCBORVcuYWNmdF9zZXJpZXMNCiwgTkVX LmFjZnRfc2VyaWFsX25vDQosIE5FVy5jZXJ0X21heF9ncl93dDo6aW50DQosIE5FVy5hY2Z0X2Nh dGVnb3J5DQosIE5FVy5hY2Z0X3JlZ19jbHMNCiwgTkVXLmhvbWVidWlsdA0KLCBORVcuZmNfc2Vh dHM6OmludA0KLCBORVcuY2Nfc2VhdHM6OmludA0KLCBORVcucGF4X3NlYXRzOjppbnQNCiwgTkVX LnRvdGFsX3NlYXRzOjpzbWFsbGludA0KLCBORVcubnVtX2VuZzo6c21hbGxpbnQNCiwgTkVXLmZp eGVkX3JldHJhY3RhYmxlDQosIE5FVy50eXBlX2xhc3RfaW5zcA0KLCBUT19USU1FU1RBTVAoTkVX LmRhdGVfbGFzdF9pbnNwLCdNTS9ERC9ZWSBISDI0Ok1JOlNTJykNCiwgTkVXLmFmbV9ocnNfbGFz dF9pbnNwOjpyZWFsDQosIE5FVy5hZm1faHJzOjpyZWFsDQosIE5FVy5lbHRfaW5zdGFsbA0KLCBO RVcuZWx0X29wZXINCiwgTkVXLmVsdF9haWRlZF9sb2NfZXYNCiwgTkVXLmVsdF90eXBlDQosIE5F Vy5vd25lcl9hY2Z0DQosIE5FVy5vd25lcl9zdHJlZXQNCiwgTkVXLm93bmVyX2NpdHkNCiwgTkVX Lm93bmVyX3N0YXRlDQosIE5FVy5vd25lcl9jb3VudHJ5DQosIE5FVy5vd25lcl96aXANCiwgTkVX Lm9wZXJfaW5kaXZpZHVhbF9uYW1lDQosIE5FVy5vcGVyX25hbWUNCiwgTkVXLm9wZXJfc2FtZQ0K LCBORVcub3Blcl9kYmENCiwgTkVXLm9wZXJfYWRkcl9zYW1lDQosIE5FVy5vcGVyX3N0cmVldA0K LCBORVcub3Blcl9jaXR5DQosIE5FVy5vcGVyX3N0YXRlDQosIE5FVy5vcGVyX2NvdW50cnkNCiwg TkVXLm9wZXJfemlwDQosIE5FVy5vcGVyX2NvZGUNCiwgTkVXLmNlcnRzX2hlbGQNCiwgTkVXLm9w cnRuZ19jZXJ0DQosIE5FVy5vcGVyX2NlcnQNCiwgTkVXLm9wZXJfY2VydF9udW0NCiwgTkVXLm9w ZXJfc2NoZWQNCiwgTkVXLm9wZXJfZG9tX2ludA0KLCBORVcub3Blcl9wYXhfY2FyZ28NCiwgTkVX LnR5cGVfZmx5DQosIE5FVy5zZWNvbmRfcGlsb3QNCiwgTkVXLmRwcnRfcHRfc2FtZV9ldg0KLCBO RVcuZHBydF9hcHRfaWQNCiwgTkVXLmRwcnRfY2l0eQ0KLCBORVcuZHBydF9zdGF0ZQ0KLCBORVcu ZHBydF9jb3VudHJ5DQosIE5FVy5kcHJ0X3RpbWU6OnNtYWxsaW50DQosIE5FVy5kcHJ0X3RpbWV6 bg0KLCBORVcuZGVzdF9zYW1lX2xvY2FsDQosIE5FVy5kZXN0X2FwdF9pZA0KLCBORVcuZGVzdF9j aXR5DQosIE5FVy5kZXN0X3N0YXRlDQosIE5FVy5kZXN0X2NvdW50cnkNCiwgTkVXLnBoYXNlX2Zs dF9zcGVjOjppbnQNCiwgTkVXLnJlcG9ydF90b19pY2FvDQosIE5FVy5ldmFjdWF0aW9uDQosIFRP X1RJTUVTVEFNUChORVcubGNoZ19kYXRlLCdNTS9ERC9ZWSBISDI0Ok1JOlNTJykNCiwgTkVXLmxj aGdfdXNlcmlkDQosIE5FVy5hZm1faHJzX3NpbmNlDQosIE5FVy5yd3lfbnVtDQosIE5FVy5yd3lf bGVuOjppbnQNCiwgTkVXLnJ3eV93aWR0aDo6aW50DQosIE5FVy5zaXRlX3NlZWluZw0KLCBORVcu YWlyX21lZGljYWwNCiwgTkVXLm1lZF90eXBlX2ZsaWdodA0KLCBORVcuYWNmdF95ZWFyOjppbnQN CiwgTkVXLmZ1ZWxfb25fYm9hcmQNCiwgTkVXLmNvbW1lcmNpYWxfc3BhY2VfZmxpZ2h0OjpiaXQN CiwgTkVXLnVubWFubmVkOjpiaXQNCiwgTkVXLmlmcl9lcXVpcHBlZF9jZXJ0OjpiaXQNCiwgTkVX LmVsdF9tb3VudGVkX2FpcmNyYWZ0OjpiaXQNCiwgTkVXLmVsdF9jb25uZWN0ZWRfYW50ZW5uYTo6 Yml0DQosIE5FVy5lbHRfbWFudWZhY3R1cmVyDQosIE5FVy5lbHRfbW9kZWwNCiwgTkVXLmVsdF9y ZWFzb25fb3RoZXI6OnRleHQpOw0KUkVUVVJOIE5VTEw7IC0tIHJlc3VsdCBpcyBpZ25vcmVkIHNp bmNlIHRoaXMgaXMgYW4gQUZURVIgdHJpZ2dlcg0KRU5EOw0KJHBvcHVsYXRlQWlyY3JhZnQkIExB TkdVQUdFIHBscGdzcWw7DQoNCg0KDQotLSBUcmlnZ2VyOg0KDQpDUkVBVEUgVFJJR0dFUiBVVFJf QUlfU1RBR0VfQUlSQ1JBRlQNCkFGVEVSIElOU0VSVCBPTiBTVEFHRV9BSVJDUkFGVA0KRk9SIEVB Q0ggUk9XDQpFWEVDVVRFIFBST0NFRFVSRSBwb3B1bGF0ZUFpcmNyYWZ0KCk7DQoNCg0KDQotLUlu c2VydDoNCg0KSU5TRVJUIElOVE8gbnRzYmRhdGEuc3NhLnN0YWdlX2FpcmNyYWZ0IChldl9pZCwg YWlyY3JhZnRfa2V5LCByZWdpc19ubywgbnRzYl9ubywgYWNmdF9taXNzaW5nLCBmYXJfcGFydCwg Zmx0X3BsYW5fZmlsZWQsIGZsaWdodF9wbGFuX2FjdGl2YXRlZCwgZGFtYWdlLCBhY2Z0X2ZpcmUs IGFjZnRfZXhwbCwgYWNmdF9tYWtlLCBhY2Z0X21vZGVsLCBhY2Z0X3NlcmllcywgYWNmdF9zZXJp YWxfbm8sIGNlcnRfbWF4X2dyX3d0LCBhY2Z0X2NhdGVnb3J5LCBhY2Z0X3JlZ19jbHMsIGhvbWVi dWlsdCwgZmNfc2VhdHMsIGNjX3NlYXRzLCBwYXhfc2VhdHMsIHRvdGFsX3NlYXRzLCBudW1fZW5n LCBmaXhlZF9yZXRyYWN0YWJsZSwgdHlwZV9sYXN0X2luc3AsIGRhdGVfbGFzdF9pbnNwLCBhZm1f aHJzX2xhc3RfaW5zcCwgYWZtX2hycywgZWx0X2luc3RhbGwsIGVsdF9vcGVyLCBlbHRfYWlkZWRf bG9jX2V2LCBlbHRfdHlwZSwgb3duZXJfYWNmdCwgb3duZXJfc3RyZWV0LCBvd25lcl9jaXR5LCBv d25lcl9zdGF0ZSwgb3duZXJfY291bnRyeSwgb3duZXJfemlwLCBvcGVyX2luZGl2aWR1YWxfbmFt ZSwgb3Blcl9uYW1lLCBvcGVyX3NhbWUsIG9wZXJfZGJhLCBvcGVyX2FkZHJfc2FtZSwgb3Blcl9z dHJlZXQsIG9wZXJfY2l0eSwgb3Blcl9zdGF0ZSwgb3Blcl9jb3VudHJ5LCBvcGVyX3ppcCwgb3Bl cl9jb2RlLCBjZXJ0c19oZWxkLCBvcHJ0bmdfY2VydCwgb3Blcl9jZXJ0LCBvcGVyX2NlcnRfbnVt LCBvcGVyX3NjaGVkLCBvcGVyX2RvbV9pbnQsIG9wZXJfcGF4X2NhcmdvLCB0eXBlX2ZseSwgc2Vj b25kX3BpbG90LCBkcHJ0X3B0X3NhbWVfZXYsIGRwcnRfYXB0X2lkLCBkcHJ0X2NpdHksIGRwcnRf c3RhdGUsIGRwcnRfY291bnRyeSwgZHBydF90aW1lLCBkcHJ0X3RpbWV6biwgZGVzdF9zYW1lX2xv Y2FsLCBkZXN0X2FwdF9pZCwgZGVzdF9jaXR5LCBkZXN0X3N0YXRlLCBkZXN0X2NvdW50cnksIHBo YXNlX2ZsdF9zcGVjLCByZXBvcnRfdG9faWNhbywgZXZhY3VhdGlvbiwgbGNoZ19kYXRlLCBsY2hn X3VzZXJpZCwgYWZtX2hyc19zaW5jZSwgcnd5X251bSwgcnd5X2xlbiwgcnd5X3dpZHRoLCBzaXRl X3NlZWluZywgYWlyX21lZGljYWwsIG1lZF90eXBlX2ZsaWdodCwgYWNmdF95ZWFyLCBmdWVsX29u X2JvYXJkLCBjb21tZXJjaWFsX3NwYWNlX2ZsaWdodCwgdW5tYW5uZWQsIGlmcl9lcXVpcHBlZF9j ZXJ0LCBlbHRfbW91bnRlZF9haXJjcmFmdCwgZWx0X2Nvbm5lY3RlZF9hbnRlbm5hLCBlbHRfbWFu dWZhY3R1cmVyLCBlbHRfbW9kZWwsIGVsdF9yZWFzb25fb3RoZXIpIFZBTFVFUyAoJzIwMDAxMjA4 WDA3NzM0JywnMScsJ042MTcyQycsJ0xBWDk3RkExNDMgJywnTicsJzA5MSAnLCdJRlIgJyxOVUxM LCdERVNUJywnTk9ORScsJ05PTkUnLCdDZXNzbmEgJywnVDIxME4gJywnVDIxME4gJywnMjEwLTYz ODIwICcsJzM4MDAnLCdBSVIgJywnVVNVUycsJ04nLE5VTEwsTlVMTCxOVUxMLCc2JywnMScsJ1JF VFInLCdBTk5MJywnMTEvMTYvOTYgMDA6MDA6MDAnLCczLjQwMDAwMDAwZSswMScsJzEuNjQzMDAw MDBlKzAzJywnWScsJ1UnLCdVJyxOVUxMLCdKQU1FUyBFLiBFTERSRURHRSAnLCc0MDM5IEtOT0xM IFJJREdFIEFWRS4gJywnTEFTIFZFR0FTICcsJ05WJywnICcsJzg5MDMwICcsTlVMTCwnICcsJ1kn LCdSQU5HRVIgRU5URVJQUklTRVMgJywnWScsJyAnLCcgJywnICcsJyAnLCcgJywnICcsJ04nLCdO ICcsJ1VOSycsTlVMTCxOVUxMLE5VTEwsTlVMTCwnUEVSUycsJ04nLCdOJywnTFZTICcsJ0xBUyBW RUdBUyAnLCdOTScsJyAnLCcxNzUwJywnTVNUJywnTE9DTCcsJ1ZHVCAnLCcgJywnTlYnLCcgJywn NTQwJyxOVUxMLE5VTEwsJzAxLzAyLzAxIDEwOjM0OjM5JywnZGJvJyxOVUxMLCcwJyxOVUxMLE5V TEwsJ04nLCdOJyxOVUxMLE5VTEwsTlVMTCwnMCcsJzAnLCcwJywnMCcsJzAnLE5VTEwsTlVMTCxO VUxMKSB3YXMgYWJvcnRlZDogRVJST1I6IG1pc3NpbmcgRlJPTS1jbGF1c2UgZW50cnkgZm9yIHRh YmxlICJuZXciDQoNCldoZXJlOiBQTC9wZ1NRTCBmdW5jdGlvbiBwb3B1bGF0ZWFpcmNyYWZ0KCkg bGluZSAyNiBhdCBTUUwgc3RhdGVtZW50DQoNCg0KDQo/DQoNClRoZSBvbmx5IHRoaW5nIEkgY2Fu IGZpbmQgcmVsYXRlZCB0byB0aGlzIGVycm9yIHdpdGggTkVXIHZhcmlhYmxlcyBpcyBkeW5hbWlj IHBsL3Bnc3FsIHdoaWNoIHRoaXMgaXMgbm90Lg0KDQoNCg0KVGhhbmtzIGluIGFkdmFuY2VkDQot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQoKTW9vZHkncyBtb25pdG9y cyBlbWFpbCBjb21tdW5pY2F0aW9ucyB0aHJvdWdoIGl0cyBuZXR3b3JrcyBmb3IgcmVndWxhdG9y eSBjb21wbGlhbmNlIHB1cnBvc2VzIGFuZCB0byBwcm90ZWN0IGl0cyBjdXN0b21lcnMsIGVtcGxv eWVlcyBhbmQgYnVzaW5lc3MgYW5kIHdoZXJlIGFsbG93ZWQgdG8gZG8gc28gYnkgYXBwbGljYWJs ZSBsYXcuIFRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBlLW1haWwgbWVzc2FnZSwg YW5kIGFueSBhdHRhY2htZW50IHRoZXJldG8sIGlzIGNvbmZpZGVudGlhbCBhbmQgbWF5IG5vdCBi ZSBkaXNjbG9zZWQgd2l0aG91dCBvdXIgZXhwcmVzcyBwZXJtaXNzaW9uLiBJZiB5b3UgYXJlIG5v dCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IG9yIGFuIGVtcGxveWVlIG9yIGFnZW50IHJlc3BvbnNp YmxlIGZvciBkZWxpdmVyaW5nIHRoaXMgbWVzc2FnZSB0byB0aGUgaW50ZW5kZWQgcmVjaXBpZW50 LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgbWVz c2FnZSBpbiBlcnJvciBhbmQgdGhhdCBhbnkgcmV2aWV3LCBkaXNzZW1pbmF0aW9uLCBkaXN0cmli dXRpb24gb3IgY29weWluZyBvZiB0aGlzIG1lc3NhZ2UsIG9yIGFueSBhdHRhY2htZW50IHRoZXJl dG8sIGluIHdob2xlIG9yIGluIHBhcnQsIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBo YXZlIHJlY2VpdmVkIHRoaXMgbWVzc2FnZSBpbiBlcnJvciwgcGxlYXNlIGltbWVkaWF0ZWx5IG5v dGlmeSB1cyBieSB0ZWxlcGhvbmUsIGZheCBvciBlLW1haWwgYW5kIGRlbGV0ZSB0aGUgbWVzc2Fn ZSBhbmQgYWxsIG9mIGl0cyBhdHRhY2htZW50cy4gRXZlcnkgZWZmb3J0IGlzIG1hZGUgdG8ga2Vl cCBvdXIgbmV0d29yayBmcmVlIGZyb20gdmlydXNlcy4gWW91IHNob3VsZCwgaG93ZXZlciwgcmV2 aWV3IHRoaXMgZS1tYWlsIG1lc3NhZ2UsIGFzIHdlbGwgYXMgYW55IGF0dGFjaG1lbnQgdGhlcmV0 bywgZm9yIHZpcnVzZXMuIFdlIHRha2Ugbm8gcmVzcG9uc2liaWxpdHkgYW5kIGhhdmUgbm8gbGlh YmlsaXR5IGZvciBhbnkgY29tcHV0ZXIgdmlydXMgd2hpY2ggbWF5IGJlIHRyYW5zZmVycmVkIHZp YSB0aGlzIGUtbWFpbCBtZXNzYWdlLgoKVGhpcyBlbWFpbCB3YXMgc2VudCB0byB5b3UgYnkgTW9v ZHnigJlzIEludmVzdG9ycyBTZXJ2aWNlIEVNRUEgTGltaXRlZApSZWdpc3RlcmVkIG9mZmljZSBh ZGRyZXNzOgpPbmUgQ2FuYWRhIFNxdWFyZQpDYW5hcnkgV2hhcmYKTG9uZG9uLCBFMTQgNUZBClJl Z2lzdGVyZWQgaW4gRW5nbGFuZCBhbmQgV2FsZXMgTm86IDg5MjI3MDEKCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCg== --_000_1EC8157EB499BF459A516ADCF135ADCE3A2476A1LONWGMSX712admo_ Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 SGVsdmV0aWNhOw0KCXBhbm9zZS0xOjIgMTEgNiA0IDIgMiAyIDIgMiA0O30NCkBmb250LWZhY2UN Cgl7Zm9udC1mYW1pbHk6U2ltU3VuOw0KCXBhbm9zZS0xOjIgMSA2IDAgMyAxIDEgMSAxIDE7fQ0K QGZvbnQtZmFjZQ0KCXtmb250LWZhbWlseToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQg NSAzIDUgNCA2IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglw YW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9DQpAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5 OiJcQFNpbVN1biI7DQoJcGFub3NlLTE6MiAxIDYgMCAzIDEgMSAxIDEgMTt9DQovKiBTdHlsZSBE ZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0K CXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTIuMHB0 Ow0KCWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLHNlcmlmO30NCmE6bGluaywgc3Bhbi5N c29IeXBlcmxpbmsNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOiMwNTYzQzE7DQoJ dGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5r Rm9sbG93ZWQNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOiM5NTRGNzI7DQoJdGV4 dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpwDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglt c28tbWFyZ2luLXRvcC1hbHQ6YXV0bzsNCgltYXJnaW4tcmlnaHQ6MGluOw0KCW1zby1tYXJnaW4t Ym90dG9tLWFsdDphdXRvOw0KCW1hcmdpbi1sZWZ0OjBpbjsNCglmb250LXNpemU6MTIuMHB0Ow0K CWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLHNlcmlmO30NCnNwYW4uRW1haWxTdHlsZTE5 DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmOw0KCWNvbG9yOiMxRjQ5N0Q7fQ0KLk1zb0NocERlZmF1bHQNCgl7bXNvLXN0 eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1zaXplOjEwLjBwdDt9DQpAcGFnZSBXb3JkU2Vj dGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEu MGluO30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQ0KLS0+PC9zdHls ZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9ImVkaXQi IHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+ PHhtbD4NCjxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFwIHY6ZXh0PSJlZGl0 IiBkYXRhPSIxIiAvPg0KPC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPg0KPC9oZWFk Pg0KPGJvZHkgbGFuZz0iRU4tVVMiIGxpbms9IiMwNTYzQzEiIHZsaW5rPSIjOTU0RjcyIj4NCjxk aXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHls ZT0iZm9udC1mYW1pbHk6JnF1b3Q7SGVsdmV0aWNhJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMz MzMzMyI+SGVsbG8sPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlm O2NvbG9yOiMzMzMzMzMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtIZWx2ZXRpY2EmcXVvdDss c2Fucy1zZXJpZjtjb2xvcjojMzMzMzMzIj5Zb3Ugd3JvdGUgTkVXIHR3aWNlOiBORVcuTkVXPG86 cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZv bnQtZmFtaWx5OiZxdW90O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMzMzMzMzMi PjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFu IHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtIZWx2ZXRpY2EmcXVvdDssc2Fucy1zZXJpZjtjb2xv cjojMzMzMzMzIj5JTlNFUlQgSU5UTyBBSVJDUkFGVA0KPGJyPg0KVkFMVUVTIChORVcuZXZfaWQ8 YnI+DQo8Yj4sIE5FVy5ORVcuYWlyY3JhZnRfa2V5OjppbnQ8YnI+DQosIE5FVy5ORVcucmVnaXNf bm88YnI+DQosIE5FVy5ORVcubnRzYl9ubzxicj4NCjxicj4NCjwvYj48L3NwYW4+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5z LXNlcmlmO2NvbG9yOiMxRjQ5N0QiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90 O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj48bzpwPiZuYnNwOzwvbzpw Pjwvc3Bhbj48L3A+DQo8ZGl2Pg0KPGRpdiBzdHlsZT0iYm9yZGVyOm5vbmU7Ym9yZGVyLXRvcDpz b2xpZCAjRTFFMUUxIDEuMHB0O3BhZGRpbmc6My4wcHQgMGluIDBpbiAwaW4iPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmIj5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5z LXNlcmlmIj4gTWlrZSBMQVpMTyBbbWFpbHRvOmdpYW50bWV0ZmFuQGNvbWNhc3QubmV0XQ0KPGJy Pg0KPGI+U2VudDo8L2I+IFR1ZXNkYXksIEFwcmlsIDMwLCAyMDE5IDM6NDIgUE08YnI+DQo8Yj5U bzo8L2I+IHBnc3FsLXNxbEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZzxicj4NCjxiPlN1YmplY3Q6PC9i PiBFUlJPUjogbWlzc2luZyBGUk9NLWNsYXVzZSBlbnRyeSBmb3IgdGFibGUgJnF1b3Q7bmV3JnF1 b3Q7PG86cD48L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8L2Rpdj4NCjxwIGNsYXNzPSJNc29O b3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9 Im1zby1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvIj4mbmJz cDs8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtc28tbWFyZ2lu LXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0bztsaW5lLWhlaWdodDoxMi4w cHQ7YmFja2dyb3VuZDojRkZFQjlDIj4NCjxzdHJvbmc+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTox MC4wcHQ7Y29sb3I6IzlDNjUwMCI+Q0FVVElPTjo8L3NwYW4+PC9zdHJvbmc+PHNwYW4gc3R5bGU9 ImZvbnQtc2l6ZToxMC4wcHQiPiBUaGlzIGVtYWlsIG9yaWdpbmF0ZWQgZnJvbSBvdXRzaWRlIG9m IE1vb2R5J3MuIERvIG5vdCBjbGljayBsaW5rcyBvciBvcGVuIGF0dGFjaG1lbnRzIHVubGVzcyB5 b3UgcmVjb2duaXplIHRoZSBzZW5kZXIgYW5kIGtub3cgdGhlIGNvbnRlbnQgaXMgc2FmZS48L3Nw YW4+PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibXNvLW1hcmdp bi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8iPiZuYnNwOzxvOnA+PC9v OnA+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90O0hlbHZldGljYSZxdW90 OyxzYW5zLXNlcmlmO2NvbG9yOiMzMzMzMzMiPldoYXQgaXMgd3Jvbmcgd2l0aCB0aGlzIHBpY3R1 cmU6PG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZx dW90O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMzMzMzMzMiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtIZWx2 ZXRpY2EmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMzMzMzMzIj4tLXRyaWdnZXIgZnVuY3Rpb246 PG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90 O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMzMzMzMzMiPkNSRUFURSBPUiBSRVBM QUNFIEZVTkNUSU9OIHBvcHVsYXRlQWlyY3JhZnQoKQ0KPGJyPg0KUkVUVVJOUyBUUklHR0VSIEFT ICRwb3B1bGF0ZUFpcmNyYWZ0JDxicj4NCkJFR0lOPGJyPg0KPGJyPg0KPGJyPg0KSU5TRVJUIElO VE8gQUlSQ1JBRlQgPGJyPg0KVkFMVUVTIChORVcuZXZfaWQ8YnI+DQosIE5FVy5ORVcuYWlyY3Jh ZnRfa2V5OjppbnQ8YnI+DQosIE5FVy5ORVcucmVnaXNfbm88YnI+DQosIE5FVy5ORVcubnRzYl9u bzxicj4NCiwgTkVXLmFjZnRfbWlzc2luZzxicj4NCiwgTkVXLmZhcl9wYXJ0PGJyPg0KLCBORVcu Zmx0X3BsYW5fZmlsZWQ8YnI+DQosIE5FVy5mbGlnaHRfcGxhbl9hY3RpdmF0ZWQ8YnI+DQosIE5F Vy5kYW1hZ2U8YnI+DQosIE5FVy5hY2Z0X2ZpcmU8YnI+DQosIE5FVy5hY2Z0X2V4cGw8YnI+DQos IE5FVy5hY2Z0X21ha2U8YnI+DQosIE5FVy5hY2Z0X21vZGVsPGJyPg0KLCBORVcuYWNmdF9zZXJp ZXM8YnI+DQosIE5FVy5hY2Z0X3NlcmlhbF9ubzxicj4NCiwgTkVXLmNlcnRfbWF4X2dyX3d0Ojpp bnQ8YnI+DQosIE5FVy5hY2Z0X2NhdGVnb3J5PGJyPg0KLCBORVcuYWNmdF9yZWdfY2xzPGJyPg0K LCBORVcuaG9tZWJ1aWx0PGJyPg0KLCBORVcuZmNfc2VhdHM6OmludDxicj4NCiwgTkVXLmNjX3Nl YXRzOjppbnQ8YnI+DQosIE5FVy5wYXhfc2VhdHM6OmludDxicj4NCiwgTkVXLnRvdGFsX3NlYXRz OjpzbWFsbGludDxicj4NCiwgTkVXLm51bV9lbmc6OnNtYWxsaW50PGJyPg0KLCBORVcuZml4ZWRf cmV0cmFjdGFibGU8YnI+DQosIE5FVy50eXBlX2xhc3RfaW5zcDxicj4NCiwgVE9fVElNRVNUQU1Q KE5FVy5kYXRlX2xhc3RfaW5zcCwnTU0vREQvWVkgSEgyNDpNSTpTUycpPGJyPg0KLCBORVcuYWZt X2hyc19sYXN0X2luc3A6OnJlYWw8YnI+DQosIE5FVy5hZm1faHJzOjpyZWFsPGJyPg0KLCBORVcu ZWx0X2luc3RhbGw8YnI+DQosIE5FVy5lbHRfb3Blcjxicj4NCiwgTkVXLmVsdF9haWRlZF9sb2Nf ZXY8YnI+DQosIE5FVy5lbHRfdHlwZTxicj4NCiwgTkVXLm93bmVyX2FjZnQ8YnI+DQosIE5FVy5v d25lcl9zdHJlZXQ8YnI+DQosIE5FVy5vd25lcl9jaXR5PGJyPg0KLCBORVcub3duZXJfc3RhdGU8 YnI+DQosIE5FVy5vd25lcl9jb3VudHJ5PGJyPg0KLCBORVcub3duZXJfemlwPGJyPg0KLCBORVcu b3Blcl9pbmRpdmlkdWFsX25hbWU8YnI+DQosIE5FVy5vcGVyX25hbWU8YnI+DQosIE5FVy5vcGVy X3NhbWU8YnI+DQosIE5FVy5vcGVyX2RiYTxicj4NCiwgTkVXLm9wZXJfYWRkcl9zYW1lPGJyPg0K LCBORVcub3Blcl9zdHJlZXQ8YnI+DQosIE5FVy5vcGVyX2NpdHk8YnI+DQosIE5FVy5vcGVyX3N0 YXRlPGJyPg0KLCBORVcub3Blcl9jb3VudHJ5PGJyPg0KLCBORVcub3Blcl96aXA8YnI+DQosIE5F Vy5vcGVyX2NvZGU8YnI+DQosIE5FVy5jZXJ0c19oZWxkPGJyPg0KLCBORVcub3BydG5nX2NlcnQ8 YnI+DQosIE5FVy5vcGVyX2NlcnQ8YnI+DQosIE5FVy5vcGVyX2NlcnRfbnVtPGJyPg0KLCBORVcu b3Blcl9zY2hlZDxicj4NCiwgTkVXLm9wZXJfZG9tX2ludDxicj4NCiwgTkVXLm9wZXJfcGF4X2Nh cmdvPGJyPg0KLCBORVcudHlwZV9mbHk8YnI+DQosIE5FVy5zZWNvbmRfcGlsb3Q8YnI+DQosIE5F Vy5kcHJ0X3B0X3NhbWVfZXY8YnI+DQosIE5FVy5kcHJ0X2FwdF9pZDxicj4NCiwgTkVXLmRwcnRf Y2l0eTxicj4NCiwgTkVXLmRwcnRfc3RhdGU8YnI+DQosIE5FVy5kcHJ0X2NvdW50cnk8YnI+DQos IE5FVy5kcHJ0X3RpbWU6OnNtYWxsaW50PGJyPg0KLCBORVcuZHBydF90aW1lem48YnI+DQosIE5F Vy5kZXN0X3NhbWVfbG9jYWw8YnI+DQosIE5FVy5kZXN0X2FwdF9pZDxicj4NCiwgTkVXLmRlc3Rf Y2l0eTxicj4NCiwgTkVXLmRlc3Rfc3RhdGU8YnI+DQosIE5FVy5kZXN0X2NvdW50cnk8YnI+DQos IE5FVy5waGFzZV9mbHRfc3BlYzo6aW50PGJyPg0KLCBORVcucmVwb3J0X3RvX2ljYW88YnI+DQos IE5FVy5ldmFjdWF0aW9uPGJyPg0KLCBUT19USU1FU1RBTVAoTkVXLmxjaGdfZGF0ZSwnTU0vREQv WVkgSEgyNDpNSTpTUycpPGJyPg0KLCBORVcubGNoZ191c2VyaWQ8YnI+DQosIE5FVy5hZm1faHJz X3NpbmNlPGJyPg0KLCBORVcucnd5X251bTxicj4NCiwgTkVXLnJ3eV9sZW46OmludDxicj4NCiwg TkVXLnJ3eV93aWR0aDo6aW50PGJyPg0KLCBORVcuc2l0ZV9zZWVpbmc8YnI+DQosIE5FVy5haXJf bWVkaWNhbDxicj4NCiwgTkVXLm1lZF90eXBlX2ZsaWdodDxicj4NCiwgTkVXLmFjZnRfeWVhcjo6 aW50PGJyPg0KLCBORVcuZnVlbF9vbl9ib2FyZDxicj4NCiwgTkVXLmNvbW1lcmNpYWxfc3BhY2Vf ZmxpZ2h0OjpiaXQ8YnI+DQosIE5FVy51bm1hbm5lZDo6Yml0PGJyPg0KLCBORVcuaWZyX2VxdWlw cGVkX2NlcnQ6OmJpdDxicj4NCiwgTkVXLmVsdF9tb3VudGVkX2FpcmNyYWZ0OjpiaXQ8YnI+DQos IE5FVy5lbHRfY29ubmVjdGVkX2FudGVubmE6OmJpdDxicj4NCiwgTkVXLmVsdF9tYW51ZmFjdHVy ZXI8YnI+DQosIE5FVy5lbHRfbW9kZWw8YnI+DQosIE5FVy5lbHRfcmVhc29uX290aGVyOjp0ZXh0 KTs8YnI+DQpSRVRVUk4gTlVMTDsgLS0gcmVzdWx0IGlzIGlnbm9yZWQgc2luY2UgdGhpcyBpcyBh biBBRlRFUiB0cmlnZ2VyPGJyPg0KRU5EOzxicj4NCiRwb3B1bGF0ZUFpcmNyYWZ0JCBMQU5HVUFH RSBwbHBnc3FsOzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LWZh bWlseTomcXVvdDtIZWx2ZXRpY2EmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMzMzMzMzIj48bzpw PiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1 b3Q7SGVsdmV0aWNhJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMzMzMzMyI+LS0gVHJpZ2dlcjo8 bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7 SGVsdmV0aWNhJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMzMzMzMyI+Q1JFQVRFIFRSSUdHRVIg VVRSX0FJX1NUQUdFX0FJUkNSQUZUDQo8YnI+DQpBRlRFUiBJTlNFUlQgT04gU1RBR0VfQUlSQ1JB RlQ8YnI+DQpGT1IgRUFDSCBST1c8YnI+DQpFWEVDVVRFIFBST0NFRFVSRSBwb3B1bGF0ZUFpcmNy YWZ0KCk7PG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5 OiZxdW90O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMzMzMzMzMiPjxvOnA+Jm5i c3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTomcXVvdDtI ZWx2ZXRpY2EmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMzMzMzMzIj4tLUluc2VydDo8bzpwPjwv bzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7SGVsdmV0 aWNhJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMzMzMzMyI+SU5TRVJUIElOVE8gbnRzYmRhdGEu c3NhLnN0YWdlX2FpcmNyYWZ0IChldl9pZCwgYWlyY3JhZnRfa2V5LCByZWdpc19ubywgbnRzYl9u bywgYWNmdF9taXNzaW5nLCBmYXJfcGFydCwgZmx0X3BsYW5fZmlsZWQsIGZsaWdodF9wbGFuX2Fj dGl2YXRlZCwgZGFtYWdlLCBhY2Z0X2ZpcmUsIGFjZnRfZXhwbCwgYWNmdF9tYWtlLCBhY2Z0X21v ZGVsLA0KIGFjZnRfc2VyaWVzLCBhY2Z0X3NlcmlhbF9ubywgY2VydF9tYXhfZ3Jfd3QsIGFjZnRf Y2F0ZWdvcnksIGFjZnRfcmVnX2NscywgaG9tZWJ1aWx0LCBmY19zZWF0cywgY2Nfc2VhdHMsIHBh eF9zZWF0cywgdG90YWxfc2VhdHMsIG51bV9lbmcsIGZpeGVkX3JldHJhY3RhYmxlLCB0eXBlX2xh c3RfaW5zcCwgZGF0ZV9sYXN0X2luc3AsIGFmbV9ocnNfbGFzdF9pbnNwLCBhZm1faHJzLCBlbHRf aW5zdGFsbCwgZWx0X29wZXIsIGVsdF9haWRlZF9sb2NfZXYsDQogZWx0X3R5cGUsIG93bmVyX2Fj ZnQsIG93bmVyX3N0cmVldCwgb3duZXJfY2l0eSwgb3duZXJfc3RhdGUsIG93bmVyX2NvdW50cnks IG93bmVyX3ppcCwgb3Blcl9pbmRpdmlkdWFsX25hbWUsIG9wZXJfbmFtZSwgb3Blcl9zYW1lLCBv cGVyX2RiYSwgb3Blcl9hZGRyX3NhbWUsIG9wZXJfc3RyZWV0LCBvcGVyX2NpdHksIG9wZXJfc3Rh dGUsIG9wZXJfY291bnRyeSwgb3Blcl96aXAsIG9wZXJfY29kZSwgY2VydHNfaGVsZCwgb3BydG5n X2NlcnQsIG9wZXJfY2VydCwNCiBvcGVyX2NlcnRfbnVtLCBvcGVyX3NjaGVkLCBvcGVyX2RvbV9p bnQsIG9wZXJfcGF4X2NhcmdvLCB0eXBlX2ZseSwgc2Vjb25kX3BpbG90LCBkcHJ0X3B0X3NhbWVf ZXYsIGRwcnRfYXB0X2lkLCBkcHJ0X2NpdHksIGRwcnRfc3RhdGUsIGRwcnRfY291bnRyeSwgZHBy dF90aW1lLCBkcHJ0X3RpbWV6biwgZGVzdF9zYW1lX2xvY2FsLCBkZXN0X2FwdF9pZCwgZGVzdF9j aXR5LCBkZXN0X3N0YXRlLCBkZXN0X2NvdW50cnksIHBoYXNlX2ZsdF9zcGVjLCByZXBvcnRfdG9f aWNhbywNCiBldmFjdWF0aW9uLCBsY2hnX2RhdGUsIGxjaGdfdXNlcmlkLCBhZm1faHJzX3NpbmNl LCByd3lfbnVtLCByd3lfbGVuLCByd3lfd2lkdGgsIHNpdGVfc2VlaW5nLCBhaXJfbWVkaWNhbCwg bWVkX3R5cGVfZmxpZ2h0LCBhY2Z0X3llYXIsIGZ1ZWxfb25fYm9hcmQsIGNvbW1lcmNpYWxfc3Bh Y2VfZmxpZ2h0LCB1bm1hbm5lZCwgaWZyX2VxdWlwcGVkX2NlcnQsIGVsdF9tb3VudGVkX2FpcmNy YWZ0LCBlbHRfY29ubmVjdGVkX2FudGVubmEsIGVsdF9tYW51ZmFjdHVyZXIsDQogZWx0X21vZGVs LCBlbHRfcmVhc29uX290aGVyKSBWQUxVRVMgKCcyMDAwMTIwOFgwNzczNCcsJzEnLCdONjE3MkMn LCdMQVg5N0ZBMTQzICcsJ04nLCcwOTEgJywnSUZSICcsTlVMTCwnREVTVCcsJ05PTkUnLCdOT05F JywnQ2Vzc25hICcsJ1QyMTBOICcsJ1QyMTBOICcsJzIxMC02MzgyMCAnLCczODAwJywnQUlSICcs J1VTVVMnLCdOJyxOVUxMLE5VTEwsTlVMTCwnNicsJzEnLCdSRVRSJywnQU5OTCcsJzExLzE2Lzk2 IDAwOjAwOjAwJywnMy40MDAwMDAwMGUmIzQzOzAxJywnMS42NDMwMDAwMGUmIzQzOzAzJywnWScs J1UnLCdVJyxOVUxMLCdKQU1FUw0KIEUuIEVMRFJFREdFICcsJzQwMzkgS05PTEwgUklER0UgQVZF LiAnLCdMQVMgVkVHQVMgJywnTlYnLCcgJywnODkwMzAgJyxOVUxMLCcgJywnWScsJ1JBTkdFUiBF TlRFUlBSSVNFUyAnLCdZJywnICcsJyAnLCcgJywnICcsJyAnLCcgJywnTicsJ04gJywnVU5LJyxO VUxMLE5VTEwsTlVMTCxOVUxMLCdQRVJTJywnTicsJ04nLCdMVlMgJywnTEFTIFZFR0FTICcsJ05N JywnICcsJzE3NTAnLCdNU1QnLCdMT0NMJywnVkdUICcsJyAnLCdOVicsJyAnLCc1NDAnLE5VTEws TlVMTCwnMDEvMDIvMDENCiAxMDozNDozOScsJ2RibycsTlVMTCwnMCcsTlVMTCxOVUxMLCdOJywn TicsTlVMTCxOVUxMLE5VTEwsJzAnLCcwJywnMCcsJzAnLCcwJyxOVUxMLE5VTEwsTlVMTCkgd2Fz IGFib3J0ZWQ6IEVSUk9SOiBtaXNzaW5nIEZST00tY2xhdXNlIGVudHJ5IGZvciB0YWJsZSAmcXVv dDtuZXcmcXVvdDs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1m YW1pbHk6JnF1b3Q7SGVsdmV0aWNhJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMzMzMzMyI+V2hl cmU6IFBML3BnU1FMIGZ1bmN0aW9uIHBvcHVsYXRlYWlyY3JhZnQoKSBsaW5lIDI2IGF0IFNRTCBz dGF0ZW1lbnQ8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1mYW1p bHk6JnF1b3Q7SGVsdmV0aWNhJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMzMzMzMyI+PG86cD4m bmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiZxdW90 O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMzMzMzMzMiPj88bzpwPjwvbzpwPjwv c3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7SGVsdmV0aWNhJnF1 b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzMzMzMzMyI+VGhlIG9ubHkgdGhpbmcgSSBjYW4gZmluZCBy ZWxhdGVkIHRvIHRoaXMgZXJyb3Igd2l0aCBORVcgdmFyaWFibGVzIGlzIGR5bmFtaWMgcGwvcGdz cWwgd2hpY2ggdGhpcyBpcyBub3QuPG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5 bGU9ImZvbnQtZmFtaWx5OiZxdW90O0hlbHZldGljYSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMz MzMzMzMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250 LWZhbWlseTomcXVvdDtIZWx2ZXRpY2EmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMzMzMzMzIj5U aGFua3MgaW4gYWR2YW5jZWQ8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjxkaXY+LS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08ZGl2Pk1vb2R5J3MgbW9uaXRv cnMgZW1haWwgY29tbXVuaWNhdGlvbnMgdGhyb3VnaCBpdHMgbmV0d29ya3MgZm9yIHJlZ3VsYXRv cnkgY29tcGxpYW5jZSBwdXJwb3NlcyBhbmQgdG8gcHJvdGVjdCBpdHMgY3VzdG9tZXJzLCBlbXBs b3llZXMgYW5kIGJ1c2luZXNzIGFuZCB3aGVyZSBhbGxvd2VkIHRvIGRvIHNvIGJ5IGFwcGxpY2Fi bGUgbGF3LiBUaGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgZS1tYWlsIG1lc3NhZ2Us IGFuZCBhbnkgYXR0YWNobWVudCB0aGVyZXRvLCBpcyBjb25maWRlbnRpYWwgYW5kIG1heSBub3Qg YmUgZGlzY2xvc2VkIHdpdGhvdXQgb3VyIGV4cHJlc3MgcGVybWlzc2lvbi4gSWYgeW91IGFyZSBu b3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCBvciBhbiBlbXBsb3llZSBvciBhZ2VudCByZXNwb25z aWJsZSBmb3IgZGVsaXZlcmluZyB0aGlzIG1lc3NhZ2UgdG8gdGhlIGludGVuZGVkIHJlY2lwaWVu dCwgeW91IGFyZSBoZXJlYnkgbm90aWZpZWQgdGhhdCB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIG1l c3NhZ2UgaW4gZXJyb3IgYW5kIHRoYXQgYW55IHJldmlldywgZGlzc2VtaW5hdGlvbiwgZGlzdHJp YnV0aW9uIG9yIGNvcHlpbmcgb2YgdGhpcyBtZXNzYWdlLCBvciBhbnkgYXR0YWNobWVudCB0aGVy ZXRvLCBpbiB3aG9sZSBvciBpbiBwYXJ0LCBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3Ug aGF2ZSByZWNlaXZlZCB0aGlzIG1lc3NhZ2UgaW4gZXJyb3IsIHBsZWFzZSBpbW1lZGlhdGVseSBu b3RpZnkgdXMgYnkgdGVsZXBob25lLCBmYXggb3IgZS1tYWlsIGFuZCBkZWxldGUgdGhlIG1lc3Nh Z2UgYW5kIGFsbCBvZiBpdHMgYXR0YWNobWVudHMuIEV2ZXJ5IGVmZm9ydCBpcyBtYWRlIHRvIGtl ZXAgb3VyIG5ldHdvcmsgZnJlZSBmcm9tIHZpcnVzZXMuIFlvdSBzaG91bGQsIGhvd2V2ZXIsIHJl dmlldyB0aGlzIGUtbWFpbCBtZXNzYWdlLCBhcyB3ZWxsIGFzIGFueSBhdHRhY2htZW50IHRoZXJl dG8sIGZvciB2aXJ1c2VzLiBXZSB0YWtlIG5vIHJlc3BvbnNpYmlsaXR5IGFuZCBoYXZlIG5vIGxp YWJpbGl0eSBmb3IgYW55IGNvbXB1dGVyIHZpcnVzIHdoaWNoIG1heSBiZSB0cmFuc2ZlcnJlZCB2 aWEgdGhpcyBlLW1haWwgbWVzc2FnZS4gPGJyPjxicj5UaGlzIGVtYWlsIHdhcyBzZW50IHRvIHlv dSBieSBNb29keeKAmXMgSW52ZXN0b3JzIFNlcnZpY2UgRU1FQSBMaW1pdGVkPGJyPlJlZ2lzdGVy ZWQgb2ZmaWNlIGFkZHJlc3M6PGJyPk9uZSBDYW5hZGEgU3F1YXJlPGJyPkNhbmFyeSBXaGFyZjxi cj5Mb25kb24sIEUxNCA1RkE8YnI+UmVnaXN0ZXJlZCBpbiBFbmdsYW5kIGFuZCBXYWxlcyBObzog ODkyMjcwMTxkaXY+LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08L2Rp dj48L2Rpdj48L2Rpdj48L2JvZHk+DQo8L2h0bWw+DQo= --_000_1EC8157EB499BF459A516ADCF135ADCE3A2476A1LONWGMSX712admo_-- From giantmetfan@comcast.net Tue Apr 30 15:27:49 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUgp-0003gS-Ai for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 15:29:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLUfp-00052J-KS for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 15:28:01 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUfo-0004ya-Ut for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 15:28:01 +0000 Received: from resqmta-po-11v.sys.comcast.net ([2001:558:fe16:19:96:114:154:170]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUfl-0001Hd-C3 for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 15:28:00 +0000 Received: from resomta-po-14v.sys.comcast.net ([96.114.154.238]) by resqmta-po-11v.sys.comcast.net with ESMTP id LQUHhXb7DVIRHLUffhwEUq; Tue, 30 Apr 2019 15:27:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1556638071; bh=ByopjDpmvGEpdq2BZMKixU1vCoppujsl3aZXLtB6cZg=; h=Received:Received:Date:From:Reply-To:To:Message-ID:Subject: MIME-Version:Content-Type; b=jBhVW9UygDsykOD3C5IFIQV6FILGzH1YnDVFWkfJbhz9uic+rRkwoF7z8jpdEyqYR j8W4tp5b7vhbK2N5R+KhYpt61RtpudxVTqpPQ/2ObQ66Rkz/ARbOq1HEJhNLfAR6yG hAHMumAVet6qKd3oIRfp6qEJtZbB6YVMUhglV0X3a7yantQnnLDoFQnfdWAUeBkC6E cUN6AAIfAC0n7T90EZ3cq2XBKNHjFWzdxRCLMWTJdi1knJVGuN0sXPTtrrmW+2W02k SP219jg/vgAbyU65xvzl9tX9F6zYNhAaruReW2uNYy4X2QG1SwAiJCrt76G4odr/zW 2ZM0AeiAgksPQ== Received: from oxapp-asd-17o.email.comcast.net ([96.115.233.255]) by resomta-po-14v.sys.comcast.net with ESMTPS id LUfehK6NswpUALUfehoYYX; Tue, 30 Apr 2019 15:27:51 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduuddrieehgdeftdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddtnecuogfthfevqddquegrugfkmhhpohhrthgrnhgtvgculddvtddmnecujfgurhepfffhrhfvkfgjfhfugggtgffrkghiofesthejsgdtredtjeenucfhrhhomhepofhikhgvucfntegknffquceoghhirghnthhmvghtfhgrnhestghomhgtrghsthdrnhgvtheqnecukfhppeeliedrudduhedrvdeffedrvdehhedpudehhedrudejkedrudektddruddunecurfgrrhgrmhephhgvlhhopehogigrphhpqdgrshguqddujehordgvmhgrihhlrdgtohhmtggrshhtrdhnvghtpdhinhgvthepleeirdduudehrddvfeefrddvheehpdhmrghilhhfrhhomhepghhirghnthhmvghtfhgrnhestghomhgtrghsthdrnhgvthdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepphhgshhqlhdqshhqlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptd X-Xfinity-VMeta: sc=20;st=legit Date: Tue, 30 Apr 2019 11:27:49 -0400 (EDT) From: Mike LAZLO Reply-To: Mike LAZLO To: Tom Lane Cc: pgsql-sql@lists.postgresql.org Message-ID: <1574448700.109324.1556638069968@connect.xfinity.com> In-Reply-To: <26223.1556632058@sss.pgh.pa.us> References: <625497565.102576.1556631694006@connect.xfinity.com> <26223.1556632058@sss.pgh.pa.us> Subject: Re: ERROR: missing FROM-clause entry for table "new" MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Medium X-Originating-Client: open-xchange-appsuite X-Originating-IP: ::ffff:155.178.180.11 X-Mailer: Open-Xchange Mailer v7.8.4-Rev38 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk THANKS! That was done with an pgAdmin replace! Now it runs. Sometimes it just takes a second set of eyes! > On April 30, 2019 at 9:47 AM Tom Lane wrote: > > > Mike LAZLO writes: > > What is wrong with this picture: > > Hm, the error message is pretty unhelpful, but I think the root problem > is too many "NEW"s in several places: > > > , NEW.NEW.aircraft_key::int > ^^^^^^^ > > regards, tom lane > >