Hi Everyone, I'm brand new at this, and am trying to set up PostgreSQL for the very first time. It looks like my installation of RH9 a few weeks...

Rob

01-18-2004 11:26 PM
Tom Lane

Does it make any sence to index a date field? I am guessing that PostgreSQL has already optimized these fields??? Thanks in...

Alan T. Miller

01-17-2004 10:28 PM
Tom Lane

I am converting an application from another database to postgresql. I am creating my new table using the 'Serial' type for the primary key. When...

Alan T. Miller

01-17-2004 12:37 AM
joseph speigle

Question. How do I compile or enable ECPG in postgres? Is it a seperate download or is it in postgres 7.4?

Chris

01-16-2004 02:05 PM
Chris

How can you sync 2 database to be identical in the case of a failover, where one server goes down, the other already has all of the correct info,...

Bryan Irvine

01-16-2004 12:25 PM
Bryan Irvine

Is it possible to write C code (presumably using libpq) to carry out transactions? I can't seem to find functions in this API which start and end a...

Dave

01-15-2004 11:09 PM
Dave

hi, all I'm writting a procedure by pl/pgsql as following. It's a star-join query for star schema in data warehouse. The procedure is to test...

jack_dull

01-15-2004 09:08 AM
jack_dull

Hi folks, Bit of a situation here: I have my own local and remote systems (7.3.3 says pg_config.h) initdb-ed with -E...

Aarni Ruuhimäki

01-14-2004 08:02 PM
Aarni Ruuhimäki

Hi all Debian has upgraded me to 7.4 ofpostgres, but when it tries to start postgres I get an error mentioning that the data is in 7.3 format...

glenn

01-14-2004 07:48 PM
glenn

Hello pg-cracks, I´m connecting remote to a pgsql server and get a successful login to the specified database xy. I can do the basic queries BUT...

Ralf Bortfeldt

01-14-2004 02:24 PM
Tom Lane

I've been reading on the postgres mailing list about the shortfalls of inheritance and wanted to make sure that my problem is linked to this popular...

Daniel Harris

01-14-2004 02:01 PM
Stephan Szabo

Hello I began with a laptop, installed Red Hat Enterprise Linux 3. I do not know what is included or not on this version. I downloaded some RPMs...

Lduren02@aol.com

01-14-2004 06:02 AM
Aarni Ruuhimäki

Hi I am interested in running a PHP app that when it comes up it checks to see if the requuired database is present. If not it creates it and...

Marcel Wolf

01-13-2004 09:17 AM
Devrim GUNDUZ

Hello I'm using Red Hat 9 in text mode (X-Windows would have a negative influenceon performance). How could I make sure that PostgreSQL starts...

Frederic Logghe

01-13-2004 06:29 AM
Aarni Ruuhimäki

Hi, I created a database in debian using psql (as database user russell). My php4 script can't access it. It reports: Warning: pg_connect(): Unable...

Russell Shaw

01-13-2004 04:51 AM
Russell Shaw

Hi, I just installed pgsql on debian. Can i have initdb create the database cluster in my home directory and have it all owned by russell instead of...

Russell Shaw

01-13-2004 12:32 AM
Oliver Elphick

I use postgres on a window server (IIS 5.1) Is there anybody that knows if is possible to make postgres no case sensitive in the manipulating data...

Dario Ottaviano

01-13-2004 12:27 AM
Oliver Elphick

It seems that perls local::time function returns the day of the month as 1-31 whereas postgres returns it as 01-31. I need to compare dates if...

hodges@xprt.net

01-12-2004 10:39 AM
Bruno Wolff III

Hi, I'm trying to delete from a table based on a foreign key from another table. I've tried this: DELETE FROM a FROM a LEFT JOIN b ON a.b =...

Noel

01-12-2004 09:35 AM
Tom Lane

Tor Gunston <tor (AT) tor (DOT) to> writes: This suggests to me that something has clobbered malloc's internal data structures. The most common...

Tom Lane

01-11-2004 11:01 PM
Tor Gunston

Dennis Veatch wrote: -- Bruno LEVEQUE System Engineer SARL NET6D bruno.leveque (AT) net6d (DOT) com http://www.net6d.com

Dennis Veatch

01-11-2004 10:40 PM
Andreas

Any suggestions as to why I can not initialize the database (see error below) are greatly appreciated. I am new to PostgreSQL. I am using W2K,...

Olaf Meding

01-11-2004 10:28 PM
George Weaver

Hi list, I just downloaded the source from PostgreSQL 7.4.1 and installed it on Red Hat 9. Install was succesfull. After this I installed PostGIS...

bartvde@xs4all.nl

01-11-2004 03:18 PM
Tom Lane

Hi, I tried to remove a column by using the command ALTER TABLE tablename REMOVE COLUMN column1 But I got a message: "error: not yet...

small.witch@gmx.de

01-11-2004 03:02 PM
Tom Lane

On 21/11/2003, at 7:43 AM, Bryan Encina wrote: I have a different problem, but the same situation - the same upgrade 7.1.3 to 7.4, by a clean fresh...

Cath Lawrence

01-09-2004 07:11 PM
Tom Lane

Hi list, I just downloaded the source from PostgreSQL 7.4.1 and installed it on Red Hat 9. Install was succesfull. After this I installed PostGIS...

bartvde@xs4all.nl

01-09-2004 05:49 PM
Bruno LEVEQUE

On Fri, Jan 09, 2004 at 12:25:45 -0800, Bryan Irvine <bryan.irvine (AT) kingcountyjournal (DOT) com> wrote: I don't think there is an FAQ, but it...

Bryan Irvine

01-09-2004 04:47 PM
Steve Crawford

I'm having a really strange insert problem, which I cannot figure out. I have a table in my database, which I created using the following query (I'm...

Lola Lee

01-09-2004 06:59 AM
Martin Atukunda

Hi, I am trying to use an partial index on a varchar-coloumn as described in the documentation (section 11.7.) The commands I ran were: CREATE...

Martin Hampl

01-08-2004 04:14 PM
Tom Lane

"Stephen Shorrock" <smsh (AT) bas (DOT) ac.uk> writes: You need quotes. For mostly historic reasons, nextval takes a string argument containing the...

Tom Lane

01-08-2004 12:38 PM
Tom Lane

Hi! I've just suffered a serious disk meltdown. Successfully I've got all the files from pgsql 7.0 backed up. Now I have problem because 7.4 won't...

Marcin Gil

01-08-2004 11:14 AM
Tom Lane

Is there a way to see how many connections are open at a given time. We have a constantly running program gathering data and putting it into a table....

Rob Sell

01-07-2004 03:06 PM
Tom Lane

Hi, I'm moving from MySQL to Pg. MySQL lets me create indices like this: CREATE TABLE t ( id INTEGER NOT NULL, numba INTEGER ...

Andreas

01-07-2004 12:11 PM
Andreas

Rory Campbell-Lange <rory (AT) campbell-lange (DOT) net> writes: Since the function contains an UPDATE, I suspect this may be the same problem fixed...

Tom Lane

01-06-2004 01:00 PM
Tom Lane

Hi, I really don't understand the part of the docmentation about determining the disk usage of a database (section 24.1). The bit that puzzles me...

Martin Hampl

01-06-2004 12:56 PM
Bruce Momjian

Folks, I'm in need of a little pointer on how to do the following: I have a company-table and an employee-table. The employee-table has...

Maximilian Tyrtania

01-06-2004 11:49 AM
Bruno Wolff III

Hi Can we use postgresql in windows xp? I mean does it have any version which can work in XP or not? If so where can I download...

gavaneh

01-05-2004 07:19 PM
vhikida@inreach.com

Oops, Please forget about this, the mail wasn't finished yet. Sorry, -> Maximilian Tyrtania | Mty (AT) fischerAppelt (DOT) de fischerAppelt...

Maximilian Tyrtania

01-05-2004 12:04 PM
Maximilian Tyrtania

"Unable to Query DB: ERROR: You can't use relation names alone in the target list, try relation.*." Could any of you help explaining what this...

Nick Tew

01-05-2004 07:33 AM
Nick Tew

On Jan 5, 2004, at 12:13 AM, Michael Glaesemann wrote: On second thought, I think this SELECT isn't specific enough. This should be better: UPDATE...

Dan Jewett

01-05-2004 01:13 AM
Michael Glaesemann

Hi, as the subject says - if I do the same interactively in the interpreter, it works. I tried plsql < x.sql and plsql -f x.sql, both fail with...

Wolfgang Rohdewald

01-05-2004 12:41 AM
Tom Lane

Hulou, First, you will have to run initdb (as user postgres perhaps): #initdb -D /path/to/datadir/(owned by by postgres) -E (for encoding, perhaps...

Aarni Ruuhimäki

01-04-2004 04:22 PM
Aarni Ruuhimäki

I am converting 4 sites from C-ISAM (btree) to PostgreSQL which necessitates pretty well a full re-development. I am using Mandrake 9.2 + cooker so...

George Walsh

01-04-2004 03:19 PM
ghaverla@freenet.edmonton.ab.ca

Hi I am a novice in using postgresql and I've faced to a problem at the beginning of my work.... I have Linux OS on my computer and it has...

gavaneh

01-04-2004 10:04 AM
Bruno LEVEQUE

Further to my earlier posting, I have now figured out that I have to create clusters for each of the users in their own directory structures. I have...

G. Walsh

01-03-2004 11:45 PM
Bruce Momjian

G. Walsh, DSC Directional Services Corp., #507 890 Academy Close, Victoria, B.C. V8V 2Y1 (250) 386-4498 ---------------------------(end of...

G. Walsh

01-03-2004 11:44 PM
Bruce Momjian

If I create a table and assign the column type for what will be the primary key the value of "Serial", do I need to explicitly create an index...

Alan T. Miller

01-03-2004 05:38 AM
Sukellusseura Vesikot r.y.

Maybe this sounds stupid, but, where is the actual database file? I'm sure there's a file that is the actual DB, but...

Bryan Irvine

01-01-2004 06:09 PM
Michael Glaesemann

Hi, I posted this question via usenet to comp.databases.postgresql.novice once before but was not member of the list pgsql-novice. Sorry! I'm...

Olaf Ferger

01-01-2004 01:36 PM
Tom Lane

Hi, Mace, Richard wrote, On 12/31/2003 12:59 PM: you probably want this from php. Better to use, ask at comp.databases.postgresql.interfaces.php...

CoL

12-31-2003 06:25 PM
Michael Glaesemann