Tom Lane wrote: > Florian Weimer <[EMAIL PROTECTED]> writes: > > Tom Lane <[EMAIL PROTECTED]> writes: > >> SET SESSION AUTHORIZATION should have been used instead, but I doubt > >> Florian has any convenient way to re-do the dump file with that option. > > > Fortunately, I can re-do the dump (I'm eager to become a professional > > with a production and a testing machine ;-). > > Oh, in that case you can use > pg_dump -X use-set-session-authorization > > > But SET SESSION AUTHORIZATION does not seem to be available in 7.2.1, > > yet 7.1.3. > > I do not think 7.1's pg_dump had this option, but you can run 7.2's > pg_dump against the 7.1 server (in fact that is probably preferable > anyhow). > > I would like to see use-set-session-authorization become the default > before 7.3 release, but haven't got around to doing anything about it.
Certainly seems like a good idea. TODO item? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
