From: Cobus Carstens <cobus.carstens@swistgroup.com>
To: pgsql-interfaces@postgresql.org
Date: Tue, 28 Oct 2003 07:45:42 +0200
Message-ID: <DEC925D2FB9081448C3D6EC26E85868CF81404@steinmail.swistgroup.com> (raw)
Hi there.
I'm running Postgresql 7.3.2 on Mandrake 9.1.
I'm using ecpg (version 2.10.0) to compile the embedded sql code in my C
programs.
The problem experienced has to do with array indexing in SQL statements.
I browsed your test files in the CVS repository and found one
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/interfaces/
ecpg/test/test1.pgc?rev=1.31.2.1&content-type=text/x-cvsweb-markup) that
contains the code I would like to be able to use.
When I precompile the abovementioned file with ecpg, I get the following
error
test1.pgc:130: parse error at or near "[".
It is the same problem I'm experiencing with my program. I tested my
program on Postgresql 7.3.4 as well, but it also did not work (the ecpg
version was the same as the 7.3.2's).
What do you suggest I do to get this working? Grab latest code from CVS?
My second question is with regards to Oracle style bulk inserts/updates.
I've played around with the "COPY" command and it seems to have good
performance (even though I have to explicitly sprintf all values in a
string first). I'm currently working on a port of existing software that
stores huge amounts of (telecoms) data, so performance is critical. Is
there any special way of handling a lot of updates? I can understand
that updates might need to be done one at a time, but it would be nice
if I can cut out the overhead of calling an update sql statement
repeatedly - I'm thinking in the line of the Oracle bulk updates where
you give the sql statement and host arrays containing the fieldvalues
for the different updates.
Any hints/suggestions would be appreciated.
Regards,
Cobus Carstens
Attachments:
[application/x-pkcs7-signature] smime.p7s (4.0K, ../DEC925D2FB9081448C3D6EC26E85868CF81404@steinmail.swistgroup.com/2-smime.p7s)
download
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: cobus.carstens@swistgroup.com
Subject: Re:
In-Reply-To: <DEC925D2FB9081448C3D6EC26E85868CF81404@steinmail.swistgroup.com>
* 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