Re: [HACKERS] 7.4 build problem on Linux Vserver

2003-12-12 Thread Roderick A. Anderson
On Thu, 11 Dec 2003, Dave Page wrote: > > "Dave Page" <[EMAIL PROTECTED]> writes: > > > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes > > > -Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE > > > -I/usr/include -c -o path.o path.c > > > gcc: cannot specify -o with -c or -S

Re: [HACKERS] postgresql-7.4 make error: tuptoaster.c: In function

2003-12-05 Thread Roderick A. Anderson
On Fri, 2 Jan 2004, julius wrote: > im not sure if this is the correct mailing list, please correct me if it is not. > my gcc is version 3.2, configure runs fine i deativated readline-support...but this > error occours: > > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declar

Re: [HACKERS] Learning PostgreSQL

2003-10-07 Thread Roderick A. Anderson
On Sun, 5 Oct 2003, Bruce Momjian wrote: > Neil Conway wrote: > > On Sun, 2003-10-05 at 17:45, Bruce Momjian wrote: > > > Neil Conway wrote: > > > > Depending on what part of the source you're interested in, a book on > > > > DBMS implementation might also be useful, such as > > > > > Wow, $100.

Re: [HACKERS] Update on replication

2002-12-17 Thread Roderick A. Anderson
I just got my copy of SysAdmin Magazine and was surprised to see an article about Usogres -- The PostgreSQL Replication Tool. I don't remember seeing it mentioned on this or the General list. Though I just started reading the article and don't have a firm grasp on it yet, I do remember a discus

Re: [HACKERS] postgresql performance tuning document ?

2002-08-08 Thread Roderick A. Anderson
On Thu, 8 Aug 2002, Nigel J. Andrews wrote: > > I see files truncated at 1Gb on my Linux server: > > > > -rw---1 postgres users855490560 Aug 6 20:53 795261707.2 > > -rw---1 postgres users943259648 Aug 8 23:34 823049708 > > -rw---1 postgres users1073741824 Au

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-29 Thread Roderick A. Anderson
On Mon, 29 Jul 2002, Chris Humphries wrote: > well that and people tend to drift towards an easy answer, > like php... amazing how that combo is so popular... hrrmm... Well people seem to get so ... about php that I didn't want to touch that topic. Rod -- "Open Source Software - Sometimes

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-29 Thread Roderick A. Anderson
On Mon, 29 Jul 2002 [EMAIL PROTECTED] wrote: [snip] > e) Inertia. MySQL got more popular way back when; the reasons may no longer > apply, but nobody is going to move to PostgreSQL without _compelling_ reason, > and you'll have to show something _really compelling_. I would like to add one o

Re: [HACKERS] Password sub-process ...

2002-07-26 Thread Roderick A. Anderson
On Fri, 26 Jul 2002, Jan Wieck wrote: > What would be good is IMHO to have GRANT|REVOKE CONNECT which defaults > to REVOKE, so only superusers and the DB owner can connect, but that the > owner later can change it without the need to edit hba.conf. Oh, yes. Me too please. I think something clo

Re: [HACKERS] Use of /etc/services?

2002-06-08 Thread Roderick A. Anderson
On Sat, 8 Jun 2002, Peter Eisentraut wrote: > This is inconsistent with the official IANA assignment which reads Thanks. I'll update my services file and check all those I come into contact with. I'll check if a new install if Redhat 7.3 has the correct entries this weekend. > postgresql

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Roderick A. Anderson
I see PostgreSQL in /etc/services on an upgraded Redhat Linux 7.3 system. Don't think it was me adding it since I didn't have PG running on the system. Rod -- Please don't tell my mother I'm a System Administrator. She thinks I play piano in a bordello. -

Re: [HACKERS] Re: Notes about int8 sequences

2001-08-06 Thread Roderick A. Anderson
On Mon, 6 Aug 2001, Tom Lane wrote: > Hmm. That's a possibility. There's some potential for trouble if an > application is expecting an int4 result from "SELECT nextval()" and > gets int8 instead, but if we think we could live with that... I assume there will be the same limitations as you men

Re: [HACKERS] Foreign Key Columns And Indices

2001-02-04 Thread Roderick A. Anderson
On Mon, 5 Feb 2001, Christopher Kings-Lynne wrote: > Just a quick question, when a column of a table is defined to be a foreign > key, is it implicitly indexed, or does one still need to explicitly CREATE > INDEX? I don't think you can actually declare the column in the table as a foreign key.

Re: GreatBridge RPMs (was: Re: [HACKERS] question)

2001-01-23 Thread Roderick A. Anderson
On Tue, 23 Jan 2001, Peter Eisentraut wrote: > In general, RPMs only work on systems that are the same as the one they > were built on, for various degrees of "same". If you're not picking up > the RPMs from your distributor or you're sure that the builder used the > same version as you have, it

Re: [HACKERS] Re: Beta2 ... ?

2001-01-06 Thread Roderick A. Anderson
On Fri, 5 Jan 2001, Lamar Owen wrote: > Ok, consider my mind changed. :-). My only concerns were, due to some > feedback I have gotten, is that people would treat the RPM release as > _productions_ rather than beta -- but maybe I'm just being paranoid. Just because you're paranoid doesn't mean