Hi Everybody, I am having problems while installing pgbench program. I followed the below procedure to install according to the docs: (1)...

Pallav Kalva

11-08-2004 10:01 AM
Pallav Kalva

(re-post) Dear list, Please let me know if this is not the list to ask this kind of question. I am trying to optimize a query that joins two...

Morten K. Poulsen

11-08-2004 09:58 AM
Morten K. Poulsen

You could try DbDesigner(4) at http://dbdesigner.sourceforge.net/ -----Message d'origine----- De : Johan Wehtje Envoyé : lundi 8 novembre 2004...

Masse Jacques

11-08-2004 05:45 AM
Masse Jacques

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Here's a question for the SQL guru's out there, which I've been trying to solve for the last couple...

Uwe C. Schroeder

11-08-2004 04:38 AM
Uwe C. Schroeder

What version of postgres are you using? In postgresql-7.4.6, I get an empty query buffer when I try what you describe here. -tfo -- Thomas F....

Patrick Hatcher

11-07-2004 10:36 PM
Thomas F.O'Connell

At the risk of asking an ill-formed oft-asked question that's probably in the FAQ, is there any report generation tools that are particularly suited...

Randy Yates

11-07-2004 04:06 PM
Ned Lilly

Hello, I have a table with a rule that goes something like this: CREATE OR REPLACE RULE sometable_delete ON DELETE DO delete FROM cache WHERE...

Net Virtual Mailing Lists

11-07-2004 01:47 PM
Stephan Szabo

Hello, Lets say I have data like this: value1|value2|value3|value4|....|value(N) ------|------|------|------|----|-------- 100 | 200 | 300 | ...

Net Virtual Mailing Lists

11-07-2004 04:19 AM
Arjen van der Meijden

Iam trying to import data from ms-sql server to postgres. I export the data which has datetime columns in sql server using BCP. I use the following...

Goutam Paruchuri

11-07-2004 01:53 AM
Sim Zacks

I'd like to have a DB client connect using a username ('psuedodba') different from the creator/owner ('dba') of the DB and its tables, but still have...

Ed L.

11-06-2004 01:58 PM
Peter Eisentraut

I don't seem to be able to connect to gborg.postgresql.org this evening... Jerry ---------------------------(end of...

Jerry LeVan

11-06-2004 10:27 AM
Alvaro Herrera Munoz

Hi, How can i get the Client Host name/IP Address for the current connection(session). Is there any function or system table(view) which will these...

Mario A. Soto Cordones

11-06-2004 10:02 AM
Mario A. Soto Cordones

Hi, Anybody know/have functions or package to create text file from postgres function? I want to execute a function to take some fields from a...

Leo Martin Orfei

11-06-2004 09:10 AM
Tino Wildenhain

* We in Calicut UNIversity using posgresql in our examination wing. Now we can not use our database. It gives some message as follows. XLogFlush :...

madhu v t

11-06-2004 07:01 AM
madhu v t

I searched through the net quickly and the list archives, but could not find anything doing this. Is it possible? There is a Perl module for doing...

Robert Fitzpatrick

11-06-2004 12:46 AM
Bruce Momjian

Is there some clear reason why I can't using EXECUTE of a PREPAREd query as I can a SELECT statement in CREATE TABLE AS, INSERT, FROM...

Andrew Lazarus

11-05-2004 11:59 PM
Neil Conway

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Are there any people in this community who keep blogs of their PostgreSQL lives? We are working...

Devrim GUNDUZ

11-05-2004 04:03 PM
Devrim GUNDUZ

Hi. anybody know how to sen a parameter an a trigger. thank for your help Mario Soto

Mario A. Soto Cordones

11-05-2004 04:00 PM
Michael Fuhr

i am currently migrating a db from Oracle to Pg and in some of my triggers i use variables, i.e. i have some thing like this: CREATE OR...

Vassilev, Lubomir G.

11-05-2004 03:27 PM
Vassilev, Lubomir G.

This is postgres 7.4 on a linux box ... I have driven myself to distraction trying to what ought to be easy. I have a table with house number,...

Gregory S. Williamson

11-05-2004 01:34 PM
Gregory S. Williamson

Hello everyone: I am attempting to upgrade from 7.2 to 7.4 Postgresql. I have successfully installed 7.4 and am attempting to use the pgdump from...

Bob Powell

11-05-2004 11:29 AM
Peter Eisentraut

Hi all, I have to develop an embedded database with PostgreSQL. I have a Linux Distribuction that works only in single user mode as root. The...

stefari@tiscali.it

11-05-2004 11:19 AM
Tom Lane

On Wed, Oct 27, 2004 at 09:21:39AM +0200, Thomas Hallgren wrote: How can there be a "canonical list of known timezones" if every operating system...

Bruno Wolff III

11-05-2004 10:39 AM
Tom Lane

Hi all, I have to develop an embedded database with PostgreSQL. I have a Linux Distribuction that works only in single user mode as root. The...

Stefano Farina

11-05-2004 10:24 AM
Stefano Farina

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Fri, 5 Nov 2004, Sally Sally wrote: AFAIR, you have to REINDEX pg_type to get rid of this...

Devrim GUNDUZ

11-05-2004 10:21 AM
Devrim GUNDUZ

Hi, i would like to check for a given query (insert, update, delete) if there is a key or constraint violation which prevents the query from being...

Alex P

11-05-2004 09:50 AM
Csaba Nagy

Hi all, What are the characters used for pattern matching with PostgreSQL 7.3. I know it is using % and _ . Any other characters ?. rgds Atnony...

Antony Paul

11-05-2004 07:40 AM
Tk421

I am trying to install PostgreSQL on OS X 10.3, using the package from Entropy.ch. The installation instructions there, as well as anywhere else I...

Nathan Mealey

11-05-2004 05:20 AM
Joel

Hi I have just released SHSQL under the GPL, it is a method how SQL can be easily integrated into shell scripts. The web site is at...

Eddy Macnaghten

11-05-2004 01:05 AM
Eddy Macnaghten

I would like to be able to truncate all of the tables in a schema without worrying about FK constraints. I tried issuing a "SET CONSTRAINTS ALL...

David Parker

11-04-2004 03:36 PM
Tom Lane

My guess is that you will get better performance from a similarly priced Dual Opteron for the following reasons: 1) OS-X is not 64-bit yet, 64-bit...

Jeff Bohmer

11-04-2004 03:35 PM
Timothy Perrigo

What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0? Is it still considered an important maintenance task? If so,...

Ed L.

11-04-2004 03:08 PM
Vivek Khera

Hi! I have to select a random row from a table where primary key isn't continuous (some rows have been deleted). Postgres just seems to do something...

Kari Lavikka

11-04-2004 12:56 PM
Kari Lavikka

Hello all, I have a few somewhat simple questions.... Does the postmaster vacuum it's internal (pg_*) tables? if not what is the best way to vacuum...

Joe Maldonado

11-04-2004 11:46 AM
Richard Huxton

I am generally interested in a good solution for this. So far our solution has been to increase the hardware to the point of allowing 800...

Kevin Barnard

11-04-2004 11:00 AM
Kevin Barnard

People, I will visit Seoul, Korea to attend "3rd Northeast Asia OSS Promotion Forum" from Dec 1st to Dec 5th. I would like to meet with someone...

Tatsuo Ishii

11-04-2004 03:09 AM
Tatsuo Ishii

I am running a web-based accounting package (SQL-Ledger) that supports multiple languages on PostgreSQL. When a database encoding is set to Unicode,...

Edmund Lian

11-03-2004 11:45 PM
Michael Glaesemann

While dealing with filesystem bloat issues, I found a large file named 43710738, recently updated and sitting in one of my database directories, $...

Ed L.

11-03-2004 05:56 PM
Tom Lane

Hi, Is there a way to translate information in pg_xlog files to a more readable format? Basically we have someone accidentally emptied a text column...

Reynard Hilman

11-03-2004 03:14 PM
Tom Lane

Is there a function that will give me the number of months, as an integer, in Pg 7.4.x? I found the date_trunc function but that will return text...

Patrick Hatcher

11-03-2004 03:08 PM
Franco Bruno Borghesi

I'm looking for a function that returns a md5 encryption for postgreSQL 7.3.4 I've found that this function exists on version 7.4, but I have had...

Tk421

11-03-2004 01:33 PM
Joe Conway

Hello: I'm trying to use kylix3 and postgresql 7.4.1. My distro was Debian Woody, kernel 2.20. I make the link /usr/local/pgsql/lib/libpq.so...

Carlos Ojea Castro

11-03-2004 12:49 PM
Uwe C. Schroeder

I am going to sync a schema in postgres with one in an oracle db. The tables are simple, but there are 200 of them. I would like to try to keep the...

Randall Smith

11-03-2004 10:57 AM
Randall Smith

I reconfigured the redhat startup script for postgresql to work with version 8 and that is working fine. I thought I could put autovacuum in the...

Sim Zacks

11-03-2004 08:34 AM
Sim Zacks

Hi All, I hope this is the correct mailing list for this question. But neither postgresql.org nor google could help me out on this subject. I did...

M.A. Oude Kotte

11-02-2004 08:57 PM
Paul Tillotson

I'm still mulling the best way to handle this situation. I have a table that describes work to be processed. This table includes a description of...

Steve Crawford

11-02-2004 06:30 PM
Steve Crawford

I assume I'm not the first person to have encountered this, but I couldn't find anything in the FAQ or on the mailing lists recently. My apologies if...

Randall Nortman

11-02-2004 05:48 PM
Steve Crawford

Hi, First I'm trying to move a MySQL database to Postgres. I have to emulate a MySQL sql statement - ''Describe tablename' which in general is...

John Fabiani

11-02-2004 04:24 PM
Alvaro Herrera

Hi all, I am using an Access client linked to a PG 7.4 server via ODBC. I have a stored proc on the server that inserts rows into a table.particular...

Eric E

11-02-2004 11:14 AM
Eric E

Will there be a release 7.4.7 in the future? When can the production release of 8 be expected? thanks Alex ---------------------------(end of...

Alex P

11-02-2004 10:09 AM
Bruno Wolff III