Re: adding new field - Mailing list pgsql-hackers

hey,
let me clarify something.....

1. Whenever you run a query, its result or some other thing gets cached. I want to flush this cache? Also let me know when this cache gets flushed automatically.

2. After adding a new field in Resdom structure and making necessary changes in outfuncs.c, createfuncs. etc files, I *sometimes* get garbage value for the field added. The field is initialiazed to zero in makefuns.c....

3. **IMP*** Is there something in postgres that, only for N number of fields, of a structure, the memory is allocated, i.e., do I need to modify this "N" somewhere to reflect the addtion of a new field.

And that *weird* thing is:

1. I run some query, didn't get results.
2. Then, I commented the part which I modified [ i.e., commented that new field in Resdom structure], again run the same query, got results.
3. Next, I uncommented that part, and ran the same query again. I GOT THE RESULTS.

That's how my prog is behaving, behaving in a *weird* way. It seems like some memory probs somewhere. I can't figure it out. Yes, I'm re-compiling and running initdb whenever I make some modifications in the code.

I'm using release 8.03 and due to some reasons can't shift to some other release.

Regds,
Ranbeer