Thread: bug in pg_dump with GRANT/REVOKE
I'm running postgres 6.5.3 and 7.0.3 and pg_dump gives me the following output: DROP TABLE "genrenametable"; CREATE TABLE "genrenametable" ( "genreid" int4, "name" character varying(128), "parentgenre" int4, "enabled" bool DEFAULT 'f' NOT NULL ); REVOKE ALL on "genrenametable" from PUBLIC; GRANT SELECT on "genrenametable" to "hammor"; GRANT SELECT on "genrenametable" to "johnbr"; COPY "genrenametable" FROM stdin; 4115 80s Alt Hits 4096 t 4138 New Wave Hits 4096 t 4117 90s Alt Hits 4096 t ... As you can guess, this will not successfully restore the table. Perhaps the REVOKE/GRANT statements can be moved to after the COPY. The fancy solution would be to make sure the table owner has permissions to do the COPY, and then revoke the permissions afterward if necessary.
Off Topic post: Thought some people might find this article interesting. http://www.zend.com/zend/art/databases.php
> Thought some people might find this article interesting. > http://www.zend.com/zend/art/databases.php The only interesting thing I noticed is how fast it crashes my Netscape-4.76 browser ;) - Thomas
> > Thought some people might find this article interesting. > > http://www.zend.com/zend/art/databases.php > > The only interesting thing I noticed is how fast it crashes my > Netscape-4.76 browser ;) Yours too? I turned off Java/Javascript to get it to load and I am on BSD/OS. Strange it so univerally crashes. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
I think there is really something weird about the Zend site - I use the current IE on an NT machine, and every page loads, but then I have to wait about 10 additional seconds before IE "wakes up" and I can click any links or go to a different page. I think it may have something to do with the DHTML menus... but I haven't really looked into it. -r At 09:18 PM 6/1/01 -0400, Bruce Momjian wrote: > > > Thought some people might find this article interesting. > > > http://www.zend.com/zend/art/databases.php > > > > The only interesting thing I noticed is how fast it crashes my > > Netscape-4.76 browser ;) > >Yours too? I turned off Java/Javascript to get it to load and I am on >BSD/OS. Strange it so univerally crashes. > >-- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (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 6: Have you searched our list archives? > >http://www.postgresql.org/search.mpl > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
> > Thought some people might find this article interesting. > > http://www.zend.com/zend/art/databases.php > The only interesting thing I noticed is how fast it crashes my > Netscape-4.76 browser ;) Use Konqueror :-) I can't tell if the results are biased, but it puts PostgreSQL way ahead of MySQL and Interchange in performance (if more than a couple of simultaneous users) and most other features. Only bad words are about lack of LO support. -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk 2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@webline.dk
Thus spake Bruce Momjian > > > Thought some people might find this article interesting. > > > http://www.zend.com/zend/art/databases.php > > > > The only interesting thing I noticed is how fast it crashes my > > Netscape-4.76 browser ;) > > Yours too? I turned off Java/Javascript to get it to load and I am on > BSD/OS. Strange it so univerally crashes. Interesting. I run Opera and I generally find it fails on pages that no one else has problems with but it didn't have any problem with this one. -- D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
On Fri, 1 Jun 2001, Bruce Momjian wrote: > > > Thought some people might find this article interesting. > > > http://www.zend.com/zend/art/databases.php > > > > The only interesting thing I noticed is how fast it crashes my > > Netscape-4.76 browser ;) > > Yours too? I turned off Java/Javascript to get it to load and I am on > BSD/OS. Strange it so univerally crashes. Really odd. I have Java/Javascript with FreeBSD and Netscape 4.76 and read it just fine. One difference tho probably, I keep style sheets shut off. Netscape crashes about 1% as often as it used to. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
> > Yours too? I turned off Java/Javascript to get it to load and I am on > > BSD/OS. Strange it so univerally crashes. > > Really odd. I have Java/Javascript with FreeBSD and Netscape 4.76 and > read it just fine. One difference tho probably, I keep style sheets > shut off. Netscape crashes about 1% as often as it used to. I can confirm turning off stylesheets fixed the crash on my system too. Vince, what disadvantages are there to keep stylesheets off? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
On Sat, 2 Jun 2001, Bruce Momjian wrote: > > > Yours too? I turned off Java/Javascript to get it to load and I am on > > > BSD/OS. Strange it so univerally crashes. > > > > Really odd. I have Java/Javascript with FreeBSD and Netscape 4.76 and > > read it just fine. One difference tho probably, I keep style sheets > > shut off. Netscape crashes about 1% as often as it used to. > > I can confirm turning off stylesheets fixed the crash on my system too. > Vince, what disadvantages are there to keep stylesheets off? Text placement and colors on some sites gets a bit out of whack. Datek's website has text on top of other text, but still works. I trashed the style sheets on the PostgreSQL website long ago and never used them on other sites I write. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo atPop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
On Sat, Jun 02, 2001 at 10:59:20AM -0400, Vince Vielhaber wrote: > On Fri, 1 Jun 2001, Bruce Momjian wrote: > > > > > Thought some people might find this article interesting. > > > > http://www.zend.com/zend/art/databases.php > > > > > > The only interesting thing I noticed is how fast it crashes my > > > Netscape-4.76 browser ;) > > > > Yours too? I turned off Java/Javascript to get it to load and I am on > > BSD/OS. Strange it so univerally crashes. > > Really odd. I have Java/Javascript with FreeBSD and Netscape 4.76 and > read it just fine. One difference tho probably, I keep style sheets > shut off. Netscape crashes about 1% as often as it used to. This is getting off-topic, but ... I keep CSS, Javascript, Java, dynamic fonts, and images turned off, and Netscape 4.77 stays up for many weeks at a time. I also have no Flash plugin. All together it makes for a far more pleasant web experience. I didn't notice any problem with the Zend page. Nathan Myers ncm@zembu.com
> This is getting off-topic, but ... > > I keep CSS, Javascript, Java, dynamic fonts, and images turned off, and > Netscape 4.77 stays up for many weeks at a time. I also have no Flash > plugin. All together it makes for a far more pleasant web experience. > > I didn't notice any problem with the Zend page. You are running no images! You may as well have Netscape minimized and say it is running for weeks. :-) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
On Mon, Jun 04, 2001 at 04:55:13PM -0400, Bruce Momjian wrote: > > This is getting off-topic, but ... > > > > I keep CSS, Javascript, Java, dynamic fonts, and images turned off, and > > Netscape 4.77 stays up for many weeks at a time. I also have no Flash > > plugin. All together it makes for a far more pleasant web experience. > > > > I didn't notice any problem with the Zend page. > > You are running no images! You may as well have Netscape minimized and > say it is running for weeks. :-) Over 98% of the images on the web are either pr0n or wankage. If you don't need to see that, you can save a lot of time. But it's usually Javascript that crashes Netscape. (CSS appears to be implemented using Javascript, because if you turn off Javascript, then CSS stops working (and crashing).) That's not to say that Java doesn't also crash Netscape; it's just that pages with Java in them are not very common. There's little point in bookmarking a site that depends on client-side Javascript or Java, because it won't be up for very long. But this is *really* off topic, now. Nathan Myers ncm@zembu.com