Re: [DOCS] Htmlhelp virtually impossible to build?

2005-10-05 Thread Peter Eisentraut
Dave Page wrote:
> Unfortunately this generally seems to fail on the xsltproc step when
> it comes to building the toc etc

I just ran make htmlhelp on current CVS and it completed successfully in 
8 1/2 minutes.  I suggest you complain about the crashes to your OS 
provider.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [DOCS] Htmlhelp virtually impossible to build?

2005-10-05 Thread Peter Eisentraut
Dave Page wrote:
> > I just ran make htmlhelp on current CVS and it completed
> > successfully in
> > 8 1/2 minutes.  I suggest you complain about the crashes to your OS
> > provider.
>
> What OS were you on?

Debian "testing", i386, xsltproc 1.1.15

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[DOCS] XML and PostGreSql

2005-10-05 Thread heramb lele
Hello,
I have 2 questions . Please reply me 
 
1. To what extend PostGreSql provides object oriented features
2. Is it possible to import the XML DTD in postgre and export into the DTD
 
Thank you,
Heramb
		Yahoo! for Good 
Click here to donate to the Hurricane Katrina relief effort. 


Re: [DOCS] Updated documentation for new sequence binding

2005-10-05 Thread Jim C. Nasby
On Sun, Oct 02, 2005 at 10:54:10PM -0400, Bruce Momjian wrote:
> pgman wrote:
> > I have marged Tom's description of the new sequence binding with text I
> > was working on.  I modified it to follow the existing "we used to do X,
> > now we do Y" pattern in the surrounding entries:
> > 
> > http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
> 
> Sorry, this is a better URL:
> 
>   
> http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1

Out of curiosity, how is this file maintained as development is done?
The reason I'm asking is because it would be nice to have links to more
information, especially for the 'one-liner' items in 1.3.1 for example,
and it seems like that would be easier to do along-the-way rather than
waiting for the end. Even a link to a mailing list discussion would be
better than nothing...

That said, what's

 Improve the optimizer, including auto-resizing of hash joins (Tom)

mean?

On full_page_writes, are we certain that all battery-backed disk caches
ensure that partial-page writes can't happen?

Maybe pg_column_size should just be included in the item for all the
other size functions brought into the backend? If not, ISTM they should
at least be one after the other in the list...

Finally, weren't more changes made it contrib than what's listed?
Nothing's said about pg_autovacuum for example.
-- 
Jim C. Nasby, Sr. Engineering Consultant  [EMAIL PROTECTED]
Pervasive Software  http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf   cell: 512-569-9461

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [DOCS] XML and PostGreSql

2005-10-05 Thread Jim C. Nasby
On Wed, Oct 05, 2005 at 06:27:23AM -0700, heramb lele wrote:
> Hello,
> I have 2 questions . Please reply me 
>  
> 1. To what extend PostGreSql provides object oriented features
> 2. Is it possible to import the XML DTD in postgre and export into the DTD

Please re-post on [EMAIL PROTECTED] You might want to take a
look at the docs first
(http://www.postgresql.org/docs/8.0/static/index.html).
-- 
Jim C. Nasby, Sr. Engineering Consultant  [EMAIL PROTECTED]
Pervasive Software  http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf   cell: 512-569-9461

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [DOCS] Updated documentation for new sequence binding

2005-10-05 Thread Bruce Momjian
Jim C. Nasby wrote:
> On Sun, Oct 02, 2005 at 10:54:10PM -0400, Bruce Momjian wrote:
> > pgman wrote:
> > > I have marged Tom's description of the new sequence binding with text I
> > > was working on.  I modified it to follow the existing "we used to do X,
> > > now we do Y" pattern in the surrounding entries:
> > > 
> > >   http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1
> > 
> > Sorry, this is a better URL:
> > 
> > 
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1
> 
> Out of curiosity, how is this file maintained as development is done?
> The reason I'm asking is because it would be nice to have links to more
> information, especially for the 'one-liner' items in 1.3.1 for example,
> and it seems like that would be easier to do along-the-way rather than
> waiting for the end. Even a link to a mailing list discussion would be
> better than nothing...

I go through the CVS commits and make the release notes just before
beta.  During it incrementally is much more work.

> That said, what's
> 
>  Improve the optimizer, including auto-resizing of hash joins (Tom)
> 
> mean?

We would sometimes fail in a query where the allocated memory was larger
than our hash could hold.  This fixed that.

> 
> On full_page_writes, are we certain that all battery-backed disk caches
> ensure that partial-page writes can't happen?

Well, I would think so, but I have no documentation to state that.  The
battery-backed memory is supposed to allow for power failure and keep
writes in the cache until they hit the disk.

> Maybe pg_column_siz should just be included in the item for all the
> other size functions brought into the backend? If not, ISTM they should
> at least be one after the other in the list...

Not really.  It is different in that is does not aggregate values, but
just the storage of a column.

> Finally, weren't more changes made it contrib than what's listed?
> Nothing's said about pg_autovacuum for example.

Moved to the main server.  That is mentioned.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [email protected]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[DOCS] Online comments system

2005-10-05 Thread Philip Rodrigues
Hi,
I'm part of the KDE documentation team, and we've recently discussed ways of 
allowing users to more easily contribute to the KDE documentation. We're 
interested in the comment system that you use on the PGSQL website, since it 
provides a way for users to add to the documentation, with the potential to 
merge the additions into the official doc later.

I'd be grateful if you could tell me your experiences with the comment system: 
Do users contribute? Are the contributions useful? Is the system easy to 
administer?

Also, is there some information online about the technical side of the system? 
Is the source code available?

Thanks in advance,
Philip

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [DOCS] Online comments system

2005-10-05 Thread Robert Treat
On Wednesday 05 October 2005 16:47, Philip Rodrigues wrote:
> I'd be grateful if you could tell me your experiences with the comment
> system: Do users contribute? 

yes. spammers contribute more though :-)

> Are the contributions useful? 

some of them certainly are. i noticed someone just submitted several example 
functions into the online docs, those are certainly useful for others and 
probably would be good to incorporate into the docs.

You will have to deal with spam though. At first it wasnt a problem. Then we 
had to set up keyword blockers (mortgage,poker,etc...) soon we will be 
integrating one of those "type in this image" systems... spam sucks. 

> Is the system  
> easy to administer?
>

Yeah. We have a web interface to approve comments and also a mailing list with 
links to administer comments. 

> Also, is there some information online about the technical side of the
> system? Is the source code available?
>

The source code is available from our project page:
http://gborg.postgresql.org/project/pgweb/projdisplay.php
look under the portal module. 

please direct any follow up questions to pgsql-www.  Thats where all of the 
web stuff is actually worked on, so the folks who know the system all hang 
out there. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [DOCS] Online comments system

2005-10-05 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes:
> On Wednesday 05 October 2005 16:47, Philip Rodrigues wrote:
>> Are the contributions useful? 

> some of them certainly are. i noticed someone just submitted several example 
> functions into the online docs, those are certainly useful for others and 
> probably would be good to incorporate into the docs.

We usually try during each release cycle to make a pass through the
interactive comments of the previous release's docs and incorporate the
useful stuff.  Of course "usefulness" depends largely on the opinions of
whoever's making that scan.

(Memo to self: it's getting to be time for that again.)

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq