Re: [BUGS] Postgres JDBC-hibernate Problem

2012-09-18 Thread Craig Ringer
On 09/19/2012 03:46 AM, Freddie Burgess wrote: The Employee ingest behaves a bit differently - it handles transactions programmatically, for example: Transaction tx = session.beginTransaction(); session.save(Employee); tx.commit(); Could

Re: [BUGS] BUG #7548: pg_upgrade still requires pg_config

2012-09-18 Thread Peter Eisentraut
On Mon, 2012-09-17 at 16:53 +, m...@suse.de wrote: > It looks like the attempt to remove pg_upgrade's dependency on pg_config > (http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=2815574) was > incomplete, since contrib/pg_upgrade/exec.c still contains the line > > validate_exec(c

Re: [BUGS] BUG #7554: save image into database using jsp and servlet

2012-09-18 Thread Craig Ringer
On 09/18/2012 08:26 PM, kamalnity...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 7554 Logged by: KAMAL Email address: kamalnity...@gmail.com PostgreSQL version: 8.3.0 Operating system: windows-7 Description: i want jsp and servlet code

[BUGS] Mixed newlines in Windows installer files

2012-09-18 Thread Mike Toews
Apologies that this report is near trivial, and only concerns the Windows installers by EnterpriseDB (I'm not sure where else to post these). With all of the current EnterpriseDB builds for Windows, several files have inconsistent line endings, switching between so-called DOS (CR+LF) and UNIX (LF)

Re: [BUGS] BUG #7546: Backups on hot standby cancelled despite hot_standby=on

2012-09-18 Thread Fujii Masao
On Mon, Sep 17, 2012 at 7:28 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 7546 > Logged by: Stuart Bishop > Email address: stu...@stuartbishop.net > PostgreSQL version: 9.1.5 > Operating system: Ubuntu 12.10 > Description: > > I have a pri

Re: [BUGS] Postgres JDBC-hibernate Problem

2012-09-18 Thread Freddie Burgess
Here is a more detailed write-up of our current problem. We have a process that feeds three Postgresql database tables, two of which are partitioned tables. There are no foreign key constraint dependencies between any of these tables. Data get parsed and subsequently ingested into these tables i

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
I will try to provide one, but it will have to wait till weekend. Cheers, Andrei On Sep 18, 2012, at 2:05 PM, Tom Lane wrote: > Andrei Tchijov writes: >> SQL (Please let me know if you need definitions for other tables/views >> involved): > > What we need is a self-contained test ca

Re: [BUGS] BUG #7550: NULL result when coercing a subquery result into an array

2012-09-18 Thread tom Tom
I can't seem to reproduce this on a Ubuntu box on 9.1 or 9.2, nor can I seem to reproduce this with less than ~8 million rows on a windows one. I can reliably reproduce this with that many rows and the database dump is only ~120mb so if anyone is interested I can host it for them, otherwise I guess

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Tom Lane
Andrei Tchijov writes: > SQL (Please let me know if you need definitions for other tables/views > involved): What we need is a self-contained test case. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscript

Re: [BUGS] BUG #7550: NULL result when coercing a subquery result into an array

2012-09-18 Thread Tom Lane
tom Tom writes: > I can't seem to reproduce this on a Ubuntu box on 9.1 or 9.2, nor can > I seem to reproduce this with less than ~8 million rows on a windows > one. I can reliably reproduce this with that many rows and the > database dump is only ~120mb so if anyone is interested I can host it >

Re: [BUGS] BUG #7553: Un-executable view definitions in pg_catalog.pg_views in versions 8.3.x-9.2.0

2012-09-18 Thread Tom Lane
lal...@fhcrc.org writes: > I have run across a situation where we are changing schema and table names > that a view references. The view is still viewable with a select statement > but if you try and execute the view definition contained within the > pg_catalog.pg_views, then it fails. This appear

Re: [BUGS] BUG #7555: fail to install ora2pg through rhel5 postgresql repo (depsolv issues)

2012-09-18 Thread Devrim GÜNDÜZ
Hi, On Tue, 2012-09-18 at 15:29 +, dsoren...@atlasit.com wrote: > We are trying to install ora2pg using the postgresql RHEL5 repo but get > depsolving problems. > > Linux server 2.6.18-308.4.1.el5 #1 SMP Wed Mar 28 01:54:56 EDT 2012 x86_64 > x86_64 x86_64 GNU/Linux > > [root@server ~/]# yu

[BUGS] BUG #7555: fail to install ora2pg through rhel5 postgresql repo (depsolv issues)

2012-09-18 Thread dsorensen
The following bug has been logged on the website: Bug reference: 7555 Logged by: Daniel Email address: dsoren...@atlasit.com PostgreSQL version: 9.2.0 Operating system: RHEL 5.8 Description: Hello, We are trying to install ora2pg using the postgresql RHEL5 repo but g

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
No. But the form for entering bugs is not very ... sophisticated. Thanks for pointing me to this wiki, I will re-submit properly. Cheers, Andrei On Sep 17, 2012, at 11:55 PM, Tom Lane wrote: > and...@tchijov.com writes: >> In a view (can provide source upon request) where condition

[BUGS] BUG #7554: save image into database using jsp and servlet

2012-09-18 Thread kamalnitya87
The following bug has been logged on the website: Bug reference: 7554 Logged by: KAMAL Email address: kamalnity...@gmail.com PostgreSQL version: 8.3.0 Operating system: windows-7 Description: i want jsp and servlet code for save image.i found problem but size 0kb.

[BUGS] BUG #7553: Un-executable view definitions in pg_catalog.pg_views in versions 8.3.x-9.2.0

2012-09-18 Thread lalbin
The following bug has been logged on the website: Bug reference: 7553 Logged by: Lloyd Albin Email address: lal...@fhcrc.org PostgreSQL version: 9.0.7 Operating system: SUSE Linux (64-bit) Description: I have run across a situation where we are changing schema and tab

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
Hi, I have a view (see SQL at the end of this e-mail). Query like following works without any problems on 9.0 and 9.1. select * form v_jobs where rdms_job_number = 41771; However, on 9.2 this query acts as it is select * form v_jobs; It seems that this problem occur only

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-09-18 Thread Amit Kapila
On Tuesday, September 18, 2012 6:03 PM Fujii Masao wrote: On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote: >> To define the behavior correctly, according to me there are 2 options now: > >> Approach-1 : >> Document that both(sender and receiver) the timeout parameters should be >> greater than

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-09-18 Thread Fujii Masao
On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote: > To define the behavior correctly, according to me there are 2 options now: > > Approach-1 : > Document that both(sender and receiver) the timeout parameters should be > greater than wal_receiver_status_interval. > If both are greater, then I th

Re: [BUGS] BUG #7549: max_connections check should query master when starting standby

2012-09-18 Thread Fujii Masao
On Tue, Sep 18, 2012 at 3:48 PM, Heikki Linnakangas wrote: > On 18.09.2012 09:46, Craig Ringer wrote: >> >> On 09/18/2012 07:57 AM, Fujii Masao wrote: >>> >>> If you change the max_connections on the master, you need to take a >>> fresh backup from the master and start the standby from it. >> >> >

[BUGS] BUG #7549: max_connections check should query master when starting standby

2012-09-18 Thread Chris Travers
On Mon, Sep 17, 2012 at 11:46 PM, Craig Ringer wrote: > On 09/18/2012 07:57 AM, Fujii Masao wrote: > >> If you change the max_connections on the master, you need to take a >> fresh backup from the master and start the standby from it. >> > > WTF, really? > > What else breaks the replication and fo