Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread Craig Ringer
On 08/08/2012 02:54 PM, John R Pierce wrote: On 08/07/12 11:10 PM, Craig Ringer wrote: Please examine the PostgreSQL server logs for error details. I think they're in /var/lib/pgsql/data/pg_log on CentOS, as that's where they are on Fedora. the PGDG rpm/yum repo of 9.1 defaults logs to /var

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread John R Pierce
On 08/07/12 11:10 PM, Craig Ringer wrote: Please examine the PostgreSQL server logs for error details. I think they're in /var/lib/pgsql/data/pg_log on CentOS, as that's where they are on Fedora. the PGDG rpm/yum repo of 9.1 defaults logs to /var/lib/pgsql/9.1/data/pg_log other things of pot

Re: [BUGS] BUG #7481: DB installer Not progress

2012-08-07 Thread Sachin Srivastava
Hello Junho, We have fixed some issues related to the bug you posted, They will be available in the next upcoming PostgreSQL point release. On Tue, Aug 7, 2012 at 6:02 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7481 > Logged by: Junho Kim > E

Re: [BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread Craig Ringer
On 08/08/2012 02:06 PM, sudhir...@hotmail.com wrote: The following bug has been logged on the website: Bug reference: 7484 Logged by: sudhir Email address: sudhir...@hotmail.com PostgreSQL version: 9.1.4 Operating system: centos Description: pg_restore: [archiver (db)] Erro

[BUGS] BUG #7484: while restore database backup error is raised

2012-08-07 Thread sudhir711
The following bug has been logged on the website: Bug reference: 7484 Logged by: sudhir Email address: sudhir...@hotmail.com PostgreSQL version: 9.1.4 Operating system: centos Description: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (

Re: [BUGS] renaming+recreating table w/default sequence causes dependency seq issue

2012-08-07 Thread Tom Lane
Todd Kover writes: > I saw issues around renaming tables and not renaming sequences in the TODO > list but did not see anything about this. Apologies if I missed it. > This is with a 9.1.4 server (enterprisedb download on mac os/x lion) and also > seen on 9.1.3 built from netbsd pkgsrc. > It ap

Re: [BUGS] renaming+recreating table w/default sequence causes dependency seq issue

2012-08-07 Thread Alvaro Herrera
Excerpts from Todd Kover's message of mar ago 07 20:10:25 -0400 2012: > Given this: > -- > drop table IF EXISTS foo; > drop table IF EXISTS foo_v26; > > create table foo (id serial not null, bar integer ); > alter table foo alter column id drop default; > > alter table foo rename to foo_v26;

Re: [BUGS] Small bug in psqlodbc-09.01 prevents interoperability with LISTSERV

2012-08-07 Thread Craig Ringer
On 08/04/2012 11:43 PM, Eric Thomas wrote: Because we have customers who think Excel is an RDBMS, our product LISTSERV religiously queries ODBC capabilities at startup and prints warnings as appropriate. A customer tried to use PostgreSQL on Windows and got the following (these are our messag

[BUGS] renaming+recreating table w/default sequence causes dependency seq issue

2012-08-07 Thread Todd Kover
I saw issues around renaming tables and not renaming sequences in the TODO list but did not see anything about this. Apologies if I missed it. This is with a 9.1.4 server (enterprisedb download on mac os/x lion) and also seen on 9.1.3 built from netbsd pkgsrc. It appears that something is amiss

Re: [BUGS] event triggers patch breaks with -DCLOBBER_CACHE_ALWAYS

2012-08-07 Thread Robert Haas
On Mon, Jul 23, 2012 at 8:16 PM, Jeff Davis wrote: > Compiling 3a0e4d with -DCLOBBER_CACHE_ALWAYS causes initdb to segfault. > > It looks like the tuple was allocated in the EventTriggerCacheContext, > and before the tuple was freed, another invalidation event came along > and wiped out that conte

Re: [BUGS] BUG #7483: uuid-ossp does not compile on OS X 10.8

2012-08-07 Thread Tom Lane
dcarm...@dcarmichael.net writes: > I'm compiling PostgreSQL 9.1.4 on OS X 10.8, and the uuid-ossp extension > doesn't compile properly, as follows: Yeah, we've heard that already. It appears that OSSP needs to fix their code for Mountain Lion --- Apple seem to have changed in a way OSSP wasn't e

[BUGS] BUG #7483: uuid-ossp does not compile on OS X 10.8

2012-08-07 Thread dcarmich
The following bug has been logged on the website: Bug reference: 7483 Logged by: Douglas Carmichael Email address: dcarm...@dcarmichael.net PostgreSQL version: 9.1.4 Operating system: OS X 10.8 (Mountain Lion) Description: I'm compiling PostgreSQL 9.1.4 on OS X 10.8,

[BUGS] BUG #7481: DB installer Not progress

2012-08-07 Thread junho1 . kim
The following bug has been logged on the website: Bug reference: 7481 Logged by: Junho Kim Email address: junho1@lge.com PostgreSQL version: 9.1.3 Operating system: Windows XP sp3 Description: I have run the postgresql-9.1.3-2-windows.exe at command window. (postg

[BUGS] BUG #7482: lack of quotation marks in pg_env script

2012-08-07 Thread m . skrzypkowski
The following bug has been logged on the website: Bug reference: 7482 Logged by: Maciej Skrzypkowski Email address: m.skrzypkow...@o2.pl PostgreSQL version: 9.1.4 Operating system: Windows XP Description: In main application directory, inside pg_env.bat script there i

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2012-08-07 Thread Tom Lane
Robert Haas writes: > We just had a customer hit a very similar problem on 9.1.3, running on > Windows Server 2008 SP2. ... > The customer finds that they can reproduce this on a variety of > systems under heavy load. > Now, it looks to me like for this stack trace to happen, > PgstatCollectorMai

Re: [BUGS] BUG #6126: CC parameter in to_char() behaves incorrectly

2012-08-07 Thread Bruce Momjian
On Mon, Aug 6, 2012 at 03:20:18PM -0400, Bruce Momjian wrote: > On Sat, Aug 4, 2012 at 10:34:14AM -0400, Bruce Momjian wrote: > > > I am thinking it is too late to apply this for 9.2 because users might > > > have already tested their applications, though I doubt many are using BC > > > dates. F

Re: [BUGS] BUG #6739: PGAdmin 3 Should allow to select multiple tables in the left tree

2012-08-07 Thread Robert Haas
On Mon, Jul 16, 2012 at 6:43 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 6739 > Logged by: Stuart Axon > Email address: stua...@yahoo.com > PostgreSQL version: 9.1.0 > Operating system: Linux > Description: > > If you go to Database>{db}>

Re: [BUGS] BUG #6738: pg_dump does not handle extensions properly/invalid pg_dump output

2012-08-07 Thread Robert Haas
On Sat, Jul 14, 2012 at 1:44 PM, wrote: > Here is a feature that pg_dump needs: An option needs to be added to > explicitly suppress or allow backing up all or selected extensions. I agree. > Reason and associated bug: > The current behavior may by fine with extensions that do not add or chang

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2012-08-07 Thread Robert Haas
On Fri, Jul 31, 2009 at 10:59 AM, Luke Koops wrote: > -- postgres.exe!mainCRTStartup -- > ntoskrnl.exe!KiSwapContext+0x26 > ntoskrnl.exe!KiSwapThread+0x2e5 > ntoskrnl.exe!KeWaitForSingleObject+0x346 > ntoskrnl.exe!KiSuspendThread+0x18 > ntoskrnl.exe!KiDeliverApc+0x117 > ntoskrnl.exe!KiSwapThread+0

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-08-07 Thread Magnus Hagander
On Tue, Jul 31, 2012 at 9:07 AM, Guillaume Lelarge wrote: > On Tue, 2012-07-31 at 14:06 +0800, Craig Ringer wrote: >> On 07/31/2012 01:50 PM, Guillaume Lelarge wrote: >> >> Check the PgAdmin-III preferences; there may be an option to control its >> >> preferred bytea format. >> >> >> > There's no