
  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.

Fri, 01 Jun 2001 13:06:27 -0400
Robert Forsman <thoth@purplefrog.com>
bug in pg_dump with GRANT/REVOKE
Off Topic post:

Thought some people might find this article interesting.

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




Fri, 1 Jun 2001 12:32:46 -0500
"Matthew T. O'Connor" <matthew@zeut.net>
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:

> > > 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
Fri, 01 Jun 2001 22:08:07 +0100
Ryan Mahoney <ryan@paymentalliance.net>
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 ;)

                         - Thomas

Fri, 01 Jun 2001 23:41:45 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
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

Fri, 1 Jun 2001 21:18:28 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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

Sat, 2 Jun 2001 09:45:44 +0200
Kaare Rasmussen <kar@webline.dk>
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.

Sat, 2 Jun 2001 06:16:46 -0400 (EDT)
darcy@druid.net (D'Arcy J.M. Cain)
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
==========================================================================




Sat, 2 Jun 2001 10:59:20 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
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

Sat, 2 Jun 2001 12:35:42 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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
==========================================================================




Sat, 2 Jun 2001 12:56:57 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
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

Mon, 4 Jun 2001 12:13:49 -0700
ncm@zembu.com (Nathan Myers)
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

Mon, 4 Jun 2001 16:55:13 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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

Mon, 4 Jun 2001 14:58:04 -0700
ncm@zembu.com (Nathan Myers)
Re: Re: Interesting Atricle