Re: [GENERAL] Postgres User and Password

2001-07-13 Thread GH
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

Re: [GENERAL] Nusphere/MySQL-AB arguing

2001-07-13 Thread Peter Eisentraut
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

Re: [HACKERS] Re: [GENERAL] [PATCH] To remove EXTEND INDEX

2001-07-13 Thread Bruce Momjian
> > > > 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

Re: [GENERAL] [PATCH] To remove EXTEND INDEX

2001-07-13 Thread Bruce Momjian
> > > > 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

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Peter Eisentraut
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

RE: [GENERAL] autoincrement???

2001-07-13 Thread Kevin Bullaughey
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

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Lamar Owen
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

Re: [GENERAL] Nusphere/MySQL-AB arguing

2001-07-13 Thread Jan Wieck
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

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Peter Eisentraut
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

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Lamar Owen
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: > > /

[GENERAL] Nusphere/MySQL-AB arguing

2001-07-13 Thread Bruce Momjian
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

[GENERAL] Re: COPY and duplicates

2001-07-13 Thread Bruno Wolff III
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

Re: [GENERAL] Foreign keys?

2001-07-13 Thread Jason Earl
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

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Trond Eivind Glomsrød
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

Re: [GENERAL] Postgresql & Python 2

2001-07-13 Thread Keith F Irwin
> > 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 > >

Re: [GENERAL] Re: Backups WAS: 2 gig file size limit

2001-07-13 Thread Thomas Lockhart
> 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

Re: [GENERAL] [PATCH] To remove EXTEND INDEX

2001-07-13 Thread Bruce Momjian
> > 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

Re: [GENERAL] Re: [DOCS] QUERY - Including the new LDP PostgreSQL HOWTO in the main PostgreSQL distribution

2001-07-13 Thread Thomas Lockhart
> > 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

RE: [GENERAL] Outer joins

2001-07-13 Thread wsheldah
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

Re: [GENERAL] Outer joins

2001-07-13 Thread Tom Lane
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

RE: [GENERAL] Outer joins

2001-07-13 Thread Trewern, Ben
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

Re: [GENERAL] Visual Modeling programs

2001-07-13 Thread wsheldah
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

Re: [GENERAL] news server access down?

2001-07-13 Thread The Hermit Hacker
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

[GENERAL] Outer joins

2001-07-13 Thread eddie iannuccelli
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