From sandhyar@amiindia.co.in Mon Feb 27 05:38:36 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 252CB9DC85B for ; Mon, 27 Feb 2006 01:38:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48127-09 for ; Mon, 27 Feb 2006 01:38:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 35C079DC84D for ; Mon, 27 Feb 2006 01:38:26 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k1R5X8H4030348 for ; Mon, 27 Feb 2006 11:03:08 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id ECD2833266Efor ; Mon, 27 Feb 2006 11:03:07 +0530 (IST) Message-ID: <015601c63b60$d3155e50$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: Reg: Multiplequeries pls help me Date: Mon, 27 Feb 2006 11:14:06 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0153_01C63B8E.ECA2B9C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:92.04675 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.081 required=5 tests=[AWL=0.079, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.081 X-Spam-Level: X-Archive-Number: 200602/313 X-Sequence-Number: 20734 This is a multi-part message in MIME format. ------=_NextPart_000_0153_01C63B8E.ECA2B9C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am using multiple queries inorder to get object id from the DB.When i = am executing the same query from the DB side it is working fine. If i am using the same in my application(VC 7) it is = showing"PGRES_FATAL_ERROR" The same query i copied and pasted on server side it is executing = fine..... Why is this so? Pls tell me what i need to do...In case of complex queries executing = through my application. Help me in solving this... Thank You Sandhya ------=_NextPart_000_0153_01C63B8E.ECA2B9C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Hi,
 
I am using multiple queries inorder to get object id from the = DB.When i am=20 executing the same query from the DB side it is working fine.
If i am using the same in my application(VC 7) it is=20 showing"PGRES_FATAL_ERROR"
The same query i copied and pasted on server side it = is=20 executing fine.....
Why is this so?
Pls tell me what i need to do...In case of complex queries = executing=20 through my application.
Help me in solving this...
 
Thank You
Sandhya
------=_NextPart_000_0153_01C63B8E.ECA2B9C0-- From mike@fuhr.org Mon Feb 27 06:03:49 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B2A149DC843 for ; Mon, 27 Feb 2006 02:03:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54265-01 for ; Mon, 27 Feb 2006 02:03:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 46ED79DC85A for ; Mon, 27 Feb 2006 02:03:47 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k1R63YSc074429 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 26 Feb 2006 23:03:37 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k1R63Ys4039922; Sun, 26 Feb 2006 23:03:34 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k1R63YG5039921; Sun, 26 Feb 2006 23:03:34 -0700 (MST) (envelope-from mfuhr) Date: Sun, 26 Feb 2006 23:03:34 -0700 From: Michael Fuhr To: sandhya Cc: Postgres Subject: Re: Reg: Multiplequeries pls help me Message-ID: <20060227060334.GA39824@winnie.fuhr.org> References: <015601c63b60$d3155e50$cd00000a@sandhyar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <015601c63b60$d3155e50$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.122 required=5 tests=[AWL=0.122] X-Spam-Score: 0.122 X-Spam-Level: X-Archive-Number: 200602/314 X-Sequence-Number: 20735 On Mon, Feb 27, 2006 at 11:14:06AM +0530, sandhya wrote: > I am using multiple queries inorder to get object id from the DB. > When i am executing the same query from the DB side it is working fine. > If i am using the same in my application(VC 7) it is showing"PGRES_FATAL_ERROR" > The same query i copied and pasted on server side it is executing fine..... What's the complete error message? What do you mean by "multiple queries"? Several queries executed sequentially via separate function calls? Several queries separated by semicolons executed via the same function call? A single query with subqueries? Could you post the query or queries and explain how you're executing them? If you're writing code then please post the code that executes the queries. This seems off-topic for pgsql-admin; it would probably be more appropriate in pgsql-general, pgsql-interfaces, or pgsql-novice. -- Michael Fuhr