From: Adrian Klaver akla...@comcast.net
To: pgsql-general@postgresql.org
Cc: Postgre Novice postgrenov...@yahoo.com
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
Hello ,
after google search i havent found any solution or clue for this specific case:
Background:
Postgresql: 8.3.0
select version();
version
PostgreSQL
Can someone please share some light on this
- Forwarded Message
From: Postgre Novice postgrenov...@yahoo.com
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
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
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
where I am confused. I
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
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 definetely consider it
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
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 find some way to
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
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
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
php script
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
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.
If your function returns refcursor, then OLE DB will
interpret that to mean
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
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
18 matches
Mail list logo