X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F1FA8D1CCAF for ; Mon, 23 Feb 2004 08:54:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 04750-06 for ; Mon, 23 Feb 2004 04:54:39 -0400 (AST) Received: from ind-iport-1.cisco.com (ind-iport-1-sec.cisco.com [64.104.129.9]) by svr1.postgresql.org (Postfix) with ESMTP id 6F3D3D1BAD9 for ; Mon, 23 Feb 2004 04:54:36 -0400 (AST) Received: from india-core-1.cisco.com (64.104.129.221) by ind-iport-1.cisco.com with ESMTP; 23 Feb 2004 19:59:19 +0530 Received: from cisco.com (charminar.cisco.com [192.135.240.11]) by india-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id i1N8sOWT022237; Mon, 23 Feb 2004 00:54:24 -0800 (PST) Received: from sbiswasw2k01 (dhcp-10-77-21-42.cisco.com [10.77.21.42]) by cisco.com (8.8.8-Cisco List Logging/8.8.8) with ESMTP id OAA01856; Mon, 23 Feb 2004 14:22:37 +0530 (IST) From: "Sumita Biswas" To: "'Tom Lane'" Cc: Subject: Re: Postgres DB Date: Mon, 23 Feb 2004 14:24:32 +0530 Message-ID: <003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 In-reply-to: <20409.1077506948@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/385 X-Sequence-Number: 17075 The following Query string , when executed does not give an Error, even though the table Tbl_Billing_Data is not present. QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType, CallManagerId, ClusterId, DestConversationId, ConnectDate, FinalDestination)''+'' SELECT 2, Global_CallId_CallManagerId, globalCallId_ClusterID, DestConversationID, StartDate = MIN (Connect_Date), Final_Destination ''+'' FROM Tbl_Billing_Data''; PERFORM QueryToPopulateTemp; I some how feel that the Query is not getting executed at all, otherwise its sure to give an error. So can you please comment what would have gone wrong? Regards, Sumita