[GENERAL] Table Inheritance and foreign key problem.

DETAIL: Key (id)=(1) is not present in table "a". ==== Thanks Kostas Maistrelis. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] sql question; checks if data already exists before

nuno wrote: >hi, there. i'm trying to write a SQL statement which does the following >things. > >1. checks if data already exists in the database >2. if not, insert data into database otherwise skip. > > > Check this thread : http://archives.postgresql.org/pgsql-general/2005-10/msg01787.php

Re: [GENERAL] mysql replace in postgreSQL?

blackwater dev wrote: In MySQL, I can use the replace statement which either updates the data there or inserts it. Is there a comporable syntax to use in postgreSQL? I need to do an insert and don't want to have to worry about if the data is already there or not...so don't want to see if it th

[GENERAL] Design problem About application related with cached rows

Hello, I try to create an application for my dissertation that caches rows from an romote database. The application handles a cache database which is identical with the original. The only difference is that it does not have autogenerated fields and referential integrity is omitted. I have de

[GENERAL] I cannot view the website of postreSQL correctly

vance Kostas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]