[HACKERS] FreeBSD core team history

2000-10-12 Thread Bruce Momjian
There is an interesting article about the FreeBSD core team setup: http://www.daemonnews.org/200010/dadvocate.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blyth

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Alex Pilosov
On 13 Oct 2000, Gunnar R|nning wrote: > "Adam Lang" <[EMAIL PROTECTED]> writes: > > > May bad... sometimes it is too easy assuming everything open source is GPL. > > > > > > > correct?, so it can't really be proprietised unless they make an add-on > > Of course both lincenses can be the basis

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Gunnar R|nning
"Adam Lang" <[EMAIL PROTECTED]> writes: > May bad... sometimes it is too easy assuming everything open source is GPL. > > > > correct?, so it can't really be proprietised unless they make an add-on Of course both lincenses can be the basis of propriatery efforts(GPL and Apache(BSD style licens

[GENERAL] config

2000-10-12 Thread Michael Engelhart
Hi, I just got the Mac OS X public beta running on my home computer and want to compile postgresql for it but don't know where to start. I have installed Postgresql on linux boxes but they always just work because there are configs for them. Since v7.0.2 doesn't know about Mac OS X I'm assu

Re: [GENERAL] How does TOAST compare to other databases' mechanisms?

2000-10-12 Thread Philip Warner
At 10:12 9/10/00 -0400, Tom Lane wrote: > >There is a provision to discourage the toaster from even trying to >compress a particular column --- see the attstorage column in >pg_attribute. At the moment there's no user interface for that :-( >so you'd have to reach in with a manual "UPDATE pg_attr

[GENERAL] Binary Cursors

2000-10-12 Thread Kevin O'Gorman
You may say I'm ambitious, you may say I'm even foolish, but I'm going to do some database research work using PostgreSQL. And I've never used it before. Since I'm going to be working on optimization ideas, I'll have to get into the guts pretty quickly. For starters, though, I want to read the

Re: [GENERAL] ODMG

2000-10-12 Thread The Hermit Hacker
On Thu, 12 Oct 2000, Aristide Aragon wrote: > I was wondering... > Are there any plans to include ODMG support for psotgresql? ... > Or does anybody know of an open source ODMG DBMS? > It'd be cool if besides being object-relational, postgresql were > object oriented too! >From my understanding,

[GENERAL] ODMG

2000-10-12 Thread Aristide Aragon
I was wondering... Are there any plans to include ODMG support for psotgresql? ... Or does anybody know of an open source ODMG DBMS? It'd be cool if besides being object-relational, postgresql were object oriented too! Aristide

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Peter Mount
On Thu, 12 Oct 2000, Bruce Momjian wrote: > > Could you please put the ISBN on the web page: > > http://www.postgresql.org/docs/awbook.html > > I know I can get it from Amazon or whatever, but it would save people the > > extra trip. > > Done. > > ISBN 0-201-70331-9 > > > > > Anyway,

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread The Hermit Hacker
On Thu, 12 Oct 2000, Adam Lang wrote: > May bad... sometimes it is too easy assuming everything open source is GPL. what a narrow view on open source ... most core internet open source software is *not* GPL ... sendmail, INN, bind, isc-dhcp, apache, X11Rn, etc ... > > Adam Lang > Systems Engi

[GENERAL] Re: postgresql 7.1

2000-10-12 Thread Daniel Freedman
Regarding documentation updates... Patch updates might work for a "small" quantity of documentation ("small" in this context, meaning on order of Postgresql documentation), but I just wanted to relate my experience on large documentation sources with these types of patches (sort of funny in a sa

RE: [GENERAL] INSTR() like function?

2000-10-12 Thread Michael Loftis
Thanks much! I never even realised pg had regex built in. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 2:50 PM To: Michael Loftis Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] INSTR() like function? "Michael Loftis" <[EMAIL PROTECTED]> w

Re: [GENERAL] GUIs, OSes and related

2000-10-12 Thread Tom Lane
Michelle Murrain <[EMAIL PROTECTED]> writes: > ... And is anyone interested in a Mac port of postgres? > (MacOS X might make it real easy.) PPC Linux makes it real easy already ;-) regards, tom lane

[GENERAL] GUIs, OSes and related

2000-10-12 Thread Michelle Murrain
Hi folks, Another big question, although not so theoretical as the last one: We've been designing databases for a while now, both web based and not. I'm interested in thinking about using postgres to develop non-web based databases (ala access and filemaker pro). These are the relevant questi

Re: [GENERAL] INSTR() like function?

2000-10-12 Thread Tom Lane
"Michael Loftis" <[EMAIL PROTECTED]> writes: > IE are the characters A or B or C or D in the string "dogma" would be > INSTR('ABCD','dogma'); See the regular-expression match operators (~ and ~*). The above would be select 'dogma'::text ~* '[ABCD]'::text; assuming you meant you wanted c

[GENERAL] Problem whith Stored queries

2000-10-12 Thread Nelson Brito
Hi I have a problem, I need execute a stored queries, that have parameters. ¿ How can I execute and give parameter to my query, from psql console ?

[GENERAL] INSTR() like function?

2000-10-12 Thread Michael Loftis
In mySQL there is an INSTR(arg1,arg2) function that takes and looks for any of the characters in arg1 and matches them against arg2 IE are the characters A or B or C or D in the string "dogma" would be INSTR('ABCD','dogma'); Anyone help me to produce this sort of logic in an PSQL select statemen

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > Hmmm... interesting concept... Warez for Books. :) Yes, I suppose I have arrived when my book appears on Gnutella or Napster. > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > - Original Message - > From: "Bruce M

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Adam Lang
Hmmm... interesting concept... Warez for Books. :) Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Louis Bertrand" <[EMAIL PROTECTED]> Cc: "Adam Lang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTEC

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Tim Uckun
At 04:58 PM 10/12/00 -0400, Louis Bertrand wrote: >Thanks. It helped cheer me up: I'm fighting with MS-Access at the >moment (and losing badly). Error Number 3135 There is no message for this error. :wq Tim Uckun Due Diligence Inc. http://www.diligence.com/ Americas Background Investigation

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Bruce Momjian
> Thanks. It helped cheer me up: I'm fighting with MS-Access at the > moment (and losing badly). I hear you. PostgreSQL has been a very good thing for me, the past few years. In many ways, it is the _fun_ part of computers. -- Bruce Momjian| http://candle.pha.pa.us

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Louis Bertrand
Thanks. It helped cheer me up: I'm fighting with MS-Access at the moment (and losing badly). Ciao --Louis <[EMAIL PROTECTED]> Louis Bertrand http://www.bertrandtech.on.ca/ Bertrand Technical Services, Bowmanville, ON, Canada Tel: +1.905.623.1500 Fax: +1.905.623.3852 OpenBSD: Secure

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Bruce Momjian
> Could you please put the ISBN on the web page: > http://www.postgresql.org/docs/awbook.html > I know I can get it from Amazon or whatever, but it would save people the > extra trip. > > Anyway, I'm placing the order today with my local bookmonger. The PDF > printed pages just don't cut it.

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Bruce Momjian
> Could you please put the ISBN on the web page: > http://www.postgresql.org/docs/awbook.html > I know I can get it from Amazon or whatever, but it would save people the > extra trip. Done. ISBN 0-201-70331-9 > > Anyway, I'm placing the order today with my local bookmonger. The PDF

Re: [GENERAL] Error creating tables.

2000-10-12 Thread Tom Lane
Aristide Aragon <[EMAIL PROTECTED]> writes: > create table test4 (name varchar(10)) ; > returns > ERROR: cannot create test4 That looks like the physical creation of the table data file for 'test4' is failing. Unfortunately older releases of postgres are not very good about reporting the kernel

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Louis Bertrand
Could you please put the ISBN on the web page: http://www.postgresql.org/docs/awbook.html I know I can get it from Amazon or whatever, but it would save people the extra trip. Anyway, I'm placing the order today with my local bookmonger. The PDF printed pages just don't cut it. Thanks! --Lou

Re: [GENERAL] postgresql 7.1

2000-10-12 Thread Adam Lang
That's sort of my point. A lot of people don't seem to take in account that, like accountants and lawyers, etc., a certain amount of due care is required and with all the stuff out there, it is hard to keep track of version releases and new functionality. At least what Bruce is planning on doing

RE: [GENERAL] postgresql 7.1

2000-10-12 Thread Robert D. Nelson
>For prohjects such as this that have commercial documentation, why don't >they have "patches" for printed books also? ... >It would be an interesting documentation project that would really keep >information organized and relatively accessible ('cause sometimes digging >through webpages and email

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > Yeah, but I can't sit and read stuff like that on a screen... Granted I can > print it and get a binder, etc... but stuff like that really is easier in > publication and as long as the price isn't gouged and the book is good, I > don't mind forki

Re: [GENERAL] Re: PostgreSQL book

2000-10-12 Thread Adam Lang
Yeah, but I can't sit and read stuff like that on a screen... Granted I can print it and get a binder, etc... but stuff like that really is easier in publication and as long as the price isn't gouged and the book is good, I don't mind forking out cash for it. Adam Lang Systems Engineer Rutgers Ca

Re: [GENERAL] Error creating tables.

2000-10-12 Thread Jean-Christophe Boggio
Salut Aristide, Le Thursday, October 12, 2000 à 7:23:18 PM, tu me disais: AA> create table test (id serial, name varchar(10) ) ; AA> returns: AA> NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for SERIAL column 'test.id' AA> NOTICE: CREATE TABLE/UNIQUE will create implicit i

[GENERAL] Re: [HACKERS] postgresql 7.1

2000-10-12 Thread Peter Eisentraut
Martin A. Marques writes: > How far are we from seeing the version 7.1 out? Beta is supposed to be November 1st. Personally, I'm putting my chips on a February 1st release. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [GENERAL] Re: R: PostgreSQL book

2000-10-12 Thread bmccoy
On Thu, 12 Oct 2000, Travis Bauer wrote: > I'll second Bookpool for computer books. I've used them a couple of times > and they are good. I'm a big fan of readme.doc -- especially because they have a store only minutes from my house! Brett W. McCoy

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Adam Lang
May bad... sometimes it is too easy assuming everything open source is GPL. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Lamar Owen" <[EMAIL PROTECTED]> To: "Adam Lang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 12, 200

RE: [GENERAL] Index on substring?

2000-10-12 Thread Jeff Eckermann
Tom, Thanks very much for your full and clear answer. It's hard to imagine a general use for this facility, anyway. For me this is a one-off exercise, albeit a big one. Regards > -Original Message- > From: Tom Lane [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 12, 2000 12:49 AM > T

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Lamar Owen
Adam Lang wrote: > (Actually, under GPL, any modifications of the code have to be free also, > correct?, so it can't really be proprietised unless they make an add-on that > is private... but then postgres can be run and compiled without it). PostgreSQL is not under the GPL. PostgreSQL has (and

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Adam Lang
Correct...I'm not saying corporate is going to try to proprietize (or however you spell it :)) it. That I will say I don't think can happen... (Actually, under GPL, any modifications of the code have to be free also, correct?, so it can't really be proprietised unless they make an add-on that is

Re: [GENERAL] postgresql 7.1

2000-10-12 Thread Efrain Caro
So a new version will be out soon. How often Bruce's book will be revised? With each new version? - Original Message - From: "Tim Uckun" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 12, 2000 5:43 AM Subject: Re: [GENERAL] postgresql 7.1 > At 01:37 AM 10/12/2000 -0

Re: [GENERAL] Re: R: PostgreSQL book

2000-10-12 Thread Efrain Caro
I searched bookpool for pgsql and found nothing. It's not available for preordering and there are no pgsql book at all. At least, I searched for "postgresql"; the system returned "No Books Found". - Original Message - From: "Travis Bauer" <[EMAIL PROTECTED]> To: "Daniel Freedman" <[EMAIL

Re: [GENERAL] Re: R: PostgreSQL book

2000-10-12 Thread Travis Bauer
I'll second Bookpool for computer books. I've used them a couple of times and they are good. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Wed,

Re: [GENERAL] postgresql 7.1

2000-10-12 Thread Tim Uckun
At 01:37 AM 10/12/2000 -0400, Tom Lane wrote: >Tim Uckun <[EMAIL PROTECTED]> writes: > > What happened to outer joins? Don't you need outer joins to compete with > > the big boys? > >They're done too ;-) Wooo Hooo time to break out the champagne! --

RE: R: [GENERAL] PostgreSQL book

2000-10-12 Thread Peter Mount
On Wed, 11 Oct 2000, Robert D. Nelson wrote: > >> Heaven help you if you order it from Amazon with a real email address. > >> > >> After about a year and a half of trying to get them to stop spamming > >me, I > >> simply gave up and dropped the email account. > > > >I've always used a disposa

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Tom Lane
"Matthew N. Dodd" <[EMAIL PROTECTED]> writes: > The one place where GB can get burned is if they spend lots of time/money > implementing a feature and then attempt to recoup their investment by > holding said feature back from the PGSQL source tree. I can say with a good deal of confidence that t