Re: [HACKERS] Storing a query plan...

2004-08-31 Thread Joshua D. Drake
Hello, If you are a newbie :) I would suggest taking a slightly simpler approach by using prepared queries. Prepared queries will give you the stored plan, albeit per connection. E.g: PREPARE FOO AS SELECT EXECUTE FOO; Sincerely, Joshua D. Drake Katsaros Kwn/nos wrote: Hi! I'm new to Postgr

[HACKERS] Storing a query plan...

2004-08-31 Thread Katsaros Kwn/nos
Hi! I'm new to PostgreSQL (and C) and what I'm trying to do is to store a query plan on disc (in a binary file). My approach is to use SPI functions to get the query plan and then transform it into a 'storable' format (Replacing the pointers with actual values). Is there any other way to do this?