From: Adrian Klaver
To: pgsql-general@postgresql.org
Cc: Postgre Novice
Sent: Thu, December 10, 2009 10:23:21 PM
Subject: Re: Fw: [GENERAL] ERROR: could not open relation with OID 59132
On Wednesday 09 December 2009 11:34:39 pm Postgre Novice wrote:
>
Can someone please share some light on this
- Forwarded Message
From: Postgre Novice
To: pgsql-general@postgresql.org
Sent: Wed, December 9, 2009 5:23:18 PM
Subject: [GENERAL] ERROR: could not open relation with OID 59132
Hello ,
after google search i havent found any
Hello ,
after google search i havent found any solution or clue for this specific case:
Background:
Postgresql: 8.3.0
select version();
version
PostgreSQL 8.3.
Thanks everyone for replying. I will definitely try out the methods
outlined.
Thanks once again :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks everyone for replying. I will definitely try out the methods
outlined.
Thanks once again :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e a long time to execute. I know
that I should use a 'point in time recovery backup' but I am confused
how to exactly go about it as I am new to PostGre.
I searched the web and I know I should get a snapshot of the
filesystem and then backup the WAL archive logs but this is the part
wher
paul rivers <[EMAIL PROTECTED]> wrote:
Short answer-- no.
Longer answer-- there's really no need for the Oracle-esque nomount
state in Pg. If you're doing media recovery, it's very much all or
nothing, cluster-wide. You are not going to do media recovery for a set
of tablespaces, for example
Hello,
I want to ask if there is something like nomount state or close database state
in which I can acces postgresql to drop database or to do some other stuff.
Because when there are some connections, drop database is not
possible. Or is this done some other way?
Lukas Houf
--
Sent via pgsql
Roberts Jon <[EMAIL PROTECTED]> wrote:
> >
> > Hi all,
> >
> > I was trying to find some way to implement multithreading into my
> > postgreSQL stored functions.
> >
>
> You can use pgAgent to submit a job for each thread.
>
>
> Jon
Well, that is also an interesting idea. I will definet
Craig Ringer <[EMAIL PROTECTED]> wrote:
Past discussion here suggests that the backends are strictly single
threaded. While you might be able to use multiple threads - I don't know
- I expect you'd need to protect all SPI access by a lock that
serialized everything anyway.
Doing it external
A. Kretschmer <[EMAIL PROTECTED]> wrote:
> Maybe a solution.
>
> Please, learn to quote.
Sorry for the quoting. I guess this probably won't be OK too :-)
Strange thing about this is that there is no simple way to use
more CPUs for one function. It can be done with external functions
but why
> Původní zpráva
> Od: Andreas Kretschmer <[EMAIL PROTECTED]>
> Předmět: Re: [GENERAL] postgreSQL multithreading
> Datum: 30.3.2008 17:39:02
>
> [EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
>
> > Hi all,
> >
> > I was trying to f
Hi all,
I was trying to find some way to implement multithreading into my postgreSQL
stored functions.
The thing is, that I have data stored in multiple tables - for each day one
table - and I want to write
a function which selects data from these tables and stores them into files (or
just ret
> Původní zpráva
> Od: Albe Laurenz <[EMAIL PROTECTED]>
> Předmět: Re: [GENERAL] large object import
> Datum: 10.3.2008 08:44:30
>
> > [EMAIL PROTECTED] wrote:
> > I am having a stored function in plperlU which is called from
> > p
Hi all,
I am having a stored function in plperlU which is called from php script then.
It select data from a table, export them to a file and zips the file. The
problem is that it should store this file into temporary table. Then it should
return some identificator to php, so that the user can d
been told not to use the OLE driver because it is not working
correctly.
Now I will give it a try anyway.
There is nothing to change, because we are still investigating postgre to
know which way we will use it.
And if :-)
[One day later]
I tried it and we will not use the OLE driver for a LONG time.
Hi,
How do I call a StoredProcdure, written in PlPqSql
which returns a set of records (or tableWhatever)
and wants parameters,
from ADO while using "adCmdStoredProc" ?
ERROR: set-valued function called in context that cannot accept a set
-- VERY LONG VERSION OF THIS QUEST
Hi.
There should exist a news-server at:
news://news.postgresql.org/
but I can't connect to it.
It seems does it does not exist.
Even the name can't get resolved.
Is there a new one out there or isn't there one now ?
Cu,
Andreas
PS:
Btw, it got the news-servr from
http://www.postgresql.org/co
18 matches
Mail list logo
