Is the new mailing software for the postgres lists going to stay like it
is?
The list identification header changed from
X-Mailing-List: pgsql-general
to
List-ID:
klint.
+---+-+
: Klint Gore: "Non rhyming:
On Fri, Jul 08, 2005 at 01:37:54PM +1000, Paul McGarry wrote:
>
> Thank you Michael, your suggestion works a charm (though I didn't
> bother coalescing the two grp because I think the USING takes care of
> that anyway.
Oops, yeah -- I had started with "ON b.grp = g.grp" but changed it
to "USING (g
"David Esposito" <[EMAIL PROTECTED]> writes:
> Size of "problem" table: 6 million rows
> Ballpark guess on INSERT/UPDATE/DELETE queries on this table: over 1
> million/day
> ...
> I do a nightly VACUUM (not VACUUM FULL)
Given those parameters, you should expect a "slack" proportion of about
1/6th
Thank you Michael, your suggestion works a charm (though I didn't
bother coalescing the two grp because I think the USING takes care of
that anyway.
Paul
On 7/8/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> SELECT coalesce(g.grp, b.grp) AS grp,
>coalesce(g.count, 0) AS countgood,
>
On Fri, Jul 08, 2005 at 11:45:59AM +1000, Paul McGarry wrote:
> I basically want a query which will give me:
> ==
> grp | count(good) | sum(good) | count(bad) | sum(bad)
> -+-+-++--
>3 | 0 | | 1 | -5.00
>
Hi there everyone,
I'm having trouble getting the data I want from my tables.
Here is a simplified version of my tables:
==
create table lefty (
day date,
good numeric(10,2),
grp integer
);
insert into lefty values ('2005-06-01',5.00,1);
insert into lefty values ('2005-06-02',10.00,1);
in
Hi there everyone,
I'm having trouble getting the rows I want from a full outer join with
a where clause. Here is a simplified version of my tables:
==
create table lefty (
day date,
goodamount numeric(10,2),
grp integer
);
insert into lefty values ('2005-06-01',5.00,1);
insert into lefty
Hi,
I messed around with the following problem and just want to let you know.
I have the following function:
-CREATE OR REPLACE FUNCTION
usp_inventaire_transaction_inserer("varchar", "varchar", int2,
"varchar", "varchar", "varchar", int4, "timestamp", "timestamp",
"numeric", "numeric"
There are probability* *a few around, but i think most people just use a
flowcharting software to created designs. I know for the work that i do
with postgresql i use smartdraw as it can do anything i want then i
apply these designs to postgresql using EMS Manager.
Rob Brenart wrote:
I'm loo
On 7/7/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Thu, Jul 07, 2005 at 09:28:23PM +0200, BigSmoke wrote:
> >
> > In a trigger function, I'm trying to refer to a column given by an argument
> > to the trigger function.
>
> This comes up frequently -- search the archives for past discussion.
>
On Thu, Jul 07, 2005 at 09:28:23PM +0200, BigSmoke wrote:
>
> In a trigger function, I'm trying to refer to a column given by an argument
> to the trigger function.
This comes up frequently -- search the archives for past discussion.
The usual answer is to write the function in a language like PL/
Hello all,
Executive summary: I have btree index bloat ... I have read all of the
threads I could find on the problem and wanted to confirm that there are no
tuning parameters that could at least reduce the severity of the problem
Detail:
PostgreSQL 8.0.1 on RHEL3
Overall Database Size: 9GB
Size
On Thu, Jul 07, 2005 at 02:35:47PM -0400, Ying Lu wrote:
>
> I'd like to know how to check whether a specific object is created under
> a specific *tablespace*? How to find all objects under a specific
> tablespace?
See pg_tablespace and pg_class.reltablespace in the "System Catalogs"
chapter o
On Thu, Jul 07, 2005 at 12:22:38PM -0600, Clark Allan wrote:
> Here is an example of what i would like to do...
> ---
> CREATE FUNCTION fun_totalrecords(varchar) RETURNS int8 AS'
> DECLARE
> theTable ALIAS FOR $1;
> result int := 0;
> BEGIN
> result = COUNT(*) FR
In a trigger function, I'm trying to refer to a column given by an argument
to the trigger function.
The trigger function fires on deletes and is responsible for deleting messages
that are referred to using foreign keys which are named differently in different
tables (thus the foreign key's column
Greetings,
I'd like to know how to check whether a specific object is created under
a specific *tablespace*? How to find all objects under a specific
tablespace?
For example, one index named "idx_test1" has been created. Now I'd like
to check which tablespace does this index belong to?
Tha
Here is an example of what i would like to do...---
CREATE FUNCTION fun_totalrecords(varchar) RETURNS int8 AS'DECLAREtheTable ALIAS FOR $1;result int := 0;BEGIN
result = COUNT(*) FROM theTable; -- this is where i need helpÂ
RETURN result;
END; 'LANGUAGE 'plpgsql'
> I try to convert code from other database to Postgres.
>
> CREATE TABLE test(test BOOLEAN);
> SELECT MAX(test) FROM test;
>
> causes error
>
> ERROR: function max(boolean) does not exist
> HINT: No function matches the given name and argument types. You may need
> to add explicit type casts.
>
Many thanks Karsten. I got a system working with arrays yesterday but
will still be examining your code. I guess the next challenge is to see
how well the multidimensional array can be searched. I guess I could
make indexes on an expression to retrieve language for a specific key
since each el
On Thu, 2005-07-07 at 08:25, Andrus wrote:
> I have the following column in all my tables which contains data of last
> update of this row:
>
> updated timestamp without time zone DEFAULT now() NOT NULL,
>
> Hor to force Postgres to update this column automatically with now() value
> every tim
Andrus wrote:
I try to convert code from other database to Postgres.
CREATE TABLE test(test BOOLEAN);
SELECT MAX(test) FROM test;
causes error
ERROR: function max(boolean) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
Joe Markwardt <[EMAIL PROTECTED]> writes:
>> The next thing to check is whether the OID mentioned in pg_trigger
>> (which I forgot already) is the same as the OID shown in pg_class, ie
>> select oid from pg_class where relname = 'pl02_status_table'.
> oid
> ---
> 438094756
> (1 row)
> T
On Thu, Jul 07, 2005 at 04:25:31PM +0300,
Andrus <[EMAIL PROTECTED]> wrote
a message of 11 lines which said:
> I have the following column in all my tables which contains data of
> last update of this row:
Me too.
> I have about 100 tables and don't like to write 100 triggers.
I use a temp
"Andrus" <[EMAIL PROTECTED]> writes:
> MAX(boolean) should return true if its argument evaluates true for at least
> one row.
We call it bool_or() ...
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubsc
On Wed, 2005-07-06 at 23:36 -0400, Tom Lane wrote:
> Joe Markwardt <[EMAIL PROTECTED]> writes:
> > On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote:
> >> They appear to be triggers for a foreign-key constraint between
> >> pl_inventory_analyzer_files_table and pl02_status_table ... so I guess
> >
I try to convert code from other database to Postgres.
CREATE TABLE test(test BOOLEAN);
SELECT MAX(test) FROM test;
causes error
ERROR: function max(boolean) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
I tried
SELECT MA
I have the following column in all my tables which contains data of last
update of this row:
updated timestamp without time zone DEFAULT now() NOT NULL,
Hor to force Postgres to update this column automatically with now() value
every time when row is updated ?
I have about 100 tables and don'
[EMAIL PROTECTED] writes:
> Why is the postmaster link to the postgres executable used to run the
> postgres
> server rather than running the postgres executable directly? I have a client
> who wishes to use a monitoring application, and the fact that a link to an
> executable is used is causin
I imagine because the name of the program as seen by the kernel (for
example with ps) uses the name the program was started with, not the
name of the actual binary. That way you can use the same binary for
multiple purposes.
If the link causes you a problem, replace the link with a copy of the
fil
[EMAIL PROTECTED] writes:
> Hello
>
> Why is the postmaster link to the postgres executable used to run
> the postgres server rather than running the postgres executable
> directly? I have a client who wishes to use a monitoring
> application, and the fact that a link to an executable is used is
Hello
Why is the postmaster link to the postgres executable used to run the postgres
server rather than running the postgres executable directly? I have a client
who wishes to use a monitoring application, and the fact that a link to an
executable is used is causing a problem. Can the reference
On Wed, 6 Jul 2005 06:33:58 -0700 (PDT), [EMAIL PROTECTED]
(Stephan Szabo) wrote:
>SESSION_USER should give the original user.
Thanks all, that does what I want.
regards
Richard
---(end of broadcast)---
TIP 2: you can get off all lists at once w
On Mon, Jul 04, 2005 at 03:27:59PM -0300, David Pratt wrote:
> I am also going to look at Karsten's material shortly to see how his system
> works
I am still away from the net but here is how to find the
description in our Wiki:
Go to user support, user guide, scroll down do developers
guide, go
I don't know what OS you're using, but I recently went through the same
search on a very tight budget (free). I ended up using Visio because I
already had it. I have Visio 2002 but found out that the standard
version that I have won't connect to an ODBC DB and generate an ERD.
However, the Pro ve
Richard Huxton wrote:
Ben-Nes Yonatan wrote:
Richard Huxton wrote:
Can anyone tell me if Pl/PgSQL can support a multi dimensional array
(of up to 5 levels top I guess) with about 100,000 values?
and does it stress the system too much?
I can't imagine it being wonderful - you probably want
Ben-Nes Yonatan wrote:
Richard Huxton wrote:
Can anyone tell me if Pl/PgSQL can support a multi dimensional array
(of up to 5 levels top I guess) with about 100,000 values?
and does it stress the system too much?
I can't imagine it being wonderful - you probably want a different
procedural
36 matches
Mail list logo