Re: [BUGS] BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table

2012-07-02 Thread Amit Kapila
> From: pgsql-bugs-ow...@postgresql.org > [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of > miroslav.s...@fordfrog.com > Sent: Saturday, June 30, 2012 4:28 PM > The following bug has been logged on the website: > Bug reference: 6712 > Logged by: Miroslav Ć ulc > Email address:

Re: [BUGS] BUG #6650: CPU system time utilization rising few times a day

2012-07-02 Thread Andrzej Krawiec
Ok, we are 99% sure as for what is the reason for this situation. Let's say we have a 1 GB of free memory. Any process (especially postgres, as it is dedicated server) wants to allocate little more. Kernel has to look through cached memory to determine which cache pages can be dropped and allocated

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-02 Thread Bruce Momjian
On Sat, Jun 30, 2012 at 02:37:47PM -0400, Tom Lane wrote: > > However, surprisingly, a simple pg_dump/restore also does not preserve > > the public schema permissions either. :-( > > Right. My point is that there is a whole lot of stuff that initdb > creates but does not mark "pinned" in pg_depe

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-02 Thread Tom Lane
Bruce Momjian writes: > + > + /* > + * We unconditionally create the extension, so we must > drop it if it > + * exists. This could happen if the user deleted > 'plpgsql' and then > + * readded it, causing its oid to be greater

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-02 Thread Bruce Momjian
On Mon, Jul 02, 2012 at 01:01:51PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > + > > + /* > > +* We unconditionally create the extension, so we must > > drop it if it > > +* exists. This could happen if the user deleted > > 'plpgsql' and then

Re: [BUGS] BUG #6705: 32 bit

2012-07-02 Thread Sachin Srivastava
I looked at the logs you sent. Strangely the command *"D:\Program Files\PostgreSQL\9.1\bin\initdb.exe" --locale=C --encoding=UTF-8 -A md5 -U postgres -d "D:\Program Files\PostgreSQL\9.1\data"* * * produces no output in the log. Can you try to manually execute this above command and share the outpu