| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | ERRCODE_READ_ONLY_SQL_TRANSACTION |
| Date: | 2012-01-12 22:22:46 |
| Message-ID: | CA+U5nMJdxdZbjLYFQS3dyGb2X=vC6ZKJsWqqNJ+6AYYtAmznEw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hot Standby returns ERRCODE_READ_ONLY_SQL_TRANSACTION in most cases
for illegal actions on a standby.
There are two possible but not normally seen cases that give errors,
but don't set the correct sqlstate, which makes it difficult to
diagnose misdirected SQL from more normal SQL problems.
*Patch corrects this. Thanks to Dimitri for the report.
Backpatching to 9.0
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| ERRCODE_READ_ONLY_SQL_TRANSACTION.v1.patch | text/x-patch | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2012-01-12 22:31:51 | Re: Remembering bug #6123 |
| Previous Message | Tom Lane | 2012-01-12 21:50:58 | rewriteheap.c bug: toast rows don't get XIDs matching their parents |