[GENERAL] array_length of an empty array

2012-07-29 Thread John R Pierce
hmmm.array[]::integer[]is an empty array, {}, eg an array with zero elements but array_length(array[]::integer[]) is NULL rather than zero.this seems counterintuitive. -- john r pierceN 37, W 122 santa cruz ca mid-left coast

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Vincent Veyron
Le samedi 28 juillet 2012 à 09:39 -0700, Mark Phillips a écrit : Thanks to all who have posted. Your comments are very helpful. On Jul 26, 2012, at 11:04 AM, Vincent Veyron wrote: I had assumed the OP _was_ using Postgres already, and that this was being challenged by the new

Re: [GENERAL] Schema-only dump dumps no constraints, no triggers

2012-07-29 Thread Marek Kielar
Hi, Dnia 28 lipca 2012 1:10 Adrian Klaver adrian.kla...@gmail.com napisał(a): What where the deleted files? WAL, Logs, other? What type of WAL replication are you doing? Streaming, log shipping, etc? What are your settings for the WAL replication? In particular wal_keep_segments

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Alban Hertroys
On 29 Jul 2012, at 11:56, Vincent Veyron wrote: New manager comes in and starts talking about a bidding procedure for an application for the combined team. The guy is stopped by my 3 person team, who threatens to _strike_ if 'their' application is removed : they simply refused to work

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Jacqui Caren
On 29/07/2012 10:56, Vincent Veyron wrote: New manager comes in and starts talking about a bidding procedure for an application for the combined team. Hmm - I wonder... All sorts of perks/backhanders for some types of management when this is undertaken. I suspect this is an attempt to either

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Vincent Veyron
Le dimanche 29 juillet 2012 à 12:47 +0200, Alban Hertroys a écrit : On 29 Jul 2012, at 11:56, Vincent Veyron wrote: If upper management is any good, they'll be happy to have a chat about the situation and keep an eye out and a direct line to your people open, so that they can hear both

Re: [GENERAL] array_length of an empty array

2012-07-29 Thread Ryan Kelly
On Sun, Jul 29, 2012 at 01:03:04AM -0700, John R Pierce wrote: hmmm.array[]::integer[]is an empty array, {}, eg an array with zero elements but array_length(array[]::integer[]) is NULL rather than zero. this seems counterintuitive. It also seems to disagree with the standard: 1)

Re: [GENERAL] array_length of an empty array

2012-07-29 Thread Tom Lane
John R Pierce pie...@hogranch.com writes: hmmm.array[]::integer[]is an empty array, {}, eg an array with zero elements but array_length(array[]::integer[]) is NULL rather than zero.this seems counterintuitive. IIRC, there are a whole bunch of questionable behaviors around

Re: [GENERAL] Enums documentation glitch

2012-07-29 Thread Edson Richter
Resending, sent with wrong sender at first (sorry, I'll be more careful before sending with wrong e-mail address)... Em 29/07/2012 15:48, Edson Richter escreveu: In CREATE TYPE documentation, we see the following paragraph: Enumerated Types The second form of CREATE TYPE creates an

Re: [GENERAL] Enums documentation glitch

2012-07-29 Thread David Johnston
On Jul 29, 2012, at 14:56, Edson Richter edsonrich...@hotmail.com wrote: Resending, sent with wrong sender at first (sorry, I'll be more careful before sending with wrong e-mail address)... Em 29/07/2012 15:48, Edson Richter escreveu: In CREATE TYPE documentation, we see the

[GENERAL] password help

2012-07-29 Thread Guillermo Echevarria Quintana-Gurt
Hi, I just uninstalled version 8.4 and tried installing version 9.1 in my computer (my system is Windows 7). The issue Im facing was that when I clicked run to install the new version one of the steps was requiring me the following: please provide a password for the database superuser

[GENERAL] Enums documentation glitch

2012-07-29 Thread Edson Richter
In "CREATE TYPE" documentation, we see the following paragraph: "Enumerated Types The second form ofCREATE TYPEcreates an enumerated (enum) type, as described inSection 8.7. Enum types take a list of one or more quoted labels, each of which must be less

Re: [GENERAL] password help

2012-07-29 Thread Craig Ringer
Please don't reply directly to me, reply via the mailing list (use Reply all). On 07/30/2012 01:35 PM, Guillermo Echevarria Quintana-Gurt wrote: Hi Craig, I really appreciate your answer. My situation is the one I described you in the first email. I guess i should've add that i really have no