On Wed, Nov 01, 2006 at 08:49:48AM -0400, luis garcia wrote:
> Hi We have been making some modifications to postgres catalog, but
> it seems to be a problem with one of the fields we just added, exactly
> in the time when inserting the right values to that specific field.
Well, it's a bit hard to tell since you don't tell what changes you
actually made to the catalog. Did you remember to update the length to
the catalog entry and update the struct and all those details?
In particular:
> template1=# SELECT relname, relhasfrequency, relfrequencytype, relfrequency
> FROM pg_class WHERE relhasfrequency=true;
>
> relname | relhasfrequency | relfrequencytype | relfrequency
> - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - -
> - - - - - -
> test | t | REAL TIME | 0
> (1 row)
What's the type of "relfrequency" actually?
Much more info needed...
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.