Re: [BUGS] BUG #6206: The reset button is always blocked in case of error in the backup file.

2011-09-14 Thread Craig Ringer
On 09/15/2011 06:10 AM, Carlos wrote: The following bug has been logged online: Bug reference: 6206 Logged by: Carlos Email address: cacues...@yahoo.es PostgreSQL version: 9.1 Operating system: Windows 7 Description:The reset button is always blocked in case of err

Re: [BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-14 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33 > -0300 2011: >> _n_srv=# create table pg_temp.c (x int); >> CREATE TABLE >> _n_srv=# drop table pg_temp.c; >> DROP TABLE >> _n_srv=# create table pg_temp.c (x int unique); >> ERROR: temporary t

Re: [BUGS] Dropped index on table preventing rule creation

2011-09-14 Thread Tom Lane
Robert Haas writes: > I spent some more time looking at this tonight. I am wondering if > perhaps we should just get rid of relhasindex. -1, there is absolutely no reason to believe that's a good idea. > ... I think we could fix Thom's complaint by changing > DefineQueryRewrite() to call Relati

[BUGS] BUG #6207: fali to get lock on parent table after two consecutive updates to the same row in child table

2011-09-14 Thread Eduardo Piombino
The following bug has been logged online: Bug reference: 6207 Logged by: Eduardo Piombino Email address: drak...@gmail.com PostgreSQL version: 9.1.0 Operating system: Windows XP Description:fali to get lock on parent table after two consecutive updates to the same row

Re: [BUGS] psql doesn't reuse -p after backend fail

2011-09-14 Thread Robert Haas
On Thu, Sep 8, 2011 at 5:09 AM, Peter Eisentraut wrote: > On tis, 2011-09-06 at 17:12 +0200, hubert depesz lubaczewski wrote: >> On Mon, Sep 05, 2011 at 02:27:23PM -0400, Tom Lane wrote: >> > It's not just the port, it's all the connection parameters --- >> > do_connect relies on the PGconn object

Re: [BUGS] Dropped index on table preventing rule creation

2011-09-14 Thread Robert Haas
On Tue, Sep 13, 2011 at 4:31 PM, Tom Lane wrote: > Robert Haas writes: >> On Sep 10, 2011, at 11:26 PM, Tom Lane wrote: >>> (IOW, rather than "fix" this I'd prefer to rip out the code altogether. >>> But maybe we should wait a couple more years for that.) > >> IIRC, it's not dead code. I think y

[BUGS] BUG #6206: The reset button is always blocked in case of error in the backup file.

2011-09-14 Thread Carlos
The following bug has been logged online: Bug reference: 6206 Logged by: Carlos Email address: cacues...@yahoo.es PostgreSQL version: 9.1 Operating system: Windows 7 Description:The reset button is always blocked in case of error in the backup file. Details: Hello:

Re: [BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-14 Thread Abel Abraham Camarillo Ojeda
On Wed, Sep 14, 2011 at 4:49 PM, Alvaro Herrera wrote: > > Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33 > -0300 2011: > >> Cannot create temporary tables without using CREATE TEMP, >> if I hardcode 'pg_temp' as a schema _and_ the table uses >> a unique constraint on

Re: [BUGS] BUG #6204: Using plperl functions generate crash

2011-09-14 Thread Alex Hunsaker
On Wed, Sep 14, 2011 at 03:15, pasman wrote: > > The following bug has been logged online: > > Bug reference:      6204 > Logged by:          pasman > Email address:      pasma...@gmail.com > PostgreSQL version: 9.1.0 > Operating system:   WinXP sp3 > Description:        Using plperl functions gen

Re: [BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-14 Thread Alvaro Herrera
Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33 -0300 2011: > Cannot create temporary tables without using CREATE TEMP, > if I hardcode 'pg_temp' as a schema _and_ the table uses > a unique constraint on a column, this does work if the table > doesn't use a unique con

[BUGS] BUG #6205: ERROR: temporary tables cannot specify a schema name

2011-09-14 Thread Abel Abraham Camarillo Ojeda
The following bug has been logged online: Bug reference: 6205 Logged by: Abel Abraham Camarillo Ojeda Email address: acam...@verlet.org PostgreSQL version: 9.1.0 Operating system: OpenBSD-current/amd64 Description:ERROR: temporary tables cannot specify a schema name

Re: [BUGS] BUG #6203: Building libpq with Visual Studio 9.0 error

2011-09-14 Thread Heikki Linnakangas
On 14.09.2011 08:23, Steve wrote: The following bug has been logged online: Bug reference: 6203 Logged by: Steve Email address: argon...@yandex.ru PostgreSQL version: 9.1.0 Operating system: Windows XP SP3 x32 Description:Building libpq with Visual Studio 9.0 error

[BUGS] BUG #6203: Building libpq with Visual Studio 9.0 error

2011-09-14 Thread Steve
The following bug has been logged online: Bug reference: 6203 Logged by: Steve Email address: argon...@yandex.ru PostgreSQL version: 9.1.0 Operating system: Windows XP SP3 x32 Description:Building libpq with Visual Studio 9.0 error Details: When I'm trying to build

[BUGS] BUG #6204: Using plperl functions generate crash

2011-09-14 Thread pasman
The following bug has been logged online: Bug reference: 6204 Logged by: pasman Email address: pasma...@gmail.com PostgreSQL version: 9.1.0 Operating system: WinXP sp3 Description:Using plperl functions generate crash Details: After install postgresql 9.1.0 and Acti