> >> 1) pg_locks ::: need to write trigger... and have
high overhead...
>
> > What do you mean by "write trigger"?
>
> I'm sure he's imagining that he can create a trigger
on pg_locks and
> thereby capture lock-related events :-(
well that was wht i was thinking got it now... i
will recompil
On Tuesday 24 May 2005 21:38, Scott Marlowe wrote:
> On Tue, 2005-05-24 at 07:19, Jerome Macaranas wrote:
> > hi,
> >
> > I enabled logging for a while just to see what statement is taking too
> > much time.. listed below are some parts of the log.. im wondering why
> > this sql takes to much t
On Tuesday 24 May 2005 22:33, Tom Lane wrote:
> Jerome Macaranas <[EMAIL PROTECTED]> writes:
> > LOG: query: SELECT * FROM phpbb_smilies
> > LOG: duration: 0.005410 sec
> > LOG: duration: 390.731807 sec
> > -- this table has only 295 rows
>
> I think this is an artifact of your lack-of-vacuuming
hacking the backend... can u elaborate a little bit
more... i want to write a small utility which other
ppl can use to see when the locks are acquired etc
etc... so that they can optimise their application
using that information... in my application we have
have 4 processes doing almost the same th
Himanshu Baweja wrote:
is there any other better way by which i can get a list of locks
acquired and waited for during entire run of my application
Hacking the backend would be the easiest route, I think. Why do you need
this information -- what are you trying to do?
-Neil
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> CREATE UNIQUE INDEX name on table(param1,param2);
>
> How to create such unique index when param2 is bool type, and this param2
> should be accepted only in case of true ?
>
> I tried: CREATE UNIQUE INDEX name on table(par
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>> Estimate right now for going beta on 8.1 is July 1st ... aiming for a
> Isn't that feature freeze? Typically there has been a month between
> feature freeze and the first official beta.
Right, the on
On Tue, 24 May 2005, Bruno Wolff III wrote:
On Tue, May 24, 2005 at 19:31:28 -0300,
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
On Tue, 24 May 2005, James Croft wrote:
Scott Marlowe wrote:
I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it
needs to take to come out, w
On Tue, May 24, 2005 at 19:31:28 -0300,
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
> On Tue, 24 May 2005, James Croft wrote:
>
> >Scott Marlowe wrote:
> >>I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it
> >>needs to take to come out, which could be anything, but will l
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
>> "Himanshu Baweja" <[EMAIL PROTECTED]> writes
>> 1) pg_locks ::: need to write trigger... and have high overhead...
> What do you mean by "write trigger"?
I'm sure he's imagining that he can create a trigger on pg_locks and
thereby capture lock-relate
>"Himanshu Baweja" <[EMAIL PROTECTED]> writes
>I wanted to see which tables/transaction have acquired or are waiting for
which locks
>as far as i know there are two ways to do it
>
>1) pg_locks ::: need to write trigger... and have high overhead...
>
"select * from pg_locks" has trivial im
Jamie Deppeler wrote:
Hi,
We are having an issue importing international characters into
postgresql 8.
example Renée
The error message we get is ERROR: invalid byte sequence for encoding
"UNICODE": 0xe92044
Any help would be greatfully recieved
Jamie
Judging by the encoding of your em
Hi,
We are having an issue importing international characters into postgresql 8.
example Renée
The error message we get is ERROR: invalid byte sequence for encoding
"UNICODE": 0xe92044
Any help would be greatfully recieved
Jamie
---(end of broadcast)--
Listas Evandro (Não use este endereço para mensagens pessoais) wrote:
Try http://www.agata.org.br/us/index.php
Is very good and free
We looked at agata, but I have a real problem with the following
installation instructions on the agata page:
rpm -i --force
That's not something I care to
On Tue, 24 May 2005, James Croft wrote:
Scott Marlowe wrote:
I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it
needs to take to come out, which could be anything, but will likely be
no earlier than the end of the year.
I believe there was talk about an 8.1 coming out to r
Try http://www.agata.org.br/us/index.php
Is very good and free
On 5/24/05, Aly Dharshi <[EMAIL PROTECTED]> wrote:
Hello Dino, I think that there is something called openrpt
http://www.openrpt.com/ have youlooked at this ? Cheers, Aly.Dino Vliet wrote:> Hi folks,>> Maybe a litt
Hello Dino,
I think that there is something called openrpt http://www.openrpt.com/ have you
looked at this ?
Cheers,
Aly.
Dino Vliet wrote:
Hi folks,
Maybe a little bit off topic, but I want to convince
my managers of the value of opensource products and
decided that I wil
Hi folks,
Maybe a little bit off topic, but I want to convince
my managers of the value of opensource products and
decided that I will reverse engineer the datawarehouse
at my company. We are a small player and our
datawarehouse solution is based on an ETL tool from
Informatica, Oracle and Busines
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> writes:
> Why does Postgres perform updates to tables, even if the row doesn't
> change at all?
Because testing for this would almost surely be a net loss for the vast
majority of applications. Checking to see if the new row value exactly
equ
Sorry, missed the SQL to test.
Sebastian
/* tables */
CREATE TABLE test (
id INTEGER PRIMARY KEY,
test TEXT NOT NULL
);
CREATE TABLE join1 (
id INTEGER PRIMARY KEY,
text1 TEXT NOT NULL
);
CREATE TABLE join2 (
id INTEGER PRIMARY KEY,
text2 TEXT NO
Jaime Casanova wrote:
On 5/24/05, Sebastian Böck <[EMAIL PROTECTED]> wrote:
Martijn van Oosterhout wrote:
I'm sure I'm not the only one, but, what are you talking about? RULEs
are not really obvious so it would help if you could post an example of
what you mean...
I attach some sample SQL (
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 May 2005, Joe Conway wrote:
I got back finally last night, and I'm just now at 9 days behind in
reading the list traffic, but I should be able to build x86_64 FC3 RPMs in
the next day or two (unless someone has beat me to it). Unfo
Joe Conway wrote:
I got back finally last night, and I'm just now at 9 days behind in
reading the list traffic, but I should be able to build x86_64 FC3
RPMs in the next day or two (unless someone has beat me to it).
Unfortunately I no longer have an x86_64 FC2 machine available though...
I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 May 2005, Aly Dharshi wrote:
I hope that you are well. FC-x86_64 would suffice for me, don't know
what others may want, but is there a chance that you guys could churn a set
of RPMs with the Slony system in it. That would be extre
Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb [EMAIL PROTECTED]:
> It will be a very pleasant idea. Although I am
> an application developer I don't know if I have
> enough knowledge to do that. Do you know how could
> I help the PostgreSQL development ?
>
> Another feature I missed is the "re
I wanted to see which tables/transaction have acquired or are waiting for which locks
as far as i know there are two ways to do it
1) pg_locks ::: need to write trigger... and have high overhead...
2) trace_locks,trace_lwlocks ... etc etc ::: well for this my server says undefined p
On 5/24/05, Sebastian Böck <[EMAIL PROTECTED]> wrote:
> Martijn van Oosterhout wrote:
> > I'm sure I'm not the only one, but, what are you talking about? RULEs
> > are not really obvious so it would help if you could post an example of
> > what you mean...
> >
> > Have a nice day,
>
> Hi, I'm not
On Tue, May 24, 2005 at 13:49:40 -0300,
[EMAIL PROTECTED] wrote:
>
> Another feature I missed is the "returning" clause
> of the Oracle "INSERT" SQL command, which allow the
> user to retrieve the "serial" value after an insert
> command, which works even in a concurrent network
> environment.
It will be a very pleasant idea. Although I am an application developer I don't know if I haveenough knowledge to do that. Do you know how couldI help the PostgreSQL development ?Another feature I missed is the "returning" clause of the Oracle "INSERT" SQL command, which allow the user to retrieve
Am Dienstag, den 24.05.2005, 10:37 -0500 schrieb Mike Nolan:
> > > I hope anybody can help me on this subject. The problem is not to find
> > > a substitute for the Oracle synonyms, but a way to write queries
> > > which, reliably, can be used no matter the schema which owns the
> > > tables.
> >
I've tried to install pg_autovacuum as WindowsXP service but after intalling it properly, and when I try to initialize it, I get a 1053 error: "The service did not respond to the start or control request in a timely fashion".
The way that I've installed the service is:
pg_autovacuum -I -N .\winU
On Fri, May 20, 2005 at 01:03:08PM -0400, Tom Lane wrote:
> But having said that, I don't have a problem with putting in a
> pg_operator entry for numeric_power. And if someone wants to improve
> the scale factor calculations therein, go for it.
Oh, and while at it, it would be nice to solve the
Martijn van Oosterhout wrote:
I'm sure I'm not the only one, but, what are you talking about? RULEs
are not really obvious so it would help if you could post an example of
what you mean...
Have a nice day,
Hi, I'm not really talking about rules.
I'm talking about updates on *real* tables, and
Send email to the list address, but add -request to the end of the first
part. EG: send email to [EMAIL PROTECTED] with the
subject: unsubscribe
On Tue, 2005-05-24 at 09:51 -0400, [EMAIL PROTECTED] wrote:
> I went to the link given to unsubscribe... (someone said it was
> SIMPLER), and I did no
I'm sure I'm not the only one, but, what are you talking about? RULEs
are not really obvious so it would help if you could post an example of
what you mean...
Have a nice day,
On Tue, May 24, 2005 at 05:05:34PM +0200, Sebastian Böck wrote:
> Hi all,
>
> maybe it's a very silly question, but why
Hi Folks,
I hope that you are well. FC-x86_64 would suffice for me, don't know what
others may want, but is there a chance that you guys could churn a set of RPMs
with the Slony system in it. That would be extremely cool and would appreciate
that alot. :)
Cheers,
Aly.
Joe
> > I hope anybody can help me on this subject. The problem is not to find
> > a substitute for the Oracle synonyms, but a way to write queries
> > which, reliably, can be used no matter the schema which owns the
> > tables.
>
> Maybe you use views?
Unless it changed in 8, you can't insert into o
Hi all,
maybe it's a very silly question, but why does Postgres perform an
update on the table even if no data changes?
I recognized this recently doing a rewrite of my rules because they
took to long. I had many conditional rules I collapsed to one
unconditional rule, so that the views get
On Mon, 2005-05-23 at 14:07, LiSim: Rainer Mokros wrote:
> Hello,
> Anyone has try to install Postgres on a AMT Opteron (Dual Core) box with 4
> CPU’s and 64GB main memory and 3 TB Raid 10 (24 disks) Linux (2.6), to run a
> datawarehouse of 1TB.
> Any points
No, but if you buy my ticket I'd fly ou
Jerome Macaranas <[EMAIL PROTECTED]> writes:
> LOG: query: SELECT * FROM phpbb_smilies
> LOG: duration: 0.005410 sec
> LOG: duration: 390.731807 sec
> -- this table has only 295 rows
I think this is an artifact of your lack-of-vacuuming problems;
the table has become hugely bloated and it takes
Scott Marlowe wrote:
I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it
needs to take to come out, which could be anything, but will likely be
no earlier than the end of the year.
I believe there was talk about an 8.1 coming out to replace the caching
algorithm, but I believ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi @ all,
I'm need a little bit help on OpenSSL in combination with PG 8.0.2
under Mac OS X, but I think that is the same thing like under BSD or
Linux.
My PG running with OpenSSL and I have no problems connecting from my
laptop (running the cl
Hi,
I'm a new user of Postgree.
I want to know if is possible to use TOAD for
example to acess Postgree or if there is another Procedural Language to access
this database.
Thank you,
Julie
Hello,
Anyone has try to install Postgres on a AMT Opteron (Dual Core) box with 4
CPUs and 64GB main memory and 3 TB Raid 10 (24 disks) Linux (2.6), to run a
datawarehouse of 1TB.
Any points
Kind regards
Rainer
---(end of broadcast)---
TIP 5: Have
On Tue, 2005-05-24 at 08:37, James Croft wrote:
> Hi,
>
> Does anyone know if there is a publicly available release schedule for
> upcoming versions of PostgreSQL along with proposed new functionality?
>
> In a month or so I'm going to start on updating an app from Pg7.1 and
> would like to kno
On Tue, 2005-05-24 at 08:51, [EMAIL PROTECTED] wrote:
> I went to the link given to unsubscribe... (someone said it was
> SIMPLER), and I did not find it simple,. I clicked and
> clicked tried all sorts of thingsbut...
>
> no luck...
>
> Then I sent emails with word unsubscribe bot
I went to the link given to unsubscribe... (someone said it was SIMPLER), and I did not find it simple,. I clicked and clicked tried all sorts of thingsbut...
no luck...
Then I sent emails with word unsubscribe both in the subject and in the body
but no luck...
could someon
On Tue, 2005-05-24 at 07:19, Jerome Macaranas wrote:
> hi,
>
> I enabled logging for a while just to see what statement is taking too
> much
> time.. listed below are some parts of the log.. im wondering why this sql
> takes to much time.. they have indexes in place.. or it might be my co
Hi,
Does anyone know if there is a publicly available release schedule for
upcoming versions of PostgreSQL along with proposed new functionality?
In a month or so I'm going to start on updating an app from Pg7.1 and
would like to know if should start writing for Pg8.0 or if 8.1 is around
the
On Monday 23 May 2005 06:09 pm, Scott Marlowe wrote:
> On Mon, 2005-05-23 at 16:54, Chris Kratz wrote:
> Are you folks running 8.0 with its improved caching algorithms? Just
> wondering if that helps or not.
I should have noted that we are still using 7.4 on our production servers. We
are plann
On Tue, 2005-05-24 at 00:13, Surabhi Ahuja wrote:
> I have a table in which one attribute "id" is a bigserial
>
> when i say
> select setval('table_id_seq', 0);
> it says: values 0 is out of bounds.
> what should i do?
IS that what you really want, or do you just want the first assignment
to be a
hi,
I enabled logging for a while just to see what statement is taking too
much
time.. listed below are some parts of the log.. im wondering why this sql
takes to much time.. they have indexes in place.. or it might be my config?
tcpip_socket = true
max_connections = 260
superuser_rese
unsubscribe
On Tue, 24 May 2005 02:12 pm, Tom Lane wrote:
> "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> > I'd like to use pg_dump to grab a live backup and, based on the
> > documentation, this would seem to be a realistic possibility. When I
> > try, though, during business hours, when people are
Vidya wrote:
How do I unsubscribe from postgres general list
Go here
http://www.postgresql.org/community/lists/
Select the link for pgsql-general then follow the link to
subscribe/unsubscribe.
You can do it all via email, but I find the web interface easier.
--
Richard Huxton
Archone
Surabhi Ahuja wrote:
I have a table in which one attribute "id" is a bigserial
when i say
select setval('table_id_seq', 0);
it says: values 0 is out of bounds.
what should i do?
Try a "SELECT * FROM table_id_seq" and see what it's min_value is - I'm
guessing it's set to 1.
HTH
--
Richard
Hi and thanks for your reply!
Martijn van Oosterhout wrote:
Now to the problem. We want to merge rows with id = 2 and id = 4 into id
= 1 in the asdf table with the qwert table beeing updated to reflect the
change. The desired result would yeild:
Why doesn't:
update quert set data = 1 where d
How do I unsubscribe from postgres general list
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Am Montag, den 23.05.2005, 23:21 -0300 schrieb [EMAIL PROTECTED]:
> So the search_path can not substitute the Oracle synonyms function
> which in a single way allow us to write generic queries for an
> application no matter the schema which is being used.
>
> I can not find a solution on this matt
59 matches
Mail list logo
