I have a long but straightforward query (on some very large tables) that always ends in 'Memory exhausted in AllocSetAlloc(108)'. Even stranger are...

Aaron Birkland

09-09-2004 10:19 PM
Tom Lane

I have a view like this: CREATE or replace VIEW program_member_this_year AS SELECT DISTINCT person.person_id FROM unit.person,...

Lee Harr

09-09-2004 04:12 PM
Lee Harr

Hello, I have some stuff coming back from the database telling me that columns that I have dropped are being retined inthe table renamed...

pw

09-09-2004 03:47 PM
peter Willis

Hello, How do I clear out dropped column names that appear in pg_attribute.attname automatically? Thanks, Pete

pw

09-09-2004 03:41 PM
Martijn van Oosterhout

It be at least dual opteron 64 w 4 gigs of ram runing fedora with a huge raid striped drives as single volume. A similar system and types of querries...

Vic Cekvenich

09-09-2004 12:56 PM
Oleg Bartunov

Date: Sun, 24 Aug 2003 23:25:24 +0200 ^^^^ The date's wrong on your computer. "ruben20 (AT) superguai (DOT) com" <ruben20 (AT) superguai (DOT) com>...

Bill Moran

09-09-2004 12:13 PM
Frank Finner

Dear Postgresql experts, According to the documentation for MOVE, it returns the number of rows that it has moved over. It seems to me that this is...

Phil Endecott

09-09-2004 11:28 AM
Tom Lane

Hi everyone. Im having a problem with heritage. The situation is the following: I have two tables, tbl_everyone and tbl_employees....

Sebastian Davancens

09-09-2004 09:10 AM
Mark Gibson

Hi, I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following error when I try and run a SQL query on a script: Error...

Daniel Secomb

09-09-2004 08:49 AM
Jeff Eckermann

Hello, * On the size of arrays : I did not find any info in the Docs on this. How many bytes does an array take on disk ? My bet would be 4 bytes...

Tore Halset

09-09-2004 07:56 AM
Pierre-Frédéric Caillaud

What is the performance or other benefits of text search on pgSQL vs mySQL on large dbs? thanks for any comments, ..V -- Please post on Rich...

Vic Cekvenich

09-09-2004 07:27 AM
Vic Cekvenich

What is the performance or other benefits of text search on pgSQL vs mySQL on large dbs? thanks for any comments, ..V -- Please post on Rich...

Vic Cekvenich

09-09-2004 07:21 AM
Vic Cekvenich

As per subject, i'm considering migrating a database (still in development) from MaxDB to postgresql. The main reason for this is that the stored...

John

09-09-2004 07:07 AM
John

On Wednesday 08 September 2004 02:44 am, tsarevich (AT) gmail (DOT) com wrote: now but I'm getting another syntax error:-) test-# SELECT prod_name...

Jerome Lyles

09-09-2004 03:29 AM
Jerome Lyles

Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> writes: Certainly the NSA hasn't stopped spending serious effort. What's changed is that now there is...

David Garamond

09-08-2004 11:23 PM
Tom Lane

For those of you interested in benchmark studies and other DB vendor's marketing...

Jean-Christian Imbeault

09-08-2004 09:46 PM
Andrew Rawnsley

On a nightly basis, we shut the database down and do a file system backup. A short chronology of our database problem: 8/21 - count(*) of user...

Wes

09-08-2004 06:08 PM
Wes Palmer

Im getting this error when trying to start postgres: FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied im running...

Alexander Cohen

09-08-2004 04:02 PM
Tom Lane

I see that a newly created database in 8.0.0beta2 now has tables sql_sizing, sql_sizing_profiles, sql_packages, sql_features,...

Ed L.

09-08-2004 03:28 PM
Stephan Szabo

Dear Group. I want to read vrml file and store the same in the postgresql.So please send me some links or solution to achieve...

Ashok......

09-08-2004 12:37 PM
Paul Thomas

I have the following insert to populate a new table: insert into pending_tnmt_sec select tseceventid, tsecsecno, nextval('sec_seq'), tsecrtddt from...

Mike Nolan

09-08-2004 12:33 PM
Tom Lane

Hi, Any suggestion to Rapid Application Dev with postgreSQL ? I have a small app to make. I would prefer open-source solution if possible. I also...

Eric

09-08-2004 12:21 PM
Scott Marlowe

Hello all, I have setup 2 groups on a database: admin users I have granted all on testing to admin and tried to grant select on testing to users; If...

UMPA Development

09-08-2004 11:40 AM
UMPA Development

Hi I am trying to work out if this is possible in a select query I have a group by query which could result in several rows, what I want to do is...

mike

09-08-2004 11:34 AM
mike

From: "Mário Gamito" <gamito (AT) netual (DOT) pt> by adding the 5th field where missing ? with something like: perl -pi.bak -e's/$/\t/ if...

gnari

09-08-2004 11:17 AM
gnari

On Tuesday 07 September 2004 10:22 pm, Dorward villaruz wrote: to produce this code. I can almost understand the sed command. Everything between...

Jerome Lyles

09-08-2004 08:48 AM
Greg Stark

Dear PostgreSQL experts, I have encountered a problem with temporary tables inside plpgsql functions. I suspect that this is a known issue; if...

Phil Endecott

09-08-2004 08:10 AM
John Sidney-Woollett

Hello, is there a possibility starting or stopping postgres database and creating database instance by JAVA? Is there some API available for this?...

juleni@livetrade.cz

09-08-2004 02:25 AM
Richard Huxton

All of my non-superusers are restricted from creating databases. Whenever I upgrade Postgres, I have to hand-edit my dump and change: CREATE USER...

David Garamond

09-07-2004 09:02 PM
David Garamond

Well, a simple example, this is the ninth month, I have some summaries that display monthly totals, It would be nice if I could simply print...

Jerry LeVan

09-07-2004 04:32 PM
Jeffrey Melloy

Hello, How come within a create schema block I cannot create a sequence? I have entered in: CREATE SCHEMA joe CREATE SEQUENCE joe_seq start 1 CREATE...

Joe Maldonado

09-07-2004 03:29 PM
Manfred Koizar

Tom Lane wrote: psql -d imperial -c "vacuum full verbose analyze;" 2> /usr/local/pgsql/vac.info which gives me exactly what I want. Thanks again...

Ron St-Pierre

09-07-2004 01:42 PM
Ron St-Pierre

Hi, I'm noticing NOTICE messages can't be turned off with my cygwin-based platform. I've had other's confirm it works on linux. Here is my...

Alex Soto

09-07-2004 12:27 PM
Alex Soto

I am experiencing a similar problem with PostgreSQL running on Debian. I am not doing anything special when it happens, just once and a while. It...

Andrew Janian

09-07-2004 11:25 AM
Andrew Janian

I am setting up a single PostgreSQL installation to be used by several users. Can I restrict a database user from connecting and creating objects in...

David Garamond

09-07-2004 10:41 AM
Oliver Elphick

Is there any way to convince explain to go do its thing when given a query with placeholders in it? I'm trying to do some performance checking of...

Dan Sugalski

09-07-2004 10:00 AM
Dan Sugalski

Hi there, I want to put a number of records (variable number depending on a attribute of a table) into a certain table with a trigger statement. I...

Dino Vliet

09-07-2004 09:54 AM
Dino Vliet

I guess it would be great if Pgsql had a way to find a database definition via a system stored procedure like other database platforms have. There...

Google Mike

09-07-2004 09:17 AM
Jeff Boes

I'd like to save the list of users, groups, and databases regularly to a separate file (just in case). The output of pg_dumpall suffices for my...

David Garamond

09-07-2004 08:47 AM
David Garamond

Hi, I have a set of libraries and C/C++ programs with embedded access to a PG database. I'm using ecpg. I'm working on a Linux RedHat9...

Valerie Schneider DSI/DEV

09-07-2004 08:29 AM
Valerie Schneider DSI/DEV

Hi All, I'm developing some scripts to create my schema to be run by other developers and I'd like to have them not spit out those NOTICE...

Alex Soto

09-07-2004 08:12 AM
Alex Soto

Hi all! Apologies for sending this mail but some time back there was a thread on supporting resilient transactions - i.e. transactions which do not...

Paramveer.Singh@trilogy.com

09-07-2004 07:00 AM
Jeff

Dear my friends... I am using SuSE 9.1 and postgres 7.2.x . Each time if I want to connect to postgres with postgres I do like...

Prabu Subroto

09-07-2004 06:56 AM
Oliver Elphick

Hi all! I am running postgres 8 beta1 and for some reason it is really slow in execution. I am not able to figure out why. On a fresh install of...

Paramveer.Singh@trilogy.com

09-07-2004 06:01 AM
Paul Thomas

Hello Hopefully someone can shed some light on the following issue. After chatting at irc.freenode.net/#postgresql, without success, this is my...

Henry Combrinck

09-07-2004 05:02 AM
Rory Campbell-Lange

Hi, I have a set of libraries and C/C++ programs with embedded access to a PG database. I'm using ecpg. I'm working on a Linux RedHat9...

Valerie Schneider DSI/DEV

09-07-2004 01:46 AM
Valerie Schneider DSI/DEV

It might be a good idea to place a reference to table 8-1 in the various subsections of the Datatypes section in the online postgresql documentation....

Randy Yates

09-06-2004 10:57 PM
Randy Yates

I had RH9 Linux. It came with pgSQL, but I couldn't seem to figure out how to get PL/pgSQL going. I read the HTML documentation that came with it and...

Google Mike

09-06-2004 07:11 PM
Google Mike

I have a table that stores TEXT information. I need query this table to find *exact* matches to the TEXT... no regular expressions, no LIKE queries,...

Jon Lapham

09-06-2004 05:23 PM
NTPT

Hi all, Can it speed things up to index the order by columns? Thanks. Hadley

Hadley Willan

09-06-2004 03:14 PM
Scott Marlowe