Re: [GENERAL] help understanding collation order

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 re

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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 th

Re: [GENERAL] plpythonu memory leak

On Fri, Jan 14, 2011 at 19:14, Daniel Popowich 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 date/time to python as st

Re: [GENERAL] help understanding collation order

Tom Lane wrote: > raf 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.

[GENERAL] Ad hoc report writer

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 Postg

Re: [GENERAL] Crosstab query on huge amount of values

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 |

Re: [GENERAL] libpq: how to retrieve query result?

=?KOI8-R?B?99HexdPMwdcg4szJzs7Jy8/X?= 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 example, error can

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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 be

Re: [GENERAL] libpq: how to retrieve query result?

Hey 17 января 2011 г. 23:00 пользователь Вячеслав Блинников написал: > 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? >

Re: [GENERAL] libpq: how to retrieve query result?

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

Re: [GENERAL] iPad and Postgresql...

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

[GENERAL] libpq: how to retrieve query result?

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.

Re: [GENERAL] help understanding collation order

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 o

Re: [GENERAL] Crosstab query on huge amount of values

> -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

Re: [GENERAL] help understanding collation order

raf 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 > --

Re: [GENERAL] iPad and Postgresql...

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: http://www.postgresql.org/mailpref/pgsql-gener

Re: [GENERAL] How to generate unique invoice numbers for each day

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 compan

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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

Re: [GENERAL] Postgis error

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

Re: [GENERAL] Postgis error

=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?= 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: > ERROR: type "geometry" does

Re: [GENERAL] Postgis error

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 a

Re: [GENERAL] iPad and Postgresql...

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 pa

[GENERAL] Postgis error

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

Re: [GENERAL] iPad and Postgresql...

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 h

Re: [GENERAL] iPad and Postgresql...

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 wh

Re: [GENERAL] iPad and Postgresql...

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 yo

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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.: C:/P

Re: [GENERAL] iPad and Postgresql...

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 n

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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 a

Re: [GENERAL] HA solution

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 som

Re: [GENERAL] iPad and Postgresql...

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.sourcefo

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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 > datab

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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 requirements

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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

[GENERAL] help understanding collation order

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) v

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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

Re: [GENERAL] HA solution

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? --

Re: [GENERAL] PostgreSQL 9.0.2 hangs during shutdown on Windows (Win32)

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 oth

Re: [GENERAL] Crosstab query on huge amount of values

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

[GENERAL] Re: [ANNOUNCE] Re: [pgsql-es-ayuda] Para participantes extranjeros en el Tercer PGDay Latinoamericano.

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 > En oportunidades anteriores donde me ha tocado trabajar con empresas > cubanas fue la empresa la que gestio

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

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

Re: [GENERAL] PostgreSQL 9.0.2 hangs during shutdown on Windows (Win32)

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 t

Re: [GENERAL] Trigger Performance

On 2011-01-17, Fredric Fredricson 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: >> Hi, >> >> I've created a t

[GENERAL] PostgreSQL 9.0.2 hangs during shutdown on Windows (Win32)

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=Crossover&type=Crossover). The Host is an Intel x86 (Core2Duo) machine running

Re: [GENERAL] Trigger Performance

On 2011-01-16, Randall Smith 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. >> >> >> IF EXISTS