| From: | Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Wrong error message in REINDEX command |
| Date: | 2015-03-08 03:19:58 |
| Message-ID: | CAD21AoDunNHhBLhR=61VsSo1UTKrtWTBBAOd2+KK9Yk-4CPYhw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I got wrong error message when I did REINDEX SYSTEM command in
transaction as follows.
It should say "ERROR: REINDEX SYSTEM cannot run inside a transaction block"
Attached patch fixes it.
[postgres][5432](1)=# begin;
BEGIN
[postgres][5432](1)=# reindex system postgres;
ERROR: REINDEX DATABASE cannot run inside a transaction block
STATEMENT: reindex system postgres;
Regards,
-------
Sawada Masahiko
| Attachment | Content-Type | Size |
|---|---|---|
| fix_reindex_error_message.patch | application/octet-stream | 593 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabrízio de Royes Mello | 2015-03-08 03:29:16 | Re: Strange debug message of walreciver? |
| Previous Message | Bruce Momjian | 2015-03-08 01:19:57 | Re: File based Incremental backup v8 |