[GENERAL] pg_dump recording privileges on foreign data wrappers

? Is there a way to get pg_dump to output the necessary statements such that running the dump back through psql results in the same priviliges that I started with? I am using version 9.5.6. Thanks very much, -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Conflicting function name in dynamically-loaded shared library

for the response and insight. -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Conflicting function name in dynamically-loaded shared library

developers to change the function's name, but that could break other code that currently uses it, and even if it didn't, I would prefer something less intrusive on that project. Thanks very much for any ideas about this, -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Re: User-defined operator function: what parameter type to use for uncast character string?

using 'CREATE TYPE' and excludes domains. If I am mistaken on that point I would be grateful to learn of that mistake. Thanks again, -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Re: User-defined operator function: what parameter type to use for uncast character string?

. Thanks again, -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] User-defined operator function: what parameter type to use for uncast character string?

of the query. I've also tried anyelement, but that does not work even with a cast. Thank you, -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Can a view represent a schedule for all days into the future?

the specifics of what I'm trying to. It seems like there ought to be a way, but I haven't figured it out. Thanks very much. -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Can a view represent a schedule for all days into the future?

On Thu, Oct 10, 2013 at 10:42:47AM -0700, David Johnston wrote: Adam Mackler-3 wrote http://stackoverflow.com/questions/19237450/can-sql-view-have-infinite-number-of-rows-repeating-schedule-each-row-a-day Not sure how you can state But I'm willing to agree never to query such a view

[GENERAL] A view representing a schedule for all days into the future

the specifics of what I'm trying to. It seems like there ought to be a way, but I haven't figured it out. Thanks very much. -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Can a view use a schema search_path?

with the schema name. Am I correct in concluding that there's no way to have a single view in the public schema that selects data from tables in different other schemas depending on my search_path at the time I execute a query involving that view? Thanks. -- Adam Mackler

[GENERAL] Views versus user-defined functions: formatting, comments, performance, etc.

factors should I be thinking of while deciding whether to store my self-composed, multi-hundred-line long SQL statement as a view or a function? -- Adam Mackler -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org