Good morning, Currently my company is in the process of moving from an Oracle to a Postgres environment. One of the challenges we're facing is...

David McNelis

01-27-2007 03:09 AM
jpd

I have a sql query that does not provide the correct counts. select location.name as "location Name", count ( case when incident.location_type = 138...

Bigjim

01-26-2007 12:25 PM
Bigjim

Hi, I am under debian sarge and it is running well. I've been trying to install postgreSQL 7.8.4 and it was working. After trying to customize my...

news.free.fr

01-17-2007 08:42 PM
roGGery

Hi, I would like to upgrade a Suse 9.3 from postgres 8.0 to 8.1 (preferably), because I develop on my local machine which has postgres 8.1 installed...

M. Strobel

01-17-2007 06:59 AM
Laurenz Albe

LOG: could not receive data from client: No connection could be made because the target machine actively refused it. I get this message during a...

Rocky Phelps

01-15-2007 10:00 PM
Bruce Lewis

Hi, I have problems to use the silent installation explained at http://pginstaller.projects.postgresql.org/silent.html to install postgres8.2. I want...

Carsten Hammer

01-08-2007 03:02 PM
Carsten Hammer

When a table is inherited, sequence doesn't increase by 1 but by more than 1. For example, let be defined table parent with CREATE TABLE parent(id...

karas

01-04-2007 07:45 AM
Laurenz Albe

Hello, I experience unstable behaviour of PostgreSQL 8.1, running a Java data import program using JDBC. It is showing the following message in the...

Yourdon

01-03-2007 11:57 AM
Yourdon

i'm creating a db to store mail account's data user by postfix i created the tables, i inserted some test accounts and i created an user (postfix)...

BLADELA

12-27-2006 03:23 AM
Laurenz Albe

Hello, I don't know if this is a stupid question to ask or not, but I am currently writing a backup application for Postgres. I am using shell...

Fuzzydave

12-22-2006 03:49 AM
Laurenz Albe

Has anyone used PostgreSQL with Datacard ID Works version 5? We tested version 4 successfully, but version 5 uses OLEDB, and we haven't found a setup...

Al Balmer

12-19-2006 12:17 PM
Al Balmer

I am writing a backup application currently and I am working on the shell scripts that will handle the pg_dumpall and pg_restore functions. One of...

Fuzzydave

12-15-2006 09:10 AM
Laurenz Albe

I have looked and looked, and cannot find an answer to a simple challenge. I want to export a CSV file from postgres, but I would like to...

kinaole

12-13-2006 06:57 PM
HansH

Michael Ruf <usenet.rufmichael (AT) gmx (DOT) de> wrote: Thanks for sharing this, it is most useful! Yours, Laurenz Albe

HansH

12-13-2006 11:00 AM
Laurenz Albe

I have a database with the log entries from my Apache log. Right now I have only one table which is the log entry split into fields. The...

Perry Smith

12-12-2006 02:44 AM
Laurenz Albe

US Based Internet development company seeking to establish an ongoing relationship with one programming team. You must be able to develop...

WH

12-11-2006 12:55 PM
WH

When I execute ps on my linux server I can see: .... 8021 ? S 2:51 \_ postgres: vt tdb 127.0.0.1(51399) idle 8037 ? S 9:35 \_...

pbr

12-11-2006 11:30 AM
HansH

Hi all. I have installed Freebsd 6.1 with PostgreSql Server 8.1. I can run server when I first log, as root user, and after that I log as...

GvaderTh

12-03-2006 12:37 PM
Riemer Palstra

Hi, My problem is that in one of my tables I have a column for 'name'. It can have from two to ten or mores words in it, separated by spaces. It's...

Luis P. Mendes

11-30-2006 12:48 PM
Luis P. Mendes

I am a student working on a team project using postgres 8.1. When I install the db initially, everything works fine. However, once I restart my...

clowtown

11-21-2006 12:43 PM
clowtown

Forgive me if this question is a bit too generic, if it is, feel free to just not respond. I have a database which has been running in PostgreSQL...

Engada

11-20-2006 03:39 AM
Laurenz Albe

Hi - I'd like to return search results based on a date range that is selected by the user : <select name="date1yy"> <option value="1995-01-01"...

One

11-16-2006 05:10 PM
Ch Lamprecht

The following in the pg_hba.conf file allows "some" computers on our network to connect PostgreSQL on the machine...

O.B.

11-13-2006 03:35 PM
jpd

Hi Group! I am trying to work & connect php wirh PGSQL on Red Hat ES 3. I got some Important path...

jatrojoomla

11-13-2006 03:25 AM
Laurenz Albe

Sascha Bohnenkamp <bohnenkamp (AT) mevisbreastcare (DOT) de> wrote: For PQexec(), write array literals as you would in psql. If you intend to use...

Laurenz Albe

11-10-2006 03:44 AM
Laurenz Albe

Sascha Bohnenkamp <bohnenkamp (AT) mevisbreastcare (DOT) de> wrote: If you are looking for a C header file, it...

Laurenz Albe

11-10-2006 02:57 AM
Laurenz Albe

We're converting an Informix application to Postgresql. We relied on the sqlca structure to report the number of rows changed and errors, but the...

Al Balmer

11-08-2006 09:54 AM
Al Balmer

Sascha Bohnenkamp <bohnenkamp (AT) mevisbreastcare (DOT) de> wrote: I am afraid that the only documentation for this is the source code. Also, look...

Laurenz Albe

11-07-2006 09:04 AM
Laurenz Albe

Michael Ruf <usenet.rufmichael (AT) gmx (DOT) de> wrote: I looked into it, and (unfortunately for you) things are working as designed. This is a...

Laurenz Albe

11-06-2006 05:30 AM
Laurenz Albe

Hello all, I was going through the ingres code, and found this comment: /* Give up if unable to get memory in one minute */ Arrrrgggg!!!! Time...

dhruv

11-04-2006 10:08 AM
Kees Nuyt

First let me say I am not a database expert, so I hope my question makes sense. I apologize in advance if my question isn't worded...

eldorado

11-02-2006 02:45 PM
eldorado

Hello, I am trying to find a solution to the following problem: Given a table: CREATE TABLE public.test ( id integer , date date, text varchar,

Ch Lamprecht

11-02-2006 03:27 AM
Laurenz Albe

Hello everyone. I have created the following table: CREATE TABLE public.books ( name VARCHAR PRIMARY KEY );

Dynomath

10-27-2006 10:57 AM
Dynomath

Is there anything free like MySQL Migration Toolkit ? Guido

Guido Noe'

10-26-2006 01:39 PM
Christof Thalhofer

Hello there, in former times (i. e. Borland Paradox) there was a data type named "Blob" (= Binary Large OBject) which was used to store pictures...

Frank Werner

10-25-2006 11:30 AM
Laurenz Albe

Hello, I'm going to ask the same question as I previously asked in berkeley-db newsgroup: I'm coming from an MS-database world, using Access with...

Vivien Parlat

10-22-2006 06:01 PM
fathibn@free.fr

Begin <wNCdnUekcoY3CqvYnZ2dnUVZ_vmdnZ2d (AT) comcast (DOT) com> On 2006-10-18, Jimmy Zhang <crackeur (AT) comcast (DOT) net> wrote: Is this the...

jpd

10-18-2006 09:18 PM
jpd

Hello. I have been looking around in the documentation for the solution to my problem, but I have found nothing. I have a table lik this: test=#...

Thomas H. Espe

10-13-2006 10:27 AM
Laurenz Albe

I'm porting a number of programs from Informix embedded SQL to postgreSQL, and ran into the following problem. The optim_accounts.ec program included...

Al Balmer

10-11-2006 10:55 AM
Al Balmer

Hi all, I want to copy a table with constraints, indexes, .... But with the "SELECT * INTO MyTableCopy FROM MyTable" the column's properties aren't...

Manu

10-11-2006 08:52 AM
HansH

Hi! I do the following with postgresql. First I disable auto-commit, then create table tab ( col varchar(30), constraint colunq unique...

Ralf Wiebicke

10-10-2006 05:08 AM
Ralf Wiebicke

Hi, Is postgresql manual available in Texinfo format? I'm an emacs user and I'd appreciate to read the documentation within my...

Matthias

10-07-2006 06:57 AM
Andreas Seltenreich

Hi all, I have a question regarding rules, in particular when the where clause is evaluated. Here my case: I store output from metalog also in...

Klaus Dahlke

10-05-2006 03:43 PM
Klaus Dahlke

Hi, I've created the following table as an example from a bigger one: # \d lixo Table "public.lixo" Column | Type |...

Luis P. Mendes

10-03-2006 03:46 PM
Luis P. Mendes

Perhaps posted it on wrong forums initially as I got only one response (which was helpful but I was looking for more). Please help if you...

10-03-2006 02:57 AM
The|Godfather

Hello, Is there a way to gatehr postgresql statistics via snmp, so it could be monitored via cactus or HPopenview ?

fathibn@free.fr

10-02-2006 12:51 AM
fathibn@free.fr

After getting slony to run succesfully on one server with simply two local databases as master and slave, the other one appears to be more of a...

Steven Mocking

09-29-2006 02:25 PM
Steven Mocking

Hello, I'm running PostgreSQL 7.3.15 on a RedHat Enterprise 3 dedicated server for website hosting. The system is a P4 2.8 Ghz with 4 GB RAM. Can...

AndyX

09-29-2006 01:40 AM
Laurenz Albe

Hi Folks, This is my first post to this group, and of the 100 threads appearing when I subscribed, I haven't seen any mention of the problem. Nor...

R. Joseph Newton

09-27-2006 11:12 PM
R. Joseph Newton

What is the most accurate way of determining how much space is currently being utilized by a table or index? I know about looking up the relfilenode...

mike@barrodale.com

09-27-2006 12:36 PM
Andreas Kretschmer