Postgres Pro
Downloads
Home   >   mailing lists

Re: I often have to do "update if exist, else insert", is my database design wrong? - Mailing list pgsql-general

From Richard Huxton
Subject Re: I often have to do "update if exist, else insert", is my database design wrong?
Date
Msg-id 48899A62.5020704@archonet.com
Whole thread Raw
In response to I often have to do "update if exist, else insert", is my database design wrong?  ("A B" <gentosaker@gmail.com>)
List pgsql-general
Tree view 
A B wrote:
>
> Or is there some more general problem with the table design?
> table_XY is in this case (and most cases) a table like this
>
> create table table_XY (
>    x  int references table_X,
>    y  int references table_Y
> );

Without knowing what XY are and what you are using table_XY for it's
going to be difficult for anyone to offer useful advice.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "A B"
Date:
Subject: I often have to do "update if exist, else insert", is my database design wrong?
Next
From: "A B"
Date:
Subject: Subselect with limit