Re: Strange loss of data during INSERT

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: Strange loss of data during INSERT
Дата
Msg-id AANLkTim49AaDJ+M255Bdb7ts+kM-ywSLG=mTfHMQjBW2@mail.gmail.com
обсуждение исходный текст
Ответ на Strange loss of data during INSERT  ("Altmann, Sebastian" <Sebastian.Altmann@isogmbh.de>)
Список pgsql-general
Are you sure the password is NULL? Some fields are not shown in pgAdmin if they are too long, but that seems improbable to me for passwords.
pgAdmin also has an option "Show NULL values as <NULL>" (in file|options|query).

If you take the SQL from the log, can you reproduce this in postgres?
If so, please email the code (i hope it's work with personal data scrambled ?).

cheers,

WBL

On Thu, Mar 24, 2011 at 12:01 PM, Altmann, Sebastian <Sebastian.Altmann@isogmbh.de> wrote:

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.Altmann@isogmbh.de

http://www.isogmbh.de

 

Amtsgericht Nürnberg HRB 18299

Geschäftsführer: Harald Goeb

Sitz: Nürnberg

 




--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

В списке pgsql-general по дате отправления:

Предыдущее
От: "Altmann, Sebastian"
Дата:
Сообщение: Strange loss of data during INSERT
Следующее
От: "Altmann, Sebastian"
Дата:
Сообщение: Re: [RMX:#] Re: Strange loss of data during INSERT