On Fri, Jul 13, 2001 at 09:43:57PM -0400, some SMTP stream spewed forth:
[...]
> My problem is with my Linux Posgres installations.
> I compiled as root and installed as root user. As root I can
> root@thinkpad root]# su postgres
> root@thinkpad root]# pg_ctl start ... Or use postmas
Bruce Momjian writes:
> Some of you may be following the problems between MySQL AB and Nusphere.
> Jan found this nice summary:
>
> http://www.newsforge.com/article.pl?sid=01/07/12/2142237
>
> The issues involve the MySQL trademark, MySQL websites, the GPL, and
> open source community devel
> > > > Note, this patch makes it as if it never existed. So, if you think some of
> > > > the code may be useful, now is the time to speak up! :)
> > > Shouldn't this conversation be happening on the -hackers list? TIA
> > Actually, because it had a patch attached, it should go to patches,
> > r
> > > > Note, this patch makes it as if it never existed. So, if you think some of
> > > > the code may be useful, now is the time to speak up! :)
> > > Shouldn't this conversation be happening on the -hackers list? TIA
> > Actually, because it had a patch attached, it should go to patches,
> > r
Trond Eivind Glomsrød writes:
> Exactly what bug are you thinking of?
>
> The current build process tries to detect your current version of
> python and build for that..
The RPMs Lamar distributed had Python 1.5 hardcoded. If you fixed that in
the meantime, my apologies.
--
Peter Eisentraut
one way to do this is with a sequence.
CREATE SEQUENCE some_seq MINVALUE 1;
CREATE TABLE address (
address_id int PRIMARY KEY ,
street VARCHAR(40),
zipcodeINT,
city VARCHAR(40),
countryVARCHAR(40)
);
INSERT INTO address VALUES(select
On Friday 13 July 2001 14:47, Peter Eisentraut wrote:
> Lamar Owen writes:
> > But I will reiterate that the prebuilt binary RPMs are built for _stock_
> > RedHat (and hopefully the systems used to build the non-RedHat binaries
> > are stock, as well).
> Maybe the directory naming on the ftp site
Bruce Momjian wrote:
> Some of you may be following the problems between MySQL AB and Nusphere.
> Jan found this nice summary:
>
>http://www.newsforge.com/article.pl?sid=01/07/12/2142237
>
> The issues involve the MySQL trademark, MySQL websites, the GPL, and
> open source community developmen
Lamar Owen writes:
> But I will reiterate that the prebuilt binary RPMs are built for _stock_
> RedHat (and hopefully the systems used to build the non-RedHat binaries are
> stock, as well).
Maybe the directory naming on the ftp site should indicate this. For
instance, I see v7.1-Mandrake, that
On Friday 13 July 2001 12:20, Peter Eisentraut wrote:
> Keith F Irwin writes:
> > But redhat 7.1 comes stock with python 1.5.2. For various reasons, I've
> > upgraded to Python 2.1, which DOESN'T replace python 1.5, but, rather,
> > installs the new version along side. In other words:
> > /
Some of you may be following the problems between MySQL AB and Nusphere.
Jan found this nice summary:
http://www.newsforge.com/article.pl?sid=01/07/12/2142237
The issues involve the MySQL trademark, MySQL websites, the GPL, and
open source community development.
--
Bruce Momjian
On Fri, Jul 13, 2001 at 11:01:28AM -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 13, 2001 at 09:40:24AM -0400,
> Ryan Mahoney <[EMAIL PROTECTED]> wrote:
> > Is it possible for the COPY command to warn about duplicate key violations
> > (and not insert them...) but still proc
It was a little bit late when I wrote that, and so I
probably should have been a little more specific. I
don't know if you would notice a performance
difference between the joined tables query and and the
non-joined version for such simple tables. I might
have to spend a bit of time today loadin
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Keith F Irwin writes:
>
> > But redhat 7.1 comes stock with python 1.5.2. For various reasons, I've
> > upgraded to Python 2.1, which DOESN'T replace python 1.5, but, rather,
> > installs the new version along side. In other words:
> >
> > /us
> > What does it mean to hardcode the pyver variable on top of the file?
>
> Look at the specfile, and you'll see the an attempt to autodetect the
> version of python installed. You can hardcode the result...
AH! The Spec file! Okay, THAT I get. :) Excellent. That'll work
nicely.
Keith
>
>
> I mentioned this on general a while ago.
I'm not usually there/here, but subscribed recently to avoid annoying
bounce messages from replies to messages cross posted to -hackers. I may
not stay long, since the volume is hard to keep up with.
> I had the problem when I dumped my 7.0.3 db to upgr
> > Note, this patch makes it as if it never existed. So, if you think some of
> > the code may be useful, now is the time to speak up! :)
>
> Shouldn't this conversation be happening on the -hackers list? TIA
Actually, because it had a patch attached, it should go to patches,
right?
--
Br
> > For a long time, I thougt HOWTO is docuement for "quick start". Isn't it?
> I'm not sure there is an understood meaning of what a HOWTO actually it.
> It's an explanation of how to do something, I guess... Generally I've found
> (as in your example) that it's putting software together and maki
I think there should be a Postgres Features section. It might be nice to have a
concise comparison chart comparing its features with, for instance, MySQL, SQL
Server 2000, Oracle, and any others that come up often in questions. The
comparison chart should be frank while still unabashedly highl
eddie iannuccelli <[EMAIL PROTECTED]> writes:
> Can anyone confirm me that Postgres 7.1 does not support outer join ?
What? It definitely *does* support outer joins.
> Are functions similar to classical stored procedure ?
Depends on how loose your idea of "similar" is ... a function can't
read
Title: RE: [GENERAL] Outer joins
Postgres 7.1 does support Left, right & outer joins. Functions are similar to stored procedures but they cannot return rows. I think that this limitation is being worked on for the next release (7.2).
By the way should there be a 'Postgres Features' page on
It looks like they aren't quite ready for a full release yet, and may not even
be ready to save changes made to the table schema, based on what I read at
http://dbdesigner.sourceforge.net/. It does look promising though.
Bruce Momjian <[EMAIL PROTECTED]> on 07/12/2001
05:39:29 PM
To: Morg
nope, that was fixed ...
On Thu, 12 Jul 2001, Joseph Shraibman wrote:
> The Hermit Hacker wrote:
> >
> > Service is still offered, we've having a problem with hardware locking up
> > solid for no apparent reason ... its being looked into ...
> >
>
> Is this the same problem that is preventing m
Can anyone confirm me that Postgres 7.1 does not support outer join ?
Are functions similar to classical stored procedure ?
thanks
--
**
Eddie IANNUCCELLI - tel: 05 61 28 54 44
INRA, Laboratoire de Génétique Cellulaire
Chemin de Borde Rouge - Auzev
24 matches
Mail list logo