close connection
"Dominique Bessette - Halsema" <dbhalsema@gmail.com> wrote:
is there a way to close the connection in postgres after i insert something?
The short answer is "yes".
In order to provide a more detailed answer, I suspect you're going to have
to provide a little more context ... are you writing a C application, or
using the psql program or something else?
--
Bill Moran
http://www.potentialtech.com
I'm http posting postgres from my wfs. in otherwords i'm postgres is my
datastore and i'm posting xml to it. so do you know how to close it in xml?
Show quoted text
On 1/24/08, Bill Moran <wmoran@potentialtech.com> wrote:
"Dominique Bessette - Halsema" <dbhalsema@gmail.com> wrote:
is there a way to close the connection in postgres after i insert
something?
The short answer is "yes".
In order to provide a more detailed answer, I suspect you're going to have
to provide a little more context ... are you writing a C application, or
using the psql program or something else?--
Bill Moran
http://www.potentialtech.com
On Jan 24, 2008, at 3:47 PM, Dominique Bessette - Halsema wrote:
is there a way to close the connection in postgres after i insert
something?
Of course. Exactly how will be dependent on what you're using to
access the db (language/framework-wise).
Erik Jones
DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
I dont really understand the question but here's an xml example of what is
getting posted to postgres, and i'm trying to figure out how to do a
connection.close() type of thing in it.
<wfs:Transaction service="WFS" version="1.0.0" xsi:schemaLocation="
http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd
http://www.opengeospatial.net/cite
http://<host>:<port>/geoserver/wfs/DescribeFeatureType?typename=cite:tracks,cite:alias
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cite="
http://www.opengeospatial.net/cite" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:wfs="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml
"> <wfs:Delete typeName="cite:tracks"> <ogc:Filter> <
ogc:PropertyIsEqualTo> <ogc:PropertyName>guid</ogc:PropertyName> <
ogc:Literal>TEST11108</ogc:Literal> </ogc:PropertyIsEqualTo> </
ogc:Filter> </wfs:Delete> </wfs:Transaction>
Show quoted text
On 1/24/08, Erik Jones <erik@myemma.com> wrote:
On Jan 24, 2008, at 3:47 PM, Dominique Bessette - Halsema wrote:
is there a way to close the connection in postgres after i insert
something?Of course. Exactly how will be dependent on what you're using to
access the db (language/framework-wise).Erik Jones
DBA | Emma(R)
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
Import Notes
Reply to msg id not found: b713ca6c0801250836o2d02e724y92bd41016a059af1@mail.gmail.com
i forgot to add on the xml code
<wfs:Transaction service="WFS" version="1.0.0" xsi:schemaLocation="
http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd
http://www.opengeospatial.net/cite
http://<host>:<port>/geoserver/wfs/DescribeFeatureType?typename=cite:tracks,cite:alias
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cite="
http://www.opengeospatial.net/cite" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:wfs="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml
"> <wfs:Delete typeName="cite:tracks"> <ogc:Filter> <
ogc:PropertyIsEqualTo> <ogc:PropertyName>guid</ogc:PropertyName> <
ogc:Literal>TEST11108</ogc:Literal> </ogc:PropertyIsEqualTo> </
ogc:Filter> </wfs:Delete> </wfs:Transaction>
Show quoted text
On 1/24/08, Dominique Bessette - Halsema <dbhalsema@gmail.com> wrote:
I'm http posting postgres from my wfs. in otherwords i'm postgres is my
datastore and i'm posting xml to it. so do you know how to close it in xml?On 1/24/08, Bill Moran <wmoran@potentialtech.com> wrote:
"Dominique Bessette - Halsema" <dbhalsema@gmail.com> wrote:
is there a way to close the connection in postgres after i insert
something?
The short answer is "yes".
In order to provide a more detailed answer, I suspect you're going to
have
to provide a little more context ... are you writing a C application, or
using the psql program or something else?--
Bill Moran
http://www.potentialtech.com
On 1/28/08, Dominique Bessette - Halsema <dbhalsema@gmail.com> wrote:
I dont really understand the question but here's an xml example of what is
getting posted to postgres, and i'm trying to figure out how to do a
connection.close() type of thing in it.
Postgres doesn't have a built-in webserver, so you are obviously going
through some kind of webserver/appserver to do the HTTP post. Figure out
how to tell that server to close the connection.
-Doug