LiveCode Forums.

Is it possible in Revolution to LISTEN on notifications sent by the PostgreSQL database asynchronously? I want to subscribe (LISTEN) with my client to messages sent after e.g. inserts into a specific table. To active that, you create a rule on a table in postgresql: CREATE RULE loginsert AS ON INSER...

Jan, thx for the tip, but I've used several variations of the database name, eg: PostgreSQL, postgresql, PostGreSQL, pgsql, dbpostgresql (as this is the db driver name), ... In every case I'm getting the invalid database type error message. For additional info: the db is accessible via command line ...

I'm currently evaluating (trial license) Revolution 2.7.2 under Mac OSX (PPC) 10.4.7 in combination with PostgreSQL databases. I'm using following script code, to connect to PostgreSQL: put revOpenDatabase("PostgreSQL","dbserver:5432","Statistics","view","secret") into tConnectionID answer tConnecti...