> This looks good. I like the black/white lists. > > In load_balance_mode, if we decide to send a SELECT statement to the > standby and it results in an ERROR, what happens? There seems to be 2 > retryable error conditions.
In any case currently pgpool-II returns exact same error message returned from PostgreSQL. > The ERROR could be an error caused by attempt to write to the database, > in which case we expect that the SELECT can be re-executed correctly on > the master. > Such errors will return 25006 READ ONLY SQL TRANSACTION > > The ERROR could also be caused by a Hot Standby conflict, in which case > we can re-execute the query with some hope of later success. > Such errors will return 40001 SERIALIZATION FAILURE > > Possibly somewhat late, but it would be cool to add that feature. I > would be happy to help. Thanks. It's too late for 3.0 but I'm looking forward to having those features in the future releases. Are you going to write patches for this? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
