in the session
established by postgres_fdw have to be schema-qualified. Trigger
function is executed in such context, so you need to qualify all
objects in your trigger function with schema name, like
'public.nppsmoke_2013_09'.
Regards,
--
Shigeru HANADA
--
Sent via pgsql-general mailing list (pgsql
not sure about other object types, but IMO secure information such
as URI which includes password should be stored in user mappings rather
than servers.
Regards,
--
Shigeru Hanada
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
=252 width=18) (actual
time=0.008..0.045 rows=252 loops=1)
Total runtime: 0.089 ms
(2 rows)
IMHO planner should be modified so that it can estimate result rows
accurately in this case.
--
Shigeru Hanada
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
/projects/interdbconnect/
[2]http://archives.postgresql.org/pgsql-hackers/2011-10/msg01329.php
Regards,
--
Shigeru Hanada
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with foreign tables.
Regards,
--
Shigeru Hanada
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general