Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > Is the function you show here: > > http://pastie.org/10366558 > > the actual function you are using in the trigger? > > If so, there is no mechanism for getting the location coordinates into > the table, if that is what you want. > this is the function and there is a trigger which gets the coordinates into the table. It works perfectly when postgres is able to make a connection and get the data. But this is exactly what works only rarely... And I dont know the reason... PS: this is the trigger, but as I said, it works if there is a connection... http://pastie.org/10368578 -- :: Igor Sosa Mayor :: joseleopoldo1792@xxxxxxxxx :: :: GnuPG: 0x1C1E2890 :: http://www.gnupg.org/ :: :: jabberid: rogorido :: :: -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
