From: Sumita Biswas <sbiswas@cisco.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres DB
Date: Mon, 23 Feb 2004 14:24:32 +0530
Message-ID: <003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com> (raw)
In-Reply-To: <20409.1077506948@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sbiswas@cisco.com, tgl@sss.pgh.pa.us
Subject: Re: Postgres DB
In-Reply-To: <003a01c3f9ea$a7b58320$2a154d0a@apac.cisco.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox