Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D3F56475D93 for ; Wed, 13 Nov 2002 21:56:34 -0500 (EST) Received: from virt3s.webintellects.com (virt3s.webintellects.com [216.98.153.73]) by postgresql.org (Postfix) with ESMTP id 25F9D475D87 for ; Wed, 13 Nov 2002 21:56:34 -0500 (EST) Received: from pclnxrhunter.digitalglobe.com (ew-fw-out.digitalglobe.com [205.166.175.2]) (authenticated (0 bits)) by virt3s.webintellects.com (8.11.6/8.11.6) with ESMTP id gAE43pr04501 for ; Wed, 13 Nov 2002 20:03:51 -0800 Subject: serial type question From: Ray Hunter To: pgsql-php@postgresql.org Content-Type: text/plain Organization: Venticon Consulting Message-Id: <1037217368.6700.113.camel@pclnxrhunter.digitalglobe.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 13 Nov 2002 19:56:08 +0000 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/62 X-Sequence-Number: 1644 I have a php script that will be inserting from a form into two tables. Table1 has a serial data type. Table2 references Table1's serial data type (PK). Here are my questions: 1. Can i run a transaction process from php? If yes, how? 2. How can i get the serial value for inserting into the 2nd table? -- Thank you, Ray Hunter