Re: [BUGS] BUG #5389: Column order on dump/reload broken from defined setof function

2010-03-28 Thread Robert Haas
On Fri, Mar 26, 2010 at 7:00 AM, Dimitri Fontaine wrote: > "Timothy Seever" 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

Re: [BUGS] BUG #5392: Query Optimization

2010-03-28 Thread Robert Haas
On Sat, Mar 27, 2010 at 6:06 AM, wrote: >> I am facing problem in optimizing my this query. can u please let me know >> how can i optimize this query. > this is most probably not a PostgreSQL bug. You are more likely to get > help from pgsql-nov...@postgresql.org. But to help others help you, you

Re: [BUGS] BUG #5394: invalid __declspec for PG_MODULE_MAGIC

2010-03-28 Thread Tom Lane
"Vladimir Barzionov" writes: > In fmgr.h, > macros PG_MODULE_MAGIC, PG_FUNCTION_INFO_V1.. are declared with incorrect > "storage-class". It uses PGDLLIMPORT for declare __declspec(). > In general for building external DLL module, PGDLLIMPORT must be > __declspec(dllimport). As it is. > However i

[BUGS] BUG #5394: invalid __declspec for PG_MODULE_MAGIC

2010-03-28 Thread Vladimir Barzionov
The following bug has been logged online: Bug reference: 5394 Logged by: Vladimir Barzionov Email address: snego.bar...@gmail.com PostgreSQL version: 8.3.10 Operating system: win32 Description:invalid __declspec for PG_MODULE_MAGIC Details: In fmgr.h, macros PG_MODU