View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000256 | Pgpool-II | Bug | public | 2016-10-19 22:54 | 2016-10-20 07:47 |
| Reporter | tatzlwurm2 | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Product Version | 3.5.4 | ||||
| Summary | 0000256: Load Balancing option with master slave doesn't work for Functions that write. | ||||
| Description | I have a master with a few slaves with load balancing option on. | ||||
| Steps To Reproduce | I connect via pgpool : CREATE OR REPLACE FUNCTION spcwriteperson(fname varchar(20)) RETURNS VOID AS $$ BEGIN INSERT INTO person (firstName) VALUES (fname); END $$ LANGUAGE 'plpgsql'; create table person(firstname varchar(20)); select spcwriteperson('x'); ERROR: cannot execute INSERT in a read-only transaction CONTEXT: SQL statement "INSERT INTO person (firstName) VALUES (fname)" PL/pgSQL function spcwriteperson(character varying) line 3 at SQL statement | ||||
| Tags | No tags attached. | ||||
|
|
My mistake, I am new to this and didn't see black_function_list. After editing this now works correctly, please close. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-10-19 22:54 | tatzlwurm2 | New Issue | |
| 2016-10-19 23:00 | tatzlwurm2 | Note Added: 0001127 | |
| 2016-10-20 07:47 | t-ishii | Status | new => closed |
