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 C01B3D1E939 for ; Mon, 1 Mar 2004 03:16:42 +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 62312-03 for ; Sun, 29 Feb 2004 23:16:43 -0400 (AST) Received: from mail.michaelchaney.com (mail.michaelchaney.com [207.65.84.68]) by svr1.postgresql.org (Postfix) with ESMTP id 57DCCD1B83D for ; Sun, 29 Feb 2004 23:16:39 -0400 (AST) Received: from pcp08698233pcs.500ash01.tn.comcast.net (fractal.trailer) [69.137.114.17] by mail.michaelchaney.com with esmtp (Exim 4.20 #1 (FreeBSD)) id 1Axdu2-000G3s-3Q; Sun, 29 Feb 2004 21:15:34 -0600 Received: from mdchaney by fractal.trailer with local (Exim 3.35 #1 (Debian)) id 1Axdz8-000147-00 for ; Sun, 29 Feb 2004 21:20:50 -0600 Date: Sun, 29 Feb 2004 21:20:50 -0600 From: Michael Chaney To: pgsql-sql@postgresql.org Subject: Re: Postgres DB Message-ID: <20040301032050.GC4046@michaelchaney.com> References: <20409.1077506948@sss.pgh.pa.us> <003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com> User-Agent: Mutt/1.3.28i Organization: Michael Chaney Consulting Corporation X-URL: http://www.michaelchaney.com/ X-MailScanner-Information: Please see http://www.michaelchaney.com/mail/spam.php for more information X-MailScanner: Found to be clean X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-3.4, required 5, IN_REP_TO) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/406 X-Sequence-Number: 17096 On Mon, Feb 23, 2004 at 02:24:32PM +0530, Sumita Biswas wrote: > 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''; I had a situation where a subquery had an error in it, and the query simply returned no rows instead of throwing an error. It looks like it might well be a bug that we're experiencing, I just haven't had time to chase it down. Michael -- Michael Darrin Chaney mdchaney@michaelchaney.com http://www.michaelchaney.com/