| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | Shigeru HANADA <shigeru(dot)hanada(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> |
| Subject: | Re: pgsql_fdw, FDW for PostgreSQL server |
| Date: | 2012-04-07 20:19:21 |
| Message-ID: | CAA-aLv7j3H0UOhq7YFZBkvtik_HC-A=8LtrqN6Xf-gZQyrzobw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2012/4/7 Shigeru HANADA <shigeru(dot)hanada(at)gmail(dot)com>:
> I've updated pgsql_fdw so that it can collect statistics from foreign
> data with new FDW API.
I notice that if you restart the remote server, the connection is
broken, but the client doesn't notice this until it goes to fire off
another command. Should there be an option to automatically
re-establish the connection upon noticing the connection has dropped,
and issue a NOTICE that it had done so?
Also I'm not particularly keen on the message provided to the user in
this event:
ERROR: could not execute EXPLAIN for cost estimation
DETAIL: FATAL: terminating connection due to administrator command
FATAL: terminating connection due to administrator command
There's no explanation what the "administrator" command was, and I
suspect this is really just a "I don't know what's happened here"
condition. I don't think we should reach that point.
--
Thom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2012-04-07 20:51:03 | Re: Last gasp |
| Previous Message | Peter Eisentraut | 2012-04-07 17:27:12 | Re: Fix PL/Python metadata when there is no result |