Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and search_path - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_dump and search_path
Date
Msg-id 20150811183600.GC3040@postgresql.org
Whole thread Raw
In response to Re: pg_dump and search_path  ("Steve Thames" <sthames42@gmail.com>)
List pgsql-hackers
Tree view 
Steve Thames wrote:
> Thank you gentlemen for clarifying this.
> 
> I found this problem when my database modeling tool saw a change in the
> database (the nextval() parameters) after a database restore.
> I guess the tool must be reading adsrc for this information.

You can tell for sure by setting log_statement=all.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: How to compare different datums within from a tuple?
Next
From: Robert Haas
Date:
Subject: Re: WIP: SCRAM authentication