[SQL] query PostgreSQL from c++

Hi folks, I'm asked to write a "small" c++ application to query a PostgreSQL DB. In principel I can't see why this should be so difficult but I don't really know a lot about the API. Therefor I thought I just ask if anyone has done this before - of course I think - and might be able and willing t

[SQL] realising a counter in an pgpsql-trigger

Hi folks, I want to do the following: I have a column in every table, named c_update, it's purpose is to hold how many times the dataset was updated. This should be done automatically by the trigger - which already set sthe update-user, -time and date. How can I do this ??? chris --

[SQL] DELETE FROM fails with error

Hi folks, I have the problem that I can't delete datasets out of my tables. It's like that: I have a table: tblshop ID_Shop oid with sequence --- Sh_Name ID_Country ... there is an index on ID_Country I have a second table: tblcountry ID_Cou