[HACKERS] what is necessary for filling SysCache?

2008-11-26 Thread Pavel Stehule
Hello I added two new columns to pg_proc. I have a problem because access via SearchSysCache doesn't work /* Search syscache by name only */ catlist = SearchSysCacheList(PROCNAMEARGSNSP, 1, CStringGetDatum(funcname),

Re: [HACKERS] what is necessary for filling SysCache?

2008-11-26 Thread Tom Lane
Pavel Stehule [EMAIL PROTECTED] writes: I added two new columns to pg_proc. I have a problem because access via SearchSysCache doesn't work Well, you blew the catalog modifications somewhere, but since you haven't shown us what you did it's hard to guess where. You might want to pull the diffs

Re: [HACKERS] what is necessary for filling SysCache?

2008-11-26 Thread Pavel Stehule
some more info: CATALOG(pg_proc,1255) BKI_BOOTSTRAP { NameDataproname;/* procedure name */ Oid pronamespace; /* OID of namespace containing this proc */ Oid proowner; /* procedure owner */

Re: [HACKERS] what is necessary for filling SysCache?

2008-11-26 Thread Dimitri Fontaine
Hi, Le mercredi 26 novembre 2008, Tom Lane a écrit : You might want to pull the diffs for some past pg_proc addition from CVS and go over the changes. This one is a good minimal example: http://archives.postgresql.org/pgsql-committers/2005-03/msg00433.php The following link should help the

Re: [HACKERS] what is necessary for filling SysCache?

2008-11-26 Thread Tom Lane
Pavel Stehule [EMAIL PROTECTED] writes: some more info: /* VARIABLE LENGTH FIELDS: */ oidvector proargtypes;/* parameter types (excludes OUT params) */ Oid proallargtypes[1]; /* all param types (NULL if IN o char

Re: [HACKERS] what is necessary for filling SysCache?

2008-11-26 Thread Pavel Stehule
2008/11/26 Tom Lane [EMAIL PROTECTED]: Pavel Stehule [EMAIL PROTECTED] writes: some more info: /* VARIABLE LENGTH FIELDS: */ oidvector proargtypes;/* parameter types (excludes OUT params) */ Oid proallargtypes[1]; /* all