Re: [HACKERS] LIBPQ on Windows and large Queries

2001-07-26 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: > Is anybody trying to solve the 8191 bytes query limit from libpq > windows port ??? I think it's *your* responsibility, at least to identify what's going on. This is an open source project, and that means you can and should fix problems that aff

Re: [HACKERS] Failed compile PostgreSQL 7.1.2 on AIX 5.1

2001-07-26 Thread Dominic J. Eidson
On Thu, 26 Jul 2001, BigWhat.com wrote: > I am attempting to compile PostgreSQL 7.1.2 on an IBM B50 running AIX 5.1. I'm jealous. I saw a rack full of B50's and fell in love.. ;-) [Snip] > gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations > access/SUBSYS > .o bootstrap/SUBSYS.o c

[HACKERS] pltcl - lastoid

2001-07-26 Thread bob
I noticed that pltcl didn't have any way to get to SPI_lastoid like plpgsql does.. I started using pltcl a lot because I like to decide when and how my queries get planned.. so I put one together really quick Sorry I don't have the original around to make a quick diff, but its a very small cha

Re: [HACKERS] Bad timestamp external representation

2001-07-26 Thread Philip Warner
At 15:13 26/07/01 -0700, Nathan Myers wrote: >Should pg_dump be lossy? No it shouldn't, but it already is because it uses decimal text reps of everything; we lose data when dumping floats as well. In the latter case we should dump the hex text reps to get the full bit width. Something similar is

Re: [HACKERS] Bad timestamp external representation

2001-07-26 Thread Bruce Momjian
> > > It is not a bug, in general, to generate or accept times like > > > 09:01:60. Leap seconds are inserted as the 60th second of a minute. > > > ANSI C defines the range of struct member tm.tm_sec as "seconds > > > after the minute [0-61]", inclusive, and strftime format %S as "the > > > second

[HACKERS] Failed compile PostgreSQL 7.1.2 on AIX 5.1

2001-07-26 Thread BigWhat.com
I am attempting to compile PostgreSQL 7.1.2 on an IBM B50 running AIX 5.1. Running configure works fine but when I go to the next step and run gmake dies with the following error. If someone could point me in the direction of what exactly is causing the error I would appreciate it greatly. gmak

Re: [HACKERS] Bad timestamp external representation

2001-07-26 Thread Nathan Myers
On Thu, Jul 26, 2001 at 05:38:23PM -0400, Bruce Momjian wrote: > Nathan Myers wrote: > > Bruce wrote: > > > > > > I can confirm that current CVS sources have the same bug. > > > > > > > It's a bug in timestamp output. > > > > > > > > # select '2001-07-24 15:55:59.999'::timestamp; > > > >

Re: [HACKERS] Release of 7.2

2001-07-26 Thread Bruce Momjian
See the TODO list with dashes. > What's new in 7.2? URL? > > -- > Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just > ^/ /(_)_ __ _ ___ __ selective about who its friends are > / / | | '_ \| | | \ \/ / Debian Certified Linux Developer > _ ///

Re: [HACKERS] Bad timestamp external representation

2001-07-26 Thread Bruce Momjian
> On Wed, Jul 25, 2001 at 06:53:21PM -0400, Bruce Momjian wrote: > > > > I can confirm that current CVS sources have the same bug. > > > > > It's a bug in timestamp output. > > > > > > # select '2001-07-24 15:55:59.999'::timestamp; > > > ?column? > > > ---

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

2001-07-26 Thread Bruce Momjian
Should we add this to /contrib? > 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 file included indicates what still remains to be done (a lot!). > > In particular, it would be good to implement more of the XPath grammar.

[HACKERS] RE: LIBPQ on Windows and large Queries

2001-07-26 Thread Joel Burton
On Thu, 26 Jul 2001, Khoa Do wrote: > I'm surprised you are even able to run postgres in windows. I > didn't even know postgres supported windows. Could you kindly point me to > instructions on how to run it and build the postgres souce on windows? If > nobody will try to fix it, then ma

RE: [HACKERS] LIBPQ on Windows and large Queries

2001-07-26 Thread Khoa Do
I'm surprised you are even able to run postgres in windows. I didn't even know postgres supported windows. Could you kindly point me to instructions on how to run it and build the postgres souce on windows? If nobody will try to fix it, then maybe we should just try it ourseleves and po

Re: [HACKERS]

2001-07-26 Thread Patrick Welche
On Thu, Jul 26, 2001 at 04:55:14PM +0700, Zudi Iswanto wrote: > I am developing application with c++ ... > /tmp/ccy63XDd.o(.text+0x70): undefined reference to `PQsetdbLogin' > /tmp/ccy63XDd.o(.text+0x91): undefined reference to `PQstatus' > /tmp/ccy63XDd.o(.text+0xc4): undefined reference to `PQe

[HACKERS] Re: Re: Storing XML in PostgreSQL

2001-07-26 Thread John Gray
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 file included indicates what still remains to be done (a lot!). In particular, it would be good to implement more of the XPath grammar. However, once we get into the realm of more c

Re: [HACKERS] Can Postgres handle 2-phase commits ?

2001-07-26 Thread Keith G. Murphy
Howard Williams wrote: > > I can't seem to find any posts or docs on the subject > This was discussed quite a few months ago, and the answer was "no". ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/

[HACKERS] Re: Release of 7.2-Not released!!! Just a Question!

2001-07-26 Thread mlw
Oops!! I looked at the title and it may have been misleading. Sorry. mlw wrote: > > Just want to say I have been looking at the development version of 7.2 and I am > completely impressed. The one huge stumbling block to a 24x7 deployment, > vacuum, has been removed!! This is utterly fantastic! I

Re: [HACKERS] Release of 7.2

2001-07-26 Thread Turbo Fredriksson
What's new in 7.2? URL? -- Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just ^/ /(_)_ __ _ ___ __ selective about who its friends are / / | | '_ \| | | \ \/ / Debian Certified Linux Developer _ /// / /__| | | | | |_| |> < Turbo Fredriksson

[HACKERS] Linking a shared library against a C function

2001-07-26 Thread John Gray
In the course of developing my XML parser hooks I've been using an external XML parser (expat) which is built as a shared library. The C functions I'm writing need to access functions within that library. Is it OK just to link the .so of my backend function against the expat library? i.e. to do

[HACKERS] Release of 7.2

2001-07-26 Thread mlw
Just want to say I have been looking at the development version of 7.2 and I am completely impressed. The one huge stumbling block to a 24x7 deployment, vacuum, has been removed!! This is utterly fantastic! Is there a target date for release? (sorry for asking, I know how irritating such questions

[HACKERS] plpgsql: 'SELECT * FROM tbl'

2001-07-26 Thread Turbo Fredriksson
If I do something like that, psql claims: ERROR: unexpected SELECT query in exec_stmt_execsql() why? How do I do this? -- Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just ^/ /(_)_ __ _ ___ __ selective about who its friends are / / | | '_ \| | | \

Re: [HACKERS] Re: plpgsql: Debug function?

2001-07-26 Thread Turbo Fredriksson
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: >> Is there a way to debug a PL/pgSQL function? It's behaving very >> irradic! Joel> It's crude, but you can output debugging statements w/ RAISE Joel> NOTICE or catch flawed assumptions by RAISE EXCEPTION. Tom> Also try tu

[HACKERS]

2001-07-26 Thread Zudi Iswanto
Dear all ... I have a postgres problem I am developing application with c++ to connect to postgres SQL. When I compiled my source.cc I found some error like this : /tmp/ccy63XDd.o: In function `main': /tmp/ccy63XDd.o(.text+0x70): undefined reference to `PQsetdbLogin' /tmp/ccy63XDd.o(.text+0x91)

AW: [HACKERS] Re: Slow Performance in PostgreSQL

2001-07-26 Thread Zeugswetter Andreas SB
> > There is one table, let's > > say table1, with about 11. rows. On doing a "select distinct var1 > > from table1" via ODBC-Driver, I had to wait about 15 sec for the result. 1. I assume following index exists: create index table1_x0 on table1 (var1); "select distinct" when execut