I have a process that is hitting deadlocks. The message I get talks about
relation and database numbers, not names. How do I map the numbers back
into names?
David
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an
> I have a process that is hitting deadlocks. The message I get talks about
> relation and database numbers, not names. How do I map the numbers back
> into names?
Hi,
you need to query the catalog:
-- relations like tables:
select oid, relname from pg_class;
-- databases:
select oid,
On Friday 27 October 2006 09:59, Alban Hertroys wrote:
> Hello list,
>
> We're investigating a ways to replicate changes to the database to
> several "outside" systems.
>
> Some filtering will need to take place, as not all changes are allowed
> to go to all systems. Whether the system receiving th
Top at 350-400 concurrent connections! Although more than my project's
peak estimates, it is a bit discomforting. Are there any *promising*
load testing numbers with Windows 2003? I'd be happy to share results
from my simulations.
Matt
> Original Message
> Subject: Re: [GENERAL]
On Fri, Oct 27, 2006 at 03:59:02PM +0200, Alban Hertroys wrote:
> 2.) Use one of the existing replication systems. We're currently under
> the impression that (we've looked at Slony-I particularly) the slave
> system is supposed to be another (postgresql?) database. This wouldn't
> fit our needs
Marc G. Fournier wrote:
> - --On Friday, October 27, 2006 19:05:01 -0300 Alvaro Herrera
> <[EMAIL PROTECTED]> wrote:
>
> > http://archives.postgresql.org/pgsql-es-ayuda/2006-10/msg00565.php
>
> The one you sent me is from ~2 hours after the original post:
>
> Date: Fri, 27 Oct 2006 11:12:53 -0
Hello,
I'm having a performance issue with
postgresql. I'm using it with JBoss BPM api and when I use the api to
delete a process instance from the database, it seems like the delete requests
are taking quite a long time to delete. I've also noticed that when I
execute the delete, the c
> JDBC *can* cancel a running statement. You just need to call cancel()
> from another thread.
>
> http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#cancel()
>
> Works great in my SQL front end.
Are you sure ? Ever tried to cancel a long running statement and see if
it is still ru
Hello,
I'm a bit new to PostgreSQL, and I have a question about user-defined
types.
Is it possible to have an array of user-defined types?
Suppose the type looks like this:
CREATE TYPE part AS
(id int2,
count int2);
Now I want to have a column in a table that is a list of parts:
alter tab
Is there a means to know the type of an expression ?
Something like a "typeof" function ?
As I work a lot with numbers of type "numeric", I often want to know
the precision of the result returned by an expression, in case the
returned result is "numeric".
I would also like to know if numbers of ty
Hi,
Does PG support Instead of Triggers?.
Regards,
Gabriel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 10/27/06, Sandeep Kumar Jakkaraju <[EMAIL PROTECTED]> wrote:
Is postgres installed by default in Fedora Core 5 ??
-
Sandeep Kumar Jakkaraju
I know that there are Fedora 5 RPM's for postgresql, that you can easily install via yum or your favorite install method. It's *probably* included amon
Hi everyone,
I am searching for the easiest way to let PostgreSQL parse a special
dialect of SQL. The dialect I want to parse augments common SQL in a way
that enables expressions within a WHERE clause to be annotated and is
thus not compatible with the standard SQL syntax anymore.
I am tota
On Fri, Oct 27, 2006 at 03:40:51PM -0400, Schwenker, Stephen wrote:
> I'm having a performance issue with postgresql. I'm using it with JBoss
> BPM api and when I use the api to delete a process instance from the
> database, it seems like the delete requests are taking quite a long time
> to delet
[EMAIL PROTECTED] wrote:
> Top at 350-400 concurrent connections! Although more than my project's
> peak estimates, it is a bit discomforting. Are there any *promising*
> load testing numbers with Windows 2003? I'd be happy to share results
> from my simulations.
Well keep in mind this is a Window
On Fri, Oct 27, 2006 at 05:49:19PM +0530, chelliah gabriel - Sun Microsystems -
Bangalore India wrote:
> Does PG support Instead of Triggers?.
PostgreSQL has INSTEAD OF rules. Will that work? What are you
trying to do?
http://www.postgresql.org/docs/8.1/interactive/sql-createrule.html
http://w
Matthias Lüdtke wrote:
> Hi everyone,
>
> I am searching for the easiest way to let PostgreSQL parse a special
> dialect of SQL. The dialect I want to parse augments common SQL in a way
> that enables expressions within a WHERE clause to be annotated and is
> thus not compatible with the standa
Michael Fuhr wrote:
> On Fri, Oct 27, 2006 at 05:49:19PM +0530, chelliah gabriel - Sun Microsystems
> - Bangalore India wrote:
> > Does PG support Instead of Triggers?.
>
> PostgreSQL has INSTEAD OF rules.
It also has the ability to prevent the execution of the action which
triggered the, um, tr
On Sun, 29 Oct 2006, Alvaro Herrera wrote:
>
> Matthias Lüdtke wrote:
> > Hi everyone,
> >
> > I am searching for the easiest way to let PostgreSQL parse a special
> > dialect of SQL. The dialect I want to parse augments common SQL in a way
> > that enables expressions within a WHERE clause to be
Alvaro Herrera wrote:
I am searching for the easiest way to let PostgreSQL parse a special
dialect of SQL. The dialect I want to parse augments common SQL in a way
that enables expressions within a WHERE clause to be annotated and is
thus not compatible with the standard SQL syntax anymore.
N
Any thoughts on why dynamically adding a column to a table
would require a run time of 24,000 + milliseconds??
Adding a serial column to three tables requires almost
100,000 ms.
Bob Pawley
Richard Troy wrote:
Our package lets you pass individual statements or entire files full
of SQL with embeded comments as it's not that uncommon among SQL
dialects - they're just stripped out before getting to the engine, as
Alvaro suggested.
Unfortunately I need the information in the statemen
Matthias,
what you want might be a type of collation sequence. You should be able to
code that within Postgres, I'd think, but I wouldn't think that passing
arguments as comments is appropriate.
RT
On Sun, 29 Oct 2006, Matthias Lüdtke wrote:
> Date: Sun, 29 Oct 2006 18:26:30 +0100
> From: Matt
[EMAIL PROTECTED] writes:
> Is it possible to have an array of user-defined types?
Scalar types, yes; composite types, no. Unfortunately the case you're
talking about is a composite type.
regards, tom lane
---(end of broadcast)
Bob Pawley <[EMAIL PROTECTED]> writes:
> Any thoughts on why dynamically adding a column to a table would require =
> a run time of 24,000 + milliseconds??
Updating all the rows to store the default value, no doubt. See
http://developer.postgresql.org/pgdocs/postgres/ddl-alter.html
especially the
Matthias Lüdtke wrote:
> Alvaro Herrera wrote:
> >>I am searching for the easiest way to let PostgreSQL parse a special
> >>dialect of SQL. The dialect I want to parse augments common SQL in a way
> >>that enables expressions within a WHERE clause to be annotated and is
> >>thus not compatible w
=?ISO-8859-1?Q?Matthias_L=FCdtke?= <[EMAIL PROTECTED]> writes:
> In fact, parsing this SQL dialect would just be the first step, as the
> annotations within the query induce an ordering of the result set.
> So I need this extra information in the query to accomplish the
> subsequent task of sorti
Alvaro Herrera wrote:
In fact, parsing this SQL dialect would just be the first step, as the
annotations within the query induce an ordering of the result set.
Huh, what is this supposed to be able to do that you can't do with the
already existing ORDER BY clause?
Basically, conditional stat
Tom,
Tom Lane wrote:
In fact, parsing this SQL dialect would just be the first step, as the
annotations within the query induce an ordering of the result set.
So I need this extra information in the query to accomplish the
subsequent task of sorting the result set in a certain way before the
r
Matthias Luedtke wrote:
>
> Alvaro Herrera wrote:
> >>In fact, parsing this SQL dialect would just be the first step, as the
> >>annotations within the query induce an ordering of the result set.
> >
> >Huh, what is this supposed to be able to do that you can't do with the
> >already existing ORD
On 10/29/06, Matthias Luedtke <[EMAIL PROTECTED]> wrote:
Alvaro Herrera wrote:
>> In fact, parsing this SQL dialect would just be the first step, as the
>> annotations within the query induce an ordering of the result set.
>
> Huh, what is this supposed to be able to do that you can't do with th
On 10/26/06, Robert Treat <[EMAIL PROTECTED]> wrote:
the wordpress guys have basically said they do not want to support postgres,
which is mainly why we swapped to s9y on planetpg. you can read some more
info here:
http://people.planetpostgresql.org/xzilla/index.php?/archives/13-One-Good-Port.ht
Dawid Kuroczko wrote:
Suppose one would like to create a WordPress workalike, i.e. a blogging
engine sharing look&feel of WordPress but written from scratch. What
language/framework do you think would be the best?
Try Squeak/Seaside (www.seaside.st). The continuation stuff
is optional, you can
Dawid Kuroczko wrote:
On 10/26/06, Robert Treat
<[EMAIL PROTECTED]> wrote:
the wordpress guys have basically said they
do not want to support postgres,
which is mainly why we swapped to s9y on planetpg. you can read some
more
info here:
http://people.planetpostgresql.org/xz
On Oct 29, 2006, at 10:00 pm, Dawid Kuroczko wrote:
Ruby on Rails perhaps? I have not written a single line in Ruby, but
I've read on the list here that it has very good PostgreSQL
interface...
Dawid,
The Rails postgres adapter works great. In fact, by and large you
don't need to care
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Matthias Luedtke wrote:
>> Basically, conditional statements are annotated with integers that
>> represent weights, like
>>
>> (...)WHERE (foo = 'a')[42] OR (bar = 'b')[20]
> (That particular notation has the drawback that the [n]
> would be interpret
Hi,
I'm new to postgresql and I'm looking for references and books. We are
usually coding in php/C.
Can somebody recommend me good books which covers Postgresql 8.x?
Which one is worth from following books?
1. PostgreSQL (2nd Edition) by Korry Douglas (Paperback - Jul 26, 2005)
2. Beginning
On 10/30/06, Ashley Moran <[EMAIL PROTECTED]> wrote:
Arguably that's because Ruby and Rails share
more of the design philosophy of Postgres, whereas PHP's design
rigour seems to be inspired by MySQL.
Could you please give some example of such "inspired by MySQL features
of PHP design"?
--
Bes
Nikolay Samokhvalov wrote:
On 10/30/06, Ashley Moran <[EMAIL PROTECTED]> wrote:
Arguably that's because Ruby and Rails share
more of the design philosophy of Postgres, whereas PHP's design
rigour seems to be inspired by MySQL.
Could you please give some example of such "inspired by MySQL feat
Ganbold,
There are man PDF files out there that outline all of the workings of
postgresql. They are easy to read, but also have 'deep dive'
information in them as well. The PDF's are really valuable, both for
the novice and for those who are experienced.
I'd start there.
Ganbold wrote:
H
40 matches
Mail list logo
