Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-08-31 Thread Rikard Pavelic
On 29.8.2012. 21:02, Merlin Moncure wrote: > On Wed, Aug 29, 2012 at 10:44 AM, Chris Travers > wrote: > >> Again, the question is simply this: >> >> Are the table constraints for storage complete in themselves (and assuming >> full knowledge of all changes of internal data types) or are they >> e

Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-08-31 Thread Chris Travers
On Fri, Aug 31, 2012 at 12:32 AM, Rikard Pavelic wrote: > > > I'm doing something most DBA would probably think it's a bad idea, but at > least > I can provide you with use case of Postgres usage. > There are bad ideas and there are bad ideas. The question of course is what you get and what it

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-08-31 Thread Andrew Hastie
On 29/08/12 18:16, Tom Lane wrote: Andrew Hastie writes: I'm currently working on a project where I need to get PGv9.1 up and running on an IBM AIXv7.1 server, so I do have access to a suitable machine for a period of time if I can provide any further diags to help resolve the issue. That wou

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-08-31 Thread Tom Lane
Andrew Hastie writes: > Thanks for the pointers. Hopefully some of the following may shed some > light on the issue. Thanks for the results. It seems difficult to come to any conclusion other than that AIX has got wcstombs_l but not mbstowcs_l ... which is darn bizarre; I'd suggest reporting it

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Alvaro Herrera
Excerpts from Tom Lane's message of vie jun 22 22:37:10 -0400 2012: > j...@pgexperts.com writes: > > DROP and CREATE extension appear to work fine, but if you ALTER EXTENSION > > postgis SET SCHEMA foo, it leaves a few relations behind. > > What it seems to be leaving behind is indexes ... also re

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-08-31 Thread Andrew Hastie
On 31/08/12 15:59, Tom Lane wrote: Andrew Hastie writes: Thanks for the pointers. Hopefully some of the following may shed some light on the issue. Thanks for the results. It seems difficult to come to any conclusion other than that AIX has got wcstombs_l but not mbstowcs_l ... which is darn

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

2012-08-31 Thread Bruce Momjian
On Tue, Aug 7, 2012 at 12:15:14PM +, m.skrzypkow...@o2.pl wrote: > 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 >

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Tom Lane
Alvaro Herrera writes: > Aha, I see the bug. It seems the split for AlterObjectNamespace_oid > related to tables was done at the wrong level: there should be a new > AlterTableNamespace_internal call that does all the extra stuff, and > which is to be called from AlterObjectNamespace_oid. Sounds

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

2012-08-31 Thread Dave Page
On Fri, Aug 31, 2012 at 5:17 PM, Bruce Momjian wrote: > On Tue, Aug 7, 2012 at 12:15:14PM +, m.skrzypkow...@o2.pl wrote: >> The following bug has been logged on the website: >> >> Bug reference: 7482 >> Logged by: Maciej Skrzypkowski >> Email address: m.skrzypkow...@o2.pl >

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Alvaro Herrera
Excerpts from Tom Lane's message of vie ago 31 12:17:59 -0400 2012: > Alvaro Herrera writes: > > Aha, I see the bug. It seems the split for AlterObjectNamespace_oid > > related to tables was done at the wrong level: there should be a new > > AlterTableNamespace_internal call that does all the ext

[BUGS] BUG #7512: can't install pgdg-centos91-9.1-4.noarch.rpm

2012-08-31 Thread s0525775
The following bug has been logged on the website: Bug reference: 7512 Logged by: Jana Weschenfelder Email address: s0525...@htw-berlin.de PostgreSQL version: 9.1.0 Operating system: Scientific Linux 6 Description: Hello, If I try to install Postgresql91 (in this cas

[BUGS] BUG #7513: Cluster install failed

2012-08-31 Thread gravesl
The following bug has been logged on the website: Bug reference: 7513 Logged by: Larry Email address: grav...@smartronix.com PostgreSQL version: 8.4.0 Operating system: win server 2003 SP2 Description: Post-Installation failed(Cluster install failed). I have gotten th

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of vie ago 31 12:26:50 -0400 2012: > Excerpts from Tom Lane's message of vie ago 31 12:17:59 -0400 2012: > > Alvaro Herrera writes: > > > Aha, I see the bug. It seems the split for AlterObjectNamespace_oid > > > related to tables was done at the wrong level:

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-08-31 Thread Tom Lane
Andrew Hastie writes: > On 31/08/12 15:59, Tom Lane wrote: >> As a temporary workaround, you should probably just modify pg_config.h >> after configure runs, to remove the HAVE_WCSTOMBS_L symbol. > Confirm that the workaround works just fine. Now have PG 9.1.5 up and > running on AIX just fine.

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Tom Lane
Alvaro Herrera writes: > Here's a patch. Looks reasonable, but please try a little harder on the comments for the new function --- IMO it should have a header comment that explains what it's supposed to do exactly. > For some reason, AlterSeqNamespaces was being passed a schema name. > This wasn

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Alvaro Herrera
Excerpts from Tom Lane's message of vie ago 31 16:01:03 -0400 2012: > Alvaro Herrera writes: > > Here's a patch. > > Looks reasonable, but please try a little harder on the comments for the > new function --- IMO it should have a header comment that explains what > it's supposed to do exactly. S

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of vie ago 31 16:25:40 -0400 2012: > Excerpts from Tom Lane's message of vie ago 31 16:01:03 -0400 2012: > > Alvaro Herrera writes: > > > Here's a patch. > > > > Looks reasonable, but please try a little harder on the comments for the > > new function --- IM

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-08-31 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Alvaro Herrera's message of vie ago 31 16:25:40 -0400 2012: >> This doesn't actually work though: it's trying to move sequences twice. >> Not sure what the right fix for this is ... still looking. > Besides being listed with deptype=extension for the extensi

Re: [BUGS] BUG #7512: can't install pgdg-centos91-9.1-4.noarch.rpm

2012-08-31 Thread Devrim GÜNDÜZ
Hi, On Fri, 2012-08-31 at 14:47 +, s0525...@htw-berlin.de wrote: > If I try to install Postgresql91 (in this case > postgresql91-9.1.5-1PGDG.rhel6) from > http://yum.pgrpms.org/9.1/redhat/rhel-6-x86_64/repoview/, I receive the > message that the package "centos-release" is missing. Ok, but if

Re: [BUGS] BUG #7513: Cluster install failed

2012-08-31 Thread Craig Ringer
On 08/31/2012 11:49 PM, grav...@smartronix.com wrote: The following bug has been logged on the website: Bug reference: 7513 Logged by: Larry Email address: grav...@smartronix.com PostgreSQL version: 8.4.0 Operating system: win server 2003 SP2 Description: Post-Installation

Re: [BUGS] BUG #6239: Looking for a technical contact point for PostgreSQL compatibility issue on Windows8

2012-08-31 Thread Simon Riggs
On 4 October 2011 02:42, Seiko Ishida wrote: > The following bug has been logged online: > > Bug reference: 6239 > Logged by: Seiko Ishida > Email address: v-sei...@microsoft.com > PostgreSQL version: 8.2.4 > Operating system: Windows 8 > Description:Looking for a tec