Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 3:13 AM, Robert Haas wrote: > On Mon, Dec 21, 2009 at 7:05 AM, Ashish Anand > wrote: >> Hi, >> I downloaded from here >> http://www.postgresql.org/download/windows >> which leads to >> http://www.enterprisedb.com/products/pgdownload.do#windows >> and has a note: >> The on

[BUGS] Re: Postgresql 8.4.2, Windows XP - temporary file leak: File still referenced

2009-12-22 Thread Heikki Linnakangas
Алексей wrote: > windows or linux. > See test script Hmm, looks like I broke this with the patch to fix the assertion failure when a cursor is opeened in a subtransaction and the subtransaction is then rolled back. Thanks for the report! The bug is that when we put tuples to the tuplestore that h

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Well, I hope he does. Thanks by the way. --Ashish. On Tue, Dec 22, 2009 at 8:43 AM, Robert Haas wrote: > On Mon, Dec 21, 2009 at 7:05 AM, Ashish Anand > wrote: > > Hi, > > I downloaded from here > > http://www.postgresql.org/download/windows > > which leads to > > http://www.enterprisedb.com/

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Actually its not critical for Postgres but I was going through the tutorial in the Postgres .chm help file where this directory was mentioned. And it specifically said "If you installed a pre-packaged version of PostgreSQL"(see the first mail) which made it look like a bug. Nevertheless, I have do

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Tom Lane
Dave Page writes: > In 12 years of working with PG, I never noticed that directory > required building manually (which is why it's not it any installer > from EDB, or the community). Is there any reason for that? To judge from the RPM examples, you'd probably need special actions anyway. The RPM

Re: [BUGS] OutOfMemory hibernate scroll with 2M records | Postgresql 8.4 DB

2009-12-22 Thread Kevin Grittner
Craig Ringer wrote: > Greg Stark wrote: >> Ankit Kumar wrote: >>> Thanks for your response. Hibernate works well when I change the >>> DB to SQL server but somehow the moment I point to Postgresql it >>> start generating OutOfMemory. Is there some configuration at DB >>> end to ensure it starts us

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 3:30 PM, Ashish Anand wrote: > Just to make it clear, if it wasn't apparent already, my operating system is > Windows 7. I'm pretty sure the MSVC build system doesn't even know about the tutorial directory, so we'd need to fix that before any installer changes were made.

Re: [BUGS] OutOfMemory hibernate scroll with 2M records | Postgresql 8.4 DB

2009-12-22 Thread Ankit Kumar
All Thanks alot for your help. Got it working by setting the following: - 1. Connection to AutoCommit(false); 2. Criteria.scroll(ScrollMode.FORWARD_ONLY); 3. Set hibernate.jdbc.fetch_size=1000 Regards Ankit Kevin Grittner wrote: Craig Ringer wrote: Greg Stark wrote: Ankit Kumar wro

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Just to make it clear, if it wasn't apparent already, my operating system is Windows 7. --Ashish. On Tue, Dec 22, 2009 at 8:18 PM, Tom Lane wrote: > Dave Page writes: > > In 12 years of working with PG, I never noticed that directory > > required building manually (which is why it's not it any

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Alvaro Herrera
Tom Lane escribió: > # Have to hack makefile to put correct path into tutorial scripts > sed "s|C=\`pwd\`;|C=%{_libdir}/pgsql/tutorial;|" < src/tutorial/Makefile > > src/tutorial/GNUmakefile > make %{?_smp_mflags} -C src/tutorial NO_PGXS=1 all > rm -f src/tutorial/GNUmakefile > > install -d -m 7

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Sorry your tenses were a bit jumbled up in last response. Couldn't make out what was past and what will be future action. But in short seems like you/someone is going to make the fix pretty soon? Am I right here? But regardless, please open a bug in your bug tracking database so that it doesn't ge

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Tom Lane
Alvaro Herrera writes: > Tom Lane escribió: >> It looks to me like the unmodified Makefile builds the .sql files >> on the assumption they will be used *in the source tree*. So basically >> no installer could use that as-is anyway. > Sounds like something that should be fixed upstream, if someon

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Alvaro Herrera
Ashish Anand escribió: > I think they just have to be there. Preferably in the form of raw code - as > documentation mentions. Feel free to propose a patch! -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Alvaro Herrera
Ashish Anand escribió: > I thought enterprise db wasn't open-source. Is it? > Give me a link please. I'll give the patch. Some of its products are (EDB is a company), but here we're talking about PostgreSQL which definitely is open source. You can find the source code here: http://git.postgresql

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
I think they just have to be there. Preferably in the form of raw code - as documentation mentions. --Ashish. On Wed, Dec 23, 2009 at 1:23 AM, Tom Lane wrote: > Alvaro Herrera writes: > > Tom Lane escribió: > >> It looks to me like the unmodified Makefile builds the .sql files > >> on the assu

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
I thought enterprise db wasn't open-source. Is it? Give me a link please. I'll give the patch. On Wed, Dec 23, 2009 at 1:44 AM, Alvaro Herrera wrote: > Ashish Anand escribió: > > I think they just have to be there. Preferably in the form of raw code - > as > > documentation mentions. > > Feel fre

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Just to be clear - link for source code enlistment of enterprise db. On Wed, Dec 23, 2009 at 1:46 AM, Ashish Anand wrote: > I thought enterprise db wasn't open-source. Is it? > Give me a link please. I'll give the patch. > > > On Wed, Dec 23, 2009 at 1:44 AM, Alvaro Herrera < > alvhe...@commandpr

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 8:43 PM, Ashish Anand wrote: > Alvaro, Please read the first three mails in this thread. > > Dave, can you open a bug at your end. Just open it so that it can be tracked > two months down the line. I am not insisting on fixing it right now. There is nothing to fix at 'my e

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Dave Page
On Tue, Dec 22, 2009 at 9:03 PM, Ashish Anand wrote: > Fine. Whatever suits you. I guess there is only so much I can do through > e-mails as an end user. I was just trying not to drop the ball and do a > positive handover. Don't worry - we appreciate the bug report, and are not in the habit of ig

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Fine. Whatever suits you. I guess there is only so much I can do through e-mails as an end user. I was just trying not to drop the ball and do a positive handover. Thanks anyways. --Ashish. On Wed, Dec 23, 2009 at 2:28 AM, Dave Page wrote: > On Tue, Dec 22, 2009 at 8:43 PM, Ashish Anand > wrot

Re: [BUGS] BUG #5250: Tutorial examples(pre-compiled) not present with precompiled binary version of PostgreSQL.

2009-12-22 Thread Ashish Anand
Alvaro, Please read the first three mails in this thread. Dave, can you open a bug at your end. Just open it so that it can be tracked two months down the line. I am not insisting on fixing it right now. --Ashish. On Wed, Dec 23, 2009 at 1:49 AM, Alvaro Herrera wrote: > Ashish Anand escribió: >

[BUGS] BUG #5253: installer fails to populate data directory

2009-12-22 Thread Daniel Convissor
The following bug has been logged online: Bug reference: 5253 Logged by: Daniel Convissor Email address: dani...@analysisandsolutions.com PostgreSQL version: 8.4.2-1 Operating system: Windows XP Pro SP3 Description:installer fails to populate data directory Details: