Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id AAA06117 for postgres-redist; Wed, 21 Sep 1994 00:01:15 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199409210701.AAA06117@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from NMSU.Edu (dns1.NMSU.Edu [128.123.3.5]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id AAA06107 for <postgres@postgres.Berkeley.EDU>; Wed, 21 Sep 1994 00:01:14 -0700
Received: from cs by NMSU.Edu (8.6.8.1/NMSU-1.18)
	id BAA19997; Wed, 21 Sep 1994 01:01:09 -0600
Date: Wed, 21 Sep 1994 01:01:08 -0600
Message-Id: <199409210701.BAA19997@NMSU.Edu>
Received: from boron (boron.CS.NMSU.Edu) by cs (4.1/SMI-4.1)
	id AA28009; Wed, 21 Sep 94 01:01:08 MDT
Received: by boron (4.1/SMI-4.1)
	id AA24635; Wed, 21 Sep 94 01:01:07 MDT
From: pmamnani@cs.nmsu.edu (Praveen Mamnani)
To: postgres@postgres.Berkeley.EDU
Subject: append 
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 21 Sep 94 00:01:15 -0700
Resent-XMts: smtp


I tried to execute append using libpq PQexec command :
 
it does work if I use integer as an attribute to my class. 
 
The problem arises when I try to use character string , as follows :
 
PQexec("create Info (name=char16, login=char16, age=int4)");     
    PQexec("append Info (name=""david"", login=""dwill"", age=20)");  
 
I have to put the double quotes around the name and login otherwise
I get a syntax error.
 
When I try to run the following in a Program, at execution I get 
the error :
           
type id lookup of 362 failed.
 
I get this similar error, when using frontend monitor (not libpq) when
I do not put any "" around the name and the login as follows :
 
Query sent to backend is "append info(name=joe, login=d, age=2)"
WARN:Sep 21 00:54:12:type id lookup of 362 failed
 
But this does work if I put quotes around joe and d.
 
I am not able to figure out what I am doing wrong syntactically
when using libpq (as shown above).
 
anyones help would be appreciated. 
 
Thank You.
 
Praveen.


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================