Re: [BUGS] ORDER BY...LIMIT optimization does not work with inherited tables

2008-11-21 Thread John Smith
I have just run into this issue myself and I was wondering if it is considered a bug or a missing feature? Is there a plan to address this in an upcoming release? Has anyone found a good work around to the problem in the interim? Thanks! John. On Wed, May 7, 2008 at 4:38 AM, Marshall, Steve <[EMA

Re: [BUGS] Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"

2008-06-30 Thread John Smith
onally selecting > the "Factory" zone? I don't think I've put the correct timezone file in /etc/localtime so it is using some default file from the Gentoo install. John On Mon, Jun 30, 2008 at 12:26 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "John Smith" &l

[BUGS] Recovery failed on a backup with " lock AccessShareLock on object 16477/244169/0 is already held"

2008-06-30 Thread John Smith
Hi, I hit an issue running PG 8.2.3 with the continuous archiving feature where I was unable to recover from the backup. I was wondering if this may be related to bug #3245? These are the steps that occurred before I saw this problem: 1. Prepare transaction. 2. A base backup of the database w

Re: [BUGS] BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts.

2008-04-04 Thread John Smith
On Fri, Apr 4, 2008 at 7:46 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "John Smith" <[EMAIL PROTECTED]> writes: > > Steps to reproduce: > > -- start with a running PG instance with WAL archiving enabled > > -- select pg_start_backup('tes

[BUGS] BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts.

2008-04-04 Thread John Smith
The following bug has been logged online: Bug reference: 4089 Logged by: John Smith Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux 2.6.20-gentoo-r8 Description:When available disk space is low pg_stop_backup() fails, as do

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-10 Thread John Smith
AIL PROTECTED]> Reply-To: pgsql-bugs@postgresql.org To: John Smith <[EMAIL PROTECTED]> CC: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #1547: CREATE TYPE AS error Date: Sat, 2 Apr 2005 19:23:45 -0700 On Mon, Mar 28, 2005 at 12:51:42AM +, John Smith wrote: > I re-installed po

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-02 Thread John Smith
I re-installed postgresql as a service and CREATE TYPE AS works. So I then re-installed postgresql as a program (as I had originally done) and CREATE TYPE AS doesn't work. Perhaps you could check this on your system. John Smith --

[BUGS] BUG #1547: CREATE TYPE AS error

2005-03-17 Thread John Smith
The following bug has been logged online: Bug reference: 1547 Logged by: John Smith Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:CREATE TYPE AS error Details: When trying to create a complex type, the parser