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

Поиск
Список
Период
Сортировка
От Tom Good
Тема Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)
Дата
Msg-id Pine.LNX.3.95.980406145554.16518A-100000@mailhost.nrnet.org
обсуждение исходный текст
Список 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);
}



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Tom Good
Дата:
Сообщение: Re: [INTERFACES] Re: ecpg - `exec sql delete' failing (fwd)
Следующее
От: Christopher Luk
Дата:
Сообщение: libpq can't do "insert"