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.
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:
Show quoted text
Thought some people might find this article interesting.
http://www.zend.com/zend/art/databases.phpThe 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
Import Notes
Reply to msg id not found: 200106020118.f521ISk14086@candle.pha.pa.usReference msg id not found: 3B182839.4CD11E7C@alumni.caltech.edu | Resolved by subject fallback
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.phpThe 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
Thought some people might find this article interesting.
http://www.zend.com/zend/art/databases.phpThe 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.phpThe 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.phpThe 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 at Pop4 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, Pennsylvania 19026
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 at Pop4 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.phpThe 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, Pennsylvania 19026
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