Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Gavin Sherry
On Mon, 30 Jul 2001, mlw wrote: > Bruce Momjian wrote: > > > > > > I would find it very helpful to see a table of what sorts of XML > > > > functionality each major vendor supports. > > > > > > Actually I was thinking of databases of data, not database systems. > > > > I think we can go two way

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread mlw
Bruce Momjian wrote: > > > > I would find it very helpful to see a table of what sorts of XML > > > functionality each major vendor supports. > > > > Actually I was thinking of databases of data, not database systems. > > I think we can go two ways. Allow COPY/pg_dump to read/write XML, or > wr

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Bruce Momjian
> I have been fighting, for a while now, with idiot data vendors that think XML > is a cure all. The problem is that XML is a hierarchical format where as SQL is > a relational format. > > It would be good to get pg_dump to write an XML file and DTD, but getting > external sources of XML into Pos

Re: [HACKERS] PostgreSQL7.1 on AIX5L is running with too poor ferformance

2001-07-29 Thread Tom Lane
"Leslie" <[EMAIL PROTECTED]> writes: > PostgreSQL7.1 is now running on AIX5L( S85, 6GB memory, 6CPU), which was > running on Linux before(Pentium3, 2CPU, as far as I > remember...sorry..). > The performance( on AIX5L ) is just half as good as the one( on Linux ). Hmm ... is the AIX compil

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Bruce Momjian
> > I would find it very helpful to see a table of what sorts of XML > > functionality each major vendor supports. > > Actually I was thinking of databases of data, not database systems. I think we can go two ways. Allow COPY/pg_dump to read/write XML, or write some perl scripts to convert XML

Re: [HACKERS] Re: Re: Storing XML in PostgreSQL

2001-07-29 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. > I've packaged up what I've done so far and you can find it at > http://www.cabbage.uklinux.net/pgxml.tar.gz > > The TODO f

Re: [HACKERS] OU8...

2001-07-29 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. > Skip the patch for configure.in in that last one, use this in it's > place (I missed one sysv5uw). > > > > -- > Larry

Re: [HACKERS] Re: Re: Re: Storing XML in PostgreSQL

2001-07-29 Thread Bruce Momjian
> In article <9jrn78$pbv$[EMAIL PROTECTED]>, "Colin 't Hart" <[EMAIL PROTECTED]> > wrote: > >> Should we add this to /contrib? > > > > I think so, at least until we get something better. > > > > I'm happy for you to add it, if you're willing to have it (It is meant to > be under the PostgreSQL

Re: [HACKERS] From TODO, XML?

2001-07-29 Thread Bruce Momjian
> I was looking over the todo list and saw that someone wanted to support XML. I > have some quick and dirty stuff that could be used. > > OK, what should the feature look like? > > Should it be grafted onto pg_dump or should a new utility pg_xml be created? > > How strict should it be? A stric

Re: [HACKERS] LIBPQ on Windows and large Queries

2001-07-29 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > Well haven't this problem solved already ? I'm not sure. Steve, have you tried current sources? regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe comman

Re: [HACKERS] LIBPQ on Windows and large Queries

2001-07-29 Thread Hiroshi Inoue
Tom Lane wrote: > > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > Yes it's real. > > Error handling seems the cause. > > Hmm, are you working with CVS tip or 7.1.* sources? I'm wondering > how this interacts with the recent patch to #define errno as > WSAGetLastError() on WIN32... > Oops sorry

Re: [HACKERS] LIBPQ on Windows and large Queries

2001-07-29 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > Yes it's real. > Error handling seems the cause. Hmm, are you working with CVS tip or 7.1.* sources? I'm wondering how this interacts with the recent patch to #define errno as WSAGetLastError() on WIN32... regards, tom lane --

[HACKERS] Re: From TODO, XML?

2001-07-29 Thread mlw
"Ross J. Reedstrom" wrote: > > On Sun, Jul 29, 2001 at 12:19:48PM -0400, mlw wrote: > > > > > > Bill > > Programmer > > > > 1290 > > > > Canton Ave > > > > > > > > Milton > > > > > > > > > > The above is almost impossible to conver

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Ross J. Reedstrom
On Sun, Jul 29, 2001 at 12:19:48PM -0400, mlw wrote: > > > Bill > Programmer > > 1290 > > Canton Ave > > > > Milton > > > > > The above is almost impossible to convert to a relational format without > additional information

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread mlw
Ken Hirsch wrote: > > mlw <[EMAIL PROTECTED]> wrote: > > > "Frank Ch. Eigler" wrote: > > > : So a parser that can scan a DTD and make a usable create table (...) > > > : line would be very helpful. [...] > > > > > > Hmm, but hierarchically structured documents such as XML don't map > > > well to

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Ken Hirsch
mlw <[EMAIL PROTECTED]> wrote: > "Frank Ch. Eigler" wrote: > > : So a parser that can scan a DTD and make a usable create table (...) > > : line would be very helpful. [...] > > > > Hmm, but hierarchically structured documents such as XML don't map > > well to a relational model. The former ten