On Jul 30, 2007, at 3:20 AM, Srinivas Kotapally wrote:
I just wanted to know if the patches that are applied to Postgres
are back ported to earlier versions? For example, I run the last
stable release in version 8.1... 8.1.9? Do I need to upgrade to
8.2.x to benefit from the patches? Or is
Moving to -general.
On Jul 26, 2007, at 12:51 PM, NetComrade wrote:
I apologize for cross-posting, but I need some help w/o too many
advices RTFM :). After Oracle and MySQL, this becomes the third
product that I need to learn to some degree, and I need a few links
which would provide a 'quick tu
[Please don't post the same question to many lists. Choose one. If
you're unsure if it's the correct list for your question, ask if
there's a more appropriate one. This question is find for -novice or -
general. Thanks.]
On Jul 30, 2007, at 23:19 , Ronald Rojas wrote:
And, I want to add the
Hi,
Anybody knows how to add column with reference to BEFORE or AFTER any
given column? Let say here's my table structure:
Column | Type| Modifiers
--+---+---
surname | character varying |
lastname | character varying |
address | character
On 7/31/07, Michael Fuhr <[EMAIL PROTECTED]> wrote:
>
> On Tue, Jul 31, 2007 at 10:35:25AM +1200, adey wrote:
> > -- CAUTION: this query may impact system performance as you are
> selecting
> > from system tables
>
> What difference are you expecting that to make and why?
It was a warning I recei
On Mon, Jul 30, 2007 at 06:20:14AM -0400, Srinivas Kotapally wrote:
> I just wanted to know if the patches that are applied to Postgres are back
> ported to earlier versions? For example, I run the last stable release in
> version 8.1... 8.1.9? Do I need to upgrade to 8.2.x to benefit from the
>
On Tue, Jul 31, 2007 at 10:35:25AM +1200, adey wrote:
> -- CAUTION: this query may impact system performance as you are selecting
> from system tables
What difference are you expecting that to make and why?
--
Michael Fuhr
---(end of broadcast)---
On Mon, Jul 30, 2007 at 07:11:11PM +0300, Milen A. Radev wrote:
> I have performance problems with a DB (slow queries) and I suspect the
> main cause is that a lot of queries wait for a lock on one small
> table. That's why I need some stats about the number and (average)
> wait-time for locks (eve
Try this query for a start, and add system tables to the join to find what
you want:-
-- displays locks with database name and username, but not table
-- CAUTION: this query may impact system performance as you are selecting
from system tables
select
relation
, c.relname
, u.usename
, pid
On Thu, 26 Jul 2007 21:02:58 -0500, John Koller
<[EMAIL PROTECTED]> wrote:
>NetComrade wrote:
>
>> I'd like to know a couple of things
>> a) how do I access this thing as a DBA to poke around
>
>The command line client is psql. Since psql defaults to port 5432 and you do
>appear to have two cluste
run this in the command line
locate postmaster.pid
or
find / -name "postmaster.pid" -print
that should locate any postmaster files and then remove whatever
looks like the postmaster.pif file
Thank you! I found postmaster.pid in usr/local/pgsql/data. I deleted
the whole pgsql directory an
Hello all
Follow up my previous post and the respons given by Andrew Sullivan,
I make a lot of tests and first problem the function _PG_fini are never
called it is a bug ?.
This is a big problem for me because I want to cleanup the data managed
by my trigger.
second problem I cannot detect from a
Hello all
Follow up my previous post and the respons given by Andrew Sullivan,
I make a lot of tests and first problem the function _PG_fini are never
called it is a bug ?.
This is a big problem for me because I want to cleanup the data managed
by my trigger.
second problem I cannot detect from a
Hello all
Follow up my previous post and the respons given by Andrew Sullivan,
I make a lot of tests and first problem the function _PG_fini are never
called it is a bug ?.
This is a big problem for me because I want to cleanup the data managed
by my trigger.
second problem I cannot detect from a
Hello all
Follow up my previous post and the respons given by Andrew Sullivan,
I make a lot of tests and first problem the function _PG_fini are never
called it is a bug ?.
This is a big problem for me because I want to cleanup the data managed
by my trigger.
second problem I cannot detect from a
I have performance problems with a DB (slow queries) and I suspect the
main cause is that a lot of queries wait for a lock on one small
table. That's why I need some stats about the number and (average)
wait-time for locks (even only for this particular table).
After a bit of googling I found a pr
I try to do a silent install under Windows using the following command
msiexec /i postgresql-8.0-int.msi /qr INTERNALLAUNCH=1
SERVICEPASSWORD="1955" CREATESERVICEUSER=1 SUPERPASSWORD="1955"
Everything starts smoothly but I end up with an errormessage pointing me to
a file called pgperm.log which
Hi All,
I just wanted to know if the patches that are applied to Postgres are back
ported to earlier versions? For example, I run the last stable release in
version 8.1... 8.1.9? Do I need to upgrade to 8.2.x to benefit from the
patches? Or is there a latest 8.1.9 binary that I can download and
You could do a stored procedure for inserting into another table... Otherwise if
you want to get the result as a query, you could do something like,
Select field1, exp(field2) as expoffield2 from tablename1
Hope that helps,
Srini
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
19 matches
Mail list logo
