Hi,
Maybe someone on this list actually have already tried this:
I'm planning to make a partitioned database. From Postgres documentation
I can see, that there are basically two methods to route INSERTS into
partitioned table:
one. is a TRIGGER
other. is a RULE
My Table will have
Oh, as I was writing a CUBE query today and realized that I forgot to
mention this. And unlike most gripes, like MERGE INTO or CTE's which are
really convenience things, this is key piece of functionality that you
just can't reproduce in Postgres.
That said, there's not the same sense of comm
"Akhtar Yasmin-B05532" <[EMAIL PROTECTED]> writes:
> I tried postmaster -D /home/data/www/pg7/data, but the error message
> still doesn't appear.
Maybe you have it configured to log to syslog? Look in postgresql.conf.
regards, tom lane
--
Sent via pgsql-general mailing
Hi,
Thanks for the prompt reply,
I tried postmaster -D /home/data/www/pg7/data, but the error message
still doesn't appear.
Nothing really happens after this command.
Is there a way I can find where the errors are logging..?
Thanks n regards
-Original Message-
You might try invoking th
"Akhtar Yasmin-B05532" <[EMAIL PROTECTED]> writes:
> The log says,
> postmaster successfully started
That's not the postmaster's log, that's just pg_ctl saying it managed
to find and exec the postmaster. I speculate that you are sending
the log to /dev/null which is why you cannot find out anythi
Hello,
I am attempting to compile a C trigger function for
use with Postgresql.
The function uses SPI and I am comiling in linux
using gcc.
The compiler is finding all the correct headers
but complains that it can't find the SPI functions.
I am compiling with -lpq .
Do I need to compile with
The log says,
postmaster successfully started
But I don't think its started as, while connecting to db, I get the
following error in the logs as,
psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain
On Wed, 3 Sep 2008 15:34:26 -0700
"Akhtar Yasmin-B05532" <[EMAIL PROTECTED]> wrote:
> Even the command pg_ctl -D /home/data/www/pg7/data start
> Does not start the server, I mean the message I get on running the
> command, is:
> postmaster successfully started
O.k. what does the log say?
Joshua
It says,
pg_ctl: 5432: not found
postmaster successfully started
But when I check the status, by using the command pg_ctl status,
Its says,
pg_ctl: postmaster or postgres is not running
Any idea when the postmaster.pid file is created?, because after giving
the start command I cannot see the .p
Even the command pg_ctl -D /home/data/www/pg7/data start
Does not start the server, I mean the message I get on running the
command, is:
postmaster successfully started
But the status still shows,
pg_ctl: postmaster or postgres is not running
Also when I try to access psql, it gives me the follow
On Wed, 3 Sep 2008 15:19:25 -0700
"Akhtar Yasmin-B05532" <[EMAIL PROTECTED]> wrote:
>
> It says,
> pg_ctl: 5432: not found
> postmaster successfully started
pg_ctl doesn't take a -p argument for the port. -p is reserved for the
path to the postmaster. Try:
pg_ctl -D /home/data/www/pg7/data sta
On Wed, 3 Sep 2008 14:58:45 -0700
"Akhtar Yasmin-B05532" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am using the following command to start the database:
>
> pg_ctl start -p 5432 -D /home/data/www/pg7/data
>
> Yes I know, 7.2 is a very old version, but that's what we have to work
> with for now
On Wed, 3 Sep 2008, Mira Dimitrijevic wrote:
> Hi,
> I wrote the trigger function below and when trying to execute it, I
> get the following error:
>
> 15:00:42 [CREATE - 0 row(s), 0.000 secs] [Error Code: 0, SQL
> State: 42601] ERROR: syntax error at or near "INSERT"
>
> I am using DBVisuali
Hi,
I am using the following command to start the database:
pg_ctl start -p 5432 -D /home/data/www/pg7/data
Yes I know, 7.2 is a very old version, but that's what we have to work
with for now..
:-(
-Original Message-
From: Raymond O'Donnell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, S
On 03/09/2008 20:11, Akhtar Yasmin-B05532 wrote:
> I am facing this peciliar problem.I am using postgres 7.2.2 installed on
> solaris.
I know this isn't helpful to your particular problem, but 7.2.* is VERY
old - in fact, I don't think it's even maintained any more.
Also, the command you used to
Hi,
I wrote the trigger function below and when trying to execute it, I
get the following error:
15:00:42 [CREATE - 0 row(s), 0.000 secs] [Error Code: 0, SQL
State: 42601] ERROR: syntax error at or near "INSERT"
I am using DBVisualizer's "SQL Commander" window, not the "create
funcit
HI,
I am facing this peciliar problem.I am using postgres 7.2.2 installed on
solaris.
It has been running very well since all the time, until somebody tried
to stop it. Using the command
Now it does not start.
On giving the start command its says:
/home/data/www/pg7/bin/pg_ctl: 5432: not fo
On Sep 2, 2008, at 4:16 AM, jose lawrence wrote:
HI,
I want to get more information whether MVCC conflicts with manual
locking ?
Have you read the chapter on MVCC and locks?
http://www.postgresql.org/docs/8.2/interactive/mvcc.html
Erik Jones>, Database Administrator
Engine Yard
Support
On Wed, Sep 3, 2008 at 2:07 PM, Tony Caduto
<[EMAIL PROTECTED]> wrote:
> David Fetter wrote:
>>
>> What they want to have is a huge entity they can blame when everything
>> goes wrong. They're not interested in the actual response times or
>> even in the much more important time-to-fix because onc
David Fetter wrote:
What they want to have is a huge entity they can blame when everything
goes wrong. They're not interested in the actual response times or
even in the much more important time-to-fix because once they've
blamed Oracle, they know the responsibility is no longer on their
shoulde
On Wed, 03 Sep 2008 15:55:17 -0400
William Garrison <[EMAIL PROTECTED]> wrote:
> So I expected scanning the index was faster, and still had everything
> it needed to do the count. Or perhaps it was because I said COUNT(*)
> so it needs to look at the other columns in the table? I really just
> w
Can't it just scan the index to get that? I assumed the index had links
to every fileid in the table. In my over-simplified imagination, the
table looks like this:
ctid|fileid|column|column|column|column
ctid|fileid|column|column|column|column
ctid|fileid|column|column|column|column
ctid|file
Bill,
Did you try it like this:
parent_id = 0
category_name = ''
select category, parent_category_id
from note.category
where category_id = 477 into category_name, parent_id;
raise notice 'curr cat, name, parent id: % % ', category_name,
parent_id;
I have found in the past that it
On Wed, Sep 3, 2008 at 10:36 AM, William Garrison <[EMAIL PROTECTED]> wrote:
> When I attended the PostgreSQL East conference, someone presented a way of
> doing this that they used for http://www.mailermailer.com/ and they did
> this:
>
> SET constraint_exclusion = on;
> EXPLAIN
> SELECT
> *
>
Fernando Moreno wrote:
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
The prefix is added by the mailing list software. It's there so that
people subscribed to multiple pgsql-* lists can easily distinguish them.
Ther
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
Are messages without this prefix likely to be ignored by automatic filters
or something like that?
Thanks in advance.
Hi,
If you are a Fedora-9 or RHEL/CentOS 5 user and want to test new
features of PostgreSQL 8.4 and help development team, you may use the
packages that I have just released, based on today's CVS snapshot. I am
planning to push new packages each weekend during commitfest.
Please note that these p
-- Original message --
From: William Garrison <[EMAIL PROTECTED]>
> I am looking for records with duplicate keys, so I am running this query:
>
> SELECT
> fileid, COUNT(*)
> FROM
> file
> GROUP BY
> fileid
> HAVING
> COUNT(*)>1
>
> The table has an
When I attended the PostgreSQL East conference, someone presented a way
of doing this that they used for http://www.mailermailer.com/ and they
did this:
SET constraint_exclusion = on;
EXPLAIN
SELECT
*
FROM
test
WHERE
id = 7
AND id % 4 = 3
Their business layer then generated the "AN
"David West" <[EMAIL PROTECTED]> writes:
> I'm wondering why the postgres planner is not capable of determining the
> correct partition for a simple select for the following partitioning scheme,
The planner doesn't know anything about the behavior of %.
Heed the fine manual's advice:
Keep the
I am looking for records with duplicate keys, so I am running this query:
SELECT
fileid, COUNT(*)
FROM
file
GROUP BY
fileid
HAVING
COUNT(*)>1
The table has an index on fileid (non-unique index) so I am surprised
that postgres is doing a table scan. This database is >15GB, and there
On Wed, 3 Sep 2008, Fco. Mario Barcala Rodr?guez wrote:
Hi all:
Is there any way to create a case sensitive full text index? My target
is to make case sensitive full text searches but I don't know how.
I could create a configurario for full text searching:
CREATE TEXT SEARCH CONFIGURATION pub
On Wed, Sep 3, 2008 at 10:24 AM, David West <[EMAIL PROTECTED]> wrote:
> Hi folks,
>
>
>
> I'm wondering why the postgres planner is not capable of determining the
> correct partition for a simple select for the following partitioning scheme,
> in which I'd like to automatically divide rows into fo
On Wed, Sep 3, 2008 at 9:36 AM, <[EMAIL PROTECTED]> wrote:
>
> I don't know if Oracle changed recently, but the last few times I used it,
> it was incredibly annoying having to put everything in a subquery to get a
> LIMIT-type operation to work AFTER the sort, so that you could use their
> ROWNUM
Hi all:
Is there any way to create a case sensitive full text index? My target
is to make case sensitive full text searches but I don't know how.
I could create a configurario for full text searching:
CREATE TEXT SEARCH CONFIGURATION public.myconfiguration (PARSER =
pg_catalog.default);
CREATE
Hi folks,
I'm wondering why the postgres planner is not capable of determining the
correct partition for a simple select for the following partitioning scheme,
in which I'd like to automatically divide rows into four sub-tables, ie, a
simple form of hash partitioning.
Any ideas why this doe
I don't know if Oracle changed recently, but the last few times I used it,
it was incredibly annoying having to put everything in a subquery to get a
LIMIT-type operation to work AFTER the sort, so that you could use their
ROWNUM. For example, to get the first 50 rows of a SELECT result. Their
Tom Lane ha scritto:
Edoardo Panfili <[EMAIL PROTECTED]> writes:
labelDatum = DirectFunctionCall1(enum_out,datumIbrido);
label = (char *) DatumGetPointer(labelDatum);
Just FYI, preferred style for the second line would be
label = DatumGetCString(labelDatum);
Nearly al
aderose <[EMAIL PROTECTED]> writes:
> Starting with a database where analyze has never been run I get worse
> performance after running it -- is there something I'm missing?
Well, not basing such a sweeping statement on a single query example
would be a good start ;-). This particular plan might
Edoardo Panfili <[EMAIL PROTECTED]> writes:
> labelDatum = DirectFunctionCall1(enum_out,datumIbrido);
> label = (char *) DatumGetPointer(labelDatum);
Just FYI, preferred style for the second line would be
label = DatumGetCString(labelDatum);
Nearly all standard data types hav
Martijn van Oosterhout ha scritto:
On Tue, Sep 02, 2008 at 10:53:03AM +0200, Edoardo Panfili wrote:
But i have a little question about parameters of enum_out.
Datum enum_out(PG_FUNCTION_ARGS);
this is a part of my function
---
Datum esterna
On Wed, Sep 3, 2008 at 5:56 AM, Robert Treat
<[EMAIL PROTECTED]>wrote:
> On Tuesday 02 September 2008 17:21:12 Asko Oja wrote:
> > On Tue, Sep 2, 2008 at 2:09 AM, Michael Nolan <[EMAIL PROTECTED]> wrote:
> > > Oracle handles connecting to multiple databases (even on
> multiple/remote
> > > compute
postgresql version 8.3:
I found issue when optimisator had tried rollup subrequest (without attempt
compare final cost with direct plan) and finished with bad plan.
The simplest test is below:
Preparing data:
testdb=# INSERT INTO table2 select (random()*99+1)::integer from
generate_series(1,1
Roberts, Jon wrote:
PostgreSQL has table partitioning in it so you don't have to dynamically
figure out which table to get the data from.
I know, but the super table can't handle the number of partition tables
I need, 10K-100K tables. Whenever I do a query on the super table, it
just aborts
44 matches
Mail list logo
