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 02: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 02: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 03: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 07: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 07: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 03: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 11:34 AM
Guy

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

Thomas Guettler

12-04-2007 10: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 08: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 03: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 07: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 12: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 11:20 AM
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 04: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 07: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 02: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 03: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 11:18 AM
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 07: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 06: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 09: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 05: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 04: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 10: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 03: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 02: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 03: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 12: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 05: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 06: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 02:36 AM
Laurenz Albe

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

Patrox

09-13-2007 08: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 03: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 04: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 06: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 06: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 11:17 AM
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 01: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 05: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 09: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 07: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 07:35 AM
Laurenz Albe

Hi Ng, probably simple question: what is the easiest way to get the id of an inserted row. I have the folliwing table: Create table...

Stefan Braumeister

07-11-2007 07:35 AM
Stefan Braumeister

Sascha Bohnenkamp wrote: Thanks but it's probably not what I am looking for: I would need to make materialized views by hand before or after A1......

dblearner

07-09-2007 07:41 AM
dblearner

Hi All, I am pretty new to SQL and having trouble trying to formulate a query from what I have been reading in a couple of books (and got...

Kurt

07-03-2007 05:37 AM
Kurt

Hi Group, i am new in the database topic and i look for an database that can work with compressed database files. i look mysql 6 has the falcon...

Thomas Fragstein

07-03-2007 12:34 AM
Andreas Kretschmer

Hallo, I would like to know how is the difference about the performance of PostgreSQL and Firebird. thx

xdb

07-02-2007 02:29 AM
Laurenz Albe

Howdy all, The PostgreSQL documentation says of the INTERVAL type: Internally interval values are stored as months, days,...

Ben Finney

06-29-2007 03:03 AM
Andreas Kretschmer

Hallo everybody, I just have a little question, but very important for my applications, I would want to know the exactly statement (or function) to...

davide

06-26-2007 10:59 AM
Laurenz Albe