Thread: pg_dump question

pg_dump question

From
Carol Walter
Date:
Hello-

I'm trying to do an upgrade of version 8.1 to 8.2.3.  The restore is
failing because of some code that is in some views.  If I dump the
just the schema and then dump just the data, will the views be included?

Carol

Re: pg_dump question

From
"Scott Marlowe"
Date:
On Dec 7, 2007 2:18 PM, Carol Walter <walterc@indiana.edu> wrote:
> Hello-
>
> I'm trying to do an upgrade of version 8.1 to 8.2.3.  The restore is
> failing because of some code that is in some views.  If I dump the
> just the schema and then dump just the data, will the views be included?

Well, that really kinda depends.

Are you pg_dumping with 8.2's pg_dump?  If not try that.

What exact error messages are you getting?