From: Christopher Luk <wluk@hkcccc.org>
To: pgsql-interfaces@postgreSQL.org
Subject: libpq can't do "insert"
Date: Wed, 08 Apr 1998 12:38:04 +0800
Message-ID: <352AFF2C.AE00EDB4@hkcccc.org> (raw)
References: <l03110700b14e7e560855@[147.233.159.109]>
I have a question on the libpq( c language) libraries.
The included testlibpq.c can extract data from the postgres95 database.
Modifing the testlibpq.c enable me to extract data from any database in the
postgres95. Hovever, when I changed the "select" query to "insert" query, the
code seems doesn't work. Could somebody tell me is it another way to do
"insert" or something I have missed?
eg.
res=PQexec(conn, "DECLARE myportal CURSOR FOR select * .......");
was changed to
res=PQexec(conn, "DECLARE myportal CURSOR FOR insert into .......");
But can't do insert.
--
Regards, Christopher Luk
System Analyst - The Hong Kong Council of the Church of Christ in China
Phone : (852) 2397-1022 Fax : (852) 2397-7405
mailto:wluk@hkcccc.org URL : http://www.hkcccc.org (Chinese based)
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-interfaces@postgresql.org
Cc: wluk@hkcccc.org
Subject: Re: libpq can't do "insert"
In-Reply-To: <352AFF2C.AE00EDB4@hkcccc.org>
* 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