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
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
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
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
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
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
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
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
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
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
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
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
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
=?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
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
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
[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)
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
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
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
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
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
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
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
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
[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 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
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 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,
Does PG support Instead of Triggers?.
Regards,
Gabriel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
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
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
> 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 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
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
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
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 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
> 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,
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
40 matches
Mail list logo
