On 10/26/11 11:13 PM, Andrea Peri wrote:
Hi,
I'm using the compiled version of PG 9.1.1 on win32 .
try-ing to call the xslt_process(text,text) (two parameter version)
PG say me it is not available.
In the docs are say that it is available only if compiled with the
libxslt lib.
I see that dl
Hi,
I'm using the compiled version of PG 9.1.1 on win32 .
try-ing to call the xslt_process(text,text) (two parameter version)
PG say me it is not available.
In the docs are say that it is available only if compiled with the libxslt
lib.
I see that dll is available in the lib folder.
So I guess
Today I tried to restore a 70GB database with the standard "pg_dump -h
old_server <…> | psql -h new_server <…>" method. I had 100GB set aside for WAL
files, which I figured surely would be enough, because all of the data,
including indices, is only 70GB. So I was a bit surprised when the restore
On Wed, Oct 26, 2011 at 6:09 PM, patrick keshishian wrote:
> On Wed, Oct 26, 2011 at 4:49 PM, William E. Moreno A.
> wrote:
>> Solution: http://archives.postgresql.org/pgsql-general/2007-12/msg01339.php
>> Solution: Message-id: <476d6de1.4050...@latnet.lv>
>>
>>
>> Problem: FATAL: the database
On Wed, Oct 26, 2011 at 4:49 PM, William E. Moreno A.
wrote:
> Solution: http://archives.postgresql.org/pgsql-general/2007-12/msg01339.php
> Solution: Message-id: <476d6de1.4050...@latnet.lv>
>
>
> Problem: FATAL: the database system is starting up
>
> Solved: change postgresql_flags in /etc/r
Solution: http://archives.postgresql.org/pgsql-general/2007-12/msg01339.php
Solution: Message-id: <476d6de1.4050...@latnet.lv>
Problem: FATAL: the database system is starting up
Solved: change postgresql_flags in /etc/rc.conf to: postgresql_flags="-s -m
fast" or postgresql_flags="-s -m sm
On 26/10/2011 23:14, René Fournier wrote:
> OK, great. Thank. And when I recreate it, should I do so from a template, or
> just CREATE DATABASE postgres ?
AIUI, CREATE DATABASE always uses a template - if you don't specify one,
it uses template1 (I think).
Ray.
--
Raymond O'Donnell :: Galway
OK, great. Thank. And when I recreate it, should I do so from a template, or
just CREATE DATABASE postgres ?
On 2011-10-26, at 4:10 PM, Tom Lane wrote:
> =?iso-8859-1?Q?Ren=E9_Fournier?= writes:
>> I accidentally imported lots of data into the postgres database via
>> something like:
>> psql -
=?iso-8859-1?Q?Ren=E9_Fournier?= writes:
> I accidentally imported lots of data into the postgres database via something
> like:
> psql -U postgres -q -f super_massive_database_dump.sql
> Now, although I've manually dropped all the tables -- and \d+ shows
> nothing -- there are still various vie
I accidentally imported lots of data into the postgres database via something
like:
psql -U postgres -q -f super_massive_database_dump.sql
Now, although I've manually dropped all the tables -- and \d+ shows nothing --
there are still various views, functions, etc that must account for a lot of
On 27/10/11 02:38, salah jubeh wrote:
Can someone please direct me where I can find documentation about ALL
and ANY functions. I searched postgresql documentation but I did not
find the appropriate pages
Thanks in advance
Read the reference URLs provided by the other replies, as I quote onl
On Oct 26, 2011, at 16:15, Alexander Farber wrote:
> Hello again,
>
> still I can't figure out how to perform a join
> to fetch all games where a player has participated -
> I have a table containing all games played:
>
> # select * from pref_games limit 5;
> gid | rounds | finished
>
Are you able to specify multiple ldapservers in pg_hba.conf and if so
what is the format? I'd like to be able to build some redundancy incase
one of the ldap servers goes down.
Thanks!
--
Darin Perusich
Email: darin.perus...@ctg.com
Office: 716-888-3690
The information transmitted is intended o
> -Original Message-
> From: Josh Kupershmidt [mailto:schmi...@gmail.com]
> Sent: Wednesday, October 26, 2011 5:04 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] psql HTML mode - quoting HTML characters
>
> On Wed, Oct 26, 2011 at 3:5
On Wed, Oct 26, 2011 at 3:51 PM, Nicholson, Brad (Toronto, ON, CA)
wrote:
> How do I quote characters like < and > in psql's HTML mode?
>From a brief look at print_html_text() and html_escaped_print() in
psql's print.c, I don't see any way to tell psql not to escape some
block of text in HTML pri
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Wednesday, October 26, 2011 4:16 PM
Cc: pgsql-general
Subject: Re: [GENERAL] Saving score of 3 players into a table
Hello again,
still I can't figure
Hello again,
still I can't figure out how to perform a join
to fetch all games where a player has participated -
I have a table containing all games played:
# select * from pref_games limit 5;
gid | rounds | finished
-++
1 | 10 | 2011-10-26
Hi,
How do I quote characters like < and > in psql's HTML mode?
For example:
Regular mode:
postgres=# select 'http://www.postgresql.org>Postgres';
?column?
http://www.postgresql.org>Postgres
(1 row)
HTML mode:
postgres=# \H
On 10/26/11 6:38 AM, salah jubeh wrote:
Can someone please direct me where I can find documentation about ALL
and ANY functions. I searched postgresql documentation but I did not
find the appropriate pages
http://www.postgresql.org/docs/current/static/functions-subquery.html#FUNCTIONS-S
>
> Caveat #2 applies here
>
> http://developer.postgresql.org/pgdocs/postgres/hot-standby.html#HOT-STANDBY-CAVEATS
>
> The consistent state is delayed until your long running transactions
> end, which is workload dependent but transient.
>
I'm not quite sure how this correlates to what I'm seeing
http://www.postgresql.org/docs/9.1/static/functions-subquery.html
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 63
Can someone please direct me where I can find documentation about ALL and ANY
functions. I searched postgresql documentation but I did not find the
appropriate pages
Thanks in advance
On 21/10/11 12:23, Yoann Moreau wrote:
Hello,
I'm using a GIN index for a text column on a big table. I use it to
rank the rows, but I also need to get the term positions for each
document of a subset of documents. I assume these positions are stored
in the index, because doc says positions ca
On Wed, Oct 26, 2011 at 10:15 AM, Simon Riggs wrote:
> On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian
> wrote:
>
> > Interesting. Although your example of one, 10-dimension array works,
> > five hundred 2-dimension arrays does not work. I can do the SELECT, but
> the
> > CREATE TABLE fail
On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian
wrote:
> Interesting. Although your example of one, 10-dimension array works,
> five hundred 2-dimension arrays does not work. I can do the SELECT, but the
> CREATE TABLE fails:
>
> ERROR: row is too big: size 9024, maximum size 8160
> SQL sta
"mailtolouis2020-postg...@yahoo.com"
writes:
> remove.c:182: error: âXLOG_GIN_INSERTâ undeclared (first use in this
> function)
> remove.c:182: error: (Each undeclared identifier is reported only once
> remove.c:182: error: for each function it appears in.)
> remove.c:184: error: âXLOG_GIN
Daniele Varrazzo writes:
> On Wed, Oct 26, 2011 at 1:04 AM, Andrew Hammond
> wrote:
>> On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane wrote:
>>> [ pokes around for a bit ... ] Hmm, can you say how the failing query
>>> was submitted, exactly? I'm wondering if it came in via simple Query
>>> (PQexec
It would be very nice if the postgres documentation would contain
version information like this: "application_name: new in version 9.0"
Or: "... deprecated since version ...".
Or: "removed in version x.y. Use ... instead"
Is there a reason, why this is not done?
Thomas Güttler
--
Thomas Gu
On 26 October 2011 10:08, Alexander Farber wrote:
> create table pref_games {
> gid serial,
> rounds integer not null,
> finished timestamp default current_timestamp
> }
> then how do I find the new game id after I've just created it here:
>
> create or
Hi,
Is anyone able to compile pglesslog under postgres9.1.1 ?
When I try it I got this error:
make -f Makefile.pg_compresslog all
make[1]: Entering directory
`/usr/src/postgresql-9.1.1/contrib/pg_lesslog_1.4.2_pg90'
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statemen
On Wed, Oct 26, 2011 at 1:04 AM, Andrew Hammond
wrote:
> On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane wrote:
>> [ pokes around for a bit ... ] Hmm, can you say how the failing query
>> was submitted, exactly? I'm wondering if it came in via simple Query
>> (PQexec) or extended-query protocol (any
On Wed, Oct 26, 2011 at 3:17 AM, Lee Hachadoorian
wrote:
> I decided
> to try to combine all the sequences into one table using array columns.
> (This would actually make querying easier since the users wouldn't have to
> constantly JOIN the sequences in their queries.) Next problem: I run into
>
Hello again,
thank you for your replies. If I create a separate table for games:
create table pref_users (
uid varchar(32) primary key,
first_name varchar(64),
female boolean,
avatar varchar(128)
}
create table pref_games {
On 10/26/2011 12:31 AM, David Johnston wrote:
On Oct 25, 2011, at 22:17, Lee Hachadoorian wrote:
I need some advice on storing/retrieving data in large rows. Invariably someone
points out that very long rows are probably poorly normalized, but I have to
deal with how to store a dataset whi
34 matches
Mail list logo
