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 n

Re: [GENERAL] password help

2012-07-29 Thread Craig Ringer
On 07/30/2012 02:30 AM, Guillermo Echevarria Quintana-Gurt wrote: 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 follo

[GENERAL] Enums documentation "glitch"

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

[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 (postg

Re: [GENERAL] Enums documentation "glitch"

2012-07-29 Thread David Johnston
On Jul 29, 2012, at 14:56, Edson Richter 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 following paragraph: >>

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 enumera

Re: [GENERAL] array_length of an empty array

2012-07-29 Thread Tom Lane
John R Pierce 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 empty arrays. Some

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:

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 s

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 ge

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 w

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 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 ? > Is the WAL rep

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

[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