| 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: | Whole Thread | Raw Message | 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 |