Re: [SQL] how to know when a table is altered

2000-06-07 Thread Ed Loehr
Vincenzo Passoli wrote: > > 3.SQL does't have a TRIGGER on this 'event' (CREATE TRIGGER mytrig ON > mytable FOR ALTER AS ...). Can be Added ? I don't know. Maybe someone else does (though I think pgsql-sql is very low volume...pgsql-general would get a lot more readers). > 4.May be beautiful

RE: Re: [SQL] how to know when a table is altered

2000-06-07 Thread Vincenzo Passoli
he } -->use the cache Probably this solution must be used when is logical to be used. bye, valter >From: Ed Loehr <[EMAIL PROTECTED]> >To: Vincenzo Passoli <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: Re: [SQL] how to know when a table is altered >Date: Wed, 07 J

Re: [SQL] how to know when a table is altered

2000-06-07 Thread Ed Loehr
Ed Loehr wrote: > > Vincenzo Passoli wrote: > > > > i'm developing a framework (mod_perl+apache) that reads the db-schema and > > explode html forms. > > > > now i read the schema and cache it into perl-hashes to speedup things. > > > > my problem is to recognise when a table is altered so that t

Re: [SQL] how to know when a table is altered

2000-06-07 Thread Ed Loehr
Vincenzo Passoli wrote: > > i'm developing a framework (mod_perl+apache) that reads the db-schema and > explode html forms. > > now i read the schema and cache it into perl-hashes to speedup things. > > my problem is to recognise when a table is altered so that the framework can > update the re

[SQL] how to know when a table is altered

2000-06-07 Thread Vincenzo Passoli
i'm developing a framework (mod_perl+apache) that reads the db-schema and explode html forms. now i read the schema and cache it into perl-hashes to speedup things. my problem is to recognise when a table is altered so that the framework can update the related forms connected to the db tables.