Re: [BUGS] pg_dump dependency loop with extension containing its own schema

Thom Brown writes: > I'm getting a dependency loop issue with pg_dump when adding a schema > to an extension where the schema being added is the same as the one > containing the extension. > CREATE EXTENSION file_fdw; > ALTER EXTENSION file_fdw ADD SCHEMA public; ISTM we ought to disallow that .

[BUGS] pg_dump dependency loop with extension containing its own schema

Hi, I'm getting a dependency loop issue with pg_dump when adding a schema to an extension where the schema being added is the same as the one containing the extension. CREATE EXTENSION file_fdw; ALTER EXTENSION file_fdw ADD SCHEMA public; $ pg_dump -f /dev/null test pg_dump: [sorter] WARNING: co

Re: [BUGS] Bug when changing datatype of primary key column

hubert depesz lubaczewski writes: > $ create table z (i int4); > CREATE TABLE > $ create unique index q on z (i); > CREATE INDEX > $ alter table z add primary key using index q; > ALTER TABLE > $ alter table z alter column i type int8; > ERROR: could not open relation with OID 16503 > looks like

[BUGS] Bug when changing datatype of primary key column

tested on: 1. 9.1.3 2. 9.3devel (yesterdays head in git) steps to reproduce: $ create table z (i int4); CREATE TABLE $ create unique index q on z (i); CREATE INDEX $ alter table z add primary key using index q; ALTER TABLE $ alter table z alter column i type int8; ERROR: could not open relati

Re: [BUGS] BUG #7486: Error Group by

On Fri, Aug 10, 2012 at 10:33 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7486 > Logged by: Anderson Abreu > Email address: andersonab...@gmail.com > PostgreSQL version: 8.4.12 > Operating system: Linux > Description: > > Dear, > > I'm te