Re: [BUGS] BUG #6689: socket file name convention doesn't allow different IPs and the same port for different pgclusters

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 7:33 PM, Mark Schneider wrote: > Am 15.06.2012 07:56, schrieb Magnus Hagander: > >> On Wed, Jun 13, 2012 at 2:45 AM,  wrote: >>> >>> The following bug has been logged on the website: >>> >>> Bug reference:      6689 >>> Logged by:          Mark >>> Email address:      m...@

[BUGS] pg_upgrade fails with missing FTS resources

2012-06-15 Thread Daniele Varrazzo
Hello, pg_upgrade fails on missing FTS dictionaries requiring external files. --check fails to detect the incompatibility. E.g. after installed italian_fts (http://pgxn.org/dist/italian_fts/) into a database, the pg_upgrade_dump_db.sql contains the command: CREATE TEXT SEARCH DICTIONARY italian_

Re: [BUGS] BUG #6689: socket file name convention doesn't allow different IPs and the same port for different pgclusters

2012-06-15 Thread Mark Schneider
Hello Magnus, Thanks a lot for your time checking my email. Am 15.06.2012 07:56, schrieb Magnus Hagander: On Wed, Jun 13, 2012 at 2:45 AM, wrote: The following bug has been logged on the website: Bug reference: 6689 Logged by: Mark Email address: m...@it-infrastrukturen.or

Re: [BUGS] BUG #6694: 9.2 beta 2 : psql commands \db and \db+ fail

2012-06-15 Thread Philippe BEAUDOIN
Hello, paf=# \db ERROR: column "spclocation" does not exist LINE 3: spclocation AS "Location" ^ Are you using the psql provided by 9.2 beta 2? Or an older version? It appears that the version of psql in 9.2 beta 2 does the correct thing, look at src/bin/psql/describe

Re: [BUGS] BUG #6690: ALL and ANY array operators

2012-06-15 Thread Tom Lane
sergey-1...@yandex.ru writes: > As I see in documentation, > http://www.postgresql.org/docs/current/static/functions-aggregate.html there > is an ambiguity with bool_or aggregate and ANY array operator, so bool_or > cannot has standard name ANY. So ANY should always mean array operator. But > such

[BUGS] Can't move extension out of pg_catalog

2012-06-15 Thread Daniele Varrazzo
After moving an extension into the pg_catalog schema, it seems impossible to move it somewhere else: test=# create extension ltree; CREATE EXTENSION test=# alter extension ltree set schema pg_catalog; ALTER EXTENSION test=# alter extension ltree set schema public; ERROR: cannot remove dependency

Re: [BUGS] Can't move extension out of pg_catalog

2012-06-15 Thread Tom Lane
Daniele Varrazzo writes: > After moving an extension into the pg_catalog schema, it seems > impossible to move it somewhere else: > test=# create extension ltree; > CREATE EXTENSION > test=# alter extension ltree set schema pg_catalog; > ALTER EXTENSION > test=# alter extension ltree set schema p

Re: [BUGS] BUG #6695: PgAdminIII

2012-06-15 Thread Euler Taveira
On 14-06-2012 21:17, fabio.lun...@gmail.com wrote: > Quando criado usuário(CREATE USER) com a opção CONNECTION LIMIT, a interface > gráfica do PgAdmin III parece não respeitar o parâmetro, ou está criando > novas conexões desnecessárias. Isso pode ser simulado criando um usuário com > CONNECTION LI

Re: [BUGS] pg_upgrade fails with missing FTS resources

2012-06-15 Thread Bruce Momjian
On Fri, Jun 15, 2012 at 04:15:57PM +0100, Daniele Varrazzo wrote: > Hello, > > pg_upgrade fails on missing FTS dictionaries requiring external files. > --check fails to detect the incompatibility. > > E.g. after installed italian_fts (http://pgxn.org/dist/italian_fts/) > into a database, the pg_u

Re: [BUGS] pg_upgrade fails with missing FTS resources

2012-06-15 Thread Tom Lane
Bruce Momjian writes: > On Fri, Jun 15, 2012 at 04:15:57PM +0100, Daniele Varrazzo wrote: >> pg_upgrade fails on missing FTS dictionaries requiring external files. >> --check fails to detect the incompatibility. > Sure, we can test for that. What system column stores these file names? Trying to

Re: [BUGS] pg_upgrade fails with missing FTS resources

2012-06-15 Thread Bruce Momjian
On Fri, Jun 15, 2012 at 10:27:59PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Fri, Jun 15, 2012 at 04:15:57PM +0100, Daniele Varrazzo wrote: > >> pg_upgrade fails on missing FTS dictionaries requiring external files. > >> --check fails to detect the incompatibility. > > > Sure, we can