Thread: XML

XML

From
Sean
Date:
If I wanted to store the below XML in a text field, would I be able to
insert additional attributes, and/or be able to substitute the id of the
inner g tag when querying it from the database.  For example:

From:
<g id="myGtag>
    <g id="myGtag2">
    <\g>
<\g>

To:
<g id="myGtag>
    <g id="Button1a" onClick="click1();" >
    <\g>
<\g>

Thanks.

Sean.


Re: Hosting

From
Sean
Date:
Has anyone used both www.Hub.Org and www.pgHoster?  If so, which one did
you like better?  Thanks.

Sean


Re: Hosting

From
Date:
i use http://2wdhost.com/ and have had a good
experience.

they don't use the latest versions of postgresql,
though.  they use pgsql 7.3.4, php 4.3.10 and apache
1.3.33 running on redhat.

the price is right, too.

--- Sean <scene@themountainscene.com> wrote:

> Has anyone used both www.Hub.Org and www.pgHoster?
> If so, which one did
> you like better?  Thanks.
>
> Sean
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please
> send an appropriate
>        subscribe-nomail command to
> majordomo@postgresql.org so that your
>        message can get through to the mailing list
> cleanly
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Hosting

From
"Derrick Betts"
Date:
I've used pgHoster before and wasn't all that thrilled.  Currently we use
A2Hosting.com and have been extremely satisfied.

Derrick
----- Original Message -----
From: "Sean" <scene@themountainscene.com>
To: <pgsql-novice@postgresql.org>
Sent: Tuesday, July 19, 2005 1:25 PM
Subject: Re: [NOVICE] Hosting


> Has anyone used both www.Hub.Org and www.pgHoster?  If so, which one did
> you like better?  Thanks.
>
> Sean
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>


Re: Hosting

From
Tom Lane
Date:
<operationsengineer1@yahoo.com> writes:
> i use http://2wdhost.com/ and have had a good
> experience.

> they don't use the latest versions of postgresql,
> though.  they use pgsql 7.3.4, php 4.3.10 and apache
> 1.3.33 running on redhat.

7.3.4 is two years old next week, and there are several *critical* bugs
fixed in the later 7.3.x releases.  If they're still on 7.3.4, I'd take
that as conclusive proof that they're either incompetent or don't give
a damn about their PG-using customers.  See
http://developer.postgresql.org/docs/postgres/release-7-3-10.html
and following pages.

            regards, tom lane

Re: Hosting

From
"Marc G. Fournier"
Date:

As we have clients that require it, we offer our clients access to 7.2,
7.4 and 8.0, as well as dedicated DB servers ...

On Tue, 19 Jul 2005, Tom Lane wrote:

> <operationsengineer1@yahoo.com> writes:
>> i use http://2wdhost.com/ and have had a good
>> experience.
>
>> they don't use the latest versions of postgresql,
>> though.  they use pgsql 7.3.4, php 4.3.10 and apache
>> 1.3.33 running on redhat.
>
> 7.3.4 is two years old next week, and there are several *critical* bugs
> fixed in the later 7.3.x releases.  If they're still on 7.3.4, I'd take
> that as conclusive proof that they're either incompetent or don't give
> a damn about their PG-using customers.  See
> http://developer.postgresql.org/docs/postgres/release-7-3-10.html
> and following pages.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: Hosting

From
Date:
Tom,

when i brought this up before they said it was
cpanel's fault (they use cpanel to administer
everything) b/c cpanel didn't support higher versions.
 i'll follow up again and see what cpanel is up to.

while not close to perfect, it is a cheap setup for
learning the craft.

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> <operationsengineer1@yahoo.com> writes:
> > i use http://2wdhost.com/ and have had a good
> > experience.
>
> > they don't use the latest versions of postgresql,
> > though.  they use pgsql 7.3.4, php 4.3.10 and
> apache
> > 1.3.33 running on redhat.
>
> 7.3.4 is two years old next week, and there are
> several *critical* bugs
> fixed in the later 7.3.x releases.  If they're still
> on 7.3.4, I'd take
> that as conclusive proof that they're either
> incompetent or don't give
> a damn about their PG-using customers.  See
>
http://developer.postgresql.org/docs/postgres/release-7-3-10.html
> and following pages.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please
> send an appropriate
>        subscribe-nomail command to
> majordomo@postgresql.org so that your
>        message can get through to the mailing list
> cleanly
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Hosting

From
John DeSoi
Date:
On Jul 19, 2005, at 3:56 PM, Derrick Betts wrote:

> Currently we use A2Hosting.com and have been extremely satisfied.

I'm using them also. Performance and service has been very good.

They just upgraded to PostgreSQL 8 fairly recently, so just be sure
to tell them you need this version since it is not available on all
of their hardware.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


Re: Hosting

From
Date:
Derrick,

i took a look at A2Hosting.com and noticed they offer
cpanel.  can you access pgsql 8.0 through cpanel?

tia...

--- Derrick Betts <derrick@grifflink.com> wrote:

> I've used pgHoster before and wasn't all that
> thrilled.  Currently we use
> A2Hosting.com and have been extremely satisfied.
>
> Derrick
> ----- Original Message -----
> From: "Sean" <scene@themountainscene.com>
> To: <pgsql-novice@postgresql.org>
> Sent: Tuesday, July 19, 2005 1:25 PM
> Subject: Re: [NOVICE] Hosting
>
>
> > Has anyone used both www.Hub.Org and www.pgHoster?
>  If so, which one did
> > you like better?  Thanks.
> >
> > Sean
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please
> send an appropriate
> >       subscribe-nomail command to
> majordomo@postgresql.org so that your
> >       message can get through to the mailing list
> cleanly
> >
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>




____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs


Re: Hosting

From
"Derrick Betts"
Date:
I actually use pgAdmin to access my DB.  I've never used cPanel for that.
Occasionally, I will implement a MySQL database while testing a piece of
software though php, and I use cPanel for that.  If I like the software, I
usually re-write the php code to access my postgres DB, and drop the mySQL
DB in cPanel.

I would highly recommend using something like pgAdmin for administering your
DB though.  I much prefer using that than a web interface.  If you can get
access from your machine through pgAdmin, then I would suggest this route.
A2Hosting can help you set up a secure channel to use when connecting from
pgAdmin to your database on their system. (That's what they did for me,
however, I'm the only admin.)

Derrick

----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: "Derrick Betts" <derrick@grifflink.com>; <pgsql-novice@postgresql.org>
Sent: Sunday, July 24, 2005 11:02 PM
Subject: Re: [NOVICE] Hosting


> Derrick,
>
> i took a look at A2Hosting.com and noticed they offer
> cpanel.  can you access pgsql 8.0 through cpanel?
>
> tia...
>
> --- Derrick Betts <derrick@grifflink.com> wrote:
>
>> I've used pgHoster before and wasn't all that
>> thrilled.  Currently we use
>> A2Hosting.com and have been extremely satisfied.
>>
>> Derrick
>> ----- Original Message -----
>> From: "Sean" <scene@themountainscene.com>
>> To: <pgsql-novice@postgresql.org>
>> Sent: Tuesday, July 19, 2005 1:25 PM
>> Subject: Re: [NOVICE] Hosting
>>
>>
>> > Has anyone used both www.Hub.Org and www.pgHoster?
>>  If so, which one did
>> > you like better?  Thanks.
>> >
>> > Sean
>> >
>> >
>> > ---------------------------(end of
>> broadcast)---------------------------
>> > TIP 1: if posting/reading through Usenet, please
>> send an appropriate
>> >       subscribe-nomail command to
>> majordomo@postgresql.org so that your
>> >       message can get through to the mailing list
>> cleanly
>> >
>> >
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map
>> settings
>>
>
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
>


Re: Hosting

From
John DeSoi
Date:
On Jul 25, 2005, at 1:18 AM, Derrick Betts wrote:

> I would highly recommend using something like pgAdmin for
> administering your DB though.  I much prefer using that than a web
> interface.  If you can get access from your machine through
> pgAdmin, then I would suggest this route. A2Hosting can help you
> set up a secure channel to use when connecting from pgAdmin to your
> database on their system. (That's what they did for me, however,
> I'm the only admin.)

Did have to have a fixed IP address to set this up? By secure you
mean SSL?

Thanks,



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL