On Sat, Apr 14, 2007 at 06:26:22PM -0400, Tom Lane wrote:
> "Michael Nolan" <[EMAIL PROTECTED]> writes:
> > I've narrowed down the conditions under which pg_dump in 8.2.3 is creating a
> > segmentation fault.
> > It appears to happen only when dumping a sequence that is created for a
> > serial dat
dcrespo wrote:
SELECT
CASE WHEN is_odd(t.number) THEN 'Update' ELSE 'Insert' END AS
action,
CASE WHEN is_odd(t.number) THEN t.number ELSE NULL END AS number,
FROM ... ;
As you can see, is_odd function (only a function example) is being run
twice with exactly the same parameters to put a
"Michael Nolan" <[EMAIL PROTECTED]> writes:
> I've narrowed down the conditions under which pg_dump in 8.2.3 is creating a
> segmentation fault.
> It appears to happen only when dumping a sequence that is created for a
> serial data element.
Thanks for the test case --- I can reproduce this now on
"Mason Hale" <[EMAIL PROTECTED]> writes:
> On 4/14/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> The methodology that pre-8.2 pg_dump uses for serial columns is
>> vulnerable to quite a number of problems if serial sequences don't have
>> the expected names, and this seems to be another one.
> I assu
Nico Sabbi <[EMAIL PROTECTED]> writes:
> To begin with I followed the example of the docs: in the recovery.conf
> file of the
> slave instance I set
> restore_command = 'cp -av /var/lib/pgsql/data/pg_xlog/%f %p'
Hm, it looks like you are trying to copy xlog segments straight from the
pg_xlog d
On 14/04/07, Alain Roger <[EMAIL PROTECTED]> wrote:
After clicking on your link i got "invalid project" page :-(
and the whole page is empty...
Ouch Alain...
Try
http://pgfoundry.org/projects/pg-migrator/
:-)
But ask a single postgres oldskool cat (which I am patently not!) and
you will get exa
Hi,
I'm trying to run a query to find the median value, organized by
date. However, when I run the query, it runs for about 4 hours, and
then quits with the following message:
> ERROR: could not write block 10447102 of temporary file: No space left on
> device
> HINT: Perhaps out of disk spac
Hi,
after having read the documentation and the few posts in this list I
tried to set up
a warm standby replication between two instances of postgres running on
my pc
in 2 different base directories and 2 different ports.
(The second one was a cp -a of the first one after having created a
bac
I wish to display the output of a cursor but haven't discovered the trick.
Here's what I'm doing:
-- The function
CREATE OR REPLACE FUNCTION tmp.sps(character varying, date)
RETURNS refcursor AS
$BODY$
DECLARE
ref refcursor;
BEGIN
OPEN ref FOR select * from tmp.sps_measurement where
Sorry, I forgot to also mention that I am running this on a machine
with 80GB free disk space, and 1GB RAM (but I wouldn't think that this
would be the problem, would it?)
--Richard
On Apr 13, 9:25 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to run a query to find th
I wish to display the content of a cursor but haven't discovered the
trick. Here's what I'm doing:
-The function
CREATE OR REPLACE FUNCTION tmp.sps(character varying, date)
RETURNS refcursor AS
$BODY$
DECLARE
ref refcursor;
BEGIN
After clicking on your link i got "invalid project" page :-(
and the whole page is empty...
On 4/14/07, Erik Jones <[EMAIL PROTECTED]> wrote:
On Apr 14, 2007, at 11:38 AM, Alain Roger wrote:
> thanks for the info.
> anyway i was thinking to do that, but i wanted to be sure.
>
> On 4/14/07, An
Hi,
I did a copy export from my web hosted database.
I did an export in COPY and SQL mode for 1.data and 2.structure only
When i try to import the data, phppgadmin raises an error : "No server
supplied!"
what could be the reason ?
I was thinking about those picture i have in DB like '\\37\\
On Apr 14, 2007, at 11:38 AM, Alain Roger wrote:
thanks for the info.
anyway i was thinking to do that, but i wanted to be sure.
On 4/14/07, Anton Melser < [EMAIL PROTECTED]> wrote:On
14/04/07, Alain Roger < [EMAIL PROTECTED]> wrote:
> Hi,
>
> My web host upgrade his postgreSQL version to 8
I've narrowed down the conditions under which pg_dump in 8.2.3 is creating a
segmentation fault.
It appears to happen only when dumping a sequence that is created for a
serial data element.
uscf=> create table public.seqtest
uscf-> (field1 text,
uscf(> field2 serial);
create table public.seqtes
On 4/14/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Hmm ... which sequence is entry.id actually referring to on the source
database? I suspect that it is linked to some differently-named
sequence like "entry_id_seq1" and the source's "entry_id_seq" is not
in truth doing anything (and, in particular
Rajarshi Guha <[EMAIL PROTECTED]> writes:
> select A from theTable where sim(B, C) > 0.8
> I realize that my table is essentially a collection of 12-dimensional
> points and that I could replace my similarity function with a distance
> function.
> Thus my query boils down to asking 'find me rows
thanks for the info.
anyway i was thinking to do that, but i wanted to be sure.
On 4/14/07, Anton Melser <[EMAIL PROTECTED]> wrote:
On 14/04/07, Alain Roger <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My web host upgrade his postgreSQL version to 8.2.3 so i would like to
do
> the same on my local comp
On 13/04/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
On 4/13/07, Terry Martin <[EMAIL PROTECTED]> wrote:
> I would like to know if I there is a utility to take a UDP packet which
> has specific information in the payload and extract the information
> from the packet and place it in the Postg
It's fairly likely that that report is misleading: most Unix versions
of "top" report Postgres' shared memory as belonging to *each* backend,
and I'll bet taskmanager is doing the same thing. You could reduce
shared memory usage (cut shared_buffers in particular), which might make
the reported us
On Fri, Apr 13, 2007 at 06:09:50PM -0400, Rajarshi Guha wrote:
> Hi, I have a table of about 10M rows. It has two columns A and B, where
> A is a text field and B is a real[12] field.
>
> Now when this table is queried it is usually of the form:
>
> select A from theTable where sim(B, C) > 0.8
"Mason Hale" <[EMAIL PROTECTED]> writes:
> After running pg_dump to backup my database, and then running pg_restore to
> load the db (on a different server),
> I run into a problem with creating a sequence.
Hmm ... which sequence is entry.id actually referring to on the source
database? I suspect
Hi,
My web host upgrade his postgreSQL version to 8.2.3 so i would like to do
the same on my local computer where i develop.
Is there something particular to do ?
or can I just run the exe file (on windows) without doing a complete backup
(pgdump) before ?
thanks a lot,
--
Alain
---
"Anton Melser" <[EMAIL PROTECTED]> writes:
> I am stuck for the moment with 1gig of ram on a win xp machine running
> a 8.2.3 postgres. With the java website taking 300meg, eclipse taking
> 250meg+, firefox 150meg+, all of which are going to be nasty to reduce
> the mem usage of, I am looking at re
On 14/04/07, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
# [EMAIL PROTECTED] / 2007-04-14 13:27:33 +0200:
> Hi,
> I am stuck for the moment with 1gig of ram on a win xp machine running
> a 8.2.3 postgres. With the java website taking 300meg,
how is it going to scale?
It's not! The site is alrea
# [EMAIL PROTECTED] / 2007-04-14 13:27:33 +0200:
> Hi,
> I am stuck for the moment with 1gig of ram on a win xp machine running
> a 8.2.3 postgres. With the java website taking 300meg,
how is it going to scale?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.
Hi,
I am stuck for the moment with 1gig of ram on a win xp machine running
a 8.2.3 postgres. With the java website taking 300meg, eclipse taking
250meg+, firefox 150meg+, all of which are going to be nasty to reduce
the mem usage of, I am looking at reducing postgres usage (the java
website runs o
27 matches
Mail list logo
