Re: [BUGS] BUG #7821: constant disconnection with external network

2013-01-23 Thread Kevin Grittner
alessan...@nwsoftware.com.br wrote: > I use PostgreSQL 9.0.6 and I´m with a problem using PostgreSQL with external > network, by internet (cloud). > > If the user open the application and don´t use the application by minutes, > the connection with database is lost, but if the user to use applicat

[BUGS] psql \d command hides objects from "lower" schemas

2013-01-23 Thread Ben Morgan
*Version and Operating System:* PostgreSQL 9.2.2 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.7.2, 32-bit PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 32-bit *Description of Bug:* I attached a file *input.sql* which contains a few commands necessary for bug report. In summary: create

Re: [BUGS] psql \d command hides objects from "lower" schemas

2013-01-23 Thread Josh Kupershmidt
On Wed, Jan 23, 2013 at 6:21 AM, Ben Morgan wrote: > Given this, when using the psql command \d, I expect to see all the tables, > and the view as well as the table. But instead the objects in the front-most > schema mask the other objects. > > I'm submitting this as a bug, because it seems to be

Re: [BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link

2013-01-23 Thread Devrim GÜNDÜZ
Hi, On Tue, 2013-01-22 at 17:13 +, georgi-georgiev-pg...@japannext.co.jp wrote: > The following bug has been logged on the website: > > Bug reference: 7823 > Logged by: Georgi Georgiev > Email address: georgi-georgiev-pg...@japannext.co.jp > PostgreSQL version: 9.2.2 > Ope

Re: [BUGS] BUG #7822: PGDG packaged postgresql92 binaries do not find their libraries

2013-01-23 Thread Devrim GÜNDÜZ
Hi, On Tue, 2013-01-22 at 17:08 +, georgi-georgiev-pg...@japannext.co.jp wrote: > The following bug has been logged on the website: > > Bug reference: 7822 > Logged by: Georgi Georgiev > Email address: georgi-georgiev-pg...@japannext.co.jp > PostgreSQL version: 9.2.2 > Ope

Re: [BUGS] BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328

2013-01-23 Thread Pius Chan
Hi Tom, We actually may find the cause of the problem. Last night we found two several old rows in the jms_messages table which should be gone long time ago. Once we deleted them, everything is back to normal, no more ERROR message. We suspected these rows are corrupted. Thanks a lot for your

[BUGS] BUG #7814: Rotation of the log is not carried out.

2013-01-23 Thread Jeff Janes
On Tue, Jan 22, 2013 at 9:29 PM, Jeff Janes wrote: > On Tuesday, January 22, 2013, Tom Lane wrote: >> >> >> So what we need on Windows is for the data transfer thread to notice >> when "Log_RotationSize > 0 && ftell(syslogFile) >= Log_RotationSize", >> and then either signal the control thread to

Re: [BUGS] Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

2013-01-23 Thread Jeff Janes
On Sunday, December 9, 2012, Alvaro Herrera wrote: > Tom Lane wrote: > > > > spam_ea...@gmx.net writes: > > > postgres=# create user testuser with password 'secret'; > > > CREATE ROLE > > > postgres=# create database testdb owner testuser; > > > CREATE DATABASE > > > testdb=> drop owned by testus

Re: [BUGS] BUG #7814: Rotation of the log is not carried out.

2013-01-23 Thread Tom Lane
Jeff Janes writes: > On Tue, Jan 22, 2013 at 9:29 PM, Jeff Janes wrote: >> On Tuesday, January 22, 2013, Tom Lane wrote: >>> So what we need on Windows is for the data transfer thread to notice >>> when "Log_RotationSize > 0 && ftell(syslogFile) >= Log_RotationSize", >>> and then either signal th

[BUGS] PL/R Median Busts Commit (Postgres 9.1.6 + plr 8.3.0.13 on Ubuntu 12.10 64 bit)

2013-01-23 Thread Mark Kirkwood
I admit - it sounds unlikely. However a simple scenario (attached) gives rise to: WARNING: AbortTransaction while in COMMIT state PANIC: cannot abort transaction 880983, it was already committed Essentially we are doing: BEGIN; DROP TABLE IF EXISTS tab0; CREATE TEMP TABLE tab0 ( id INTEGER P