Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)

From: Tom Good <tomg(at)nrnet(dot)org>
To: PostgreSQL Interfaces List <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)
Date: 1998-04-06 18:58:22
Message-ID: Pine.LNX.3.95.980406145554.16518A-100000@mailhost.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello again -

In the ongoing struggle to get ecpg to delete a tuple:

my main() has been pared to what you see below...no effect.
Meanwhile if I run
registry=>\i /home/tomg/killrec.sql;
I get:
DELETE FROM central WHERE client_id = 10002
DELETE 1
EOF

I dunno...
(thanks!)
Tom

-------------------------------------------------------------------
main() {
EXEC SQL CONNECT 'registry';

if(sqlca.sqlcode) {
printf("Error connecting to database server.\n");
exit(0);
}

EXEC SQL DELETE FROM central WHERE client_id = 10002;
exit(0);
}

Browse pgsql-interfaces by date

  From Date Subject
Next Message Christopher Luk 1998-04-08 04:38:04 libpq can't do "insert"
Previous Message Herouth Maoz 1998-04-06 12:45:44 Re: ecpg - `exec sql delete' failing (fwd)