
I have been playing with schema's under 7.3beta and now I am trying to use pg_dump.  Is there a way to just dump 1 of my
schema out?  


Should pg_dump -t "A.*" ...  dump out just schema A's objects?


Thanks
Jim


Mon, 16 Sep 2002 08:12:25 -0400
"Jim Buttafuoco" <jim@contactbda.com>
7.3 Beta Schema and pg_dump
"Jim Buttafuoco" <jim@contactbda.com> writes:
> I have been playing with schema's under 7.3beta and now I am trying to
> use pg_dump.  Is there a way to just dump 1 of my schema out?

Nope; I intended to make that happen, but didn't get around to it.

			regards, tom lane

Mon, 16 Sep 2002 09:16:55 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.3 Beta Schema and pg_dump 
This seems like a "must" have option for pg_dump,  looking at the code, it seems that only a couple of queries would
need to be changed and a command line option (-N, --namespace=) would need to be added.

If I was to create a patch would it make it into 7.3?

Thanks
Jim



> "Jim Buttafuoco" <jim@contactbda.com> writes:
> > I have been playing with schema's under 7.3beta and now I am trying to
> > use pg_dump.  Is there a way to just dump 1 of my schema out?
> 
> Nope; I intended to make that happen, but didn't get around to it.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org





Mon, 16 Sep 2002 09:35:26 -0400
"Jim Buttafuoco" <jim@contactbda.com>
Re: 7.3 Beta Schema and pg_dump 
"Jim Buttafuoco" <jim@contactbda.com> writes:
> This seems like a "must" have option for pg_dump,
> If I was to create a patch would it make it into 7.3?

I dunno ... I'd like to have it too, but it would break our "no new
features during beta" rule.  Comments anyone?

			regards, tom lane

Mon, 16 Sep 2002 10:02:10 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.3 Beta Schema and pg_dump 
On Mon, 16 Sep 2002, Tom Lane wrote:

> "Jim Buttafuoco" <jim@contactbda.com> writes:
> > This seems like a "must" have option for pg_dump,
> > If I was to create a patch would it make it into 7.3?
>
> I dunno ... I'd like to have it too, but it would break our "no new
> features during beta" rule.  Comments anyone?
>

I'd love to have this feature. What's about contrib/ ?

> 			regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Mon, 16 Sep 2002 18:32:39 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: 7.3 Beta Schema and pg_dump 
Tom Lane writes:

> "Jim Buttafuoco" <jim@contactbda.com> writes:
> > This seems like a "must" have option for pg_dump,
> > If I was to create a patch would it make it into 7.3?
>
> I dunno ... I'd like to have it too, but it would break our "no new
> features during beta" rule.  Comments anyone?

I do not believe Jim's premise that it would only take a couple of changes
to a couple of queries.  Clearly, it would take at least some change to
any query that reads information about schema-aware objects.  And it needs
to be made backward compatible.  And what about cross-schema dependencies?

-- 
Peter Eisentraut   peter_e@gmx.net


Mon, 16 Sep 2002 19:25:48 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: 7.3 Beta Schema and pg_dump 
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> "Jim Buttafuoco" <jim@contactbda.com> writes:
> This seems like a "must" have option for pg_dump,
> If I was to create a patch would it make it into 7.3?
>> 
>> I dunno ... I'd like to have it too, but it would break our "no new
>> features during beta" rule.  Comments anyone?

> I do not believe Jim's premise that it would only take a couple of changes
> to a couple of queries.  Clearly, it would take at least some change to
> any query that reads information about schema-aware objects.

Actually, my vision of this was not to change any queries at all, but
just to modify the pg_dump code to include a "select this schema" option.
The infrastructure is already there in pg_dump to mark individual schemas
as to be dumped or not --- we only need a command-line option that can
mark them.

> And what about cross-schema dependencies?

Given the lack of any dependency tracing in pg_dump at the moment, I
think we just leave that on the user's head for now.  It's not any worse
than the behavior of -t, which is perfectly capable of giving you an
incomplete dump.

			regards, tom lane

Mon, 16 Sep 2002 13:33:13 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.3 Beta Schema and pg_dump 
> "Jim Buttafuoco" <jim@contactbda.com> writes:
> > This seems like a "must" have option for pg_dump,
> > If I was to create a patch would it make it into 7.3?
> 
> I dunno ... I'd like to have it too, but it would break our "no new
> features during beta" rule.  Comments anyone?

I don't see a huge reason to stick to that rule in this instance...

Chris


Tue, 17 Sep 2002 09:30:47 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: 7.3 Beta Schema and pg_dump 
Christopher Kings-Lynne wrote:
> > "Jim Buttafuoco" <jim@contactbda.com> writes:
> > > This seems like a "must" have option for pg_dump,
> > > If I was to create a patch would it make it into 7.3?
> > 
> > I dunno ... I'd like to have it too, but it would break our "no new
> > features during beta" rule.  Comments anyone?
> 
> I don't see a huge reason to stick to that rule in this instance...

Reclassify it as a bug ... problem solved.  ;-)

Actually, it is sort of a bug because it is something we should have
added for schemas but forgot.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Tue, 17 Sep 2002 01:29:00 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: 7.3 Beta Schema and pg_dump