From: | Deniz Atak <denizatak(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Table dublicates values |
Date: | 2011-07-16 08:47:50 |
Message-ID: | CAL30GtFWVG=2URvTz4MHzADV+zsrUw57EwHOnFBFF1-y0ur25g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I am using postgresql on Glassfish server. When I restart the server for
some reason, one of my databases' tables duplicates the values. For example
aTable is from aDatabase:
select * from aTable
col1 | col2
-----------------------+---------
text/html | 1672
text/javascript | 374
text/css | 94
text/xml | 21
text/plain | 14
text/html | 1672
text/javascript | 374
text/css | 94
text/xml | 21
text/plain | 14
Do you have any opinion why this is happening? I can write a workaround code
to handle this situtation but I want to learn the reason for this. If
someone has any opinion about this issue it will be highly appreciated.
Thanks in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | - - | 2011-07-16 10:32:33 | Slow query with sub-select |
Previous Message | Brent Wood | 2011-07-15 19:37:34 | Re: Error Importing CSV File |