Hello, I'm new to pgpool. I currently have pgpool II 2.2.2 installed. the underlying PostgreSQL database is 8.4. i'm not doing parallel queries, but i am using replication and pooling. i've successfully tested it up to 3 nodes, and i am able to detach, recover, and attach nodes with no problems.
when i issue inserts, updates, deletes, selects - i get the expected results on all attached nodes. however when i do inserts from within functions, the insert only occurs on the master node. the table has a SERIAL primary key, and i expect that this can be an issue with synchronizing, but shouldn't the insert at least happen on all nodes? i have also tried adding things like: LOCK TABLE table_name IN SHARE ROW EXCLUSIVE MODE; INSERT.... to no avail. is this a known issue, or by design? or am i screwing up? any help would be appreciated -janos
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
