pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrei Bintintan <klodoma@ar-sd.net>
To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
To: pgsql-admin@postgresql.org
Subject: Re: duplicates
Date: Mon, 6 Sep 2004 10:48:17 +0300
Message-ID: <008601c493e5$e0965940$0b00a8c0@forge> (raw)
References: <Pine.LNX.4.58.0409060922390.20253@p-roman.jct.ac.il>

I am not sure that I understand clearly your problem. Are you sure that your
query's are written correctly?

For duplicates you can make a uniqe indexing so this will avoid any
dupplicates in your table.
CREATE UNIQUE INDEX table_column_uniqueidx ON table(column);

If the rows are dissapearing, please check your delete query, because that
is the only way to erase all rows from the table.

If still got problems, please post some queries, be more specific.

Best regards,
Andy.

----- Original Message -----
From: "Tsirkin Evgeny" <tsurkin@mail.jct.ac.il>
To: <pgsql-admin@postgresql.org>
Sent: Monday, September 06, 2004 9:33 AM
Subject: [ADMIN] duplicates


> Hello dear list!
> Here is the problem i have:
> i am using 7.3.4 postgres .i have an aplication that updating 2 tables.
> while it needs to update something - it does not select the rows that
> are already in the table search what it needs to update and execute
> an 'update' query .in place it deletes all the old rows and inserts the
> new one.However while we have a havy load we got a duplicate rows in the
> table ,althought we use transaction an both delete and the new insert
> are in the same transaction.We are pretty sure there is no bug in
> the applicatioin that inserts the data more then once .
> Is that a known problem ?What could be the problem?
>
> --
> Evgeny.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly




view thread (14+ messages)  latest in thread

Message-ID: <008601c493e5$e0965940$0b00a8c0@forge>
Permalink:  ../008601c493e5$e0965940$0b00a8c0@forge/
Also on:    postgresql.org/message-id/008601c493e5$e0965940$0b00a8c0@forge

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: klodoma@ar-sd.net, tsurkin@mail.jct.ac.il
  Subject: Re: duplicates
  In-Reply-To: <008601c493e5$e0965940$0b00a8c0@forge>
  References: <Pine.LNX.4.58.0409060922390.20253@p-roman.jct.ac.il> <008601c493e5$e0965940$0b00a8c0@forge>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox