Re: [ADMIN] pg_restore and transaction id wraparound

2003-11-29 Thread ow
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Actually you can only have 4 billion SQL commands per xid, because the > CommandId datatype is also just 32 bits. I've never heard of anyone > running into that limit, though. > Perhaps noone yet had a table with 4B records in pgSql. Otherwise, how woul

Re: [ADMIN] pg_restore and transaction id wraparound

2003-11-29 Thread Tom Lane
Christopher Browne <[EMAIL PROTECTED]> writes: > - If you type in BEGIN;, then you could have 10 billion SQL > statements after that, and they would, altogether, consume 1 xid. Actually you can only have 4 billion SQL commands per xid, because the CommandId datatype is also just 32 bits. I've

Re: [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Bruce Momjian
Christopher Browne wrote: > In the last exciting episode, [EMAIL PROTECTED] (Bruce Momjian) wrote: > > I would hate to be the only license that OpenBSD doesn't like. :-) > > I think you haven't conversed with Theo enough [shudder...] > > You wouln't want him to prefer the GPL, would you :-). Wh

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Richard Welty
On Fri, 28 Nov 2003 17:58:19 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > OK, where did you get this wording? Is this something Berkeley released > as one of their versions of the BSD license. yes, i believe that it originally came from the Berkeley lawyers. richard -- Richard Welty

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Richard Welty
On Sat, 29 Nov 2003 09:01:39 +1100 Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > Correct me if I'm wrong, but wouldn't that also require permission from > every other contributer to PostgreSQL ever? I mean, hypothetically there > might be someone in there who disagrees with the change. i don

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Richard Welty
On Fri, 28 Nov 2003 17:23:56 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > Richard Welty wrote: > > but you can consult with the attorneys for the Regents. they have > > changed the license at times, and have passed those changes on > > to other BSD licensed projects (e.g., when they remo

Re: [ADMIN] pg_restore and transaction id wraparound

2003-11-29 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (ow): > Hypothetical situation: a table containing, say, 10 billion rows is backed up > and then restored with pg_restore. Would this lead to the transaction id > wraparound issue since 10B rows are imported in one "batch"? No. Copying the 10 billion rows in only consumes

Re: [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] (Bruce Momjian) wrote: > I would hate to be the only license that OpenBSD doesn't like. :-) I think you haven't conversed with Theo enough [shudder...] You wouln't want him to prefer the GPL, would you :-). -- let name="cbbrowne" and tld="cbbrowne

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Richard Welty
On Fri, 28 Nov 2003 13:50:23 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Breen Ouellette <[EMAIL PROTECTED]> writes: > > The result of this ambiguity is that the > > latest CD release of OpenBSD (3.4) no longer includes Postgresql > We are not changing the license text we inherited from Berkeley.

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-29 Thread Martijn van Oosterhout
On Fri, Nov 28, 2003 at 04:50:40PM -0500, Richard Welty wrote: > On Fri, 28 Nov 2003 13:50:23 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > > Breen Ouellette <[EMAIL PROTECTED]> writes: > > > The result of this ambiguity is that the > > > latest CD release of OpenBSD (3.4) no longer includes Postgres

Re: [ADMIN] Why both?: /var/log/messages AND /var/log/pgsql.

2003-11-29 Thread Oliver Elphick
On Sat, 2003-11-29 at 13:32, ow wrote: > --- ow <[EMAIL PROTECTED]> wrote: > > pgSql 7.4.0 on RH7.3 > > > > Hi, > > > > It appears that pgSql somehow logs messages to BOTH /var/log/messages and > > /var/log/pgsql. I expected that it would only log to /var/log/pgsql. > > > > It appears I forgot

Re: [ADMIN] Installing pgtclsh

2003-11-29 Thread Oliver Elphick
On Tue, 2003-11-25 at 14:05, Nigel Bishop wrote: > I installed PG Ver 7.3.2 on Solaris 8 several months ago and this has > been running fine. One of the developers has now asked that the > pgtclsh interface be installed. Does this mean that I have to do a > ./configure --with-tcl, then make, then

Re: [ADMIN] Why both?: /var/log/messages AND /var/log/pgsql.

2003-11-29 Thread ow
--- ow <[EMAIL PROTECTED]> wrote: > pgSql 7.4.0 on RH7.3 > > Hi, > > It appears that pgSql somehow logs messages to BOTH /var/log/messages and > /var/log/pgsql. I expected that it would only log to /var/log/pgsql. > It appears I forgot to add local0.none on the /var/log/messages line in /etc/s

Re: [ADMIN] pg_lo_import alternative ...

2003-11-29 Thread Kent L. Nasveschuk
Your method sounds very interesting for storing images. I'd be interested in knowing what other attributes you store with the images. My interest in storing images is for documents that pertain to personnel records such as copy of certifications, licenses, diploma, training courses, personnel evalu

[ADMIN] Why both?: /var/log/messages AND /var/log/pgsql.

2003-11-29 Thread ow
pgSql 7.4.0 on RH7.3 Hi, It appears that pgSql somehow logs messages to BOTH /var/log/messages and /var/log/pgsql. I expected that it would only log to /var/log/pgsql. Any ideas? Thanks - /etc/syslog.conf # Save postgresql logs loc