On Fri, Mar 26, 2010 at 7:00 AM, Dimitri Fontaine
dfonta...@hi-media.com wrote:
Timothy Seever tim.see...@gmail.com writes:
CREATE FUNCTION testfunc() RETURNS setof tablec AS $BODY$ SELECT * FROM
tablec; $BODY$ LANGUAGE 'sql' STABLE;
Common wisdom saith to never ever use SELECT * in your
Timothy Seever tim.see...@gmail.com writes:
CREATE FUNCTION testfunc() RETURNS setof tablec AS $BODY$ SELECT * FROM
tablec; $BODY$ LANGUAGE 'sql' STABLE;
Common wisdom saith to never ever use SELECT * in your code. You just
found out a reason why.
Regards,
--
dim
--
Sent via pgsql-bugs
The following bug has been logged online:
Bug reference: 5389
Logged by: Timothy Seever
Email address: tim.see...@gmail.com
PostgreSQL version: 8.3.5, others
Operating system: Linux
Description:Column order on dump/reload broken from defined setof
function
Details:
Timothy Seever tim.see...@gmail.com writes:
Adding a column to an inherited table in-place works as expected with the
combined table/etc. However on dump/reload the physical order changes, so
any? predefined select from a setof function pulling from the combined table
will result in a