Hello,
I wonder if there are some special cases where STABLE functions should
be avoided.
I think for example of functions using set_config or querying the
advisory locks.
Thanks in advance,
Marc Mamin
On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote:
> Okay my required n00b question of the week, hopefully this'll be an easy one..
>
> I decided to give pgAgent a shot, because there's this stored sproc
> (sorry, function) I need to run nightly and I think spending hours
> figuring out pgAg
On Mon, Oct 18, 2010 at 2:07 AM, Dave Page wrote:
> On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote:
>> Okay my required n00b question of the week, hopefully this'll be an easy
>> one..
>>
>> I decided to give pgAgent a shot, because there's this stored sproc
>> (sorry, function) I need
On Mon, Oct 18, 2010 at 2:21 AM, Mike Christensen wrote:
> On Mon, Oct 18, 2010 at 2:07 AM, Dave Page wrote:
>> On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote:
>>> Okay my required n00b question of the week, hopefully this'll be an easy
>>> one..
>>>
>>> I decided to give pgAgent a sho
On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen wrote:
> Sorry, it looks like it defaulted to the wrong DB. I created the
> schema in the "postgres" database and now I see a Jobs node..
:-)
> One last question - How do I configure pgAgent to start automatically?
You'll need to put together
On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen wrote:
>> Sorry, it looks like it defaulted to the wrong DB. I created the
>> schema in the "postgres" database and now I see a Jobs node..
>
> :-)
>
>> One last question - How do I configure p
On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen wrote:
> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote:
>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen
>> wrote:
>>> Sorry, it looks like it defaulted to the wrong DB. I created the
>>> schema in the "postgres" database and now I see
On Mon, Oct 18, 2010 at 2:43 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen wrote:
>> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote:
>>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen
>>> wrote:
Sorry, it looks like it defaulted to the wrong DB. I create
On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen wrote:
> Okay I found one that I can use..
>
> One question.. Should the connection string in the script have the
> password for "root" hard coded in it? Or will it use a password from
> ~/.pgpass automatically? If so, what user account will it
On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen wrote:
> On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote:
>> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen
>> wrote:
>>> Okay I found one that I can use..
>>>
>>> One question.. Should the connection string in the script have the
>>> pas
Hi all.
I need to implement a (classical) categorization of items accordingly
to a tree-like hierarchy.
I mean, I have a tree describing the hierarchy itself. Then I need to
link each item to one or
more categories.
Later I may be asked to select all items belonging to one or more
categories or any
On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen wrote:
>> Okay I found one that I can use..
>>
>> One question.. Should the connection string in the script have the
>> password for "root" hard coded in it? Or will it use a password from
>>
On Mon, Oct 18, 2010 at 3:37 AM, Dave Page wrote:
> On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen wrote:
>> On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote:
>>> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen
>>> wrote:
Okay I found one that I can use..
One question..
2010/10/16 Andrus Moor :
> In 9.0 query below returns error
>
> 7/42703:ERROR: column pg_trigger.tgisconstraint does not exist
>
> How to change it so that it works in all servers starting at 8.0 (or at
> least
> from 8.1) to 9.0 ?
> Or if this is not possible how to fix it so that it works in 9 ?
"Marc Mamin" writes:
> I wonder if there are some special cases where STABLE functions should
> be avoided.
> I think for example of functions using set_config or querying the
> advisory locks.
set_config has side-effects and hence should not be done in non-volatile
functions.
On Mon, Oct 18, 2010 at 4:47 AM, Marc Mamin wrote:
> I wonder if there are some special cases where STABLE functions should be
> avoided.
>
> I think for example of functions using set_config or querying the advisory
> locks.
Advisory locks are highly volatile and everything that touches them
sho
Hello,
i'm using initdb of an PostgreSQL 8.4 installed over the port-system of
FreeBSD:
=
> initdb foo --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8
--lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8
--lc-monetary=de_DE.UTF-8 --lc-numeric=de_DE.UTF-8 --lc-time=de_DE.UTF-8
The files belon
Craig Ringer wrote:
Have you re-tried all this on a clean source tree, running under the
msys shell from start to finish?
A handy thing to know is that running "make maintainer-clean" in the
source code tree will clean out all artifacts from any previous build
attempt.
--
Greg Smith, 2ndQua
On 18 October 2010 15:46, Torsten Zühlsdorff wrote:
> Hello,
>
> i'm using initdb of an PostgreSQL 8.4 installed over the port-system of
> FreeBSD:
>
> =
>
>> initdb foo --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8
>> --lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8 --lc-monetary=de_DE.UTF-8
On Monday 18 October 2010 7:46:21 am Torsten Zühlsdorff wrote:
> Hello,
>
> i'm using initdb of an PostgreSQL 8.4 installed over the port-system of
> FreeBSD:
>
> =
>
> > initdb foo --locale=de_DE.UTF-8 --lc-collate=de_DE.UTF-8
>
> --lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8
> --lc-moneta
Adrian Klaver writes:
> On Monday 18 October 2010 7:46:21 am Torsten Zühlsdorff wrote:
>> So: any idea why the database is not visible? And how do get rid of the
>> "non-existing" databases ;)
> My guess is that you have more than one installation of Postgres. The initdb
> is
> working on one c
In response to Tom Lane :
> Adrian Klaver writes:
> > On Monday 18 October 2010 7:46:21 am Torsten Z_hlsdorff wrote:
> >> So: any idea why the database is not visible? And how do get rid of the
> >> "non-existing" databases ;)
>
> > My guess is that you have more than one installation of Postgre
Hey guys,
My archive became unavailable for a short while, causing the archiver
process to stop copying files out. Now it seems to be stuck although
the archive location is available again.
This is from ps -ax: postgres: archiver process last was
0001032300F8
How do I wa
On Sun, Oct 17, 2010 at 10:58 PM, AI Rumman wrote:
> I am using Postgresql 8.1.
> I need to know which query are executing seq_scan on tables as statistics
> said there were 4 seq_scan on the tables for the last 2 days.
Not sure really. You could log all query plans I think, but I don't
know if
Never mind, it picked up again. It took a few hours, not sure why.
Scot Kreienkamp
skre...@la-z-boy.com
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scot Kreienkamp
Sent: Monday, October 18, 2010 11:29 AM
To: pgsql-general@postgresql.or
Hey folks,
As a gentle reminder PgWest 2010 is two weeks away. In case you missed
it, Sun Microsystems Founder Scott McNealy will be presenting the
keynote. Here are the relevant links:
Agenda:
https://www.postgresqlconference.org/2010/west/agenda
Registration:
https://www.postgresqlconference.
On 10/12/2010 08:28 PM, Bruce Momjian wrote:
Steve Crawford wrote:
On 09/25/2010 07:03 AM, Tom Lane wrote:
rey writes:
Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
I retried after make maintainer-clean and same problem -
Here's a question: is my source download getting mangled by unpacking
with WinZip instead of gzip?
I'm beginning to suspect so.
I don't have gzip installed. And frankly, I don't know how - the GNU
site doesn't seem to have a step-by-ste
I'm about to launch an in house 'Aplpha' stage project. One of the marketing
driven outputs on the page is filled by a:
SELECT
COUNT(*)
WHERE
date_field IS NOT NULL AND
date_field > :todays_date;
Last I heard, this kind of query is kind of slow on Postgres in particular,
(Love postgres o
On 19/10/2010 5:58 AM, Turner, John J wrote:
Here's a question: is my source download getting mangled by unpacking
with WinZip instead of gzip?
I doubt it. I use 7-zip on Windows without problems. You certainly don't
need to use gzip and GNU tar.
I'm pretty puzzled about why c.h isn't seei
On 19/10/10 11:15, Dennis Gearon wrote:
I'm about to launch an in house 'Aplpha' stage project. One of the marketing
driven outputs on the page is filled by a:
SELECT
COUNT(*)
WHERE
date_field IS NOT NULL AND
date_field> :todays_date;
Last I heard, this kind of query is kind of slow
I began to suspect my version of WinZip was lousing up the pg source
files when it dropped files from a zlib.tar I was trying to install.
So, I installed 7-zip and unpacked the pg source with that..
- I ran ./configure --without-zlib
Then: make world
Success!
(then: make install-world)
So, now
On 19/10/10 11:58, Turner, John J wrote:
> I began to suspect my version of WinZip was lousing up the pg source
> files when it dropped files from a zlib.tar I was trying to install.
Hmm, ok. Thanks for the heads-up, then. "Winzip mangles tar archives"
goes into the list of possible fault causes..
Hi,
I downloaded PostgreSQL 9.0.1 binary package for Linux from Entreprise DB Web
page, but when I try to install the binary package, I get the follwing message
error:
/home/ttamba/Desktop/postgresql-9.0.1-1-linux.bin: 1: Syntax error: "("
unexpected
I'm using ubuntu 10.04 LTS distribution a
Dennis Gearon wrote:
Is there any architectural way to speed it up? I'd actually like to run it
every 2-60 seconds to update a counter on a page for the marketing guy, (which
for once, is me :-
Could always maintain it with triggers. See
http://wiki.postgresql.org/wiki/Slow_Counting for a d
Hi List,
Is there any feature to drop the view with out cascading the dependents.
Below is my requirement.
I have a view which is dependent on the other view/table. I wanted to drop the
view dynamically and recreate the view with same name ( definition of view will
differ ) with out cascading
Thom Brown schrieb:
initdb creates a database cluster, not a database. [..]
Now i'm feeling like fool - this is so obviously. -.- I will stop
posting stressed to the Usenet.
I'm sorry. Thanks for your replies and time!
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der
37 matches
Mail list logo
