Re: [GENERAL] Delphi PostgreSQL Forum

2000-10-10 Thread Efrain Caro
Maybe, here is a confusion about the word "Delphi". Everywhere I use "Delphi" in this emails, I mean the Delphi web site that has to do with forums about anything. What I want to do is to open a forum in www.delphi.com for pgsql discussions. - Original Message - From: "Daryl Chance" <[EMA

Re: [GENERAL] Delphi PostgreSQL Forum

2000-10-10 Thread Daryl Chance
doh. nevermind...I was under the impression you were talking about Borland Delphi. Nm :) Thanks for clearing it up, | Daryl Chance | I have made this letter longer then | | Valuedata, LLC | usual because I lacked the time to | | Memphi

Re: [GENERAL] Installation problem

2000-10-10 Thread Adam Lang
If I recall, it is the type of system, linux, bsd, x86, etc. Stuff like that. I think I encountered a problem like that when trying to compile Sendmail. For that there was a paramter where you could specify the host type in one of the config files. I think the problem derives from some sort of

Re: [GENERAL] index on points

2000-10-10 Thread Tom Lane
Peter Keller <[EMAIL PROTECTED]> writes: > Therefore we decided to use PostgreSQL as our DB. At this time we have > the problem to find points in a polygon. In postgres you have the > operator '@' to find points in a polygon. But if you have many points it > is realy to slow without indexing the p

Re: [GENERAL] Installation problem

2000-10-10 Thread John Gray
> If I recall, it is the type of system, linux, bsd, x86, etc. Stuff like > that. I think I encountered a problem like that when trying to compile > Sendmail. For that there was a paramter where you could specify the host > type in one of the config files. I think the problem derives from some

Re: [GENERAL] index on points

2000-10-10 Thread Jeff Hoffmann
Tom Lane wrote: > > Peter Keller <[EMAIL PROTECTED]> writes: > > Therefore we decided to use PostgreSQL as our DB. At this time we have > > the problem to find points in a polygon. In postgres you have the > > operator '@' to find points in a polygon. But if you have many points it > > is realy t

Re: [GENERAL] My new job

2000-10-10 Thread Marc G. Fournier
On Tue, 10 Oct 2000, Sergio A. Kessler wrote: > Bruce Momjian <[EMAIL PROTECTED]> el día Tue, 10 Oct 2000 01:06:42 > -0400 (EDT), escribió: > > [...] > >After careful consideration, I have decided to accept a job with Great > >Bridge. There will be a press announcement tomorrow (Tuesday) with

Re: [GENERAL] Installation problem

2000-10-10 Thread Tom Lane
[EMAIL PROTECTED] writes: > I am installing on Mandrake Linux 7.0 and when I run configure I get : > 'can not guess host type' Hmm, so the config.guess script isn't able to make any sense of what your uname command produces. What do you get from "uname -a" ? regards, to

Re: [GENERAL] Delphi PostgreSQL Forum

2000-10-10 Thread Tom Lane
"Efrain Caro" <[EMAIL PROTECTED]> writes: > Maybe, here is a confusion about the word "Delphi". Everywhere I use > "Delphi" in this emails, I mean the Delphi web site that has to do with > forums about anything. What I want to do is to open a forum in > www.delphi.com for pgsql discussions. While

Re: [GENERAL] Problem specifying limit in select inside insert.

2000-10-10 Thread Tom Lane
Denis Perchine <[EMAIL PROTECTED]> writes: > insert into address (cid,email) select distinct '49'::int,member.email from > member imit 1 ; INSERT ... SELECT ... LIMIT doesn't work. In existing releases the LIMIT clause is just dropped on the floor by the parser :-(. In current CVS sources you

Re: [GENERAL] Is there any caveats on toasted fields?

2000-10-10 Thread Tom Lane
"He Weiping (Laser Henry)" <[EMAIL PROTECTED]> writes: > I'm using current CVS tree, the table is simple: > then I do some insert using sql script, and some work fine, but others > always > got such kind of messages like: > psql:scriptname:1615: ERROR: parser: parse error at or near "ll" > P.S.

Re: [GENERAL] Delphi PostgreSQL Forum

2000-10-10 Thread Efrain Caro
I have been thinking in that same thing. I've been looking on how much Linux forums and mailing lists are there and how difficult is to get the information that I want. So I already realized that this is a bad idea. I was looking mainly for a place where there are archives so that I may be able to

Re: [GENERAL] index on points

2000-10-10 Thread Tom Lane
Jeff Hoffmann <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> There is already support for r-tree indexes, but as far as I know the >> '@' operator is not connected up to indexes. > i'm just throwing this out without testing it, but i think something > like this might work: coerce both the poin

Re: [HACKERS] My new job

2000-10-10 Thread Peter Eisentraut
Bruce Momjian writes: > After careful consideration, I have decided to accept a job with Great > Bridge. Whatever happened to this: Date: Tue, 09 May 2000 15:19:48 -0400 From: Tom Lane <[EMAIL PROTECTED]> To: Ross J. Reedstrom <[EMAIL PROTECTED]> Cc: PostgreSQL-general <[EMAIL PROTECTED]> Subje

Re: [GENERAL] Listing Triggers corresponding to foreign keys

2000-10-10 Thread Stephan Szabo
On Tue, 10 Oct 2000, Trewern, Ben wrote: > Hi all, > > Am I right in saying that when you add a constraint to a table it just > produces three triggers? If so which triggers? A foreign key constraint, yes. (Check constraints, unique, primary key and not null are handled differently). > Ther

[GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Bruce Momjian
> Bruce Momjian writes: > > > After careful consideration, I have decided to accept a job with Great > > Bridge. > > Whatever happened to this: > > Date: Tue, 09 May 2000 15:19:48 -0400 > From: Tom Lane <[EMAIL PROTECTED]> > To: Ross J. Reedstrom <[EMAIL PROTECTED]> > Cc: PostgreSQL-general <[E

Re: [GENERAL] Re: JDBC Performance

2000-10-10 Thread Peter Mount
On Tue, 10 Oct 2000, Keith L. Musser wrote: > jdbc7.0-1.2.jar 1.89 ms5.0 ms 3.9 ms > postgresql.jar (191450 bytes)1.36 ms3.1 ms 3.2 ms > postgresql.jar (204223 bytes)1.78 ms3.9 ms 4.1 ms > > In Test #2 w/ GC, I purposefully ran System.gc() every 1

Re: [HACKERS] My new job

2000-10-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Bruce Momjian writes: >> After careful consideration, I have decided to accept a job with Great >> Bridge. > Whatever happened to this: > From: Tom Lane <[EMAIL PROTECTED]> > : One thing we have agreed to is that there must not be an unseemly fracti

Re: [GENERAL] Some advanced database features, are they present inPostgreSQL

2000-10-10 Thread Peter Mount
On Tue, 10 Oct 2000, Marc SCHAEFER wrote: >- ability to have databases bigger than the host's maximum file size This has been in there since the old postgres days (although we did find it have a problem with Linux and files exactly 2Gig). PostgreSQL now splits tables at the 1Gb level, so tab

Re: [GENERAL] Some advanced database features, are they present inPostgreSQL

2000-10-10 Thread Peter Eisentraut
Marc SCHAEFER writes: >- log all transactions to a special log file, that can be used for > backup purposes: Will be in 7.1. >- hard transactions: cutting the power to a PostgreSQL server > may cause data loss and/or data corruption. Some databases use > sophisticated tec

Re: [GENERAL] Installation problem

2000-10-10 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > I am installing on Mandrake Linux 7.0 and when I run configure I get : > 'can not guess host type' Your compiler installation is messed up. > It wants me to specify the host - is this the IP address or something > else? It's the type of the host system, e.g., i586-

Re: [HACKERS] My new job

2000-10-10 Thread Mitch Vincent
What is the main concern? That Great Bridge or PostgreSQL Inc will try to influence development? This is just my lowly opinion but it seems to me that this could be a storm brewing in a tea cup, it just doesn't seem to be that threatening a situation at a glance. Congrats to everyone on their ne

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

2000-10-10 Thread Alfred Perlstein
* Peter Eisentraut <[EMAIL PROTECTED]> [001010 09:47] wrote: > Bruce Momjian writes: > > > After careful consideration, I have decided to accept a job with Great > > Bridge. > > Whatever happened to this: > > Date: Tue, 09 May 2000 15:19:48 -0400 > From: Tom Lane <[EMAIL PROTECTED]> > To: Ross

[GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Bruce Momjian
> Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Bruce Momjian writes: > >> After careful consideration, I have decided to accept a job with Great > >> Bridge. > > > Whatever happened to this: > > > From: Tom Lane <[EMAIL PROTECTED]> > > : One thing we have agreed to is that there must not be

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

2000-10-10 Thread Bruce Momjian
> I think Great Bridge makes a shining example of an exception to > that rule, the impression I got from the developers already there > as well as the managment was very good. > > And although I loath to speak for others, you wouldn't think that > Bruce would take this position if it somehow comp

Re: [HACKERS] My new job

2000-10-10 Thread Alfred Perlstein
* Tom Lane <[EMAIL PROTECTED]> [001010 10:03] wrote: > > From: Tom Lane <[EMAIL PROTECTED]> > > : One thing we have agreed to is that there must not be an unseemly fraction > > : of core members working for the same company. With six people on core, > > : probably about two working at the same c

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

2000-10-10 Thread Adam Lang
I think it comes down to more of an issue of "conflict of interest". Worry that core members will have more loyalty to the project in view of their employers as opposed to the view of the project itself. That risk is increased ten-fold when multiple members are in the same company. It is tough

Re: [GENERAL] Some advanced database features, are they present in PostgreSQL

2000-10-10 Thread Tom Lane
>> - hard transactions: cutting the power to a PostgreSQL server >> may cause data loss and/or data corruption. That is false; Postgres is secure now against power failures, at least if you run in the default mode with lots of fsync()s. The WAL feature planned for 7.1 should make performance bet

Re: [HACKERS] My new job

2000-10-10 Thread Don Baccus
At 01:02 PM 10/10/00 -0400, Tom Lane wrote: >Bottom line is we're not sure what to do now. Opinions from the >floor, anyone? Yeah, quit worrying and work your collective butts off on 7.1 and 7.2 :) Seriously...the core group is obviously committed to PG, and appear to be folks of integrity.

Re: [HACKERS] My new job

2000-10-10 Thread Bruce Momjian
> At 01:02 PM 10/10/00 -0400, Tom Lane wrote: > > >Bottom line is we're not sure what to do now. Opinions from the > >floor, anyone? > > Yeah, quit worrying and work your collective butts off on 7.1 and 7.2 :) C'mon, Don. Stop beating around the bush. Tell us what you really think. :-) --

[GENERAL] Curious age() behavior

2000-10-10 Thread Mitch Vincent
Maybe I'm just overlooking something really simple but this has me a bit confused. What I'm trying to do is get the amount of time from A to B -- I thought age() would do just that but it seems to be about a day off sometimes. hhs=# SELECT age('Sun Dec 03 08:00:00 2000 EST','Tue Oct 10 08:00:00

[GENERAL] Curious age() behavior Cont'd

2000-10-10 Thread Mitch Vincent
I should point out that it works as I expected it to on other values.. hhs=# SELECT age('Sun Nov 05 08:00:00 2000 EST','Tue Oct 10 08:00:00 2000 EDT') as esec; esec -- @ 26 days 1 hour (1 row) hhs=# SELECT ('Tue Oct 10 08:00:00 2000 EDT'::timestamp + '1 mon 24 days 1 hour

Re: [GENERAL] Some advanced database features, are they present in PostgreSQL

2000-10-10 Thread Marc SCHAEFER
On Tue, 10 Oct 2000, Peter Eisentraut wrote: > Will be in 7.1. [ ... ] > Something like this has recently been announced as add-on from PostgreSQL, [ ... ] > That has been available for quite a while. [ ... ] So, those are very good news. Thanks, and keep the good work.

[GENERAL] Re: My New Job

2000-10-10 Thread K Parker
>> It's not like Great Bridge >> wants to turn PostgreSQL >> into a pinball machine emulator. > All right, who leaked the Great Bridge > product plans. :-) Somebody was bound to. We all agree that what the world really needs is a Great Pinball Machine Emulator--it's just that we want there to

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

2000-10-10 Thread Bruce Momjian
> Dave Smith <[EMAIL PROTECTED]> writes: > > Well to calm any fears of Great Bridge taking over what exactly are the > > terms of employment? Are the developers merely continuing on with what > > they were working on and now getting paid for it, or is Great Bridge > > saying here are the projects

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

2000-10-10 Thread Bruce Momjian
> I just don't see what the conflict might be. It's not > like Great Bridge is going to hold Bruce's family > hostage and force him to rewrite PostgreSQL in Cobol. > In fact, Great Bridge had better treat their employees > very well or they will find that their are greener > pastures somewhere e

Re: [GENERAL] Regression tests of plain 7.0.2 fails

2000-10-10 Thread Martin Jacobs
Tom Lane schrieb: > [EMAIL PROTECTED] (Martin Jacobs) writes: > > Ignoring the minor floatingpoint errors, the first annoying > > severe was in parallel group2 > > sequential test create_type ... FAILED > > > ERROR: TypeCreate: function 'widget_in(opaque)' does not exist > > O

[GENERAL] Pg.pm question

2000-10-10 Thread KMiller
When I run a perl script named enc.pl I get this error.  It looks like Pg.pm can't resolve something when it reaches the line: bootstrap Pg $VERSION; Can't locate loadable object for module Pg in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_p

[GENERAL] Postmaster crashes periodically

2000-10-10 Thread Philip Warner
Probably once per week or so I get a message like: Server process (pid 12243) exited with status 11 at Tue Oct 10 01:20:01 2000 Terminating any active server processes... Followed by one of these for each backend: NOTICE: Message from PostgreSQL backend: The Postmaster

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

2000-10-10 Thread Gunnar R|nning
"Adam Lang" <[EMAIL PROTECTED]> writes: > I wasn't judging. I was mentioning to others what the concerns probably > were. Also, it isn't a concern of "Company B" taking over. It is of the > possibility of development put in the direction that best benefits of > Company B as opposed to the proj

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

2000-10-10 Thread Gunnar R|nning
Bruce Momjian <[EMAIL PROTECTED]> writes: > more in voliation of the original plan. > violation ? Or is this just another gap in my knowledge of the English language ? Gunnar

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

2000-10-10 Thread Adam Haberlach
On Tue, Oct 10, 2000 at 05:06:37PM -0400, Dave Smith wrote: > Adam Lang wrote: > Well to calm any fears of Great Bridge taking over what exactly are the > terms of employment? Are the developers merely continuing on with what > they were working on and now getting paid for it, or is Great Bridge

RE: [GENERAL] Some advanced database features, are they present inPostgreSQL

2000-10-10 Thread The Hermit Hacker
right now, we are working with our partners internally on this, before we release it publicly, but more information can be found at: http://www.erserver.com/ On Tue, 10 Oct 2000, Rob Hutton wrote: > I'm looking for info about the synching and I don't see any. Is there a > more

Re: [GENERAL] Pg.pm question

2000-10-10 Thread Alex Pilosov
Have you ran 'make install' for Pg module? While you are on it, I'd suggest using DBD::Pg instead of Pg. -alex On Tue, 10 Oct 2000, KMiller wrote: > When I run a perl script named enc.pl I get this error. It looks like Pg.pm can't >resolve something when it reaches the line: bootstrap Pg $VE

Re: [GENERAL] Pg.pm question

2000-10-10 Thread bmccoy
On Tue, 10 Oct 2000, KMiller wrote: > Can anyone explain this in more detail and/or offer suggestions for a > fix? How about some code? It's hard to tell just by looking at error messages. Brett W. McCoy http://www.chapelperilous.net --

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

2000-10-10 Thread Gunnar R|nning
Adam Haberlach <[EMAIL PROTECTED]> writes: > All this whinging about "corperate direction" is really meaningless > unless you are prepared to jump ship or split off in a clone of the > original one. The code is what you do with it. We are all lucky that > it is as good and useful as it is

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

2000-10-10 Thread Philip Warner
At 17:25 10/10/00 -0400, Tom Lane wrote: > >So the question is, what do we do now? > There seem to be several concerns (in no particular order): 1. Conscious design/development choices based partly/solely on the needs of one or more companies as opposed to the interest of the open source project

[GENERAL] directory mapping RH with RPM vs RH with tar.z install

2000-10-10 Thread Bob Hartung
Hi again, I've got 7.0.3 installed and running if the results of ps ax | grep pgsql are to be believed! My question: Is the correct comparative directory mapping as follows?? Non RH RH /usr/local/pgsql/bin/usr/bin /var/lib

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

2000-10-10 Thread Tom Lane
Gunnar R|nning <[EMAIL PROTECTED]> writes: > Bruce Momjian <[EMAIL PROTECTED]> writes: >> more in voliation of the original plan. > violation ? Or is this just another gap in my knowledge of the English > language ? You're right, he's wrong. We native English speakers are notoriously poor spel

Re: [GENERAL] Delphi PostgreSQL Forum

2000-10-10 Thread Fredrick Bartlett
Hello, Daryl! Take a look at the Dephi Components Zeos Database Objects for PostgreSQL. If you are familiar with delphi TDataSet you will be right at home with ZDBO components. http://www.zeos.dn.ua Daryl Chance wrote: > doh. nevermind...I was under the impression you were talking > about

Re: Re[2]: [GENERAL] TEXT vs VARCHAR

2000-10-10 Thread Tom Lane
David Huttleston Jr <[EMAIL PROTECTED]> writes: > There is another issue with TEXT vs VARCHAR. A TEXT field is not > handled well by ODBC and MS Access. If there is an index on the TEXT > field, the ODBC link will fail, saying something like "Can Not Index a > OLE field." OLE fields are Access'

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

2000-10-10 Thread Tom Lane
Ned Lilly <[EMAIL PROTECTED]> writes: Bridge wants to turn PostgreSQL into a pinball machine emulator. >> >> All right, who leaked the Great Bridge product plans. :-) > "He's a PostgreSQL wizard, there's got to be a twist..." rotfl ... where's the C&C warning on this?

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

2000-10-10 Thread Bruce Momjian
> Gunnar R|nning <[EMAIL PROTECTED]> writes: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> more in voliation of the original plan. > > > violation ? Or is this just another gap in my knowledge of the English > > language ? > > You're right, he's wrong. We native English speakers are notor

Re: [GENERAL] Postmaster crashes periodically

2000-10-10 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > Server process (pid 12243) exited with status 11 at Tue Oct 10 01:20:01 > 2000 > I'd be interested in any hints as to how to track this down since I can't > seem to find any core files etc. This is under Linux 2.2.10 & PG > 7.0.2. A backend SEGV cr