[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

[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] 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

[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 * from

[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

[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

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

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

[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 into temp

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 thinking the

[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

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

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 on

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; select *

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.

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 normally runs on

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

[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

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 ;).