Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Tue, Feb 23, 2010 at 00:50, Alex Hunsaker wrote: > On Mon, Feb 22, 2010 at 14:31, Tom Lane wrote: >> I'm inclined to stay with the same basic >> implementation and just hack up the regexp some more to cope with 5.11's >> more verbose -v output. > > And here is a stab at that: Grr... stupid wo

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Mon, Feb 22, 2010 at 14:31, Tom Lane wrote: > I'm inclined to stay with the same basic > implementation and just hack up the regexp some more to cope with 5.11's > more verbose -v output. And here is a stab at that: $ echo "This is perl, version 4.0" | sed -n 's/This is perl.*v[a-z ]*\([0-9]\.

Re: [BUGS] BUG #5341: problema al iniciar pgadmin

2010-02-22 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Feb 23, 2010 at 01:42:30AM +, Jaime Mendieta wrote: > > The following bug has been logged online: > > Bug reference: 5341 [...] > cuando termino de instalar postgres 8.4.2 me sale un cuadro que dice > "Problem running post-install

Re: [BUGS] to_char issue?

2010-02-22 Thread Bruce Momjian
bruce wrote: > Dave Page wrote: > > This was posted as a documentation comment: > > > > to_char(interval '0d 0h 12m 44s', 'DD HH MI SS'); > > with HH and HH12 will return 12 instead of 0. > > > > Testing on 8.4.1, it does seem to be the case that you get "00 12 12 > > 44". Seems bogus to me, but

[BUGS] BUG #5341: problema al iniciar pgadmin

2010-02-22 Thread Jaime Mendieta
The following bug has been logged online: Bug reference: 5341 Logged by: Jaime Mendieta Email address: mendie...@gmail.com PostgreSQL version: 8.4.2 Operating system: Windows Vista Description:problema al iniciar pgadmin Details: cuando termino de instalar postgres

Re: [BUGS] to_char issue?

2010-02-22 Thread Bruce Momjian
Bruce Momjian wrote: > Dave Page wrote: > > This was posted as a documentation comment: > > > > to_char(interval '0d 0h 12m 44s', 'DD HH MI SS'); > > with HH and HH12 will return 12 instead of 0. > > > > Testing on 8.4.1, it does seem to be the case that you get "00 12 12 > > 44". Seems bogus to

Re: [BUGS] to_char issue?

2010-02-22 Thread Bruce Momjian
Dave Page wrote: > This was posted as a documentation comment: > > to_char(interval '0d 0h 12m 44s', 'DD HH MI SS'); > with HH and HH12 will return 12 instead of 0. > > Testing on 8.4.1, it does seem to be the case that you get "00 12 12 > 44". Seems bogus to me, but am I and the OP missing somet

Re: [BUGS] BUG #5103: "pg_ctl -w (re)start" fails with custom unix_socket_directory

2010-02-22 Thread Bruce Momjian
Michael Renner wrote: > Alvaro Herrera wrote: > > Michael Renner wrote: > > > >> Mentioning PGHOST in pg_ctl's > >> manpage/documentation should make this entirely clear for people who > >> aren't familiar with the extensive environment variables PostgreSQLs > >> client library can use. [1] > > >

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Jonathan Leto
Howdy, First, thanks to everyone for the quick responses to my bug report. > The output format of "perl -v" has been reasonably consistent for well > over a decade, eg (examples captured from various machines around my > house) > >        This is perl, version 4.0 >        This is perl, v5.8.7 bu

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Mon, Feb 22, 2010 at 14:31, Tom Lane wrote: > Alex Hunsaker writes: >> How about something like the below? > > I still think that this is optimizing the wrong thing.  We care about > the clarity of the message the user sees, not about how short or clean > the Perl code is.  I'm inclined to sta

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Mon, Feb 22, 2010 at 14:17, Alex Hunsaker wrote: > On Mon, Feb 22, 2010 at 13:07, Tom Lane wrote: >> Alex Hunsaker writes: >>> !   perl_version_error=`$PERL -e 'use 5.00801;' 2>&1` ... > How about something like the below? Find attached one that modifies config/perl.m4 as well :) perl_conf

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Tom Lane
Alex Hunsaker writes: > How about something like the below? I still think that this is optimizing the wrong thing. We care about the clarity of the message the user sees, not about how short or clean the Perl code is. I'm inclined to stay with the same basic implementation and just hack up the

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread David Fetter
On Mon, Feb 22, 2010 at 02:17:57PM -0700, Alex Hunsaker wrote: > On Mon, Feb 22, 2010 at 13:07, Tom Lane wrote: > > Alex Hunsaker writes: > >> !   perl_version_error=`$PERL -e 'use 5.00801;' 2>&1` > > > > This is not a path towards an acceptable solution, as it effectively > > assumes what we are

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Mon, Feb 22, 2010 at 13:07, Tom Lane wrote: > Alex Hunsaker writes: >> !   perl_version_error=`$PERL -e 'use 5.00801;' 2>&1` > > This is not a path towards an acceptable solution, as it effectively > assumes what we are setting out to prove, namely that we have found > a reasonably modern vers

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Tom Lane
Jonathan Leto writes: > On Mon, Feb 22, 2010 at 12:07 PM, Tom Lane wrote: >>> This is perl 5, version 11, subversion 4 (v5.11.4-114-ga4cc961*) built for >>> x86_64-linux >> >> Ugh.  Can't they manage to keep that message reasonably consistent? > The form of the version string is the closest rel

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Jonathan Leto
Howdy, On Mon, Feb 22, 2010 at 12:07 PM, Tom Lane wrote: > Alex Hunsaker writes: >> On Mon, Feb 22, 2010 at 10:57, Jonathan wrote: >>> This is perl 5, version 11, subversion 4 (v5.11.4-114-ga4cc961*) built for >>> x86_64-linux > > Ugh.  Can't they manage to keep that message reasonably consiste

Re: [BUGS] BUG #5340: Requirement of different syntax on different OS

2010-02-22 Thread Jaime Casanova
On Mon, Feb 22, 2010 at 2:51 PM, pradeep wrote: > > The following bug has been logged online: > > Bug reference:      5340 > Logged by:          pradeep > Email address:      patilpradeep...@yahoo.com > PostgreSQL version: 1.10.1 > Operating system:   windows 7 > Description:        Requirement of

[BUGS] BUG #5340: Requirement of different syntax on different OS

2010-02-22 Thread pradeep
The following bug has been logged online: Bug reference: 5340 Logged by: pradeep Email address: patilpradeep...@yahoo.com PostgreSQL version: 1.10.1 Operating system: windows 7 Description:Requirement of different syntax on different OS Details: If I am using window

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Tom Lane
Alex Hunsaker writes: > On Mon, Feb 22, 2010 at 10:57, Jonathan wrote: >> This is perl 5, version 11, subversion 4 (v5.11.4-114-ga4cc961*) built for >> x86_64-linux Ugh. Can't they manage to keep that message reasonably consistent? > ! perl_version_error=`$PERL -e 'use 5.00801;' 2>&1` This

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Tim Bunce
Using perl -e 'use 5.008010' would be a more reliable way for configure to test the perl version. Tim. On Mon, Feb 22, 2010 at 05:57:56PM +, Jonathan Duke Leto wrote: > > The following bug has been logged online: > > Bug reference: 5339 > Logged by: Jonathan "Duke" Le

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alvaro Herrera
Alex Hunsaker escribió: > On Mon, Feb 22, 2010 at 10:57, Jonathan wrote: > > checking for perl... /home/leto/bin/perl > > configure: using perl > > configure: WARNING: > > *** The installed version of Perl, /home/leto/bin/perl, is too old to use > > with PostgreSQL. > > *** Perl version 5.8 or la

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Mon, Feb 22, 2010 at 12:44, Alex Hunsaker wrote: > On Mon, Feb 22, 2010 at 10:57, Jonathan wrote: >> configure: using perl >> configure: WARNING: >> *** The installed version of Perl, /home/leto/bin/perl, is too old to use >> with PostgreSQL. >> *** Perl version 5.8 or later is required, but t

Re: [BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Alex Hunsaker
On Mon, Feb 22, 2010 at 10:57, Jonathan wrote: > > The following bug has been logged online: > > Bug reference:      5339 > Logged by:          Jonathan "Duke" Leto > Email address:      jonat...@leto.net > PostgreSQL version: master 0f50d482 > Operating system:   CentOS 5.4 (Linux kernel 2.6.18)

Re: [BUGS] BUG #5118: start-status-insert-fatal

2010-02-22 Thread Kevin Grittner
Bruce Momjian wrote: > I think you should just edit the TODO wiki and list all the things > we agree need fixing Will do. It may take me a while to chase down all the issues from the LSB script work. If I recall correctly, some of what I was looking at seems necessary for a well-behaved LSB

[BUGS] BUG #5339: Version of Perl detected incorrectly

2010-02-22 Thread Jonathan
The following bug has been logged online: Bug reference: 5339 Logged by: Jonathan "Duke" Leto Email address: jonat...@leto.net PostgreSQL version: master 0f50d482 Operating system: CentOS 5.4 (Linux kernel 2.6.18) Description:Version of Perl detected incorrectly Detai

Re: [BUGS] BUG #5118: start-status-insert-fatal

2010-02-22 Thread Bruce Momjian
Kevin Grittner wrote: > Bruce Momjian wrote: > > > Was this ever addressed? > > It should probably be on the TODO list. I was going to try to do > this along with other items which came out of generating an LSB > conforming init script, but have been pulled in different directions > for now.

Re: [BUGS] BUG #5118: start-status-insert-fatal

2010-02-22 Thread Kevin Grittner
Bruce Momjian wrote: > Was this ever addressed? It should probably be on the TODO list. I was going to try to do this along with other items which came out of generating an LSB conforming init script, but have been pulled in different directions for now. When I get the time I've been intendi

Re: [BUGS] helo

2010-02-22 Thread Kevin Grittner
Kris Jurka wrote: > You need to pass an instance of java.sql.Array, not a Collection > or something else that is array like. Ah, right. After extracting an array from the java.util.ArrayList, it needs to be turned into a java.sql.Array using the Connection.createArrayOf method. Most definit

Re: [BUGS] BUG #5118: start-status-insert-fatal

2010-02-22 Thread Bruce Momjian
Was this ever addressed? --- Tom Lane wrote: > "Kevin Grittner" writes: > > Tom Lane wrote: > >> I'm not sure whether we'd want to provide a function within libpq > >> for this, or just code it in pg_ctl. > > > I'm incli

Re: [BUGS] helo

2010-02-22 Thread Kris Jurka
On Mon, 22 Feb 2010, beulah prasanthi wrote: Helo I am working on spring project with postgres 8.4 i wrote a function in postgrees which i am passing the argument email email[] array From front end we need to insesrt data into that emailarray .so i used java.arraylist.util while i am runn

Re: [BUGS] BUG #5338: PG_DUMP fails due to invalid adnum value

2010-02-22 Thread Tom Lane
"Toni Helenius" writes: > I tried to google this but I didn't get much info. What is this all about?? > I get the following error while trying to take a dump: > pg_dump: finding the columns and types of table "bsc_day1_001" > pg_dump: finding default expressions of table "bsc_day1_001" > pg_dump:

[BUGS] BUG #5338: PG_DUMP fails due to invalid adnum value

2010-02-22 Thread Toni Helenius
The following bug has been logged online: Bug reference: 5338 Logged by: Toni Helenius Email address: toni.helen...@syncrontech.com PostgreSQL version: 8.3.9 Operating system: Windows 2008 Server Enterprise Description:PG_DUMP fails due to invalid adnum value Details:

Re: Fwd: [BUGS] exception in plsql

2010-02-22 Thread Kevin Grittner
Ravi wrote: > when I tried to use the toArray method to extract exception raised > saying > > org.postgresql.util.PSQLException: Cannot cast an instance of > [Ljava.lang.Object; to type Types.ARRAY OK, that looks like an array, so I'm now a bit lost. Could you put together a self-contained

Re: [BUGS] BUG #5334: Version 2.22 of Perl Safe module breaks UTF8 PostgreSQL 8.4

2010-02-22 Thread Tim Bunce
On Fri, Feb 19, 2010 at 02:22:33PM -0700, Alex Hunsaker wrote: > On Fri, Feb 19, 2010 at 14:00, Tim Bunce wrote: > > On Fri, Feb 19, 2010 at 09:32:38AM -0700, Alex Hunsaker wrote: > >> On Fri, Feb 19, 2010 at 09:18, Alex Hunsaker wrote: > >> > It seems to me a more correct fix would be to require

Fwd: [BUGS] exception in plsql

2010-02-22 Thread Ravi
-- Forwarded message -- From: Ravi Date: Mon, Feb 22, 2010 at 7:31 PM Subject: Re: [BUGS] exception in plsql To: Kevin Grittner when I tried to use the toArray method to extract exception raised saying org.postgresql.util.PSQLException: Cannot cast an instance of [Ljava.lang.Ob

Re: [BUGS] exception in plsql

2010-02-22 Thread Kevin Grittner
beulah prasanthi wrote: > org.postgresql.util.PSQLException: Cannot cast an instance of > java.util.ArrayList to type Types.ARRAY* An ArrayList is not an array -- it is a List implementation which uses an array, internally. What happens if you use the toArray method to extract an array from t

[BUGS] pgsql exception

2010-02-22 Thread Ravi
Method in Dao public void savePerson(Person person, List addresses, List emails, List numbers){ call.withProcedureName(" person_save1"); Map out = call.execute(new PGPerson(person),addresses,null,null); } *SP in Database* CREATE OR REPLACE FUNCTION person_save(person_to_save

[BUGS] exception in plsql

2010-02-22 Thread beulah prasanthi
show details 5:21 PM (19 minutes ago) Method in Dao public void savePerson(Person person, List addresses, List emails, List numbers){ call.withProcedureName(" person_save1"); Map out = call.execute(new PGPerson(person),addresses,null,null); } *SP in Database* CREATE OR REPL

[BUGS] typecast exception

2010-02-22 Thread beulah prasanthi
-- Forwarded message -- From: Ravi Date: Mon, Feb 22, 2010 at 5:21 PM Subject: To: Prasanthi Method in Dao public void savePerson(Person person, List addresses, List emails, List numbers){ call.withProcedureName(" person_save1"); Map out = call.execute(new PGPer

[BUGS] typecast exception

2010-02-22 Thread beulah prasanthi
Helo I am working on spring project with postgres 8.4 i wrote a function in postgrees which i am passing the argument email email[] array >From front end we need to insesrt data into that emailarray .so i used java.arraylist.util while i am running i got the following error Please help me err

[BUGS] TypeCast: util.list to array type

2010-02-22 Thread beulah prasanthi
Helo I am working on spring project with postgres 8.4 i wrote a function in postgrees which i am passing the argument email email[] array >From front end we need to insesrt data into that emailarray .so i used java.arraylist.util while i am running i got the following error Please help me err

[BUGS] helo

2010-02-22 Thread beulah prasanthi
Helo I am working on spring project with postgres 8.4 i wrote a function in postgrees which i am passing the argument email email[] array >From front end we need to insesrt data into that emailarray .so i used java.arraylist.util while i am running i got the following error Please help me err