PostGreSql 7.4.3 Am I right in assuming that a foreign key on a table does not explicity create an index on that column on the foreign table? I can...

Steve Tucknott

08-27-2004 04:16 PM
Steve Tucknott

I have recently noticed that there are ~22 postmaster processes that are "idle in transaction". They are definitely caused from a web/Apache...

Doug Silver

08-27-2004 02:12 PM
Doug Silver

Hi! I'm new to PostgreSQL (and C) and what I'm trying to do is to store a query plan on disc (in a binary file). My approach is to use SPI functions...

Katsaros Kwn/nos

08-27-2004 10:34 AM
Tom Lane

I have a view from which I select values, but I need to do a 'SELECT DISTINCT' query on a 'varchar' column and order by lower case eg: SELECT...

Jake Stride

08-26-2004 08:05 PM
Luiz K. Matsumura

With lots of help from folks on this mailing list, the readme files and other net sources, i've found a simple process for seeting up an WinXP box as...

operationsengineer1@yahoo.com

08-26-2004 01:11 PM
A Gilmore

How can I find out what object corresponds to a given OID in the relation column in the pg_locks table? Thanks in...

Frank Kurzawa

08-26-2004 12:01 PM
Tom Lane

I have a table with a text column and I'd like to find entries matching "pattern*" in that column. When using a between i get: sd=> explain analyze...

Jesper Krogh

08-26-2004 03:27 AM
Jesper Krogh

I know I know, this topic is probably a cliche by now, but I am looking for real world developers' and DBAs' experiences from people who have...

Kunal

08-25-2004 11:50 PM
Kunal

Hi Okay... you guys said "No question is too simple here", so here I go... I see 4 directories/ folders in...

Kunal

08-24-2004 07:30 PM
Hisashi Wakai

Hello. I have a function that creates a long TEXT string that looks like...

Betsy Barker

08-24-2004 07:28 PM
Betsy Barker

Tom tom, If you're usng 7.4, you can drop the public schema, which will drop all objects in it: DROP SCHEMA public CASCADE; However, you may not...

Josh Berkus

08-24-2004 04:07 PM
Oliver Elphick

the inquirer <listquestions (AT) yahoo (DOT) com> writes: It looks like you would rather use password authentication than the default IDENT-based...

Tom Lane

08-24-2004 03:16 PM
Tom Lane

Our web-based app suffers occasional dramatic slowdowns which appear to be due to occasional contention for locked database resources. I've done the...

Frank Kurzawa

08-24-2004 01:47 PM
Frank Kurzawa

Our application currently runs in SQL Server and we are porting it over to Postgres. When we write enbedded SQL queries for SQL Server, we need to...

Mark Dexter

08-24-2004 01:46 PM
Mark Dexter

Hi guys, After some tests, I have a couple questions regarding temporary tables in Postgres... Hope someone more knowledgeable can drop me a few...

Marcus Andree S. Magalhaes

08-24-2004 11:55 AM
Tom Lane

Hi, I'm using PostgreSQL 7.4.3 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.4 (Debian 1:3.3.4-3). I'm fine with most things...

tim hall

08-24-2004 10:57 AM
Oliver Elphick

PostGreSql 7.4.3 I have a function that 'audits' inserts / updates on other tables - I have put timetraps in the code to see why it takes so long....

Steve Tucknott

08-24-2004 09:18 AM
Michael Glaesemann

It has been impossible to install PostgreSQL, an open source software, from my SUSE 8.0 . Although it tells you its been installed, each time i try...

Eyinagho Newton

08-24-2004 08:27 AM
Martin Atukunda

--- Michael Glaesemann <grzm (AT) myrealbox (DOT) com> wrote: !!!!!!!! Man, I can't believe I actually wrote that! Where's that "withdraw mail"...

Kunal

08-24-2004 07:21 AM
Bruce Momjian

On Tue, 2004-08-24 at 10:25, Steve Tucknott wrote: There is one in pgaccess -- Oliver Elphick olly (AT)...

Oliver Elphick

08-24-2004 05:47 AM
Oliver Fromme

PostGreSQL 7.4.3 (RedHat 8) Is there a 'monitor' utility that shows connected sessions details (ie who is connected, what they are executing...

Steve Tucknott

08-24-2004 05:25 AM
Steve Tucknott

I'm using CoLinux (colinux.org) and PostgreSQL, every 10-20 minutes my HD and CPU go to massive use for about 5 minutes and I am very curious about...

Vitaly Belman

08-23-2004 04:30 PM
Arthur van Dorp

I did a search for this error *dup(0) failed after 3195 successes: Bad file descriptor* and came up empty as far as resolutions. Some references...

operationsengineer1@yahoo.com

08-20-2004 11:15 AM
Tom Lane

dear lady or gentleman, I just downloaded the win version 8.0 beta 1 on my Win2K system and compiled a test program under cygwin ecp x1.cpc ; cp...

tausenddoof

08-20-2004 06:52 AM
tausenddoof

Hello, I'm currently involved in determing if PG 8.0 fulfill our expectations and it is applicable to upgrade our current versions of Pg 7.4& 7.3...

Renê Salomão

08-19-2004 01:16 PM
Bruce Momjian

Hello, I am about to begin my first installation of PostgreSQL. :-) At the moment I am installing Red Hat Linux ES v3 on a brand new machine...

Keith Worthington

08-19-2004 02:03 AM
Arthur van Dorp

Hello, I have a little problem. I suppose that this question is stupid but... When I start the configure it gave me the following error: checking...

Kaloyan Iliev Iliev

08-19-2004 01:46 AM
Arthur van Dorp

Hi All I have a script that went haywire and created 2 databases with what looks like empty names OR names made up of spaces. Here is the output of...

Jonathon Batson

08-19-2004 12:00 AM
Tom Lane

After finally getting pgsql to operate in basic mode, I've hit a snag with pgAdmin3: **Error connecting to the server: could not connect to the...

operationsengineer1@yahoo.com

08-18-2004 09:52 PM
George Weaver

hi, i have a btree index on col1 in table1. The column has either values 1,2,3, or 4. 4 does not appear that much in the table (only 5...

Amir Zicherman

08-18-2004 02:18 PM
Bruno Wolff III

Can anybody help get me started here? I've downloaded the 8-beta .msi file and ran set up on my XP Home laptop. Now I have no clue what to do. I...

operationsengineer1@yahoo.com

08-17-2004 10:56 PM
Josh Berkus

pg_attribute has way too many row versions, how can I find out what's holding a reference to these row versions? I would expect at most 4-5K row...

Michael Guerin

08-17-2004 03:48 PM
Tom Lane

How does one capture the result status of an ALTER command inside plpgsql code block? For example: ----------------- CREATE OR REPLACE FUNCTION...

jarednevans@yahoo.com

08-17-2004 01:08 PM
jarednevans@yahoo.com

I need to know why MS Access/ODBC is reporting different results than psql. I created a very simple function below: ------------------ CREATE OR...

jarednevans@yahoo.com

08-17-2004 12:46 PM
jarednevans@yahoo.com

Hi all, Thanx for all your valuable inputs. I have tried all the suggestions....they seem to be working fine....Thanks a lot. -----Original...

Pradeepkumar, Pyatalo

08-17-2004 12:17 AM
Pradeepkumar, Pyatalo

Hello group, I am newbie to postgrSQL and also databases. I am making a database of proteins. In one table I have 4 columns. Is it possible that...

Kumar S

08-16-2004 02:43 PM
Davis, Sean

I'm having a problem with using LOCK TABLE within a function (stored procedure) or outside a function. The lock is not working for me when i run...

Amir Zicherman

08-16-2004 10:24 AM
Tom Lane

How can I improve the performance of my ecpg based program in version 7.4.2 of Postgresql. The structure of my code looks like the...

Steve McAllister

08-15-2004 06:29 PM
Steve McAllister

What is the correct syntax for the following. I have table A joined to table B and C. I also have table A left outer joined to tables D and E and in...

Steve Tucknott

08-14-2004 12:57 PM
Steve Tucknott

Hi, I am having a table something like this.... CREATE TABLE(PointId integer, PointName varchar(50),PointType integer, createtime bigint); where...

Pradeepkumar, Pyatalo

08-13-2004 01:34 PM
george young

I'm at a crossroads with PGSQL. I want to use it with PHP to develop web databases as part of my job. I've developed using Access and Visual Basic,...

Skeets

08-13-2004 01:27 PM
Josh Berkus

Did you start the postmaster with the -i flag. If not, you might try that. Sean On Aug 10, 2004, at 12:31 PM, Michal Lijowski...

Sean Davis

08-13-2004 01:01 PM
Sean Davis

Eduardo, One possibility is to do the queries using DBI in perl. There are many packages for simple statistics and graphics in perl that you can...

Sean Davis

08-13-2004 10:47 AM
Sean Davis

Hi, I am migrating a database to postgresql, with a data schema change. I'd need to do some stress testing (on the db design I have, not a general...

Raphael Bauduin

08-13-2004 04:14 AM
Raphael Bauduin

Can anybody help get me started here? I've downloaded the 8-beta .msi file and ran set up on my XP Home laptop. Now I have no clue what to do. I...

Jeff Skeith

08-12-2004 10:19 PM
Jeff Skeith

I'm new to SQL and I am having a little difficulty trying to construct a query that will use the first table in the following list: TABLE...

ExpoShare.com

08-12-2004 12:53 PM
ExpoShare.com

Hi, Does a function executed by a trigger know which table fired the trigger? I'm using the same function for several triggers on different...

Raphael Bauduin

08-12-2004 08:00 AM
Herbie

PostgreSQL 7.4.3 / RedHat 8 What is the best admin tool to use with PostgreSQL? At the moment I am using pgaccess and psql - but I've heard...

Steve Tucknott

08-12-2004 03:56 AM
Steve Tucknott

Hi, I have a query regarding the SCHEMA INFORMATION. I require following information about a database i.e 1)How many tables are there? 2)What are...

Rajan Bhide

08-12-2004 02:52 AM
Bruno Wolff III

Hi, Saw the new Beta of PostgreSQL had a Windows installer, so I took a stab at it. My machine is running Windows XP on a Dell 2GHz 512MB RAM...

Chris Means

08-12-2004 12:33 AM
mike g