Thread: close connection
is there a way to close the connection in postgres after i insert something?
"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?
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> |
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®
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 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> |
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