[GENERAL] Experiences with extensibility

What types of extensibility (possibly already available in other DBMSs) are currently missing in PostgreSQL? 3. To what extent was your choice of PostgreSQL as a development platform based primarily on its extensibility features? ** Eric Davies,

[GENERAL] manipulating HeapTuples in a libpq client

I've got a server function that returns a set of HeapTuples. The server function is invoked in a query sent by a libpq client.However, I haven't spotted a way to decompose the HeapTuple returned to the client. Attempts to call GetAttributeByNum on the client result in the linker complaining about a

Re: [GENERAL] losing my large objects with Postgresql 8.1.4

thank you Tom! that did the trick! I'm still in the dark why my test data type didn't exhibit the problem, but I'm certainly a much happier camper now. Eric. At 05:40 PM 05/01/2007, Tom Lane wrote: Eric Davies <[EMAIL PROTECTED]> writes: > Some of my custom server f

[GENERAL] losing my large objects with Postgresql 8.1.4 and 8.1.5

e this type of behavior? Thank you, ****** Eric Davies, M.Sc. Barrodale Computing Services Ltd. Tel: (250) 472-4372 Fax: (250) 472-4373 Web: http://www.barrodale.com Email: [EMAIL PROTECTED] ** Mailing Address: P.O. Box 3075 STN CSC V

[GENERAL] trying to write a many-to-many type function.

ion of the type I'm trying to write even possible in PostgreSQL? ** Eric Davies, M.Sc. Barrodale Computing Services Ltd. Tel: (250) 472-4372 Fax: (250) 472-4373 Web: http://www.barrodale.com Email: [EMAIL PROTECTED]

[GENERAL] Transaction safety and large objects. Possible?

n a transaction safe manner? Thank you Eric. ****** Eric Davies, M.Sc. Barrodale Computing Services Ltd. Tel: (250) 472-4372 Fax: (250) 472-4373 Web: http://www.barrodale.com Email: [EMAIL PROTECTED] ** Mailin

[GENERAL] bigger blob rows?

32K,  our speed problems might diminish correspondingly. Is there a compile time constant or a run time configuration entry that accomplish this? Thank you. ** Eric Davies, M.Sc. Barrodale Computing Services Ltd. Tel: (250) 472-4372 Fax: (250) 472-4373

[GENERAL] link errors building extensions for Postgres on Windows using MinGW

tructures presumably. My link line looks like: gcc -u_etext -shared -fpic  -Wl,--whole-archive -o destDir/Grid.dll -Lmylibdir -L/lib -L/c/Program\ Files/PostgreSQL/8.0/lib -lmylibs -Wl,--no-whole-archive  -lpostgres -lwsock32 -lm 2> link.errs can anyone suggest a solution? Thank you, *

[GENERAL] hooks for supporting third party blobs?

ld be done (and to when). Is anyone aware of any hooks to support schemes such as ours, or has solved a similar problem? Thank you.   ****** Eric Davies, M.Sc. Barrodale Computing Services Ltd. Tel: (250) 472-4372 Fax: (250) 472-4373 Web:

[GENERAL] gist index build produces corrupt result on first access to table.

ength parameter, and it uses a very different parameter passing mechanism. In the short term, we can work around the issue, but it would be nice to be able to fix the problem. Any ideas are welcome. Thank you. Eric. ** Eric Davies, M.Sc. Barrodale Co