Re: [RMX:#] Re: Strange loss of data during INSERT - Mailing list pgsql-general
| From | Altmann, Sebastian |
|---|---|
| Subject | Re: [RMX:#] Re: Strange loss of data during INSERT |
| Date | |
| Msg-id | B35D42300242794AA3F7C3A706E3550403669297@EXCH01.isoad.isogmbh.de Whole thread Raw |
| In response to | Strange loss of data during INSERT ("Altmann, Sebastian" <Sebastian.Altmann@isogmbh.de>) |
| Responses |
Re: [RMX:#] Re: Strange loss of data during INSERT
(Adrian Klaver <adrian.klaver@gmail.com>)
|
| List | pgsql-general |
Thanks for your answer.
I’m not sure if the Password is NULL or a empty string,
I will check this in the evening, I have no access no…
If I run the INSERT statement from pgAdmin it works fine!
Here is the statement from the log file (with original personal data, after this are just my dummy entries for development):
BEGIN
insert into player (birthdate, eMail, firstname, lastname, password, username, id) values ($1, $2, $3, $4, $5, $6, $7)
Parameter: $1 = '3885-08-14 00:00:00', $2 = 'alt@isogmbh.de', $3 = 'Sebastian', $4 = 'Altmann', $5 = 'alt.iso', $6 = 'alt', $7 = '54'
COMMIT
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
Von: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] Im Auftrag von Willy-Bas Loos
Gesendet: Donnerstag, 24. März 2011 12:16
An: Altmann, Sebastian
Cc: pgsql-general@postgresql.org
Betreff: [RMX:#] Re: [GENERAL] Strange loss of data during INSERT
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
mailto:Sebastian.Altmann@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 by date: