I think those best practices threads are a treat to follow (might even consider archiving some of them in a sort of best-practices faq), so here's...

David Helgason

01-15-2004 03:32 PM
Tom Lane

From the HTML docs: "The referenced columns must be the columns of a unique or primary key constraint in the referenced table." I personally don't...

Terry Lee Tucker

01-15-2004 03:26 PM
James M Moe

Hi all! I'm doing a research project on the motives of free software / open source software developers. This survey follows a somewhat different...

Ralph Spitzer

01-15-2004 02:39 PM
Ralph Spitzer

What about a SELECT syntax like that? SELECT CASE WHEN bar.foo_id IS NULL THEN bar.* ELSE foo.* FROM foo, bar Anyway, I need a SELECT query that...

Marco Lazzeri

01-15-2004 01:59 PM
Frank Miles

On Jan 15, 2004, at 6:50 PM, Chris Travers wrote: Okay. This much I think I follow. This part I'm not sure I understand. (Again, you're meaning...

Tom Lane

01-15-2004 01:23 PM
Richard Huxton

After a powerfailure of 10hours I have got my database server back up and the phpBB2 that a site uses is not working. Here is the error. Warning:...

danfisher@bwkip.com

01-15-2004 11:47 AM
Daniel E. Fisher

In Interbase and Firebird, NUMERIC is implemented as 64-bit integer. This limits the range to NUMERIC(18, *) but for many uses that's adequate. And...

David Garamond

01-15-2004 10:55 AM
Jan Wieck

Hi all! I have a big problem installing postmaster as a service under Windows XP with cygwin. I already installed postgresql on 2 machines...

Melanie Bergeron

01-15-2004 10:33 AM
Melanie Bergeron

Hi All, I'd like to "compress" the following two filter expressions into one - assuming that it makes sense regarding query execution...

Együd Csaba

01-15-2004 10:28 AM
Tom Lane

On Thursday 15 January 2004 14:25, Uros wrote: Possibly unrelated, but what is this variable? Also - make sure you haven't got a column called...

Richard Huxton

01-15-2004 10:01 AM
Richard Huxton

Hi, I would like to know if a daemon exist to intercept Oracle queries and translate to postgresql query... I have a windows app (AccPac) that...

Eric

01-15-2004 09:47 AM
Jan Wieck

Hi, i have a question about how to handle postgresql constraint errors in the client app. I found some mails in the archive about it, too. But i...

Janning Vygen

01-15-2004 04:44 AM
Janning Vygen

I'm restoring a full dump from a 7.3.3 system to a new 7.4.1 system and am getting a 'permission denied' error when it tries to create the...

Mike Nolan

01-15-2004 04:04 AM
Jan Weerts

My application does between 20-40 inserts per transaction. I am putting all of them into functions to limit the calls from the DBI to the...

Chris Ochs

01-15-2004 03:25 AM
Richard Huxton

I write this to tell you why we won't use postgresql even though we wish we could at a large company. Don't get me wrong I love postgresql in...

Bob.Henkel@hartfordlife.com

01-15-2004 01:52 AM
Uwe C. Schroeder

Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following --> update account_summary table --> update...

Thapliyal, Deepak

01-15-2004 12:04 AM
David Garamond

I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on...

Keith G. Murphy

01-14-2004 10:41 PM
Chris Travers

Any comments on multi-versioning problem: As far as I understand from PG documentation, *CURRENTLY* VACUUM must be run regulary, otherwise: -Q....

lnd@hnit.is

01-14-2004 04:16 PM
Christopher Browne

Hi, I have a simple question. I have been looking at the HTML docs for Postgres version: PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC...

Terry Lee Tucker

01-14-2004 01:23 PM
ezra epstein

Hi, Could someone help me with quoting this right? select into aliasvalue ''|| trim(arrayval) ||'' from ''|| trim(realname) ||'' where ''||...

A E

01-14-2004 12:57 PM
ezra epstein

I am pretty sure I know this already, but every time you run a Pl/Perl function it is just like running a perl script as far as having to load...

Chris Ochs

01-14-2004 12:40 PM
Joshua D. Drake

Hi, all: I have a schema definition, worked fine for PostgreSQL 7.2 and 7.3. But I saw errors when I use it on PostgreSQL 7.4. Can anyone tell me...

Zengfa Gao

01-14-2004 11:03 AM
Richard Huxton

Recently switched to 7.4.1 and noticed that there are now several schemas besides public. In addition even if I create the database...

Francisco Reyes

01-14-2004 10:52 AM
Francisco Reyes

Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> said: My apologies. I think you did answer my question though, that there isn't a well known problem as...

Jim Wilson

01-14-2004 09:46 AM
Jim Wilson

Is it possible to use the dblink and dblink_exec features from inside pl/pgsql functions to mimic the behaviour of nested transactions by calling...

John Sidney-Woollett

01-14-2004 08:54 AM
Tom Lane

Hi Everyone, I was wondering if there are some rpms available for Red Hat Enterprise Linux 2.1. I can only see the v3 ones on the FTP...

Hadley Willan

01-14-2004 07:59 AM
Sander Steffann

Hi, I use PostgreSQL 7.4 for storing huge amount of data. For example 7 million rows. But when I run the query "select count(*) from table;",...

Sezai YILMAZ

01-14-2004 07:50 AM
Shridhar Daithankar

Andrei Ivanov <andrei.ivanov (AT) ines (DOT) ro> writes: I could not reproduce the "out of memory" failure using this information (I got "invalid...

Andrei Ivanov

01-14-2004 04:50 AM
Andrei Ivanov

Can I use a "set transaction" type mechanism within a function? thx Deep -----Original Message----- From: Joshua D. Drake Sent: Tuesday, January...

Thapliyal, Deepak

01-14-2004 04:24 AM
Paul Thomas

Is there any (simple? har!) way to optimise a particular SQL query? At this stage, I'm more interested in making the query more readable, so I've...

Alex Satrapa

01-13-2004 11:51 PM
Martijn van Oosterhout

On Fri, Dec 12, 2003 at 04:24:32AM +0100, Florian G. Pflug wrote: No, you're not. You can update to 7.3.5 by just dropping the new executables...

Florian G. Pflug

01-13-2004 09:59 PM
Tom Lane

I'm struggling using COPY FROM. COPY ... FROM STDIN expects stdin to be whatever file is being processed, so: $ cat data_file.txt | psql -f...

ezra epstein

01-13-2004 06:38 PM
ezra epstein

I am trying to move all of the sql statements from my code into a pl/pgsql function. I have one function for a transaction block that contains...

Chris Ochs

01-13-2004 06:16 PM
Tom Lane

I am developing a java/postgresql application using ant and junit. I want to deploy tested builds along with matching tables in postgresqlwith test...

Phil Campaigne

01-13-2004 05:22 PM
scott.marlowe

On Tue, Jan 13, 2004 at 14:50:25 -0500, "Daniel E. Fisher" <danfisher (AT) bwkip (DOT) com> wrote: Its a good idea to keep these discussions on...

Daniel E. Fisher

01-13-2004 03:07 PM
Bruno Wolff III

Having email problems excuse the post ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our...

John Allgood

01-13-2004 02:46 PM
John Allgood

Running a RH 9 system with postgres 7.3.2-3 I come back after vacation and my system shutdown cause of a powerouttage on the block. I restart and i...

Daniel E. Fisher

01-13-2004 01:26 PM
Daniel E. Fisher

The documentation doesn't have any examples of using an sql language function to do an insert, andI am at loss as to I am doing wrong here. The error...

Chris Ochs

01-13-2004 12:53 PM
Richard Huxton

I am currently searching some resources, why and where the PostgreSQL GEQO-Engine improves large join queries. The theoretical background is clear,...

Bernd Helmle

01-13-2004 11:13 AM
Bernd Helmle

i have always tended towards building simple user authentication structures into the application, rather than the database. historically i've been a...

Julian North

01-13-2004 10:39 AM
Julian North

Dear all, i have a problem with insertion data and running post insert trigger on it. Preambula: there is a table named raw: ipsrc | cidr ipdst |...

Anton.Nikiforov@loteco.ru

01-13-2004 09:51 AM
Tom Lane

While migrating to 7.4, which performs quite nicely btw, I must have performed some sequence of the migration incorrectly. Now, when I use pg_dump on...

Mike Mascari

01-13-2004 09:11 AM
Tom Lane

I am getting this error postgres=# \i a.sql psql:a.sql:10: ERROR: parser: parse error at or near "return" at character 26 -- a.sql --

Thapliyal, Deepak

01-13-2004 06:31 AM
Richard Huxton

"Steven O." <Steven (AT) OpZZREMOVE_ALL_Zs_AND_ALL_BETWEEN_ZZComm (DOT) com> wrote: hh73001fej4r1hotrvk030ubmpffdc6r0a (AT) 4ax (DOT) com... on SQL...

William ZHANG

01-13-2004 05:59 AM
William ZHANG

Hi folks, Guess this has been hashed b4.. But I would like to know if PITR is supported yet? If no, can you pls advice in which version will...

Thapliyal, Deepak

01-13-2004 05:28 AM
Richard Huxton

Is there any way in Postgres to SELECT a list of table names from inside of a C program using ECPG? Something similar to SELECT current_user that...

Eric Freeman

01-13-2004 02:40 AM
Chris Travers

Hello everybody! Does someone know how to build hierarchical queries to the postgresql? I have a table with tree in it (id, parent) and need to...

Anton.Nikiforov@loteco.ru

01-13-2004 01:55 AM
Anton.Nikiforov@loteco.ru

As far as I can tell, there isn't a way to get postgresql to accept column qualifiers (e.g. tablenames). A 'parse error at or near "."' gets...

Jim Wilson

01-12-2004 10:56 PM
Tom Lane

Hi, I have two tables with the following DDL: CREATE TABLE job ( job_pr SERIAL PRIMARY KEY, jobid INTEGER, job_name VARCHAR(25), owner_name...

Steve

01-12-2004 10:47 PM
Steve

I am running 7.2 and when doing a vacuum I am getting the following error.... ERROR: Cannot insert a duplicate key into unique...

Dave Smith

01-12-2004 10:43 PM
Tom Lane