numtel / pg-live-select

Live Updating PostgreSQL SELECT statements
https://www.npmjs.com/package/pg-live-select
Other
55 stars 9 forks source link

Using Schemas #9

Open shalomabitan opened 8 years ago

shalomabitan commented 8 years ago

Does the package support using schemas?

// Instantiate LivePg class
var liveDb = new LivePg(app.get('db_url') + '?ssl=true', 'myapp');

// Create a live select instance
liveDb.select('SELECT * FROM connect.contact').on('update', function(diff, data) { ... });

breaks with this error

$ statement: DROP TRIGGER IF EXISTS "myapp_contact" ON "contact"
$ relation "contact" does not exist, skipping

So I was wondering if there is anything that I would have to tweak in order to make this work for a pg database with schemas.

Thanks