bug in pg_dump with GRANT/REVOKE

Started by Robert Forsmanover 24 years ago13 messages
#1Robert Forsman
thoth@purplefrog.com

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.

#2Matthew T. O'Connor
matthew@zeut.net
In reply to: Robert Forsman (#1)
Interesting Atricle

Off Topic post:

Thought some people might find this article interesting.

http://www.zend.com/zend/art/databases.php

#3Ryan Mahoney
ryan@paymentalliance.net
In reply to: Matthew T. O'Connor (#2)
Re: Re: Interesting Atricle

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.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

#4Thomas Lockhart
lockhart@alumni.caltech.edu
In reply to: Robert Forsman (#1)
Re: Interesting Atricle

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

#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Thomas Lockhart (#4)
Re: Re: Interesting Atricle

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
#6Kaare Rasmussen
kar@webline.dk
In reply to: Thomas Lockhart (#4)
Re: Re: Interesting Atricle

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

#7Noname
darcy@druid.net
In reply to: Bruce Momjian (#5)
Re: Re: Interesting Atricle

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.
#8Vince Vielhaber
vev@michvhf.com
In reply to: Bruce Momjian (#5)
Re: Re: Interesting Atricle

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 at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

#9Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Vince Vielhaber (#8)
Re: Re: Interesting Atricle

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
#10Vince Vielhaber
vev@michvhf.com
In reply to: Bruce Momjian (#9)
Re: Re: Interesting Atricle

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
==========================================================================

#11Noname
ncm@zembu.com
In reply to: Vince Vielhaber (#8)
Re: Re: Interesting Atricle

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

#12Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Noname (#11)
Re: Re: Interesting Atricle

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
#13Noname
ncm@zembu.com
In reply to: Bruce Momjian (#12)
Re: Re: Interesting Atricle

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