Re: [GENERAL] Calender

2000-02-22 Thread Lincoln Yeoh
At 01:29 AM 23-02-2000 -0400, Jeff MacDonald wrote: >people pushing elphants ? i say hell with that, we should just buy >2 elphants, breed them and tatoo "PostgreSQL" on the calfs and sell'em. Hehe :). We'll call the parents Postmaster and Postmistress. Talk about spawning child processes ;). Co

[GENERAL] ERROR: JoinClauseSelectivity

2000-02-22 Thread sheila bel
Hi everyone, I'm trying to do a simple join query and I get an error message. My tables are : agency(agencyid serial, agency_name text, address text, ...) groupleader(leaderid serial, agency_name text, phonenum text , ...) The query : SELECT agencyid FROM agency, groupleader WHERE agency.

Re: [GENERAL] Calender

2000-02-22 Thread Jeff MacDonald
people pushing elphants ? i say hell with that, we should just buy 2 elphants, breed them and tatoo "PostgreSQL" on the calfs and sell'em. re: stuffed elephant, supppliers haven't found anything yet, and they said that these would probably be quite pricy. jeff On Wed, 23 Feb 2000, Lincoln Yeoh

Re: [GENERAL] Calender

2000-02-22 Thread Louis Bertrand
My wife's mom makes stuffed teddy bears. I've been working on convincing her that software-inspired stuffed toys would be cool (*BSD daemons, and now maybe elephants). The first few will be experimental and probably pricey, assuming I can convince her that it's cool. Ciao --Louis <[EMAIL PROTEC

Re: [GENERAL] Re: [General] pgsql on win95

2000-02-22 Thread Lincoln Yeoh
At 07:07 PM 22-02-2000 +0100, Marten Feldtmann wrote: >> On Mon, 21 Feb 2000 [EMAIL PROTECTED] wrote: >> >> Is there really an interest in spending the extra money for a >> Windows license to build a less reliable database server? >> > > Hmmm, try to think about an application, which normal

Re: [GENERAL] Calender

2000-02-22 Thread Lincoln Yeoh
At 11:39 AM 22-02-2000 -0400, Jeff MacDonald wrote: >Um , we're trying to push postgres here :) Yah, but I just couldn't resist.. How about a picture of the Postgres People pushing elephants in various ways ;). Link. p.s. Any sign of the stuffed toy elephant? It's got to be cute tho, e.g. brig

Re: [GENERAL] TRANSACTIONS

2000-02-22 Thread Lincoln Yeoh
At 12:47 PM 22-02-2000 +0100, Jose Soares wrote: >begin transaction; >create table tmp(a int); >insert into tmp values (1); >insert into tmp values (10); >ERROR: pg_atoi: error reading "10": >Numerical result out of range >commit; >s

Re: [GENERAL] Re: [General] pgsql on win95

2000-02-22 Thread Dustin Sallings
On Tue, 22 Feb 2000, Marten Feldtmann wrote: # > On Mon, 21 Feb 2000 [EMAIL PROTECTED] wrote: # > # > Is there really an interest in spending the extra money for a # > Windows license to build a less reliable database server? # # Hmmm, try to think about an application, which normally runs

Re: [GENERAL] Re: [General] pgsql on win95

2000-02-22 Thread Marten Feldtmann
> On Mon, 21 Feb 2000 [EMAIL PROTECTED] wrote: > > Is there really an interest in spending the extra money for a > Windows license to build a less reliable database server? > Hmmm, try to think about an application, which normally runs on a server, but then is also wanted (with much less

[GENERAL] Functional indices...

2000-02-22 Thread Dirk Niggemann
Hello, After some experimentation in pgsql, I would like to understand the following: 1. Why can't functions for functional indices be defined in plpgsql (nothing stops you from doing this in pltcl)? 2. Have I missed something, or are constants and constant expressions not supoported in mutipl

Re: [GENERAL] Calender

2000-02-22 Thread Jeff MacDonald
that's also a good idea. On Tue, 22 Feb 2000, Bruce Momjian wrote: > You know, you may be better off just choosing a few table like pg_class, > pg_attribute, and pg_type, and pg_proc and showing those in a fancy > manner. > > > > Um , we're trying to push postgres here :) > > > > i was thinki

[GENERAL] Fixed Length Arrays

2000-02-22 Thread Arthur M. Kang
Can somebody tell me how to define a fixed length array? The manual is pretty sparse on arrays. I'm trying to create a fixed length boolean array by using: CREATE TABLE test (apple boolean[5]); This creates the array, but it is not fixed in length. Inserting and retrieving larger arrays (grea

[GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-22 Thread Tom Lane
Jose Soares <[EMAIL PROTECTED]> writes: > --- > Interbase, Oracle,Informix,Solid,Ms-Access,DB2: > --- > connect hygea.gdb; > create table temp(a int); > insert into temp values (1); > insert in

Re: [GENERAL] Calender

2000-02-22 Thread Bruce Momjian
You know, you may be better off just choosing a few table like pg_class, pg_attribute, and pg_type, and pg_proc and showing those in a fancy manner. > Um , we're trying to push postgres here :) > > i was thinking the diagram with "spiffier arrrows" > and some drop shadows with a "ligntened elep

Re: [GENERAL] Calender

2000-02-22 Thread Jeff MacDonald
Um , we're trying to push postgres here :) i was thinking the diagram with "spiffier arrrows" and some drop shadows with a "ligntened elephant" behind On Tue, 22 Feb 2000, Lincoln Yeoh wrote: > At 03:28 PM 21-02-2000 -0400, Jeff MacDonald wrote: > > >the image we've chosen is at http://bignose

[GENERAL] Problems using Postgres-ODBC-Borland BDE

2000-02-22 Thread Robert Esser
Hello, first I hope this is the right place to post my question?! I have developed a windows application with Borland Delphi 5 Enterprise Edition, BDE 5.11 (Version from 2/2000) and store my date in a postgres database on a SuSE linux 6.1 server. I got errors in my application when trying to e

[GENERAL] Problems using Postgres-ODBC-Borland BDE

2000-02-22 Thread Robert Esser
Hello, first I hope this is the right place to post my question?! I have developed a windows application with Borland Delphi 5 Enterprise Edition, BDE 5.11 (Version from 2/2000) and store my date in a postgres database on a SuSE linux 6.1 server. I got errors in my application when trying to e

Re: [GENERAL] auto number

2000-02-22 Thread Peter Eisentraut
On Tue, 22 Feb 2000, Marco Giardini wrote: > how do i set a table with an autonumebr field? I mean a field that it's > automatically increased by one for each added record. Use a SERIAL column. E.g.: create table x (a text, b serial); insert into x(a) values ('abc'); -- Peter Eisentraut

[GENERAL] RE: [HACKERS] TRANSACTIONS

2000-02-22 Thread Dmitry Samersoff
On 22-Feb-2000 Jose Soares wrote: > begin transaction; > create table tmp(a int); > insert into tmp values (1); > insert into tmp values (10); > ERROR: pg_atoi: error reading "10": > Numerical result out of range > commit; > select

[GENERAL] TRANSACTIONS

2000-02-22 Thread Jose Soares
Hi all, The transactions should be the way to distinguish a relational database from others no-relational databases, (MySQL is the right example). We are very proud of PostgreSQL transactions but seems that it doesn't work in the right way. It shoud be important to be sure that PostgreSQL is com

[GENERAL] auto number

2000-02-22 Thread Marco Giardini
how do i set a table with an autonumebr field? I mean a field that it's automatically increased by one for each added record. Thanks .oesse. -- -- +-+-+-+-+-+ +-+-+-+-+-+-+-+-+ |m|a|r|c|o| |g|i|a|r|d|i|n|i| +-+-+-+-+-+ +-+-+-+-+-+

[GENERAL] (no subject)

2000-02-22 Thread lisa
Hallo, it was really helpfull but unfortunatly in this time I don't have time for your interesting group, so I invite you to delete my address from your list. Thanks Zamuner Lisa