| From: | "Henry Combrinck" <henry(at)zen(dot)co(dot)za> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4203: perform dblink() in begin/exception returns wrong SQLSTATE code |
| Date: | 2008-05-27 15:13:26 |
| Message-ID: | 200805271513.m4RFDQ9a004292@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
The following bug has been logged online:
Bug reference: 4203
Logged by: Henry Combrinck
Email address: henry(at)zen(dot)co(dot)za
PostgreSQL version: 8.2.6 and 8.3.1
Operating system: Linux
Description: perform dblink() in begin/exception returns wrong
SQLSTATE code
Details:
Apologies if this is the wrong forum to report this (perhaps it needs to go
to the dblink() maintainer?)
In a function on a machine using 8.2.6, the following returns a strange
SQLSTATE code:
begin
perform dblink ('host=other_machine ...',
'insert into table...');
exception when others then
raise notice 'SQLSTATE: %', SQLSTATE;
end;
The code returned is always 42601 (syntax_error) irrespective of the actual
error (eg, unique_violation).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-05-27 15:56:43 | Re: BUG #4203: perform dblink() in begin/exception returns wrong SQLSTATE code |
| Previous Message | Tom Lane | 2008-05-27 14:19:35 | Re: BUG #4196: Backend crash possible with psql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2008-05-27 15:22:22 | Doc patch: type modifiers |
| Previous Message | Greg Sabino Mullane | 2008-05-27 14:16:18 | Re: LOCK_DEBUG documentation |