Dear, I'm running pgAgent Linux daemon successfully on a Centos 5.7 32bit machine without pgAdmin and the wxWidget library as described...

DFE

12-13-2011 08:58 AM
Devrim GÜNDÜZ

Hello, I wanted to ask according such a problem which we had faced with. We are widely using postgres arrays like key->value array by doing...

Aleksej Trofimov

12-13-2011 08:17 AM
Merlin Moncure

Hello! Due to some legacy apps, I end up with two tables with similar information, but with zero intersection (i.e., both tables are exclusive of...

Pandu Poluan

12-13-2011 05:38 AM
Pandu Poluan

Hi, I know that the configuration is on postgresql.conf, I also found a lot of material about each option, but I could not find something simple to...

Jorge Perez

12-12-2011 08:20 PM
Jorge Perez

Hi all. I'm working on a project where I need to assign a boolean value to a table field, using PQexecParams. Indeed I'm using a wrapper for this...

Mauro Ziliani

12-12-2011 04:09 PM
Mauro Ziliani

Hi list, is it mandatory to: ALTER TABLE mytatable CLUSTER ON mytatable_pkey or is it an implicit thing? JY -- Is a wedding successful if it comes...

Jean-Yves F. Barbier

12-12-2011 03:00 PM
Jean-Yves F. Barbier

Hi list, I wonder if indexes are relevant or not on a small table? (250 rows, 10 columns, often retrieved in different order) JY -- If you have...

Jean-Yves F. Barbier

12-12-2011 02:23 PM
Jean-Yves F. Barbier

Thank you for the useful responses to 'Big Wide Datasets' I decided to have a go with the array option and initially it looked very promising time...

Michael Lush

12-09-2011 02:33 AM
Jean-Yves F. Barbier

Hi Using pgAdmin3 I find the pgAdmin3/Tools/Grant Wizard menu selection is always grey, no matter what object I select. I log in as...

Michael Rowan

12-08-2011 11:35 PM
Jean-Yves F. Barbier

I would like to subtract two columns - create_time and update_time of 'timestamp without time zone' type and then order results based...

Johan Martinez

12-08-2011 09:42 PM
Jayadevan M

I have dataset with ~10000 columns and ~200000 rows (GWAS data (1)) in the form sample1, A T, A A, G C, .... sampel2, A C, C T, A A, .... I'd like...

Michael Lush

12-08-2011 10:01 AM
Steve Crawford

Hello all, This time I am moving to something more advanced than assuming bugs that they don't exist. I am creating a stored procedure that accepts...

Ioannis Anagnostopoulos

12-08-2011 06:57 AM
Ioannis Anagnostopoulos

I have a dataset with ~100,000 columns and ~200,000 rows (GWAS study data(1)) none of the fields have more than about 15 characters Sample1,A I...

Michael Lush

12-08-2011 06:55 AM
Michael Lush

Sorry for the basic question, I can't seem to figure it out. I have two tables, booking and bike. Both have bike_id as primary key. I am trying to...

Jude Lucien

12-08-2011 05:15 AM
Jude Lucien

Hi all, This is my first post here and as I wanted to play it safe my first option was the novice list. My problem is as follows: I have a simple...

Ioannis Anagnostopoulos

12-07-2011 02:40 PM
Jean-Yves F. Barbier

Hello! I'm a PostgreSQL novice, and am currently learning PostgreSQL administration. Using \d+ exposes a column "Description". Now, how do I add...

Pandu Poluan

12-07-2011 03:18 AM
Pandu Poluan

Hello, I found such note in wiki of Postgresql (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server ): Note that on Windows (and on...

Lukas

12-05-2011 04:57 PM
Lukas

Hi list, AFAI understand prepared statements they can accelerate repetitive queries very much - but is it possible to prepare them from within a...

Jean-Yves F. Barbier

12-05-2011 11:52 AM
Merlin Moncure

Saludos! Tengo el siguiente problema intento crear un archivo para ser ejecutado por medio del comando \i de psql y dice lo siguiente *\i...

Lisibeth Troconis

12-04-2011 04:03 PM
Lisibeth Troconis

on http://wiki.postgresql.org/wiki/CTEReadme It shows this: INSERT INTO department (id, parent_department, "name") VALUES (0, NULL, 'ROOT'), (1, 0,...

Henry Drexler

12-02-2011 10:28 AM
Henry Drexler

Hi, all Sorry to interrupt. I am using PostgreSQL 9.1.1 and populated database with DBT-3. I changed some parameters the default postgresql.conf,...

Yangyang

12-01-2011 12:00 PM
Yangyang

HI, dear all I'm trying to force the database to select another query plan for a query, rather than the optimal one. I changed query tuning related...

Yangyang

11-30-2011 08:58 PM
Tom Lane

Hi list, What I understand from doc about GIST index, is it offers more possibilities of comparison that B-tree. But what could it really bring to a...

Jean-Yves F. Barbier

11-26-2011 02:18 AM
Jean-Yves F. Barbier

Hello postgres experts, is there any silent installer for current postgres releases (>= 9.x) available? Or what should I consider if I plan to...

Skusa, Andre

11-22-2011 12:34 PM
Sachin Srivastava

Under a normal role, I am the owner of a database. CREATE DATABASE buddy_db WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII'; ALTER DATABASE...

James Long

11-21-2011 11:17 PM
Jaime Casanova

This command run from the SQL window of pgAdmin3 results in an error: In the table vehicle there is a column maker_id There is no data in the table,...

Michael Rowan

11-21-2011 01:59 AM
Andreas Kretschmer

I have a functioning PostgreSQL 9.1.1 installation on a Mac OSX 10.6.8 machine, installed using EnterpriseDB one-click installer. The data files are...

Jane Geering

11-18-2011 08:15 PM
Jane Geering

I need to delete several records from a table so my query is composed of a DELETE command with a condition, something like the following: DELETE...

JORGE MALDONADO

11-18-2011 01:48 PM
Jean-Yves F. Barbier

Hi. I've just installed PostgreSQL 9.0.5 server & I can get the server running by...

Phil Dobbin

11-18-2011 01:04 PM
Phil Dobbin

On 11/18/2011 12:15 PM, Richard Broersma wrote: Hey...that works! Thank you, Richard! -- Do not go where the path may lead; go instead where there...

Matt Foster

11-18-2011 12:40 PM
Matt Foster

I'm having trouble getting the desired results from an OUTER JOIN, and I'm hoping I can get some help here. My first table, office_list, has a...

Matt Foster

11-18-2011 12:24 PM
Matt Foster

Hi all, I have created a database using version 9.0 and set the client encoding to UTF* in the file postgresql.conf Runnig the query: INSERT...

Kai Otto

11-18-2011 08:52 AM
Jean-Yves F. Barbier

Hi, I want to see more query plans, other than the default one for a query and compare their cost. Based on this, I can change the cost model and see...

Yangyang

11-17-2011 09:53 AM
Tom Lane

How can I ~truncate~ integers? this column 4770 4780 4800 4810 4840

Johann Schatzer

11-16-2011 03:11 PM
Steve Crawford

Hi, I’m in the process of adding postgresql support to a big legacy program which stores small values in int8 (which is a typedef for a signed...

J. Pablo González

11-16-2011 02:19 PM
J. Pablo González

I would like clarification on the first paragraph of section 9.20.2 on the page...

jmscott@setspace.com

11-16-2011 03:04 AM
Baux David

I tested the csvlog option for PostgreSQL and it works beautifully. Where can I find the reference information for all fields? I'd like to write a...

Mladen Gogala

11-14-2011 09:57 AM
royecohen

Regards, - Roy =*=*= Always do right. This will gratify some people and astonish the rest. - Mark Twain The truth is rarely pure, and never...

Roy's Email

11-12-2011 03:11 PM
Roy's Email

Hi, Im having link problems and need help. I have: Windows 7 64 bit installed postgresql-9.0.5-1-windows-x62.exe installed Visual c++ 2008 Express...

shy guy

11-11-2011 08:19 PM
shy guy

Hello, I'm getting a confusing error message. I'm trying to insert a row into a database table called "users". I'm trying to insert using the...

Ramy Abdel-Azim

11-09-2011 03:37 PM
Craig Barnes

required scripts have been added to : /etc/init.d /etc/rc2.d while installing Postgresql. Despite this server doesn't start at booting up. when i...

piotr

11-09-2011 03:08 PM
piotr

Anybody experience this before? I can log in to my database as a particular user with any arbitrary password, even though I've specifically set the...

Steven Borrelli

11-09-2011 10:40 AM
Larry Rosenman

Complete PostgreSQL newb here. I have 7-8 views worth of data in db1 that I need to copy into tables with matching schemae (schemas?) in a...

Russell Christopher

11-08-2011 08:29 AM
Francisco Leovey

On 5 November 2011 17:55, Russell Christopher <russch (AT) hotmail (DOT) com> wrote: PostgreSQL's databases are isolated from another another in a...

Thom Brown

11-08-2011 02:24 AM
Thom Brown

On Mon, 7 Nov 2011 23:20:04 +0100 "Jean-Yves F. Barbier" <12ukwn (AT) gmail (DOT) com> wrote: .... Ok, for who's interested I finally extract it...

Jean-Yves F. Barbier

11-07-2011 09:39 PM
Jean-Yves F. Barbier

Hi list, I've a function: SELECT D.typname as domname, format_type(b.oid,NULL) as dombasetype, D.typlen, D.typtypmod, D.typnotnull, D.typdefault,...

Jean-Yves F. Barbier

11-07-2011 04:20 PM
Jean-Yves F. Barbier

Hello, It seems I've rather botched my installation of postgres onto my Mac OSX lion machine. I would like to "start over from scratch". I've tried...

Ramy Abdel-Azim

11-07-2011 12:17 PM
Tom Lane

On Fri, 04 Nov 2011 16:09:59 -0400, rox wrote: For anybody who runs into this same scenario... The simply answer is to change it to select * from...

rox

11-07-2011 10:11 AM
rox

Hello I use DBI-Linkproject with PostgreSQL 8.4.9 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit...

Richard LEHAUT

11-07-2011 04:05 AM
Richard LEHAUT

On Mon, 7 Nov 2011 01:54:48 +0100 "Jean-Yves F. Barbier" <12ukwn (AT) gmail (DOT) com> wrote: Same @#!< error than last time: I left a 'END;' at the...

Jean-Yves F. Barbier

11-06-2011 07:09 PM
Jean-Yves F. Barbier