no postgresql user name specified in startup packet

[coderdan]

Hi guys,

anyone else have this issue? I have an application (D7). I can generally force this to happen if I change my bound IP address (such as connect to a VPN and then disconnect).

I typically will notice this when I call 'FStoredProc.PrepareSQL;' Where FStoredProc is a TpgStoredProcedure. If I on the other hand create all of the params by hand and then fill them this issue does NOT occur.

Thoughts?

Thanks,

Dan

BTW -- High praise for Devart Your components are great.

[coderdan]

By switching from:
FStoredProc.Connection := Conn;
FStoredProc.StoredProcName := 'spLog';
FStoredProc.Prepare; // or PrepareSQL

FStoredProc.Params[1].AsInteger := FMessageType;
FStoredProc.Params[2].AsString := FMessage;
FStoredProc.Params[3].AsInteger := FUserID;

FStoredProc.Execute;


To:
FStoredProc.Connection := Conn;
FStoredProc.StoredProcName := 'spLog';
FStoredProc.Params.CreateParam(ftInteger,'result',ptResult);
FStoredProc.Params.CreateParam(ftInteger, 'log_type',ptInput);
FStoredProc.Params.CreateParam(ftString,'log_msg',ptInput);
FStoredProc.Params.CreateParam(ftInteger,'log_user', ptInput);

FStoredProc.Params[1].AsInteger := FMessageType;
FStoredProc.Params[2].AsString := FMessage;
FStoredProc.Params[3].AsInteger := FUserID;

FStoredProc.Execute;

I only find this to be a problem when called from with a thread. Ok, well I suppose it's the finesse of the style

[Plash]

When your IP address is changed, the PostgreSQL server cannot detect that data you send belongs to the same connection. The server thinks that it is a new connection. So it returns an error.

[coderdan]

is there a connection event that can trap this?

Thanks

Dan

[Plash]

You can try to use the OnConnectionLost event. Set the LocalFailover option of TPgConnection to True to enable this event. See the "Using PgDAC / Working in an Unstable Network" topic in the PgDAC help for details.