Re: Table dublicates values

Deniz Atak wrote:
> 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.
>

Is any ORM in the picture (TOPLink, hybernate)? These can be set to
fire DDL automatically. Turn on sql-logging.

Alternatively, find the code that is supposed to populate it once, and
make sure it only gets called once. No Postgres feature is going to do
that accidentally.