Thread: close connection

close connection

From
"Dominique Bessette - Halsema"
Date:
is there a way to close the connection in postgres after i insert something?

Re: close connection

From
Bill Moran
Date:
"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

Re: close connection

From
"Dominique Bessette - Halsema"
Date:
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

Re: close connection

From
Erik Jones
Date:
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




close connection

From
"Dominique Bessette - Halsema"
Date:


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




Re: close connection

From
"Dominique Bessette - Halsema"
Date:
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


Re: close connection

From
"Douglas McNaught"
Date:
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