| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 1 | 574 |
|  | 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 | 1 | 151 |
|  | 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 | 3 | 131 |
|  | 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 | 6 | 121 |
|  | 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 | 1 | 120 |
|  | 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 | 1 | 156 |
|  | 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 | 9 | 164 |
|  | Thank you Toby and Laurenz for your solutions.
Toby A Inkster schrieb:
Thomas Guettler
|
12-04-2007 10:06 AM
Thomas Guettler | 2 | 127 |
|  | 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 | 4 | 138 |
|  | 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 | 2 | 125 |
|  | 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 | 4 | 143 |
|  | 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 | 1 | 147 |
|  | "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 | 6 | 127 |
|  | 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 | 3 | 127 |
|  | 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 | 8 | 161 |
|  | 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 | 2 | 124 |
|  | 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 | 1 | 124 |
|  | 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 | 2 | 157 |
|  | 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 | 4 | 166 |
|  | 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 | 4 | 192 |
|  | -----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 | 0 | 131 |
|  | 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 | 4 | 141 |
|  | 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 | 12 | 216 |
|  | 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 | 2 | 116 |
|  | 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 | 0 | 120 |
|  | 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 | 1 | 128 |
|  | 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 | 2 | 191 |
|  | 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 | 3 | 198 |
|  | 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 | 2 | 138 |
|  | 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 | 2 | 139 |
|  | 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 | 1 | 142 |
|  | 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 | 2 | 138 |
|  | hi!
I wonder if clustering a table improves perfs somehow ?
Any exmple/ideas about that ?
ref :...
Patrox
|
09-13-2007 08:02 AM
Patrox | 0 | 154 |
|  | 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 | 4 | 146 |
|  | 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 | 8 | 140 |
|  | 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 | 1 | 140 |
|  | 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 | 1 | 139 |
|  | 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 | 1 | 136 |
|  | 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 | 5 | 139 |
|  | 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 | 1 | 138 |
|  | 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 | 1 | 137 |
|  | 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 | 2 | 132 |
|  | 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 | 1 | 122 |
|  | 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 | 2 | 137 |
|  | 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 | 1 | 134 |
|  | 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 | 4 | 138 |
|  | 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 | 4 | 126 |
|  | 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 | 1 | 134 |
|  | 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 | 1 | 127 |
|  | 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 | 1 | 95 |