Hi folks,
Does anybody know if it is possible to create a PL which sends an http GET
request and retrieves its response ?
I am willing to use a REST service from within pgsql.
Maybe I am just trying to do an impossible.
Any hints ?
warm regards,
Ricardo
Will do that then
Thanks Guillaume
2010/11/12 Guillaume Lelarge :
> Le 12/11/2010 18:37, Ricardo Bayley a écrit :
>> Hi,
>>
>> I am wondering if there is a way to identify which columns have been
>> modified. Is there some sort of TG_TABLE_NAME, which states the
>
Hi,
I am wondering if there is a way to identify which columns have been
modified. Is there some sort of TG_TABLE_NAME, which states the
modified columns ?
Or should we check this ourselves doing something like OLD.columnA !=
NEW.columnA ?
Regards
Ricardo
--
Sent via pgsql-admin mailing lis
PM, Tom Lane wrote:
> Ricardo Bayley writes:
> > I do this with triggers. This issue I have is that the tableoid data
> cannot
> > be used with the NEW keyword. I always get value 0 instead of the actual
> > tableoid.
>
> That might work in an AFTER trigger, but
By the way,
Another option to do this, is to do some table Inheritance. So Full Text
Search is perform on each table.
So which scenario is better ? Triggers which insert data into a third table,
or Inheritance ?
Thanks in advanced !
Ricardo.
On Fri, Aug 13, 2010 at 6:08 PM, Ricardo Bayley
Hi Fellows,
I have a bunch of tables which I need to perform a Full Text Search.
The approach I am using is to insert into another table (the searcheable
table): tsvector information, tableOID and the record Id
I do this with triggers. This issue I have is that the tableoid data cannot
be used w
Hi Fellows,
I have a table with 55 columns or so, plus one extra column of datatype
geometry, I am using PostGIS.
I intend to split my table into 3 tables. So each may have 25 to 30 columns
each.
I've created a View which relates all 3 tables with their pk and fk
accordingly. This VIEW has a RUL
