View Issue Details

IDProjectCategoryView StatusLast Update
0034584FPCDatabasepublic2018-11-29 23:25
ReporterDaniel GasparyAssigned ToMichael Van Canneyt 
PrioritynormalSeverityminorReproducibilityN/A
Status closedResolutionfixed 
Platformx86-64OSLinuxOS VersionUbuntu
Product Version3.3.1Product Build 
Target Version3.2.0Fixed in Version3.3.1 
Summary0034584: PostgreSQL: Support to Payload when receiving Database Notifications
DescriptionThe payload is already being received at postgres3types.inc, record Type pgNotify, field extra.

But it's not being forwarded to the user by TEventAlert Event.

The Patch fix this.
Additional Information<FPCDIR>/packages/fcl-db/src/sqldb/postgres/pqeventmonitor.pp

48c48
< TEventAlert = procedure(Sender: TObject; EventName: string; EventCount: longint;
---
> TEventAlert = procedure(Sender: TObject; EventName, Payload: string; EventCount: longint;
167c167
< OnEventAlert(Self,notify^.relname,1,CancelAlerts);
---
> OnEventAlert(Self,notify^.relname,notify^.extra,1,CancelAlerts);
TagsNo tags attached.
Fixed in Revision40396
FPCOldBugId
FPCTarget
Attached Files

Activities

Michael Van Canneyt

2018-11-29 16:43

administrator   ~0112264

For backwards compatibility I don't want to change the event handler signature.

So I introduced a second event which handles the payload:

 OnEventAlertPayLoad

Daniel Gaspary

2018-11-29 23:25

reporter   ~0112269

Thank you Michael.

Issue History

Date Modified Username Field Change
2018-11-22 03:34 Daniel Gaspary New Issue
2018-11-29 16:38 Michael Van Canneyt Assigned To => Michael Van Canneyt
2018-11-29 16:38 Michael Van Canneyt Status new => assigned
2018-11-29 16:43 Michael Van Canneyt Fixed in Revision => 40396
2018-11-29 16:43 Michael Van Canneyt Note Added: 0112264
2018-11-29 16:43 Michael Van Canneyt Status assigned => resolved
2018-11-29 16:43 Michael Van Canneyt Fixed in Version => 3.3.1
2018-11-29 16:43 Michael Van Canneyt Resolution open => fixed
2018-11-29 16:43 Michael Van Canneyt Target Version => 3.2.0
2018-11-29 23:25 Daniel Gaspary Note Added: 0112269
2018-11-29 23:25 Daniel Gaspary Status resolved => closed