Can't select existing table/collection #3
Description
What does the log say?
Sorry I'm lost...
meteor create jmapp
meteor add storeness:meteor-postgres
jm = new SQL.Collection('jm');
if (Meteor.isClient) {
Template.body.helpers({
jms: function () {
return jm.select().fetch();
}
});
}
if (Meteor.isServer) {
jm.publish('jm', function(){
return jm.select();
});
}<body>
<div class="container">
<header>
<h1>Anwesenheitsliste</h1>
</header>
<ul>
{{#each jms}}
{{> jme}}
{{/each}}
</ul>
</div>
</body>
<template name="jme">
<li>{{Vorname}} {{Nachname}} Zimmer {{Zimmer}}</li>
</template>MP_POSTGRES=postgres://foo:bar@dev2.juhiwue.de:5432/jmdb meteor --port=3010
I20151022-17:31:23.710(2)? init 0
I20151022-17:31:23.796(2)? Exception from sub jm id 7W9KZDviw4iqdJ9n6 TypeError: Cannot read property 'submit' of undefined
I20151022-17:31:23.797(2)? at [object Object].Client.query (/home/kkappel/.meteor/packages/storeness_meteor-postgres/.0.2.1.9y08wy++os+web.browser+web.cordova/npm/node_modules/pg/lib/client.js:311:29)
I20151022-17:31:23.797(2)? at autoSelectHelper (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:645:1)
I20151022-17:31:23.797(2)? at loadAutoSelectClient (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:641:1)
I20151022-17:31:23.797(2)? at Array.SQL.Server.autoSelect (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:674:1)
I20151022-17:31:23.797(2)? at Object.publishCursor (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:928:1)
I20151022-17:31:23.797(2)? at [object Object]..extend.runHandler (livedata_server.js:1059:13)
I20151022-17:31:23.798(2)? at [object Object]..extend.startSubscription (livedata_server.js:842:9)
I20151022-17:31:23.798(2)? at [object Object]..extend.protocol_handlers.sub (livedata_server.js:614:12)
I20151022-17:31:23.798(2)? at livedata_server.js:548:43
I20151022-17:31:29.955(2)? auto 1