libpq can't do "insert"

From: Christopher Luk <wluk(at)hkcccc(dot)org>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: libpq can't do "insert"
Date: 1998-04-08 04:38:04
Message-ID: 352AFF2C.AE00EDB4@hkcccc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)hkcccc(dot)org URL : http://www.hkcccc.org (Chinese based)

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter T Mount 1998-04-08 05:44:45 Re: [QUESTIONS] JDBC driver complications
Previous Message Tom Good 1998-04-06 18:58:22 Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)