Re: [Csql-users] Newbie needs help with caching Postgres tables in CSQL

[Barney, K. L <Ker...@us...>]

After more testing let me redefine the problem:
 
If I insert rows in Postgres tables these rows propagate to the corresponding CSQL table, and if I insert rows to the CSQL tables
they do get propagated to the corresponding Postgres table
 
BUT  it only does this when I restart the csqlserver.  While csqlserver is running inserts to do not get propagated in either
direction.
 
I have tried setting ENABLE_BIDIRECTIONAL_CACHE to true and I have tried setting it to false.
 
Kerry Barney
Database Administrator
Platforms, United Space Alliance
Kennedy Space Center, FL
321-861-7467

________________________________

From: Barney, Kerry L 
Sent: Thursday, April 28, 2011 9:15 AM
To: csq...@li...
Subject: Newbie needs help with caching Postgres tables in CSQL 


Please help.  I am new to CSQL.  If I insert rows in Postgres tables these rows propagate to the corresponding CSQL table, but
updates to the CSQL tables do not propagate to the corresponding Postgres table.  The documentation suggests that this is the
default behaviour and yet it does not appear to be working.  I attached my csql.conf file.
 
Kerry Barney
Database Administrator
Platforms, United Space Alliance
Kennedy Space Center, FL
321-861-7467