Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBlyo-00CJnm-2j for pgsql-general@arkaria.postgresql.org; Sat, 09 Dec 2023 01:18:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rBlym-00DdUt-3y for pgsql-general@arkaria.postgresql.org; Sat, 09 Dec 2023 01:18:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBlyl-00DdSp-PR for pgsql-general@lists.postgresql.org; Sat, 09 Dec 2023 01:18:03 +0000 Received: from smtp81.iad3a.emailsrvr.com ([173.203.187.81]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBlyj-00AuMx-3l for pgsql-general@lists.postgresql.org; Sat, 09 Dec 2023 01:18:03 +0000 Received: from app17.wa-webapps.iad3a (relay-webapps.rsapps.net [172.27.255.140]) by smtp11.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 2988D42DB; Fri, 8 Dec 2023 20:17:59 -0500 (EST) Received: from kartographia.com (localhost.localdomain [127.0.0.1]) by app17.wa-webapps.iad3a (Postfix) with ESMTP id 114C8E1D56; Fri, 8 Dec 2023 20:17:59 -0500 (EST) Received: by apps.rackspace.com (Authenticated sender: peter.borissow@kartographia.com, from: peter.borissow@kartographia.com) with HTTP; Fri, 8 Dec 2023 20:17:59 -0500 (EST) X-Auth-ID: peter.borissow@kartographia.com Date: Fri, 8 Dec 2023 20:17:59 -0500 (EST) Subject: Re: Inserting into foreign table with sequences and default values From: "peter.borissow@kartographia.com" To: "peter.borissow@kartographia.com" Cc: "Tom Lane" , pgsql-general@lists.postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative;boundary="----=_20231208201759000000_41802" Importance: Normal X-Priority: 3 (Normal) X-Type: html In-Reply-To: <1702079063.614617754@apps.rackspace.com> References: <1702058638.91064408@apps.rackspace.com> <1468017.1702060306@sss.pgh.pa.us> <1702079063.614617754@apps.rackspace.com> X-Client-IP: 170.250.244.158 Message-ID: <1702084679.067615916@apps.rackspace.com> X-Mailer: webmail/19.0.24-RC X-Classification-ID: c0664bf8-af05-4da2-b130-b0b488ee6460-1-1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_20231208201759000000_41802 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =0ACorrection: the trigger on the remote table isn't going to work. I was t= rying so many different things today that I confused myself. Sorry...=0A = =0AOn the bright side the remote sequence works great and I can insert reco= rds from the my database to the remote database now which is a step forward= .=0A =0AI'll report back if I make any additional progress. ------=_20231208201759000000_41802 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Correction: the trigge= r on the remote table isn't going to work. I was trying so many different t= hings today that I confused myself. Sorry...

=0A

&nb= sp;

=0A

On the bright side the remote sequence works= great and I can insert records from the my database to the remote database= now which is a step forward.

=0A

 

=0A

I'll report back if I make any additional progress.

------=_20231208201759000000_41802--