Re: [GENERAL] business perspective

2001-09-12 Thread Ryan Mahoney
>The website is currently undergoing a rewrite. > >Vince. Are there architectural designs, use cases, mock-ups, color schemes, requirements, etc. that we can view online so we can understand the direction things are moving in and offer our input and talents? If this project is worked on by a

[GENERAL] postgresql reference application

2001-09-12 Thread Eric Kolve
Does anyone know of some good open source applications that are using postgresql well? I am interested in studying schema and physical design of some well thought out applications. Any suggestions would be helpful. thanks, eric ---(end of broadcast)

Re: [GENERAL] postgresql.com

2001-09-12 Thread Randy Hall
It was purchased by Great Bridge about three months ago from a cyber squatter. I will ask tomorrow what will become of the domain name. -- Randy Hall - Red Hat Certified Engineer - PostgreSQL Expert Resume: http://members.home.net/rthall3 - Original Message - From: "Ryan Mahoney" <[EMAIL

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Martijn van Oosterhout
On Wed, Sep 12, 2001 at 04:55:35PM +, Thomas Lockhart wrote: > > BTW, i don't know who thought of it but -dd-mm is a terrible format and > > should be shot. > > Where does -dd-mm appear in PostgreSQL? What is the issue here? >From the original post: > vendirza=# SHOW DATESTYLE; > NO

Re: [GENERAL] business perspective

2001-09-12 Thread Vince Vielhaber
The website is currently undergoing a rewrite. Vince. On Wed, 12 Sep 2001, Ryan Mahoney wrote: > Since Great Bridge is no longer, there is a need for a strong online > presence for companies and individuals to learn about postgresql. This gap > is a detriment to the project from a marketing

Re: [GENERAL] locale and spanish acute

2001-09-12 Thread Martín Marqués
On Mié 12 Sep 2001 20:10, you wrote: > Martín Marqués writes: > > I'm doing some searches with LIKE and have a problem with words with > > acute vocals. I would like más to be treated the same way as mas, and > > vice-verse. > > > > Is this because I don't have the locale set correctly? > > No, it

Re: [GENERAL] locale and spanish acute

2001-09-12 Thread Peter Eisentraut
Martín Marqués writes: > I'm doing some searches with LIKE and have a problem with words with acute > vocals. I would like más to be treated the same way as mas, and vice-verse. > > Is this because I don't have the locale set correctly? No, it's because it doesn't work that way. What you probab

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Graham Leggett
Barry Lind wrote: > I am guessing from the error that you are using JDBC as your client. > This looks like a known issue with the 7.0 jdbc driver. Have your tried > the 7.1 jdbc driver? (as long as you don't use the DatabaseMetadata > object too much, the 7.1 driver should work fine against a 7

[GENERAL] postgresql.com

2001-09-12 Thread Ryan Mahoney
postgresql.com takes you to greatbridge.com as of today - did it always - or am I losing my mind? -r --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 -

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Barry Lind
Graham, I am guessing from the error that you are using JDBC as your client. This looks like a known issue with the 7.0 jdbc driver. Have your tried the 7.1 jdbc driver? (as long as you don't use the DatabaseMetadata object too much, the 7.1 driver should work fine against a 7.0 database).

[GENERAL] business perspective

2001-09-12 Thread Ryan Mahoney
Since Great Bridge is no longer, there is a need for a strong online presence for companies and individuals to learn about postgresql. This gap is a detriment to the project from a marketing perspective, where GB helped the most. I visit postgresql.org a few time a week and find it to be very

[GENERAL] locale and spanish acute

2001-09-12 Thread Martín Marqués
I'm doing some searches with LIKE and have a problem with words with acute vocals. I would like más to be treated the same way as mas, and vice-verse. Is this because I don't have the locale set correctly? Saludos... ;-) -- Porqué usar una base de datos relacional cualquiera, si podés usar Po

Re: [GENERAL] locale ordering

2001-09-12 Thread Oliver Elphick
"Jacob Vennervald Madsen" wrote: >How do I change the locale in the database? >I've tried to set the LANG environment variable before starting the >database but it still sorts it the english way. You can't change it; it's set for the life of all databases. Use pg_dumpall to save all data.

[GENERAL] compiling ...

2001-09-12 Thread mike
Hi Folks, "cc -O -o pgsample pgsample.c -L/usr/local/pgsql/lib -lpq" went thru. Then I did "make pgsample.o". After that "make pgsample", this process gave me original errors: pgsample.o: In function `main': pgsample.o(.text+0x12): undefined reference to `PQconnectdb' pgsample.o(.text+0x2b):

[GENERAL] Is Perl compiled into Version?

2001-09-12 Thread R Talbot
I compiled the source to roll my Postgresql installation on 4 machines. However that was in June 2001. I had some problems getting the install to compile with java ant from Apache ( my own error). My intention was to compile and install with switches for java .. perl.. tk/tcl and python..

Re: Fwd: Re: [GENERAL] unicode in 7.1

2001-09-12 Thread Barry Lind
If you are getting a parse error as you said in a latter message, then you should set "debug_print_query = true" in your postgresql.conf file. This will cause the sql statements to be printed in the server log file and you then might be able to figure out why the statement sent couldn't be p

[GENERAL] error while generating and EXECUTEing a query dynamically

2001-09-12 Thread Gaurav Priyolkar
Hi all, The machine I am sending this mail from does not have postgres, but I did this just this morning so am typing from memory: CREATE FUNCTION footable() RETURNS INTEGER AS ' DECLARE sql VARCHAR(1000); BEGIN sql := ''CREATE TABLE foo (x INT, y CHAR) ''; EXECUTE sq

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Thomas Lockhart
> BTW, i don't know who thought of it but -dd-mm is a terrible format and > should be shot. Where does -dd-mm appear in PostgreSQL? What is the issue here? - Thomas ---(end of broadcast)--- TIP 2: you can get off all

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Graham Leggett
Martijn van Oosterhout wrote: > > vendirza=# SHOW DATESTYLE; > > NOTICE: DateStyle is ISO with US (NonEuropean) conventions > > > > vendirza=# SHOW DATESTYLE; > > NOTICE: DateStyle is ISO with US (NonEuropean) conventions > > Looks the same machine to me. That's because both machines are conf

Re: [GENERAL] Error: Bad Timestamp Format

2001-09-12 Thread Martijn van Oosterhout
On Wed, Sep 12, 2001 at 05:16:29PM +0200, Graham Leggett wrote: > According to the FAQ and docs, this is caused by the date format being > wrong, but the date format is the same on both installations: > > vendirza=# SHOW DATESTYLE; > NOTICE: DateStyle is ISO with US (NonEuropean) conventions >

Re: [GENERAL] Ridicolus Postgresql review

2001-09-12 Thread Justin Clift
Thanks Bruce, I'll check the Archives for more info about it then. Prob should have done that before asking. :-) Regards and best wishes, Justin Clift Bruce Momjian wrote: > > > Hey guys, > > > > Does anyone know anything about this SQL*Net compatible thing which we > > are supposed to be

Re: [GENERAL] Ridicolus Postgresql review

2001-09-12 Thread Bruce Momjian
> Hey guys, > > Does anyone know anything about this SQL*Net compatible thing which we > are supposed to be developing according to the article? > > I haven't heard anything about it. It is on our TODO list. That's as far as it has gone. > Also, it says we are planning full Unicode support fo

Re: [GENERAL] USA Disaster

2001-09-12 Thread Richard Zimmerman
> How is the internet and telecommunication affected? The first time we did > not have real internet-connections, and a few hours ago the satellites > began to get free ... Did the priority change, for the first moment, from > "normal, public use" to "military and government use only"? No, I

Re: [GENERAL] Strange select query

2001-09-12 Thread Einar Karttunen
On Wed, Sep 12, 2001 at 10:28:33AM +0200, Partyka Robert wrote: > Hellow, > > I notice wired behavior of backend, > > for instance I've 3 tables TA, TB, TC with about 1k of records each, > > and I do something like that: > > select * from TA as a, TB as b, TC as c where > position('some text'