Re: [BUGS] BUG #6634: pg_dump dumps cast after objects depending on it

2012-05-08 Thread Tom Lane
avand...@gmail.com writes: > A cast, which transforms a composite type to timestamp without time zone, is > included in the regular backups of a database. > There are several views utilizing this cast, but these are always listed > before the cast, therefore pg_restore or psql will issue an error

Re: [BUGS] BUG #6633: PL/Python build does not honor PYTHON on Mac OS X

2012-05-08 Thread Clay McClure
On Tue, May 8, 2012 at 11:07 AM, Clay McClure wrote: > Thanks for your reply, Tom. I will check with the Homebrew > maintainers, but my (albeit limited) understanding of the subject is > that a framework Python is only needed for GUI applications. Unless > PL/Python is opening windows and drawing

Re: [BUGS] BUG #6633: PL/Python build does not honor PYTHON on Mac OS X

2012-05-08 Thread Clay McClure
On Tue, May 8, 2012 at 1:42 AM, Tom Lane wrote: > Hmm ... on my Mac, > > $ python-config > Usage: /usr/bin/python-config > [--prefix|--exec-prefix|--includes|--libs|--cflags|--ldflags|--help] > > None of those options produce anything including "-framework Python". > So I think your upstream nee

[BUGS] BUG #6634: pg_dump dumps cast after objects depending on it

2012-05-08 Thread avandras
The following bug has been logged on the website: Bug reference: 6634 Logged by: András Váczi Email address: avand...@gmail.com PostgreSQL version: 9.1.3 Operating system: Ubuntu 10.04.4 LTS Description: A cast, which transforms a composite type to timestamp without t

Re: [BUGS] BUG #6629: Creating a gist index fails with "too many LWLocks taken"

2012-05-08 Thread Heikki Linnakangas
On 07.05.2012 18:51, Tom Lane wrote: Heikki Linnakangas writes: I wrote a quick patch to do that, and with the patch the index build finished - but it took hours. And the index was 10GB in size, where the heap is just 12 MB, and searches using the index take ages. Hm, is the example exploitin