On 04/14/2016 12:22 PM, Craig Ringer wrote:
I'd find a pg_get_tabledef(...) built-in function more interesting for this particular purpose than pg_dump as a library would be. We already have pg_get_viewdef(...), pg_get_functiondef(...) etc.
I am personally not a fan of the pg_get_Xdef() functions due to their heavy reliance on the syscache which feels rather unsafe in combination with concurrent DDL. I would not be surprised if we have some low probability bugs which cause inconsistent backups there which just has not hit enough people yet to have been reported. And this problem will only get worse as we reduce the lock level of more DDL.
Andreas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
