Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
And I forgot to add: * Allow dumping/restoring of any number of specific objects and types Chris Christopher Kings-Lynne wrote: OK, everything for pg_dump TODO I can think of: pg_dump/pg_dumpall/pg_restore * Add dumping of comments on composite type columns * Add dumping of comments on index columns * Replace crude DELETE FROM way of dumping cleaning of users and groups with separate DROP commands * Add dumping and restoring of LOB comments * Stop dumping CASCADE on DROP TYPE commands in clean mode * Add full object name to the tag field. eg. for operators we need '=(integer, integer)', instead of just '='. * Add pg_dumpall custom format dumps. This is probably best done by: * Combining pg_dump and pg_dumpall into a single binary * Export to other database (eg. Oracle, MySQL and DB2) formats I'm hopefully getting the first 4 in for 8.0 release... The full names in tags one should be done really as well at some point. Anyone got anything else? Chris Bruce Momjian wrote: Yes, shoot over that the section should contain. --- Christopher Kings-Lynne wrote: Perhaps. I was also thinking that maybe it's time to combine pg_dumpall and pg_dump into a single utility. At the moment, I can't see how pg_dumpall can ever have a -Fc option, since it will be messy to interact with the pg_dump processes. I was thinking a pg_export utility that can output to a range of other databases SQL formats would also be a good idea. It would share about 90% of the pg_dump code, but I'm trying to think of how to avoid duplicating the code. How about we have a whole pg_dump/dumpall/restore/backup section in the TODO file? Chris Bruce Momjian wrote: TODO item? --- Christopher Kings-Lynne wrote: I just got an autoreply from David stating he will be away until August 9 if we want this functionality we have to code it ourselves. If not it can wait until the next major release. It can wait --- it was submitted after feature freeze anyway, and we certainly have more than enough other things to do in the next couple days. I have a plan to allow pg_dump to dump any object in the next version - i suspect these two ideas will need reconciliation. Chris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
Yep, a whole section for pg_dump features and bugs would be nice. Bruce Momjian wrote: Do you want any of these added to the TODO? --- Christopher Kings-Lynne wrote: And I forgot to add: * Allow dumping/restoring of any number of specific objects and types Chris Christopher Kings-Lynne wrote: OK, everything for pg_dump TODO I can think of: pg_dump/pg_dumpall/pg_restore * Add dumping of comments on composite type columns * Add dumping of comments on index columns * Replace crude DELETE FROM way of dumping cleaning of users and groups with separate DROP commands * Add dumping and restoring of LOB comments * Stop dumping CASCADE on DROP TYPE commands in clean mode * Add full object name to the tag field. eg. for operators we need '=(integer, integer)', instead of just '='. * Add pg_dumpall custom format dumps. This is probably best done by: * Combining pg_dump and pg_dumpall into a single binary * Export to other database (eg. Oracle, MySQL and DB2) formats I'm hopefully getting the first 4 in for 8.0 release... The full names in tags one should be done really as well at some point. Anyone got anything else? Chris Bruce Momjian wrote: Yes, shoot over that the section should contain. --- Christopher Kings-Lynne wrote: Perhaps. I was also thinking that maybe it's time to combine pg_dumpall and pg_dump into a single utility. At the moment, I can't see how pg_dumpall can ever have a -Fc option, since it will be messy to interact with the pg_dump processes. I was thinking a pg_export utility that can output to a range of other databases SQL formats would also be a good idea. It would share about 90% of the pg_dump code, but I'm trying to think of how to avoid duplicating the code. How about we have a whole pg_dump/dumpall/restore/backup section in the TODO file? Chris Bruce Momjian wrote: TODO item? --- Christopher Kings-Lynne wrote: I just got an autoreply from David stating he will be away until August 9 if we want this functionality we have to code it ourselves. If not it can wait until the next major release. It can wait --- it was submitted after feature freeze anyway, and we certainly have more than enough other things to do in the next couple days. I have a plan to allow pg_dump to dump any object in the next version - i suspect these two ideas will need reconciliation. Chris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
Christopher Kings-Lynne wrote: OK, everything for pg_dump TODO I can think of: [snip] * Export to other database (eg. Oracle, MySQL and DB2) formats This strikes me as a can of worms, or to mix metaphors a bit, a rathole from which we might never emerge. I did have a thought the other day - now that we have COPY in/out talking CSV format, it might be nice to have an option on pg_dump to use CSV format rather than our own native text format. That should make exporting to other DBs a lot easier. Of course, that could be cutting our own throat too ... cheers andrew ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
That should make exporting to other DBs a lot easier. Of course, that could be cutting our own throat too ... It won't make any difference to anything. You can already dump in INSERT format. Being able to export to other dbs will get us _more_ users, not less. Chris ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: >> That should make exporting to other DBs a lot easier. Of course, that >> could be cutting our own throat too ... > It won't make any difference to anything. You can already dump in > INSERT format. And anyway, the DDL peculiarities would be the hard part for someone to fix, not the data formatting. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
Tom Lane wrote: Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: That should make exporting to other DBs a lot easier. Of course, that could be cutting our own throat too ... It won't make any difference to anything. You can already dump in INSERT format. And anyway, the DDL peculiarities would be the hard part for someone to fix, not the data formatting. Yes, both of these are true. cheers andrew ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
On Friday 13 August 2004 00:13, Christopher Kings-Lynne wrote: > > That should make exporting to other DBs a lot easier. Of course, that > > could be cutting our own throat too ... > > It won't make any difference to anything. You can already dump in > INSERT format. > > Being able to export to other dbs will get us _more_ users, not less. > Without some type of corresponding import utility that seems logically false. -- Robert Treat Build A Better Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
Being able to export to other dbs will get us _more_ users, not less. Without some type of corresponding import utility that seems logically false. Nope. Consider it like this. How many companies are going to move to PostgreSQL from Oracle if they cannot dump their data back to Oracle as a failsafe? Very few. How many people will use PostgreSQL if they know they cannot dump it over to MySQL or anything easily if they want to. Trying to "tie in" users is pre-opensource / big commercial company thinking. What if they have a mixed environment, and they want to be able to give data and dumps from postgres to their MySQL people? Consider that no companies switched to MS Excel when it was first invented UNTIL it could export BACK to Lotus. Otherwise, how could they give their Excel files to other users in the office who hadn't upgraded yet? Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and
OK, I have added a new pg_dump TODO section with adjustments based on feedback from original list: * pg_dump o Allow pg_dumpall to use non-text output formats o Have pg_dump use multi-statement transactions for INSERT dumps o -Allow pg_dump to dump CREATE CONVERSION (Christopher) o -Make pg_restore continue after errors, so it acts more like pg_dump scripts o Allow pg_dump to use multiple -t and -n switches This should be done by allowing a '-t schema.table' syntax. o Add dumping of comments on composite type columns o Add dumping of comments on index columns o Replace crude DELETE FROM method of pg_dumpall for cleaning of users and groups with separate DROP commands o Add dumping and restoring of LOB comments o Stop dumping CASCADE on DROP TYPE commands in clean mode o Add full object name to the tag field. eg. for operators we need '=(integer, integer)', instead of just '='. o Add pg_dumpall custom format dumps. This is probably best done by combining pg_dump and pg_dumpall into a single binary o Add CSV output format --- Andrew Dunstan wrote: > > > Christopher Kings-Lynne wrote: > > > OK, everything for pg_dump TODO I can think of: > > > > [snip] > > * Export to other database (eg. Oracle, MySQL and DB2) formats > > > > > > This strikes me as a can of worms, or to mix metaphors a bit, a rathole > from which we might never emerge. > > I did have a thought the other day - now that we have COPY in/out > talking CSV format, it might be nice to have an option on pg_dump to use > CSV format rather than our own native text format. > > That should make exporting to other DBs a lot easier. Of course, that > could be cutting our own throat too ... > > cheers > > andrew > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new
Do you want any of these added to the TODO? --- Christopher Kings-Lynne wrote: > And I forgot to add: > > * Allow dumping/restoring of any number of specific objects and types > > Chris > > Christopher Kings-Lynne wrote: > > > OK, everything for pg_dump TODO I can think of: > > > > pg_dump/pg_dumpall/pg_restore > > > > * Add dumping of comments on composite type columns > > * Add dumping of comments on index columns > > * Replace crude DELETE FROM way of dumping cleaning of users and groups > > with separate DROP commands > > * Add dumping and restoring of LOB comments > > * Stop dumping CASCADE on DROP TYPE commands in clean mode > > * Add full object name to the tag field. eg. for operators we need > > '=(integer, integer)', instead of just '='. > > * Add pg_dumpall custom format dumps. This is probably best done by: > > * Combining pg_dump and pg_dumpall into a single binary > > * Export to other database (eg. Oracle, MySQL and DB2) formats > > > > I'm hopefully getting the first 4 in for 8.0 release... The full names > > in tags one should be done really as well at some point. > > > > Anyone got anything else? > > > > Chris > > > > Bruce Momjian wrote: > > > >> Yes, shoot over that the section should contain. > >> > >> --- > >> > >> > >> Christopher Kings-Lynne wrote: > >> > >>> Perhaps. I was also thinking that maybe it's time to combine > >>> pg_dumpall and pg_dump into a single utility. At the moment, I can't > >>> see how pg_dumpall can ever have a -Fc option, since it will be messy > >>> to interact with the pg_dump processes. > >>> > >>> I was thinking a pg_export utility that can output to a range of > >>> other databases SQL formats would also be a good idea. It would > >>> share about 90% of the pg_dump code, but I'm trying to think of how > >>> to avoid duplicating the code. > >>> > >>> How about we have a whole pg_dump/dumpall/restore/backup section in > >>> the TODO file? > >>> > >>> Chris > >>> > >>> Bruce Momjian wrote: > >>> > >>> > TODO item? > > --- > > > Christopher Kings-Lynne wrote: > > > >>> I just got an autoreply from David stating he will be away until > >>> August > >>> 9 if we want this functionality we have to code it ourselves. If > >>> not it > >>> can wait until the next major release. > >> > >> > >> It can wait --- it was submitted after feature freeze anyway, and we > >> certainly have more than enough other things to do in the next > >> couple days. > > > > > > I have a plan to allow pg_dump to dump any object in the next > > version - i suspect these two ideas will need reconciliation. > > > > Chris > > > > > >> > > > > ---(end of broadcast)--- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
Is anyone working on this patch? --- Tom Lane wrote: > "David F. Skoll" <[EMAIL PROTECTED]> writes: > > On Wed, 21 Jul 2004, Tom Lane wrote: > >> pg_dump -t s1.t1 -t s2.t2 -- Dump s1.t1 and s2.t2 > > > That's a good idea, but then it's questionable whether we need the -n > > switch at all. > > Sure we do --- for backwards compatibility if nothing else. > > > It might be simpler to extend the -t switch to accept: > > pg-dump -t 's1.*' > > That would not be the same thing --- that would mean to dump *only tables* > from s1, rather than objects of all types. Anyway, I think it's a bit > late in this cycle to be proposing to implement wild-card matching. > Maybe for next time someone can do that, but for 7.5 I think we should > limit ourselves to cleaning up any design flaws of the already-submitted > patch. > > regards, tom lane > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
I just got an autoreply from David stating he will be away until August 9 if we want this functionality we have to code it ourselves. If not it can wait until the next major release. If anyone wants the original patch I can supply it. --- Tom Lane wrote: > "David F. Skoll" <[EMAIL PROTECTED]> writes: > > On Wed, 21 Jul 2004, Tom Lane wrote: > >> pg_dump -t s1.t1 -t s2.t2 -- Dump s1.t1 and s2.t2 > > > That's a good idea, but then it's questionable whether we need the -n > > switch at all. > > Sure we do --- for backwards compatibility if nothing else. > > > It might be simpler to extend the -t switch to accept: > > pg-dump -t 's1.*' > > That would not be the same thing --- that would mean to dump *only tables* > from s1, rather than objects of all types. Anyway, I think it's a bit > late in this cycle to be proposing to implement wild-card matching. > Maybe for next time someone can do that, but for 7.5 I think we should > limit ourselves to cleaning up any design flaws of the already-submitted > patch. > > regards, tom lane > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
Bruce Momjian <[EMAIL PROTECTED]> writes: > I just got an autoreply from David stating he will be away until August > 9 if we want this functionality we have to code it ourselves. If not it > can wait until the next major release. It can wait --- it was submitted after feature freeze anyway, and we certainly have more than enough other things to do in the next couple days. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
TODO item? --- Christopher Kings-Lynne wrote: > >>I just got an autoreply from David stating he will be away until August > >>9 if we want this functionality we have to code it ourselves. If not it > >>can wait until the next major release. > > > > It can wait --- it was submitted after feature freeze anyway, and we > > certainly have more than enough other things to do in the next couple days. > > I have a plan to allow pg_dump to dump any object in the next version - > i suspect these two ideas will need reconciliation. > > Chris > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
I just got an autoreply from David stating he will be away until August 9 if we want this functionality we have to code it ourselves. If not it can wait until the next major release. It can wait --- it was submitted after feature freeze anyway, and we certainly have more than enough other things to do in the next couple days. I have a plan to allow pg_dump to dump any object in the next version - i suspect these two ideas will need reconciliation. Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
Perhaps. I was also thinking that maybe it's time to combine pg_dumpall and pg_dump into a single utility. At the moment, I can't see how pg_dumpall can ever have a -Fc option, since it will be messy to interact with the pg_dump processes. I was thinking a pg_export utility that can output to a range of other databases SQL formats would also be a good idea. It would share about 90% of the pg_dump code, but I'm trying to think of how to avoid duplicating the code. How about we have a whole pg_dump/dumpall/restore/backup section in the TODO file? Chris Bruce Momjian wrote: TODO item? --- Christopher Kings-Lynne wrote: I just got an autoreply from David stating he will be away until August 9 if we want this functionality we have to code it ourselves. If not it can wait until the next major release. It can wait --- it was submitted after feature freeze anyway, and we certainly have more than enough other things to do in the next couple days. I have a plan to allow pg_dump to dump any object in the next version - i suspect these two ideas will need reconciliation. Chris ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
Yes, shoot over that the section should contain. --- Christopher Kings-Lynne wrote: > Perhaps. I was also thinking that maybe it's time to combine pg_dumpall > and pg_dump into a single utility. At the moment, I can't see how > pg_dumpall can ever have a -Fc option, since it will be messy to > interact with the pg_dump processes. > > I was thinking a pg_export utility that can output to a range of other > databases SQL formats would also be a good idea. It would share about > 90% of the pg_dump code, but I'm trying to think of how to avoid > duplicating the code. > > How about we have a whole pg_dump/dumpall/restore/backup section in the > TODO file? > > Chris > > Bruce Momjian wrote: > > > TODO item? > > > > --- > > > > Christopher Kings-Lynne wrote: > > > I just got an autoreply from David stating he will be away until August > 9 if we want this functionality we have to code it ourselves. If not it > can wait until the next major release. > >>> > >>>It can wait --- it was submitted after feature freeze anyway, and we > >>>certainly have more than enough other things to do in the next couple days. > >> > >>I have a plan to allow pg_dump to dump any object in the next version - > >>i suspect these two ideas will need reconciliation. > >> > >>Chris > >> > > > > > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] [PATCHES] Patch for pg_dump: Multiple -t options and new -T option
OK, everything for pg_dump TODO I can think of: pg_dump/pg_dumpall/pg_restore * Add dumping of comments on composite type columns * Add dumping of comments on index columns * Replace crude DELETE FROM way of dumping cleaning of users and groups with separate DROP commands * Add dumping and restoring of LOB comments * Stop dumping CASCADE on DROP TYPE commands in clean mode * Add full object name to the tag field. eg. for operators we need '=(integer, integer)', instead of just '='. * Add pg_dumpall custom format dumps. This is probably best done by: * Combining pg_dump and pg_dumpall into a single binary * Export to other database (eg. Oracle, MySQL and DB2) formats I'm hopefully getting the first 4 in for 8.0 release... The full names in tags one should be done really as well at some point. Anyone got anything else? Chris Bruce Momjian wrote: Yes, shoot over that the section should contain. --- Christopher Kings-Lynne wrote: Perhaps. I was also thinking that maybe it's time to combine pg_dumpall and pg_dump into a single utility. At the moment, I can't see how pg_dumpall can ever have a -Fc option, since it will be messy to interact with the pg_dump processes. I was thinking a pg_export utility that can output to a range of other databases SQL formats would also be a good idea. It would share about 90% of the pg_dump code, but I'm trying to think of how to avoid duplicating the code. How about we have a whole pg_dump/dumpall/restore/backup section in the TODO file? Chris Bruce Momjian wrote: TODO item? --- Christopher Kings-Lynne wrote: I just got an autoreply from David stating he will be away until August 9 if we want this functionality we have to code it ourselves. If not it can wait until the next major release. It can wait --- it was submitted after feature freeze anyway, and we certainly have more than enough other things to do in the next couple days. I have a plan to allow pg_dump to dump any object in the next version - i suspect these two ideas will need reconciliation. Chris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly