Hello all, PostgreSQL 8.3 has been released. I updated my Windows RC2 to the release version and am satisfied that it is working well for...

Silvio Bierman

02-05-2008 08:21 AM
Silvio Bierman

Hi there, im looking for a frontend with a nice feature MSAccess has: when i got a FK in a table, access can retrieve comlumns of the referenced...

Sebastian Fey

02-04-2008 02:27 AM
PBrander

Hi all, is there a way to undo changes in a database (e.g. those made because of a recent human error, an erroneous delete/update query) For example...

kunt

01-23-2008 03:16 PM
DonO

Hello all, I am trying to convert an older PG database where we stored GUIDs by explicitly converting them to byte arrays before storing them in the...

Silvio Bierman

01-23-2008 12:19 AM
Lew

Hello there, I need to enforce a unique constraint on 2 colums of a table (both of them are not primary keys). I mean that 2 rows are different when...

Coniglio Sgabbiato

01-22-2008 09:29 AM
Coniglio Sgabbiato

Hello all, During installation the initdb.exe fails: Activation context generation failed for "C:\Program Files\PostgreSQL\8.3RC2\bin\initdb.exe"....

Silvio Bierman

01-22-2008 05:29 AM
Silvio Bierman

Hi, to access settings petersprc had this solution: select setting from pg_catalog.pg_settings where name = 'modwork.transaction_id' but this does...

Thomas Guettler

01-15-2008 03:16 AM
Laurenz Albe

Hey... Where is this located? When I build the plperl makefile off of the ./postgresql-#.#.#/src directory, I only get a libplperl.so as expected....

Zoid

01-02-2008 03:32 AM
Laurenz Albe

Hi, ~ I would like to separate all PG binaries from the created data for tables, indexes (which could be written and updated to) and also from the...

lbrtchx@gmail.com

01-02-2008 03:26 AM
Laurenz Albe

Hello! I have dumped a database. Is there a way to reverse engineer the dump into an schema? What I need to have is the Entity-Relationship diagram...

Robert Welz

12-28-2007 04:54 AM
Marc Schoechlin

I use Postgresql on Linux but am no expert even there. I've been asked to help setup Postgresql on a MS Windows cluster for high-availability, which...

Harry George

12-27-2007 08:42 AM
Harry George

Hi, Postgres 8.3 behaves different, if you access an unset custom variable. Version 8.1 returned 'unset', while 8.3 fails: plpython...

Thomas Guettler

12-16-2007 08:17 PM
petersprc

I am having a bit of a problem inserting to a table when a trigger is applied to that table. The thing that I am a bit confused about, is that there...

StiltzkinMognet

12-12-2007 04:07 AM
Laurenz Albe

Toby A Inkster <usenet200711 (AT) tobyinkster (DOT) co.uk> wrote: DB Visualizer is cool, and I would say nothing against it. I have found that it...

Lothar Muss

12-04-2007 12:34 PM
Guy

Thank you Toby and Laurenz for your solutions. Toby A Inkster schrieb:

Thomas Guettler

12-04-2007 11:06 AM
Thomas Guettler

Hi, I am using postgresql 8.1. The data are in /var/lib/... and the partition is FULL. How should I do to move the data ? Is it possible just by...

Raphael

11-19-2007 09:37 AM
Stefan Braumeister

To access to postgresql I am using npgsql (visual studio 2005 c#)...are there other possibilities to access to this db? is possibile with psqlODBC?...

ulazar

11-18-2007 04:20 AM
ulazar

Howdy all, I am in need of a UUID type in PostgreSQL, so I was very glad to find the implementation 'polarrose-postgresql-uuid' at Google...

Ben Finney

11-14-2007 08:49 PM
John Koller

I am using visual c# (postgreSQL as DB and Npgsql as data provider) and now I need to print a report. I am trying to use Crystal Reports but I cannot...

yales

11-13-2007 01:40 AM
Laurenz Albe

"Rainer Bauer" <usenet (AT) munnin (DOT) com> wrote That is how I got the server version. It easily shows up in that connection. AFAICT there is...

Joe Stateson

11-09-2007 12:20 PM
Joe Stateson

We are using PostgreSQL "point data" for a coordinate system (ie: latitude longitude). Browsing a location table using phpPgAdmin shows for...

Joe Stateson

11-09-2007 05:44 AM
Laurenz Albe

Hello. At the moment, I'm active as an IBM DB2 DBA. But just out of curiousity, I'm restoring a copy of our production database into an PostgreSQL...

Jurgen Haan

11-07-2007 08:14 AM
Marco Mariani

Hi, I have a problem with a postfix 2.3.8 mail server that use a postegresql 8.1.9 database for resolving email aliases The query performed by...

Eric Belhomme

11-07-2007 03:14 AM
Eric Belhomme

HI, I have an installation on a Debian vserver, which we recently tried to move from an internal machine to a hosted vserver environment. The verser...

beach_defender

10-30-2007 03:37 AM
Laurenz Albe

So, I guess your real question should be, "how do I upgrade a postgreSQL server/instance running on a linux machine". "whether I should be doing a...

Patrox

10-25-2007 04:21 PM
dotyet@yahoo.com

This is a web based application that can be installed on a web server in your environment to manage your database over a browser. At moment is...

WebSQL - staff

10-22-2007 12:18 PM
websql.staff@gmail.com

Hello, this surprised me: select dr_cat,sum(dr_c1_amt) from r_amount group by dr_cat; dr_ca t | sum 1 | 175.00 2 | 30.00 (2 rows) next...

PaulS

10-22-2007 08:48 AM
Andreas Kretschmer

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there! We're trying to create a user-defined type in PostgreSQL 8.2 containing an array of an...

Jorge S. de Lis

10-14-2007 07:25 AM
Jorge S. de Lis

Hi, I want to automate a task to copy values to a table. The shell script is this (simple form): psql -U postgres -d sedait_db -c ' COPY...

luislupe@gmail.com

10-12-2007 10:40 AM
Jurgen Haan

Hi. Is there a way to synchronize specific tables across different databases? My specific problem: I use an accounting application at two sites...

Kai-Martin Knaak

10-12-2007 06:33 AM
Jurgen Haan

Hello all, i have a problem with the max value of a varchar field id docno description ================= 1 2 test1 2 F10 ...

Dade

10-12-2007 05:55 AM
Dade

Hello. When is postgres going to have a decent OleDb provider * with full support for the .NET OleDbSchemaGuid class * ? Any prevision? Does...

pamela fluente

10-09-2007 11:27 AM
pamela fluente

Is there a way to fully automate the installation of Postgres and PostGIS with minimal or no input from the user using a windows installer like...

smodayur@gmail.com

10-09-2007 04:14 AM
Laurenz Albe

begin Thomas Guettler schrieb: Hi Thomas, how are you? Just for info: Andreas 'ads' Scherbaum works on a project called 'tablelog':

Andreas Kretschmer

10-03-2007 03:29 AM
Andreas Kretschmer

I gave an update command in a database and forgot to write the where-condition. Rollback? "WARNING: ROLLBACK: no transaction in...

Laura I Kataja

10-01-2007 04:21 AM
Laurenz Albe

Hi, is it possible to find out when an object (e.g., schema, table, trigger, etc.) was created? I've looked through the pg_catalog table and cannot...

mark.greenbank@gmail.com

09-21-2007 01:20 AM
Andreas Kretschmer

hi ! I have many warnings like : WARNING: nonstandard use of \\ in a string literal at character 69 HINT: Use the escape string syntax for...

Patrox

09-19-2007 06:10 AM
Patrox

Hello, Been away from PostgreSQL for a while and probably needs retraining in the basics. How do I close a database? Can't even find it in the...

Adam Smith

09-18-2007 07:30 PM
Ben Finney

I developed a lot in FoxPro in the days before it was Visual FoxPro or owned by Microsoft. While I get around OK in VFP, it's definitely time for me...

Steve Freides

09-18-2007 03:36 AM
Laurenz Albe

hi! I wonder if clustering a table improves perfs somehow ? Any exmple/ideas about that ? ref :...

Patrox

09-13-2007 09:02 AM
Patrox

hi ! I would like to know how can I know on which tablespace belong a table ? In "information_schema.tables", nothing about a table's tablespace...

Patrox

09-13-2007 04:48 AM
Patrox

I have been looking at various systems that hook into PostgreSQL for replication, and I am rather confused by the many systems and what they do/how...

Michael Trausch

09-11-2007 05:28 PM
Stefan Braumeister

hi ! I would like to know if with Postgres 8.2 is there any way to force a query execution plan ? For example to use a specific index at a speciifc...

Patrox

09-10-2007 07:17 PM
Lew

Hello, I've written my first Stored Procedure with plPython (I had coded pgSQL only). This is the function: lnSemesterID = args lnNode =...

Philipp Kraus

09-06-2007 07:04 AM
Laurenz Albe

Hello, we are trying to install under FreeBSD (6.2.p7) Postgresql 8.1, Python 2.4 and plPython. We get by "create language plpythonu" an error:...

Philipp Kraus

09-05-2007 12:17 PM
Laurenz Albe

Hello, I need a little help to make a communication between a postgres db (8.1) and a PHP script. On the postgress I needn't install any kind...

Philipp Kraus

08-30-2007 02:30 AM
Philipp Kraus

Hello In Postgres "Backup and Restore" documentation I found "Before restoring a SQL dump, all the users who own objects or were granted permissions...

GG

08-20-2007 06:05 AM
Laurenz Albe

Hi I have the following scenario for a database that I need to design, and would like some hints on what to improve or do differently to achieve the...

Tom Forsmo

07-24-2007 10:02 AM
Laurenz Albe

Hi, I'd like to have your opinions, your advices about using WAL and NFS server. I moved pg_xlog/ directory to a NFS server and created a link to...

Cedrick

07-24-2007 08:40 AM
Laurenz Albe

I may be backing up against a tree here, but I was wondering if there is a way to set the maximum number of results one gets from a query before...

ebade2000@gmail.com

07-24-2007 08:35 AM
Laurenz Albe