Strange loss of data during INSERT

From: "Altmann, Sebastian" <Sebastian(dot)Altmann(at)isogmbh(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Strange loss of data during INSERT
Date: 2011-03-24 11:01:42
Message-ID: B35D42300242794AA3F7C3A706E3550403669275@EXCH01.isoad.isogmbh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everybody,

i'm having a very strange Problem:

My JEE Application initially persists Users at startup.

The problem is that the passwords are not stored,

while other data with the same datatype on this table are stored
correctly!?!

If I turn log_statement to 'all' in config I can see the INSERT
statement including the correct password(!!!) in log file,

but if I take a look with pgAdmin all password fields are empty...

When I try to execute the insert statement in pgAdmin it works fine.

By the way: If I switch the DB to OracleXE, it works fine

(But actually I don't want to user Oracle... )

Thanks for any ideas

Sebastian Altmann

________________________________

ISO Software Systeme GmbH

Eichendorffstrasse 29

90491 Nürnberg

Tel.: +49/(911) - 99594-0

Fax: +49/(911) - 99594-129

mailto:Sebastian(dot)Altmann(at)isogmbh(dot)de

http://www.isogmbh.de

Amtsgericht Nürnberg HRB 18299

Geschäftsführer: Harald Goeb

Sitz: Nürnberg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2011-03-24 11:16:06 Re: Strange loss of data during INSERT
Previous Message Willy-Bas Loos 2011-03-24 10:56:38 Re: DO Statement Body Parameters