pqstream icon indicating copy to clipboard operation
pqstream copied to clipboard

enable auto-subscription to new tables

Open tmc opened this issue 8 years ago • 4 comments

watching for schema changes would enable subscribing to tables that are created after initial connection.

tmc avatar Sep 08 '17 00:09 tmc

Is this something you need to tell Postgres to notify on or should the changes be monitored from the app side?

pieterlouw avatar Oct 18 '17 05:10 pieterlouw

The easy solution would be polling

tmc avatar Oct 18 '17 05:10 tmc

The clever thing (maybe too clever) would be subscribing to the appropriate pg tables to detect new table arrival. I lean the former.

tmc avatar Oct 18 '17 05:10 tmc

The user can specify regexp on which tables they want to manage, should this be regarded when a new table is added ?

On Wed, Oct 18, 2017 at 7:24 AM, Travis Cline [email protected] wrote:

The clever thing (maybe too clever) would be subscribing to the appropriate pg tables to detect new table arrival. I lean the former.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/tmc/pqstream/issues/4#issuecomment-337463732, or mute the thread https://github.com/notifications/unsubscribe-auth/AETJrVVq2y00sn0Sai34eXLrRRnmSrRhks5stYt5gaJpZM4PQi-T .

pieterlouw avatar Oct 18 '17 06:10 pieterlouw