Fixed postgres subscription issues v14

[PascalSenn]

Port #7155 to v14 by @williamdenton

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 58.06452% with 13 lines in your changes missing coverage. Please review.

Project coverage is 72.47%. Comparing base (41dee1d) to head (dc7b48d). Report is 74 commits behind head on main.

Files	Patch %	Lines
...rc/Subscriptions.Postgres/PostgresChannelWriter.cs	64.28%	10 Missing :warning:
....Postgres/Properties/PostgresResources.Designer.cs	0.00%	3 Missing :warning:

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #7164      +/-   ##
==========================================
- Coverage   74.95%   72.47%   -2.48%     
==========================================
  Files        2628     2645      +17     
  Lines      132020   132604     +584     
==========================================
- Hits        98951    96110    -2841     
- Misses      33069    36494    +3425     

Flag	Coverage Δ
unittests	72.47% <58.06%> (-2.48%)	:arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.