Hi Postgresql Colleagues,
I have been a user of Postgresql for a long time and seldom post here, but
after reading the recent fray over license changes, I feel compelled to
post this.
Just to add my miniscule .02 to this discussion As a contributor to
open source (and also a commercial devel
"Robert B. Easter" wrote:
>
> I'd like to know what hardware and software people use to perform tape backup
> of an online database on Linux. I would imagine the following might work(?):
>
> 1. Use RAID mirroring of the disk the db is on onto 2 two or more other
> disks.
> 2. When it
On Tue, 4 Jul 2000 [EMAIL PROTECTED] wrote:
> "Randall Parker" <[EMAIL PROTECTED]> writes:
>
> > The title says it all: Is this a foolhardy or prudent and wise move
> > at this time?
> >
> > Has anyone run Postgres databases on ReiserFS volumes under heavy
> > enough load and for long enough to
[EMAIL PROTECTED] (Jan Wieck) writes:
> Trond Eivind=?iso-8859-1?q?_Glomsr=F8d?= wrote:
> > [EMAIL PROTECTED] (Jan Wieck) writes:
> >
> > > Trond Eivind Glomsrød wrote:
> > > > [EMAIL PROTECTED] (Jan Wieck) writes:
> > > >
> > > > > Trond Eivind Glomsrød wrote:
> > > > > > Mike Mascari <[EMAIL PR
Trond Eivind=?iso-8859-1?q?_Glomsr=F8d?= wrote:
> [EMAIL PROTECTED] (Jan Wieck) writes:
>
> > Trond Eivind Glomsrød wrote:
> > > [EMAIL PROTECTED] (Jan Wieck) writes:
> > >
> > > > Trond Eivind Glomsrød wrote:
> > > > > Mike Mascari <[EMAIL PROTECTED]> writes:
> > > > >
> > > > > > This is not som
[EMAIL PROTECTED] (Jan Wieck) writes:
> Trond Eivind Glomsrød wrote:
> > [EMAIL PROTECTED] (Jan Wieck) writes:
> >
> > > Trond Eivind Glomsrød wrote:
> > > > Mike Mascari <[EMAIL PROTECTED]> writes:
> > > >
> > > > > This is not something new. SunOS, AIX, HPUX, etc. all have (at
> > > > > one tim
[EMAIL PROTECTED] (Jan Wieck) writes:
> One thing to keep in mind is that the LZ algorithm you're
> thinking of must be distributable under the terms of the BSD
> license. If it's copyrighted or patented by any third party,
> not agreeing to these terms, it's out of discussio
Jeffery Collins wrote:
> I have been looking at using the lztext type and I have some
> questions/observations. Most of my experience comes from attempting to
> compress text records in a different database (CTREE), but I think the
> experience is transferable.
First of all I welcome
Trond Eivind=?iso-8859-1?q?_Glomsr=F8d?= wrote:
> [EMAIL PROTECTED] (Jan Wieck) writes:
>
> > Trond Eivind=?iso-8859-1?q?_Glomsr=F8d?= wrote:
> > > Mike Mascari <[EMAIL PROTECTED]> writes:
> > >
> > > > This is not something new. SunOS, AIX, HPUX, etc. all have (at
> > > > one time or another) con
Ron Peterson wrote:
> your software to make any concessions?". Of course you do. The
> question is just what concessions do you require before granting use of
> your product. Any statement to the effect that BSD is "really free" is
> just navel gazing mumbo jumbo.
Good points - alot of. J
Steven Saner <[EMAIL PROTECTED]> writes:
> I will probably restart the postmaster tonight and make sure that
> logging is being done. Then if it happens again we might have more to
> go on.
If you're going to do that, please install 7.0.2 first, else the log
likely won't tell us much anyway ...
Ron, probably the best example to reassure you here is Illustra/Informix,
which is based on the old Berkeley Postgres code. A group of people at
Berkeley "forked" the Postgres code into the closed Illustra system, but it
survived as Postgres95, then later PostgreSQL when Marc and Bruce got
starte
I'd like to know what hardware and software people use to perform tape backup
of an online database on Linux. I would imagine the following might work(?):
1. Use RAID mirroring of the disk the db is on onto 2 two or more other
disks.
2. When it is time to do the backup, disconnect one
On Wed, Jul 05, 2000 at 04:29:16PM -0400, Tom Lane wrote:
> Steven Saner <[EMAIL PROTECTED]> writes:
> > Using Postgres 7.0 on BSDI 4.1
> > For the last several days we are getting errors that look like this:
>
> > Error: cannot write block 0 of krftmp4 [adm] blind.
>
> > An interesting thing is
Mike Mascari wrote:
>
> Why do you continue to insist that GPL is superior to BSD? GPL is
> BSD *with restrictions*. If someone comes along and sweeps up the
> major developers:
>
> A) Good for the major developers - they deserve to have large
> sums of cash thrown their way, particularly for ma
Any tips on how to efficiently score fields with altavista-like query
strings?
I currently use the following PL/Perl function, which unfortunatly is
rather slow, even though I have already simplified it quite a bit...
# Example: SELECT id, score(description, 'a?pha -"beta gamma"') FROM
table;
C
"Philip Poles" <[EMAIL PROTECTED]> writes:
> I'm not sure if this is relevant, but I've seen similar errors occur
> when there are too many open files on the filesystem (running Linux RH
> 6.2). I'm not sure if this problem is in the backend or the Linux
> kernal, or somewhere else, not being ver
Greetings...
I'm not sure if this is relevant, but I've seen similar errors occur when there
are too many open files on the filesystem (running Linux RH 6.2). I'm not sure
if this problem is in the backend or the Linux kernal, or somewhere else, not
being very conversant in such matters myself,
Mitch Vincent wrote:
> I was sitting here reading about TOAST and 7.1 and another question came
> into my mind.. I looked on the web page for some information about features
> to be added in 7.1 and an approximate 7.1 release date.. I found information
> on the TOAST feature as well as Referential
Greetings,
I'm investigating the use of PostgreSQL to maintain a database of
mapping data. My dataset currently stored latitudes and longitudes as
fixed-precision integers (ie, 37.234 is stored as 37234) in separate
columns: one for latitude, one for longitude.
Postgres has geometric data types
Steven Saner <[EMAIL PROTECTED]> writes:
> Using Postgres 7.0 on BSDI 4.1
> For the last several days we are getting errors that look like this:
> Error: cannot write block 0 of krftmp4 [adm] blind.
> An interesting thing is that in this example, krftmp4 is a table that
> the user that got this
if memory serves, after the insert do a:
SELECT @@IDENTITY
but why would you want to use m$ sql server?
it doesn't even run on linux... :-)
-tim.
-Original Message-
From: Mirko Geffken
To: PostgreSQL General
Sent: 7/5/00 3:34 PM
Subject: [GENERAL] SQL Server Question (Way OFF TOP
At 02:19 PM 7/5/00 -0500, [EMAIL PROTECTED] wrote:
>
>Jan Wieck wrote:
>
>> I'm in doubt why none of the other open source projects ever
>> felt the need to enforce license agreement in this way while
>> most commercial players do. Maybe it's something we don't
>> have to wor
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> I was sitting here reading about TOAST and 7.1 and another question came
> into my mind.. I looked on the web page for some information about features
> to be added in 7.1 and an approximate 7.1 release date.. I found information
> on the TOAST feature
Jan Wieck wrote:
> I'm in doubt why none of the other open source projects ever
> felt the need to enforce license agreement in this way while
> most commercial players do. Maybe it's something we don't
> have to worry about, but what if so? What if we all have
> a
hi, i have a question about pg_shadow and constraints on it.
someone left our employ and i did a dropuser on his id. later,
when i did a pg_dump none of the tables created by him were
dumped. i added him back thru createuser so that i could do a
valid pg_dump.
i tried to create a unique inde
Using Postgres 7.0 on BSDI 4.1
For the last several days we are getting errors that look like this:
Error: cannot write block 0 of krftmp4 [adm] blind.
An interesting thing is that in this example, krftmp4 is a table that
the user that got this error message would not have accessed in any
way.
Hi,
I know this is way off topic (with this being a PostgreSQL mailing list),
but I couldn't find one.
Does anyone know of a SQL Server mailing list.
In case anybody knows the answer here, here is my question:
I want to insert into a table with an identity field and get the identity
field's val
Simon Brooke wrote:
> Ned Lilly wrote:
> >
> > > Two states have adopted UCITA - Virginia and Maryland. Maryland has
> > > an October 1, 2000, effective date, but requires that its laws will
> > > only apply if there is a reasonable connection with the state.
> > > Virginia has an effective dat
is it possible to pull a column from a postgres table then have it linked
via html and php to the corresponding row. If so how would that be
accomplished?
* The Hermit Hacker <[EMAIL PROTECTED]> [000705 12:03] wrote:
>
> just to curtail this while thread to a certain point ... switching the
> license to GPL is *not* on the table, nor has it every been, nor will it
> ever be ...
Good to hear, I was getting worried for a bit that the code might
bec
just to curtail this while thread to a certain point ... switching the
license to GPL is *not* on the table, nor has it every been, nor will it
ever be ...
On Wed, 5 Jul 2000, Ron Peterson wrote:
> Ned,
>
> Thanks for inviting the community to participate in this discussion. I
> wonder, thou
Richard Rowell wrote:
>
> I'm creating a database with 20 tables or so. I have come to the
> table that will likely tie many of these tables together, that is
> every single field in this table will be a foriegn key. My question
> is, rather then include all of the fields into the primary key o
On Wed, 5 Jul 2000, The Hermit Hacker wrote:
> Personally, from all the 'legal' issues that FreeBSD has gone through over
> the years, especially recently with the BSDi/FreeBSD merger and the whole
> cryptology merger, I would think they would have been the first to
> adopt/change their BSD licen
Philip Warner wrote:
>
> At 02:36 5/07/00 +0200, Jan Wieck wrote:
> >
> >So the problem left are binary distributions.
> >
>
> There might be a technical solution here; I *think* RPM allows pretty
> flexible running of scripts. We could only make binary distributions for
> architectures that
On Wed, 5 Jul 2000, Gilles DAROLD wrote:
> Hi,
>
> I have some problem to understand why you have to change the PostgreSQL
> Licence
> agreement. You are really making confusion into my mind. For me I have this
> licence
> come with all my distributions :
>
> PostgreSQL Data Base Management
On Wed, 5 Jul 2000, Philip Warner wrote:
> At 00:24 5/07/00 -0400, Mike Mascari wrote:
> >>
> >> Am I correct in saying that you agree that the GPL is where we should be,
> >> but you want people to go there of their own free will?
> >
> >Why do you continue to insist that GPL is superior to BSD
Thus spake Jan Wieck
> Right. Someone who doesn't want to make his code "FREE" in
> the entire meaning of this word but want to make it open for
> any non-commercial use should choose it. IMHO the GPL
While I am a proponent of keeping the BSD style license, there is nothin
Mike Mascari wrote:
> Why do you continue to insist that GPL is superior to BSD? GPL is
> BSD *with restrictions*. If someone comes along and sweeps up the
> major developers:
>
> A) Good for the major developers - they deserve to have large
> sums of cash thrown their way, particularly for m
We're trying to use a unique-identifier scheme in a database; and
therefore we need to put a lock on a table.
Is there some way to do this using the PyGres (python) adapter?
-Morten
-
How to reply to email:
http://home.sol.no/~vidaan
Delete the , after KEY and give owner a datatype and everything works
fine. I have tested.
Jesus.
On Wed, 5 Jul 2000, planx plnetx wrote:
> > > CREATE TABLE workers(
> > > namevarchar(30),
> > > firstname varchar(30),
> > > id_personal decimal(10)NOT NULL UNIQUE PRIMARY KEY,
> >
Philip Warner wrote:
> I do still own copyright, but I can't prevent people using it in a
> PG-derived project. But I *can* prevent them using it in software to run a
> meat-grinder, assuming that software is not recognizably a PG derived
> database (as perceived by a reasonable person). This coul
Mike Mascari wrote:
> This is not something new. SunOS, AIX, HPUX, etc. all have (at
> one time or another) considerable BSD roots. And yet FreeBSD
> still exists... All GPL does is 'poison' the pot by prohibiting
> commercial spawns which may leverage the code. If someone makes
> some money selli
Philip Warner wrote:
>
> Am I correct in saying that you agree that the GPL is where we should be,
> but you want people to go there of their own free will?
Right. Someone who doesn't want to make his code "FREE" in
the entire meaning of this word but want to make it open for
any
>From: "Robert B. Easter" <[EMAIL PROTECTED]>
>To: "planx plnetx" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: Re: [GENERAL] REFERENCES troubles
>Date: Tue, 4 Jul 2000 18:38:28 -0400
>
>On Tue, 04 Jul 2000, planx plnetx wrote:
> > I get this error when creating a database:
> >
> > CREATE TA
>From: Bill Barnes <[EMAIL PROTECTED]>
>To: postgres general mail list <[EMAIL PROTECTED]>
>Subject: [GENERAL] Glade or wxPython and Postgresql
>Date: Mon, 3 Jul 2000 20:20:22 -0400
>
>Hello list:
>
>Has anybody on the list put one of these combinations together?
>
>Thanks,
>Bill Barnes
>
I am
>From: "Randall Parker" <[EMAIL PROTECTED]>
>Reply-To: "Randall Parker" <[EMAIL PROTECTED]>
>To: "PostgreSQL General" <[EMAIL PROTECTED]>
>Subject: [GENERAL] Anyone using ReiserFS in production work? (or advise
>against it?)
>Date: Tue, 04 Jul 2000 15:02:17 -0700
>
>The title says it all: Is t
Hi,
I have some problem to understand why you have to change the PostgreSQL
Licence
agreement. You are really making confusion into my mind. For me I have this
licence
come with all my distributions :
PostgreSQL Data Base Management System (formerly known as Postgres,
then as Postgres95).
Tom Lane wrote:
>
> "Eric Jain" <[EMAIL PROTECTED]> writes:
> > Any ideas how the following two statements could be combined into a
> > single one?
>
> > SELECT DISTINCT host, url, id
> > INTO TEMP
> > FROM log
> > WHERE
> > host IN (SELECT host FROM robots)
> > AND status IN (200, 304);
>
"Eric Jain" <[EMAIL PROTECTED]> writes:
> Any ideas how the following two statements could be combined into a
> single one?
> SELECT DISTINCT host, url, id
> INTO TEMP
> FROM log
> WHERE
> host IN (SELECT host FROM robots)
> AND status IN (200, 304);
> SELECT host, COUNT(*) AS hits
> FROM TE
50 matches
Mail list logo
