agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Praveen Mamnani <pmamnani@cs.nmsu.edu>
To: postgres@postgres.Berkeley.EDU
Subject: append
Date: Wed, 21 Sep 1994 01:01:08 -0600
Message-ID: <199409210701.BAA19997@NMSU.Edu> (raw)


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.
==============================================================================

reply

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: postgres@postgres.berkeley.edu
  Cc: pmamnani@cs.nmsu.edu
  Subject: Re: append
  In-Reply-To: <199409210701.BAA19997@NMSU.Edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox