[BUGS] error after dropping column

2010-01-11 Thread Filip Rembiałkowski
Hi all, not sure if I should send it here; if it was reported before in pgsql-general. you can just ignore it :-) with postgres 8.2.4: create table test (t1 text); create function row2text(test) returns text as 'select $1::text' language sql immutable; create index test_row2text_idx on test( row

Re: [BUGS] BUG #5271: pg_dump: schema with OID 22519 does not exist

2010-01-11 Thread Robert Haas
On Mon, Jan 11, 2010 at 2:00 AM, Michael Tenenbaum wrote: > > The following bug has been logged online: > > Bug reference:      5271 > Logged by:          Michael Tenenbaum > Email address:      mich...@strategic-techs.com > PostgreSQL version: 8.3.9 > Operating system:   Gentoo Linux > Descriptio

[BUGS] BUG #5272: PL/Python SELECT: return composite fields as dict, not str

2010-01-11 Thread Steve White
The following bug has been logged online: Bug reference: 5272 Logged by: Steve White Email address: swh...@aip.de PostgreSQL version: 8.4.2 Operating system: Linux Description:PL/Python SELECT: return composite fields as dict, not str Details: Hi, As recently post

Re: [BUGS] plperl & sort

2010-01-11 Thread Alex Hunsaker
On Thu, Nov 6, 2008 at 08:37, Alex Hunsaker wrote: > On Thu, Nov 6, 2008 at 06:41, Tom Lane wrote: >> "Alex Hunsaker" writes: >>> On Wed, Nov 5, 2008 at 18:03, Andrew Gierth >>> wrote: Then explain why the problem goes away when you build perl with threading turned off. >> >>> Hrm ye

Re: [BUGS] error after dropping column

2010-01-11 Thread Craig Ringer
On 11/01/2010 10:27 PM, Filip Rembiałkowski wrote: Hi all, not sure if I should send it here; if it was reported before in pgsql-general. you can just ignore it :-) with postgres 8.2.4: create table test (t1 text); create function row2text(test) returns text as 'select $1::text' language sql i

Re: [BUGS] error after dropping column

2010-01-11 Thread Tom Lane
Craig Ringer writes: > On 11/01/2010 10:27 PM, Filip Rembiałkowski wrote: >> ERROR: table row type and query-specified row type do not match >> DETAIL: Physical storage mismatch on dropped attribute at ordinal >> position 2. > I'm pretty certain that's not a bug. No, it is a bug, or at least

Re: [BUGS] BUG #5272: PL/Python SELECT: return composite fields as dict, not str

2010-01-11 Thread Robert Haas
On Mon, Jan 11, 2010 at 11:41 AM, Steve White wrote: > I see nothing in the documentation about this >        http://www.postgresql.org/docs/8.4/static/plpython.html > It only talks about passing composite types into and out of functions. > > This is an unpleasant discovery for those working to a