mnl.post | 4 Aug 20:15 2013
Picon

BUG #8363: checksum verification fails with StackBuilder

The following bug has been logged on the website:

Bug reference:      8363
Logged by:          Manuel
Email address:      mnl.post <at> gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   windows 8 x64 
Description:        

With latest postgreSQL download for windows x64 (9.3 beta 2): 
on windows 8 x64, checksum verification fails with Application StackBuilder
when downloading any drivers (odbc etc.).

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

jbglaw | 4 Aug 04:00 2013
Picon

BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.

The following bug has been logged on the website:

Bug reference:      8361
Logged by:          Jan-Benedict Glaw
Email address:      jbglaw <at> lug-owl.de
PostgreSQL version: Unsupported/Unknown
Operating system:   Debian unstable/experimental
Description:        

Hi!

I just found intervals that are shown with more than 24 hours in the `hours'
field. Their overall shown value matches EXTRACT (expoch from xxxx), but the
printed value looks bogus:

buildmaster=> select avg(lastbuild_same) from test_values ;
          avg
-----------------------
 1 day 26:16:18.678927
(1 row)

Notice the "26" there. It's actually 2 days 2h 16min 18sec.

Short SQL snippet can be found at
http://lug-owl.de/~jbglaw/intervals_not_printed_correctly.sql

Would be nice if somebody would test this with further PostgreSQL versions
and specifically with the most recent development branch.

Thanks,
(Continue reading)

grv87 | 2 Aug 11:52 2013
Picon

BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

The following bug has been logged on the website:

Bug reference:      8355
Logged by:          Basil Peace
Email address:      grv87 <at> yandex.ru
PostgreSQL version: 9.2.4
Operating system:   Windows 7 x64 (PostgreSQL is x86), Python 3.2.5
Description:        

PL/Python can't convert Python's float with infinity value to PostgreSQL's
float.
The reason is that Python's standard representation of infinity is 'inf'
('Infinity' is accepted as well), but PostgreSQL's representation is
'Infinity' only.
I'm speaking of Python 3 version since I have no Python 2 to test.

Consider the following code:

-- CREATE LANGUAGE plpython3u;

CREATE TABLE IF NOT EXISTS test10 (
	a double precision
);

DO LANGUAGE plpython3u $$
	plan = plpy.prepare('INSERT INTO test10 (a) VALUES ($1)', ['double
precision'])
	a = float('inf')
	plpy.execute(plan, [a])
$$;
(Continue reading)

alex | 2 Aug 09:03 2013
Picon

BUG #8354: stripped positions can generate nonzero rank in ts_rank_cd

The following bug has been logged on the website:

Bug reference:      8354
Logged by:          Alex Hill
Email address:      alex <at> hill.net.au
PostgreSQL version: 9.2.4
Operating system:   OS X 10.8.4 Mountain Lion
Description:        

Hi all,

The docs for ts_rank_cd state:

"This function requires positional information in its input. Therefore it
will not work on "stripped" tsvector values — it will always return zero."

However if a tsvector contains some stripped lexemes and some non-stripped,
ts_rank_cd will rank extents including the non-stripped values.

For example, this evaluates to zero as expected:

    SELECT ts_rank_cd(strip(to_tsvector('text search')),
plainto_tsquery('text search'))

But this doesn't:

    SELECT ts_rank_cd(to_tsvector('text') || strip(to_tsvector('search')),
plainto_tsquery('text search'))

I think this is a bug, if not in the code then in the documentation, which
(Continue reading)

mbadolato | 2 Aug 03:35 2013
Picon

BUG #8353: Core dump with uuid-ossp on FreeBSD 9,2

The following bug has been logged on the website:

Bug reference:      8353
Logged by:          Mark Badolato
Email address:      mbadolato <at> gmail.com
PostgreSQL version: 9.2.4
Operating system:   FreeBSD 9.2
Description:        

I saw a similar issue to this in the mailing list from back in 2007 (BUG
#3841).  It seems that there are still issues with uuid on FreeBSD.

I tried executing both select uuid_nil(); and select uuid_generate_v4(); 
Both cause a long delay then lose connection, and result in a core file.

This is happening on all of our FreeBSD machines (all v9.2). I tried on both
AMD and Intel procs, and in a virtual (on the AMD) and bare metal (xeon).

This is working with no problems on my Postgres install on my Mac (10.8),
installed from the binary distribution.

psql (9.2.4)
Type "help" for help.

cms=# select uuid_generate_v4();
The connection to the server was lost. Attempting reset: Failed.
!> quit

Looking at gdb doesn't really look like it's producing anything useful,
though I admit I'm not adept at doing anything with gdb.
(Continue reading)

dyuen | 2 Aug 01:48 2013

BUG #8352: Using UPPER in ON clause of JOIN

The following bug has been logged on the website:

Bug reference:      8352
Logged by:          Daisy
Email address:      dyuen <at> rbauction.com
PostgreSQL version: 9.2.4
Operating system:   Windows 7
Description:        

When joining two tables on a varchar column wrapped in a upper statement,
the join does not work if there is a trailing space in both of the varchar
values.

In the two examples below, VALUE1 and VALUE2 = "ABC "

-- Doesn't work

SELECT * FROM TABLE1 INNER JOIN TABLE2 ON UPPER(VALUE1) = UPPER(VALUE2)

-- Works

SELECT * FROM TABLE1 INNER JOIN TABLE2 ON UPPER(TRIM(VALUE1)) =
UPPER(TRIM(VALUE2))

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

(Continue reading)

Mark Kirkwood | 1 Aug 23:47 2013
Picon

Re: R: Re: postgresql 8.4 on android table with debian installed (Debian Kit APK)

On 01/08/13 22:13, f-s <at> libero.it wrote:
>> Da: mark.kirkwood <at> catalyst.net.nz
>>
>> See  http://android-dls.com/wiki/index.php?title=Debian_on_G1 near the
>> bottom they discuss this issue.
>>
>> Cheers
>>
>> Mark
>
> Thanks very very much: problem solved, postgresql, apache2, php5 ported on a
> 50$
> small android table with little debian ... transformed in a very fast, cheap
> and portable (200 g) server!!!
>
> So it's possible (I think) porting postgresql database on  all android tablets
> and rooted android cellulars!!!
>
>

For the archives, looks like that was the issue, users need to be a 
member of a certain group (gid 303) to use sockets (which is exactly 
what Alvaro suspected).

Cheers

Mark

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
(Continue reading)

josealdea | 1 Aug 19:59 2013
Picon

BUG #8351: contraseña postgresql

The following bug has been logged on the website:

Bug reference:      8351
Logged by:          jose alberto casanueva perez
Email address:      josealdea <at> hotmail.com
PostgreSQL version: 8.4.0
Operating system:   windows 7
Description:        

he olvidado mi contraseña del pgadminiii. Hay alguna forma de recuperarla?.
Gracias.

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

harshmailbox85 | 1 Aug 10:37 2013
Picon

BUG #8350: unable to register pgAgent

The following bug has been logged on the website:

Bug reference:      8350
Logged by:          Harsh Vadhan
Email address:      harshmailbox85 <at> gmail.com
PostgreSQL version: 9.2.2
Operating system:   windows
Description:        

Dear Sir,

i have installed the pgAgent, but unable to register its service(postgres
sheduling Agent-pgagnet) in services section.

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Josh Berkus | 1 Aug 20:00 2013

Re: pgBench cannot use prepared statements and reconnections

On 07/31/2013 04:11 PM, Mark Kirkwood wrote:
> Hmmm, apologies - actually it didn't - I read right past the text
> 
> ERROR:  prepared statement "P0_7" does not exist
> 

Yah.  It's quite possible that the answer is to explicitly disallow this
-- the only reason I even tried it is that I was testing for a
PostgreSQL bug -- but we should fail gracefully, e.g. "Use of prepared
statements with pgbench requires persistent connections.  You may not
use the -C and -m prepared options together".

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Josh Berkus | 1 Aug 00:08 2013

pgBench cannot use prepared statements and reconnections


To wit:

[jberkus <at> pgx-test prepare]$ pgbench -c 4 -C -T 180 -l -r -M prepared bench
starting vacuum...end.
Client 1 aborted in state 7: ERROR:  prepared statement "P0_7" does not
exist
Client 0 aborted in state 7: ERROR:  prepared statement "P0_7" does not
exist
Client 3 aborted in state 7: ERROR:  prepared statement "P0_7" does not
exist
Client 2 aborted in state 7: ERROR:  prepared statement "P0_7" does not
exist
transaction type: TPC-B (sort of)

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

--

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Gmane