[GENERAL] Error compiling postgresql UDT in visual studio 2008

2008-06-19 Thread Brijesh Shrivastav
Hi! We are in the process of moving our development environment to visual studio 2008 and as a part of that process I tried to build our postgresql extended UDT in that environment. I ran into typedef redefinition error because visual studio 2008 header file crtdefs.h typedef errcode

[GENERAL] XML Support related questions

2008-05-22 Thread Brijesh Shrivastav
Hello PostgreSQL XML Experts, I was exploring xml support in postgreSQL and ran into few questions answer to which I couldn't find easily in the documentation. I would appreciate responses to following queries: 1) Can xml column be constrained to be DOCUMENT or CONTENT type? XMLPARSE/

[GENERAL] Inline Function documentation

2007-09-18 Thread Brijesh Shrivastav
Hi! All, I have come cross many posting that talks about INLINE FUNCTION and their utility in helping optimizer decide the right plan. However, other than few posting in different forums I haven't been able to get my hands on any sort of documentation that explains which function can be converted

[GENERAL] Can someone shed some light on following error: "pg_tblspc/16763/16764/PG_VERSION" is missing

2007-07-18 Thread Brijesh Shrivastav
Hi! Some users in our group have reported running into following error occasionally. They couldn't pinpoint a specific set of action that led to this error but don't believe they did anything catastrophic as this error suggest. Any ideas or explanation will be appreciated. FATAL: "pg_tblspc/16