Brent,
By sheer coincidence, I just came across http://livecd.ominiverdi.org/
which may be exactly what you are looking for...
Included software:
* GRASS 6.3.0
* QGIS 0.11.0
* PostgreSQL 8.3.1
* PostGIS 1.3.1
* GDAL 1.5.0
* Proj 4.5.0
* R 2.4.1
* PgAdmin 1.6.3
* The win folder on the livecd, con
On Tue, Dec 9, 2008 at 8:59 PM, Chris <[EMAIL PROTECTED]> wrote:
> Richard Huxton wrote:
>>
>> WireSpot wrote:
>>>
>>> This mechanism is still not perfect. Technically it is still possible
>>> for race conditions to appear. Apparently (in PHP at least) pg_connect
>>> does persistent connections by
Robert Treat wrote:
> On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
>> Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
>> Debian has a much slower release cycle than Ubuntu and is thus
>> considered by many people to be preferable for production server
>> applicatio
On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
> Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
> Debian has a much slower release cycle than Ubuntu and is thus
> considered by many people to be preferable for production server
> applications.
>
Another option for
Richard Huxton wrote:
WireSpot wrote:
This mechanism is still not perfect. Technically it is still possible
for race conditions to appear. Apparently (in PHP at least) pg_connect
does persistent connections by default.
Nope - pg_pconnect() does that. Multiple calls to pg_connect() within
the s
Hi, Gabor
> The type of login is text.
> What is the problem with the equal sign?
> psql server version: 8.2.11
I had tested them, both got correct result.
version: 8.2.11 & 8.3.5 for windows
without partition
Maybe, as Moran said, reindex it and try again.
-
Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
Debian has a much slower release cycle than Ubuntu and is thus
considered by many people to be preferable for production server
applications.
This is one of the reasons we plan on releasing appliances that are
based on Debian
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Well, since CREATE LANGUAGE creates the functions internally, it does
> make a certain amount of sense that the functions are also handled
> internally when you do stuff to the language.
It *might* create the functions internally, or it might not. Admi
Erik Jones wrote:
>
> On Dec 8, 2008, at 1:42 PM, Tom Lane wrote:
>
>> Erik Jones <[EMAIL PROTECTED]> writes:
>>> I've just run up against a problem with ALTER LANGUAGE ... OWNER
>>> TO ... wherein the change of ownership does not propagate to a
>>> language's handler and validator functions preven
On Tue, Dec 9, 2008 at 3:35 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Piotr Foremniak <[EMAIL PROTECTED]> writes:
>> When executing some quite complex select queries our 8.3.5 Postgres
>> often hangs. The query that we used to reproduce this problem on our
>> isolated test environment is a quite co
On Dec 8, 2008, at 1:42 PM, Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
I've just run up against a problem with ALTER LANGUAGE ... OWNER
TO ... wherein the change of ownership does not propagate to a
language's handler and validator functions preventing you from
dropping the role if
I think it could be done but this is kind of a specialized
application that it is unlikely we will get in the near future, until we
get the much more common applications out of our queue.
Meanwhile you have several options: install the TurnKey PostgreSQL
appliance into a virtual machine such as VM
Piotr Foremniak <[EMAIL PROTECTED]> writes:
> When executing some quite complex select queries our 8.3.5 Postgres
> often hangs. The query that we used to reproduce this problem on our
> isolated test environment is a quite complex join of ca.15 tables.
> When executed only once, it always takes ca
From: Dann Corbit
Sent: Tuesday, December 09, 2008 2:14 PM
To: 'Tony Linden'; pgsql-general@postgresql.org
Subject: RE: [GENERAL] q query about a bug.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Linden
Sent: Tuesday, December 09, 2008 10:09 AM
To: pgsql-general@postgres
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Linden
Sent: Tuesday, December 09, 2008 10:09 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] q query about a bug.
Dear
We have a developer doing an application for us using a Postgre Db. One
of the items is to expo
In response to "Tony Linden" <[EMAIL PROTECTED]>:
> Dear
>
> We have a developer doing an application for us using a Postgre Db. One
> of the items is to export the data into a xml file and then either email
> or whatever but the ability is there then to import the xml data back
> into the datab
In response to "Schwéger Gábor" <[EMAIL PROTECTED]>:
>
> This is my first post to this list.
> Our database moved to a larger partition.
> And now I have a problem with a select query:
> db=# SELECT id, login FROM u WHERE login LIKE 'bellamarth';
>id |login
> +-
> 17
Hello,
When executing some quite complex select queries our 8.3.5 Postgres
often hangs. The query that we used to reproduce this problem on our
isolated test environment is a quite complex join of ca.15 tables.
When executed only once, it always takes ca. 500ms to finish. When
executed by a JMete
2008/12/2 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>
> On Tue, Dec 2, 2008 at 11:40 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
>
> > Is \l+ what you mean?
>
> same thing but from command line ?
> not the shell
>
it looks like a useful and easy to implement TODO item :)
>
> --
> GJ
>
> --
> Se
Hi List,
This is my first post to this list.
Our database moved to a larger partition.
And now I have a problem with a select query:
db=# SELECT id, login FROM u WHERE login LIKE 'bellamarth';
id |login
+-
173002 | bellamarth
(1 row)
db=# SELECT id, login FROM u WHER
Dear
We have a developer doing an application for us using a Postgre Db. One
of the items is to export the data into a xml file and then either email
or whatever but the ability is there then to import the xml data back
into the database. So what happens is that the contents of certain
tables
Grzegorz Jaśkiewicz wrote:
On Tue, Dec 9, 2008 at 9:02 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote:
or even, when you change bar to proper type - that is, timestamp
SELECT distinct foo, min(bar) as minbar, max(bar) as maxbar FROM
table WHERE bar < '2008-12-07
16:32:46' AND tbl_id=153 OR
Grzegorz Jaśkiewicz wrote:
On Mon, Dec 8, 2008 at 10:19 PM, Madison Kelly <[EMAIL PROTECTED]> wrote:
Hi all,
I've got a table that I am trying to SELECT DISTINCT on one column and
ORDER BY on a second column, but am getting the error:
SELECT DISTINCT ON expressions must match initial ORDER BY
On Tue, Dec 9, 2008 at 9:13 PM, Scott Marlowe <[EMAIL PROTECTED]>wrote:
>
>
> I'm pretty sure you'd have to vacuum still in between runs or the
> extra fill factor space would only get used the first time. I.e.:
>
> create table fill factor 50%
> load data into table
> update whole table -- 50% f
I think in this instance the user would be better off just installing
the pgsql windows version. It's dirt simple. I'm no windows guru
(all I use it for is games) but installing pgsql in windows was simple
enough even I could figure it out.
On Tue, Dec 9, 2008 at 1:21 AM, Liraz Siri <[EMAIL PROT
On Tue, Dec 9, 2008 at 3:17 AM, Albe Laurenz <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
>> Sebastian Böhm wrote:
>> > I have a table with a lot of columns (text and integer).
>> >
>> > It currently has 3Mio Rows.
>> >
>> > Updating a column in all rows (integer) takes endless (days).
>>
>> I
Peter Eisentraut <[EMAIL PROTECTED]>Peter Eisentraut schrieb:
> Thomas Guettler wrote:
>> My naive first solution was quite slow. Why is it so slow?
>> I guess (select d.master_id from detail as d) gets executed for every
>> master-row. But why? Shouldn't
>> it be possible to calculate it once and
On Tue, Dec 9, 2008 at 6:56 AM, Thomas Guettler <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a two tables: master and detail.
> I search all master rows without a detail row.
>
> master: 1 rows
> detail: 29800 rows
>
> Although all three solution have the same result, The execution time
> differ
Andrus wrote:
Peter,
You probably want et_EE. (Language and country codes are not always
consistent.)
I don't understand this.
Command line which I posted uses et_EE
What is the exact command line ?
Uh, forget that.
Does locale -a show the locale you want?
If not, run dpkg-reconfigure lo
Peter,
You probably want et_EE. (Language and country codes are not always
consistent.)
I don't understand this.
Command line which I posted uses et_EE
What is the exact command line ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
Thomas Guettler wrote:
My naive first solution was quite slow. Why is it so slow?
I guess (select d.master_id from detail as d) gets executed for every
master-row. But why? Shouldn't
it be possible to calculate it once and then reuse it?
Please show exact schema dumps and your PostgreSQL versi
Andrus wrote:
How to create cluster with et_EE locale ?
You probably want et_EE. (Language and country codes are not always
consistent.)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
Hi,
I have a two tables: master and detail.
I search all master rows without a detail row.
master: 1 rows
detail: 29800 rows
Although all three solution have the same result, The execution time
differs very much.
My naive first solution was quite slow. Why is it so slow?
I guess (select d.
How to create cluster with et_EE locale ?
Command below causes error.
Andrus.
mail:/var/lib/postgresql# pg_createcluster --locale=et_EE.UTF8 8.3 main
Creating new cluster (configuration: /etc/postgresql/8.3/main, data:
/var/lib/postgresql/8.3/main)...
initdb: invalid locale name "et_EE.UTF8"
in
Scott Marlowe wrote:
> Sebastian Böhm wrote:
> > I have a table with a lot of columns (text and integer).
> >
> > It currently has 3Mio Rows.
> >
> > Updating a column in all rows (integer) takes endless (days).
>
> I'm afraid you may not understand how postgresql's MVCC implementation
> works her
how about naming columns in select, instead of using cursed '*'?
that usually helps ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Dec 9, 2008 at 9:02 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote:
> or even, when you change bar to proper type - that is, timestamp
>
> SELECT distinct foo, min(bar) as minbar, max(bar) as maxbar FROM
> table WHERE bar < '2008-12-07
> 16:32:46' AND tbl_id=153 ORDER BY bar LIMIT 1;
On Mon, Dec 8, 2008 at 10:19 PM, Madison Kelly <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I've got a table that I am trying to SELECT DISTINCT on one column and
> ORDER BY on a second column, but am getting the error:
>
> SELECT DISTINCT ON expressions must match initial ORDER BY expressions
try
SE
Hi Todd,
Interesting you should bring that up, supporting high availability is
actually something we've talked about doing a bit further down the road.
Before we get to that though, there are still quite a few low hanging
fruit to pick.
If someone with experience in this field picks up the ball a
Hi Mike,
Using virtual machine software such as VirtualBox (which is free),
Microsoft Virtual PC (which is also free for use) and VMware you can
easily install TurnKey PostgreSQL into a virtual machine that can run
anywhere, including Windows.
Maybe you should try that...
Cheers,
Liraz
Pagel, M
Hi Brent,
The current release of TurnKey PostgreSQL doesn't include postgis but it
should be easy enough to add post-installation:
apt-get install postgis postgresql-8.3-postgis
Since the packages are quite small, we'll add them by default when we
release the next version of the applianc
Adam Rich Wrote:
> > >
> > > When we get windowing functions, a lot of this pain will go away :)
> > >
> >
> > Yes! Hope it won't be too long now. The patch seems to behave like it
> > should
> > now :)
> > Hopefully we'll see it commited for 8.4.
> >
> > Though this does not look too much cleaner
42 matches
Mail list logo
