Received: from hawk-systems.com (hawk-systems.com [161.58.152.235]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g035P0m36403 for ; Thu, 3 Jan 2002 00:25:00 -0500 (EST) (envelope-from dave@hawk-systems.com) Received: from cr159591a (CPE00a00cc12af5.cpe.net.cable.rogers.com [24.102.18.54]) by hawk-systems.com (8.11.6) id g035P4I11605 for ; Wed, 2 Jan 2002 22:25:04 -0700 (MST) From: "Dave VanAuken" To: Subject: update after select doesn't update... Date: Thu, 3 Jan 2002 00:29:48 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200201/3 X-Sequence-Number: 810 Am retrieveing an "available" ipaddress from a table, then later trying to perform an update to "assign" the address to an id. The update produces no error, but doesn't update either. Must be overlooking something but can't place a finger on it. Table "host_ipaddress" Attribute | Type | Modifier -----------+---------+---------- server | text | not null type | text | hostnum | integer | not null address | text | Index: host_ipaddress_pkey