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
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
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,
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
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..
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: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
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
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
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
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.
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.
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
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
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
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
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
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
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
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
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
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
"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.
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 ?
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..
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
>>
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 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
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 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: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: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: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: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 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 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
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
37 matches
Mail list logo
