On 2011-01-16, Randall Smith rand...@tnr.cc wrote:
Before reading. This is solved. Was an error on my part.
On Sun, 2011-01-16 at 03:46 +, Jasen Betts wrote:
In plpgsql IF is an implicit select.
http://www.postgresql.org/docs/8.4/interactive/plpgsql-expressions.html
IF
Hello,
I am using PostgreSQL 9.0.2-1 (specifically the pre-compiled ZIP distribution
for Win32, postgresql-9.0.2-1-windows-binaries.zip, from EnterpriseDB
http://www.enterprisedb.com/postgresql-902-binaries-win32?ls=Crossovertype=Crossover).
The Host is an Intel x86 (Core2Duo) machine running
On 2011-01-17, Fredric Fredricson fredric.fredric...@bonetmail.com wrote:
This is a multi-part message in MIME format.
--00060003050104030402
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
On 01/15/2011 11:52 PM, Randall Smith wrote:
Forgot to mention that:
1. After the shutdown request, I can see that there are still two processes
running (postgres.exe). One of the two is hogging the CPU (it uses one of the
two cores 100%, so it shows up as 50 on the task manager). The other seems to
be
waiting, using 0%.
2. If I go to
Hi,
On 15/01/2011 14:21, Craig Ringer wrote:
On 01/14/2011 03:45 PM, Jensen Somers wrote:
Bundling it as part of my application is even better. I didn't knew if
that would be possible, but it would solve some of the issues. Mainly
data protection. The data that needs to be stored should not be
Mucho agradeseria remitieran las repuestas de este tipo de corroes al que
los origino y no a todos.
Las respuestas de algunos no les interesan a todos.
Saludos
2011/1/16 Fernando Hevia fhe...@gmail.com
En oportunidades anteriores donde me ha tocado trabajar con empresas
cubanas fue la
Am 17.01.2011 00:20, schrieb Steve Litt:
On Sunday 16 January 2011 17:40:34 Julia Jacobson wrote:
Hello everybody out there using PostgreSQL,
A table with the results of students in different exams
student | date_of_exam | grade
--
Peter | 2010-09-09 | 2
Tom
On 01/17/2011 06:44 PM, Alexandros Karypidis wrote:
Forgot to mention that:
1. After the shutdown request, I can see that there are still two processes
running (postgres.exe). One of the two is hogging the CPU (it uses one of the
two cores 100%, so it shows up as 50 on the task manager). The
http://wiki.postgresql.org/wiki/Streaming_Replication
I have gone through the above link. Current streaming replication provides
Asynchronous based solution synchronous solution will come with version 9.1
Can some one please give me an approximate idea when version 9.1 will be
release?
--
On 01/17/2011 06:46 PM, Jensen Somers wrote:
Once a recording session is completed the data should be locked and not
modified anymore. And everything should be local on the user's PC, I
can't use an external database server.
Those two requirements are mutually exclusive, unless you're willing
hi,
postgresl-8.4.6 (database encoding is utf8)
the following sql behaves strangely on one of my servers:
create table ttt(id serial not null primary key, name text);
insert into ttt (name) values ('CLARKE, DAVID');
insert into ttt (name) values ('CLARK, PETER');
insert into ttt (name)
On Mon, Jan 17, 2011 at 11:46:11AM +0100, Jensen Somers wrote:
I am migrating from a binary data format. But it's hard to maintain and
add new features. Most of the operations I need to perform on the data
is list, sort and analyze, which is why I'm interested into using a
database as a
Hi,
On 17/01/2011 14:49, Craig Ringer wrote:
On 01/17/2011 06:46 PM, Jensen Somers wrote:
Once a recording session is completed the data should be locked and not
modified anymore. And everything should be local on the user's PC, I
can't use an external database server.
Those two
On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote:
But, from your initial reply I understood that a user can simply browse
to my database installation folder (e.g.: C:/ProgramData/MyApp/data),
read out and/or modify a configuration file and he can access the entire
database
On Jan 16, 2011, at 7:40 PM, Andrej wrote:
Is there an idiot installable package for MacOsX Snow Leopard that will
provide a 'better' user experience for accessing Pg via the web, especially
when viewed on the iPad?
It's not perl, but have you considered
http://phppgadmin.sourceforge.net/
On Monday 17 January 2011 5:43:19 am Jaiswal Dhaval Sudhirkumar wrote:
http://wiki.postgresql.org/wiki/Streaming_Replication
I have gone through the above link. Current streaming replication provides
Asynchronous based solution synchronous solution will come with version
9.1
Can some one
On 17/01/2011 16:46, Andrew Sullivan wrote:
On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote:
But, from your initial reply I understood that a user can simply browse
to my database installation folder (e.g.: C:/ProgramData/MyApp/data),
read out and/or modify a configuration file
On Jan 17, 2011, at 10:48 AM, John DeSoi wrote:
On Jan 16, 2011, at 7:40 PM, Andrej wrote:
Is there an idiot installable package for MacOsX Snow Leopard that will
provide a 'better' user experience for accessing Pg via the web, especially
when viewed on the iPad?
It's not perl, but
On Monday 17 January 2011 8:11:20 am Jensen Somers wrote:
On 17/01/2011 16:46, Andrew Sullivan wrote:
On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote:
But, from your initial reply I understood that a user can simply browse
to my database installation folder (e.g.:
On Jan 17, 2011, at 11:19 AM, Jerry LeVan wrote:
There also seems to be some nice looking native iPad/iPhone apps with the
ability to perform ad-hoc queries using PostgreSQL.
Pointers to the apps if you please :)
I did not give links because I have not used any of them. But if you
Jerry,
http://www.gnegg.ch/2009/08/snow-leopard-and-php/
It sorta looks like the above might blow away the existing php stuff...
Have you considered using the MacPorts version? That's what I use for
development on my Macs and I've never had a problem replicating my
production environments
On Jan 17, 2011, at 11:30 AM, Gary Chambers wrote:
http://www.gnegg.ch/2009/08/snow-leopard-and-php/
It sorta looks like the above might blow away the existing php stuff...
Have you considered using the MacPorts version? That's what I use for
development on my Macs and I've never had a
Hi,
Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server, when
trying to create a table:
CREATE TABLE observation (
(...)
spatial_value geometry,
);
I get this error message:
ERROR: type geometry does not exist
I supposed that installing postgis I would get the geographical object,
Jerry,
Yes, I tried MacPorts. I seemed get caught in some kind of dependency hell
and could not get things to update correctly.
I agree that it can be somewhat tedious to keep the packages up-to-date, but
you'll face that problem (in varying degrees of difficulty, admittedly) no
matter what
Op 17 jan 2011, om 18:35 heeft Plata Martínez, Álvaro (KNMI) het
volgende geschreven:
Hi,
Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server,
Did also install the PostGIS-functions, types, etc. in your database?
Installing PostGIS is a combination of installing the package
=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?=
alvaro.plata.marti...@knmi.nl writes:
Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server, when
trying to create a table:
CREATE TABLE observation (
(...)
spatial_value geometry,
);
I get this error message:
Hi,
for adding a geometry-column to an existing table use one of the
postgis-functions select AddGeometryColumn(...); described in:
http://postgis.refractions.net/documentation/manual-1.5/AddGeometryColumn.html
Ludwig
Am 17.01.2011 18:35, schrieb Plata Martínez, Álvaro (KNMI):
Hi,
Using
On 17/01/2011 17:26, Adrian Klaver wrote:
On Monday 17 January 2011 8:11:20 am Jensen Somers wrote:
On 17/01/2011 16:46, Andrew Sullivan wrote:
On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote:
But, from your initial reply I understood that a user can simply browse
to my database
m...@smogura.eu (Radosław Smogura) writes:
In any approach preventing gaps, locking is required. This is real life
situation; imagine you have two coworkers and then they need to create
invoices, so they looks in ledger (or a last day copy of ledger in their
offices; international company,
Didn't someone make an iPod touch app version of pgadmin?
There's this
http://itunes.apple.com/us/app/dataglass-postgresql/id390298877?mt=8
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
raf r...@raf.org writes:
the behaviour i expect (and see on macosx-10.6.6) is:
id | name
+---
4 | CLARK
2 | CLARK, PETER
3 | CLARKE
1 | CLARKE, DAVID
the behaviour i don't expect but see anyway (on debian-5.0) is:
id | name
-Original Message-
From: Julia Jacobson [mailto:julia.jacob...@arcor.de]
Sent: Monday, January 17, 2011 7:21 AM
To: pgsql-general@postgresql.org
Cc: Steve Litt
Subject: Re: Crosstab query on huge amount of values
Am 17.01.2011 00:20, schrieb Steve Litt:
On Sunday 16 January
On Mon, Jan 17, 2011 at 02:19:14PM -0500, Tom Lane wrote:
No, not particularly. Sort order is determined by lc_collate
not lc_messages. Unfortunately it's entirely possible that OSX
will give you a different sort order than Linux even for similarly
named lc_collate settings. About the only
I retrieve asynchronous queries results using PQgetResult() which returns
NULL not in case of some error, but when results end - so there is no way to
know if database responded successfully or there happened some error?
For example, error can happen when column names are miswritten.
On Jan 17, 2011, at 11:30 AM, Gary Chambers wrote:
Jerry,
http://www.gnegg.ch/2009/08/snow-leopard-and-php/
It sorta looks like the above might blow away the existing php stuff...
Have you considered using the MacPorts version? That's what I use for
development on my Macs and I've
On 01/17/2011 09:00 PM, ? wrote:
I retrieve asynchronous queries results using PQgetResult() which
returns NULL not in case of some error, but when results end - so
there is no way to know if database responded successfully or there
happened some error?
For example, error can
Hey
17 января 2011 г. 23:00 пользователь Вячеслав Блинников
slav...@gmail.comнаписал:
I retrieve asynchronous queries results using PQgetResult() which returns
NULL not in case of some error, but when results end - so there is no way to
know if database responded successfully or there
On 01/17/2011 10:21 AM, Jensen Somers wrote:
The ORM framework I want to use is http://dataobjects.net/
- Jensen
Hmm, sees you might have to be patient:) From the their manual:
Upcoming storage providers include:
* Built-in file system database (i.e. regular embedded database)
Any
=?KOI8-R?B?99HexdPMwdcg4szJzs7Jy8/X?= slav...@gmail.com writes:
I retrieve asynchronous queries results using PQgetResult() which returns
NULL not in case of some error, but when results end - so there is no way to
know if database responded successfully or there happened some error?
For
On Monday 17 January 2011 07:21:11 you wrote:
Am 17.01.2011 00:20, schrieb Steve Litt:
On Sunday 16 January 2011 17:40:34 Julia Jacobson wrote:
Hello everybody out there using PostgreSQL,
A table with the results of students in different exams
student | date_of_exam | grade
I have occasion to produce reports from our PostgreSQL database
which are ephemeral. In a previous life on CODASYL installation I
used a report writer called QUIZ to dash these things off. Is there
anything of a similar nature in the FOSS community that people care
to recommend for use with
Tom Lane wrote:
raf r...@raf.org writes:
the behaviour i expect (and see on macosx-10.6.6) is:
id | name
+---
4 | CLARK
2 | CLARK, PETER
3 | CLARKE
1 | CLARKE, DAVID
the behaviour i don't expect but see anyway (on debian-5.0) is:
On Fri, Jan 14, 2011 at 19:14, Daniel Popowich danielpopow...@gmail.com wrote:
[ snip ]
CREATE FUNCTION pygaps(start_ts timestamp without time zone, end_ts timestamp
without time zone, gap_length interval) RETURNS SETOF timerange
LANGUAGE plpythonu
AS $$
# because pg passes
On 01/17/2011 11:31 PM, Jensen Somers wrote:
But, from your initial reply I understood that a user can simply browse
to my database installation folder (e.g.: C:/ProgramData/MyApp/data),
read out and/or modify a configuration file and he can access the entire
database and modify the data. And
On tis, 2011-01-18 at 10:33 +1100, raf wrote:
p.s. if anyone in debian locale land is listening,
'E' does not sort before ','. what were you thinking? :-)
What is actually happening is that the punctuation is sorted in a second
pass after the letters. Which is both correct according to the
45 matches
Mail list logo
