Re: [HACKERS] FE/BE protocol vs. parameterized queries

2006-09-06 Thread Michael Paesold
Tom Lane wrote: The infrastructure for the former planning method (using the first Bind's parameters as sample values for estimation, but not as constants) is still there, but it's not being used now. Does anyone want to argue for changing things to plan named statements that way? I'm of two mi

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Jan de Visser
On Thursday 07 September 2006 01:24, Marc G. Fournier wrote: > > How about adding a simple: 'touch snapshotdate' .. in the root directory? > Would that suffice? I'd say date "+[something]" > snapshotdate I betcha that people that can't remember trivial things will muck up file timestamps by copy

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Marc G. Fournier
On Wed, 6 Sep 2006, Josh Berkus wrote: Josh, Well, you could grep for the latest $PostgreSQL$ header line's commit date, but I kinda wonder why exactly you should need to do that. If you don't know when you pulled the snapshot you are testing, I submit you have a process problem you ought to

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Joshua D. Drake
Josh Berkus wrote: Tom, Well, you could grep for the latest $PostgreSQL$ header line's commit date, but I kinda wonder why exactly you should need to do that. If you don't know when you pulled the snapshot you are testing, I submit you have a process problem you ought to fix. These aren't Po

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Joshua D. Drake
Josh Berkus wrote: Josh, Well, you could grep for the latest $PostgreSQL$ header line's commit date, but I kinda wonder why exactly you should need to do that. If you don't know when you pulled the snapshot you are testing, I submit you have a process problem you ought to fix. These aren't Po

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Josh Berkus
Josh, > >> Well, you could grep for the latest $PostgreSQL$ header line's commit > >> date, but I kinda wonder why exactly you should need to do that. If you > >> don't know when you pulled the snapshot you are testing, I submit you > >> have a process problem you ought to fix. > > > > These aren

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-06 Thread Abhijit Menon-Sen
At 2006-09-07 00:16:38 -0400, [EMAIL PROTECTED] wrote: > > > - Where would the code live, if it were in core? > > - Shall I hack up the API you suggested in your earlier message? > > are we still moving forward with this? I would love to see this go in > for 8.2. I don't know about its going into

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Josh Berkus
Tom, > Well, you could grep for the latest $PostgreSQL$ header line's commit > date, but I kinda wonder why exactly you should need to do that. If you > don't know when you pulled the snapshot you are testing, I submit you > have a process problem you ought to fix. These aren't PostgreSQL test p

Re: [HACKERS] Build date for snapshots?

2006-09-06 Thread Tom Lane
Josh Berkus writes: > I'm not getting bug reports for 8.2 from inside Sun. However, I'm not sure > how I can determine from the source what build day a particular snapshot > instance is from -- sometimes these files get copied around a bit before > being built. Is there a file somewhere that

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-06 Thread Merlin Moncure
On 9/5/06, Abhijit Menon-Sen <[EMAIL PROTECTED]> wrote: At 2006-09-05 16:35:49 -0400, [EMAIL PROTECTED] wrote: > > The biggest part of the work needed is to write the documentation --- > but we'd have to do that for Abhijit's patch too, since the userlocks > docs presumably fall under GPL along w

Re: [HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > In Plauger's _The Standard C Library_ (1992) on p 335 is an excerpt > from the standard (I think). At the end of a section entitled > "7.10.1.4 The strtod function" is the following: "If the correct > value would cause underflow, zero is returned and the

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-06 Thread Christopher Browne
[EMAIL PROTECTED] (Jeff Davis) wrote: > On Wed, 2006-09-06 at 18:55 -0400, Chris Browne wrote: >> [EMAIL PROTECTED] (Jeff Davis) writes: >> >> > Do you see an advantage in using LFS for PostgreSQL? >> >> >> >> Hey guys - I think the original poster only meant to suggest that it >> >> was *interest

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Alvaro Herrera
Joshua D. Drake wrote: > Gregory Stark wrote: > >"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >>The only known resolution is to reboot Windows. Using the service > >>control panel to shutdown postgresql will fail once the message is > >>received. It is unknown if using the task master to indivi

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Joshua D. Drake
Gregory Stark wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: O.k. to recap: This message will present itself, if connection attempts are made from the Web Application (Java/JDBC), or locally via PgAdmin. Once the error message is received, all subsequent connection attempts will also res

[HACKERS] Build date for snapshots?

2006-09-06 Thread Josh Berkus
Folks, I'm not getting bug reports for 8.2 from inside Sun. However, I'm not sure how I can determine from the source what build day a particular snapshot instance is from -- sometimes these files get copied around a bit before being built. Is there a file somewhere that would carry a timesta

Re: [HACKERS] gBorg status?

2006-09-06 Thread Marc G. Fournier
On Mon, 4 Sep 2006, Dave Page wrote: My understanding is that Gborg is being recovered from backup as I type. I also understand that the delay was not caused by lack of backups or anything similarly scary, but simply by other priorities. Yes, I have the backup uploaded right now, and doing 'r

Re: [HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Abhijit Menon-Sen
At 2006-09-06 18:01:38 -0400, [EMAIL PROTECTED] wrote: > > That is, we'd log a Parse or Bind operation if it individually > exceeded the duration threshold, and not otherwise. Ok. > If we've got support for logging the statement text and the parameter > values at Execute time, isn't logging the p

Re: [HACKERS] Timezone List

2006-09-06 Thread Gavin Sherry
On Wed, 6 Sep 2006, Tom Lane wrote: > Martijn van Oosterhout writes: > > In the CVS version there is a table with this information: > > http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html > > Actually, what that view gives you is timezone offset abbreviations, not > the ful

Re: [HACKERS] Timezone List

2006-09-06 Thread Andrew - Supernews
On 2006-09-06, Tom Lane <[EMAIL PROTECTED]> wrote: > Martijn van Oosterhout writes: >> In the CVS version there is a table with this information: >> http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html > > Actually, what that view gives you is timezone offset abbreviations, n

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-06 Thread Jeff Davis
On Wed, 2006-09-06 at 18:55 -0400, Chris Browne wrote: > [EMAIL PROTECTED] (Jeff Davis) writes: > >> > Do you see an advantage in using LFS for PostgreSQL? > >> > >> Hey guys - I think the original poster only meant to suggest that it > >> was *interesting*... :-) > >> > > > > I see, my mistake.

Re: [HACKERS] Postgres tracking - the pgtrack project

2006-09-06 Thread Neil Conway
Bruce Momjian wrote: Robert Treat wrote: FWIW I have never understood why we don't require patch submitters/committers to update the release notes when they do the patch. I've suggested this more than once in the past -- I think it would be a clear improvement over the status quo. Updating th

Re: [HACKERS] New XML section for documentation

2006-09-06 Thread Bruce Momjian
I have added a modified version of this to the SGML documentation, under data types. --- bruce wrote: > Here is an new XML section for our SGML documentation. It explains the > various XML capabilities, if we support them,

Re: [HACKERS] [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`

2006-09-06 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane asked: > Superusers can access anything they want to. What's your point? > The spec says "accessible" ... Not trying to lecture you Tom :), just posting my argument here for others. Temp tables are "special" because the user does not kn

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-06 Thread Chris Browne
[EMAIL PROTECTED] (Jeff Davis) writes: > On Tue, 2006-09-05 at 23:28 -0400, [EMAIL PROTECTED] wrote: >> On Tue, Sep 05, 2006 at 05:54:50PM -0700, Jeff Davis wrote: >> > On Tue, 2006-09-05 at 18:24 -0400, Chris Browne wrote: >> > > Recently seen in ACM Operating Systems Review (this is the first tim

Re: [HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Kris Jurka
On Wed, 6 Sep 2006, Tom Lane wrote: I thought somebody had mentioned that integers were also sent in binary in the latest driver code? Can't find the archive entry right now though. Using the fastpath protocol integers and oids are sent as binary. I don't know if that is related to this

Re: [HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > On 6-Sep-06, at 6:01 PM, Tom Lane wrote: >> * It doesn't log the values of parameters sent in binary mode, which >> is something that at least JDBC needs. > AFAIK, we don't need binary mode right away, currently we only send > bytea parameters in binary

Re: [HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Bruce Momjian
Tom Lane wrote: > I happened to notice that the recently added code to log Bind-message > parameters was printing garbage into my log. On investigation it turned > out to be trying to print an already-pfree'd string. That's fixable, Uh, can you show me where? > but having looked at the code clo

Re: [HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Dave Cramer
On 6-Sep-06, at 6:17 PM, Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: On 6-Sep-06, at 6:01 PM, Tom Lane wrote: * It doesn't log the values of parameters sent in binary mode, which is something that at least JDBC needs. AFAIK, we don't need binary mode right away, currently we o

Re: [HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Michael Fuhr
On Wed, Sep 06, 2006 at 11:20:12PM +0200, Martijn van Oosterhout wrote: > Odd, according to these references: > > http://www.csse.uwa.edu.au/programming/ansic-library.html#stdlib > http://cplus.kompf.de/cliblist.html > http://docs.hp.com/en/B9106-90010/strtod.3C.html > > returning ERANGE on under

Re: [HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Dave Cramer
On 6-Sep-06, at 6:01 PM, Tom Lane wrote: I happened to notice that the recently added code to log Bind-message parameters was printing garbage into my log. On investigation it turned out to be trying to print an already-pfree'd string. That's fixable, but having looked at the code closely,

Re: [HACKERS] Timezone List

2006-09-06 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Assuming we can sneak this in even though it's feature-freeze, want me > to look for it? Yeah, please take a look --- seeing the size of the code will probably help us decide if it's too late for 8.2 or not. regards, tom lan

[HACKERS] Problems with extended-Query logging code

2006-09-06 Thread Tom Lane
I happened to notice that the recently added code to log Bind-message parameters was printing garbage into my log. On investigation it turned out to be trying to print an already-pfree'd string. That's fixable, but having looked at the code closely, I see a bunch of other stuff I'm not happy abou

UUID/GUID discussion leading to request for hexstring bytea? (was: Re: [HACKERS] TODO: GUID datatype)

2006-09-06 Thread mark
On Wed, Sep 06, 2006 at 07:49:09PM +0200, Gevik Babakhani wrote: > I would like to know if anyone is working on the GUID datatype. > If not, I am going to work on it. Please let me know. Assuming you mean GUID in the same sense as UUID, there are many non-core developers who would like to see it,

Re: [HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Martijn van Oosterhout
On Wed, Sep 06, 2006 at 09:13:34PM +0200, Stefan Kaltenbrunner wrote: > that hints that setting ERANGE on an underflow (vs an overflow) is > implementation specific though I ws unable to verify that this is indeed > the case ... Odd, according to these references: http://www.csse.uwa.edu.au/progr

Re: [HACKERS] Timezone List

2006-09-06 Thread Martijn van Oosterhout
On Thu, Sep 07, 2006 at 05:29:04AM +1000, Naz Gassiep wrote: > I am also rather baffled at the way "SAT" is changed from being > interpreted as a day of the week in one mode, and a timezone in another. Ugh. It'd be an argument if people actually used SAT as a timezone. They don't, it's ACST. Ha

Re: [HACKERS] Timezone List

2006-09-06 Thread Magnus Hagander
> > In the CVS version there is a table with this information: > > > http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames. > > html > > Actually, what that view gives you is timezone offset > abbreviations, not the full zone names that you could use > with SET TIME ZONE. It st

Re: [HACKERS] FE/BE protocol vs. parameterized queries

2006-09-06 Thread Tom Lane
I wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: >> I believe this could usefully (and transparently to clients) be changed >> so that Bind on the unnamed statement does _not_ store the plan back in >> the unnamed statement's context, but instead produces a plan which is >> only used _for

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Gregory Stark
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > O.k. to recap: > > This message will present itself, if connection attempts are made from the Web > Application (Java/JDBC), or locally via PgAdmin. Once the error message is > received, all subsequent connection attempts will also result in that sam

Re: [HACKERS] [PATCHES] BUG #2600: dblink compile with SSL missing libraries

2006-09-06 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > I still need the following, on AIX: > -SHLIB_LINK = $(libpq) > +SHLIB_LINK = $(libpq) $(LIBS) No you don't --- see recent warthog complaint. We have to filter LIBS down to just the minimum. regards, tom lane ---

Re: [HACKERS] Timezone List

2006-09-06 Thread Naz Gassiep
I don't know about anyone else, but the whole australian_timezones thing seems like an ugly hackaround to me. You really shouldn't be pontificating about this if you haven't been paying attention to recent development work ;-) regards, tom lane Aah, sorry, I don

Re: [HACKERS] Timezone List

2006-09-06 Thread Tom Lane
Naz Gassiep <[EMAIL PROTECTED]> writes: > I don't know about anyone else, but the whole australian_timezones thing > seems like an ugly hackaround to me. You really shouldn't be pontificating about this if you haven't been paying attention to recent development work ;-) r

Re: [HACKERS] Timezone List

2006-09-06 Thread Naz Gassiep
Actually, what that view gives you is timezone offset abbreviations, not the full zone names that you could use with SET TIME ZONE. It strikes me that we should have a view for that as well. We could use code similar to scan_available_timezones() to generate the view output. It's somewhat urg

Re: [HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Stefan Kaltenbrunner
Michael Meskes wrote: > It seems ECPG regression tests trigger a bug in OpenBSD libc. Please try > the attached test case. I should give ERANGE as error, but on OpenBSD > errno is set to 0. > > I tried this test case on Linux, where it works, and OpenBSD 3.8 and 4.0 > (that is HEAD). On both these

Re: [HACKERS] Timezone List

2006-09-06 Thread Tom Lane
Martijn van Oosterhout writes: > In the CVS version there is a table with this information: > http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html Actually, what that view gives you is timezone offset abbreviations, not the full zone names that you could use with SET TIME ZO

Re: [HACKERS] Timezone List

2006-09-06 Thread Tom Lane
Naz Gassiep <[EMAIL PROTECTED]> writes: > Martijn van Oosterhout wrote: >> Err, where does postgres use this information? I beleive there is a >> project on pgfoundary that has some standard datasets. >> > Currently, it is stored in /src/timezone/data/iso3166.tab and I propose > to have it availa

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Michael Paesold
Tom Lane wrote: Peter Eisentraut <[EMAIL PROTECTED]> writes: Am Dienstag, 5. September 2006 05:58 schrieb Tom Lane: A couple of recently discussed FE/BE protocol issues are: not storing a plan at all for unnamed-statement cases, and thus allowing bind parameters to be treated as constants; allo

Re: [HACKERS] Timezone List

2006-09-06 Thread Naz Gassiep
Martijn van Oosterhout wrote: In the CVS version there is a table with this information: http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html Great, thanks for that Err, where does postgres use this information? I beleive there is a project on pgfoundary that has som

Re: [HACKERS] Timezone List

2006-09-06 Thread Martijn van Oosterhout
On Thu, Sep 07, 2006 at 04:07:58AM +1000, Naz Gassiep wrote: > Any chance for a DB Client accessible list of allowable time zones? I've > been told that the only way to get at this list is by looking through > the source and lifting the list from zone.tab. In the CVS version there is a table wit

[HACKERS] Timezone List

2006-09-06 Thread Naz Gassiep
Any chance for a DB Client accessible list of allowable time zones? I've been told that the only way to get at this list is by looking through the source and lifting the list from zone.tab. While I'm at it, how about an accessible list of country codes? I know that it's not core db functionali

Re: [HACKERS] Multi-valued user-defined types

2006-09-06 Thread Martijn van Oosterhout
On Wed, Sep 06, 2006 at 12:50:20PM -0400, Stephen Frost wrote: > The information for each attribute is: > > Number of dimensions > Spatial Referencing System (identified by the SRID) > Type (ie: Point, Polygon, etc) > POINT(dims, srid) - eg: POINT(2,4269) > geometry(dims, sr

[HACKERS] TODO: GUID datatype

2006-09-06 Thread Gevik Babakhani
I would like to know if anyone is working on the GUID datatype. If not, I am going to work on it. Please let me know. Regards, Gevik. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Getting a move on for 8.2 beta

2006-09-06 Thread Andrew Dunstan
Andrew Sullivan wrote: On Sun, Sep 03, 2006 at 07:42:02PM -0400, Tom Lane wrote: The hard part of this problem is finding a convenient way to capture status data out of the community's conversations. I think when you find a solution to that, you'll notice that email is not the problem.

Re: [HACKERS] Simplifying "standby mode"

2006-09-06 Thread Simon Riggs
On Sat, 2006-09-02 at 09:14 -0400, Bruce Momjian wrote: > Simon Riggs wrote: > > > > OK, I'll submit a C program called pg_standby so that we have an > > approved and portable version of the script, allowing it to be > > documented more easily. > > I think we are still waiting for this. I am als

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-06 Thread Jeff Davis
On Tue, 2006-09-05 at 23:28 -0400, [EMAIL PROTECTED] wrote: > On Tue, Sep 05, 2006 at 05:54:50PM -0700, Jeff Davis wrote: > > On Tue, 2006-09-05 at 18:24 -0400, Chris Browne wrote: > > > Recently seen in ACM Operating Systems Review (this is the first time > > > I've found as many as 1 interesting

Re: [HACKERS] wartho failing

2006-09-06 Thread ohp
Removing #include $(top_srcdir)/contrib/contrib-global.mk in sslinfo Makefile makes the problem go away... Hope it helps On Wed, 6 Sep 2006, Martijn van Oosterhout wrote: > Date: Wed, 6 Sep 2006 13:49:21 +0200 > From: Martijn van Oosterhout > To: ohp@pyrenet.fr > Cc: pgsql-hackers list > Subjec

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Jeff Davis
On Tue, 2006-09-05 at 23:00 -0400, Tom Lane wrote: > Jeff Davis <[EMAIL PROTECTED]> writes: > > On Mon, 2006-09-04 at 10:45 -0400, Tom Lane wrote: > >> The existing geometric containment tests seem to be nonstrict, so if we > >> wanted to leave room to add strict ones later, it might be best to > >

Re: [HACKERS] Getting a move on for 8.2 beta

2006-09-06 Thread Andrew Sullivan
On Sun, Sep 03, 2006 at 07:42:02PM -0400, Tom Lane wrote: > The hard part of this problem is finding a convenient way to capture > status data out of the community's conversations. I think when you find > a solution to that, you'll notice that email is not the problem. In private groups (like com

Re: [HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Stefan Kaltenbrunner
Michael Meskes wrote: > It seems ECPG regression tests trigger a bug in OpenBSD libc. Please try > the attached test case. I should give ERANGE as error, but on OpenBSD > errno is set to 0. > > I tried this test case on Linux, where it works, and OpenBSD 3.8 and 4.0 > (that is HEAD). On both these

Re: [HACKERS] [COMMITTERS] pgsql: Fix compiler warnings on 64-bit boxes:

2006-09-06 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: >> ereport(...errmsg("trouble at offset " UINT64_FORMAT, bigintvar)); > One more solution: add format code %D to expand_fmt_string() which should be > expanded to usual %d on 32-bit architecture and to UINT64_FORMAT on 64-bit. Not very workable unless yo

[HACKERS] Multi-valued user-defined types

2006-09-06 Thread Stephen Frost
Greetings, * Tom Lane ([EMAIL PROTECTED]) wrote: > Does anyone have examples of real user-defined types that would need two > fields? If not it may not be worth spending time on. Guess I'm jumping in a little late on this, but when reading the threads linked to from the TODO items on user-define

[HACKERS] DNS fixed

2006-09-06 Thread Bruce Momjian
Magnus Hagander wrote: > Yes, there are DNS issues. They are partly solved, but expect further > hiccups for a while. Seems the PostgreSQL master DNS servers became unavailable sometime in the past few hours, and Larry's secondary DNS was not responding because it had stale data. I told Larry to

Re: [HACKERS] [COMMITTERS] pgsql: Second try committing the path changes.

2006-09-06 Thread Michael Meskes
On Wed, Aug 30, 2006 at 12:48:55PM -0400, Chris Browne wrote: > > This looks like you're using an old version of the parser. preproc.y was > > changed to handle empty database names and the the error you report is > > due to an empty db name. > > I think the problem is that the latest version of p

Re: [HACKERS] [COMMITTERS] pgsql: Fix compiler warnings on 64-bit

2006-09-06 Thread Teodor Sigaev
ereport(...errmsg("trouble at offset " UINT64_FORMAT, bigintvar)); One more solution: add format code %D to expand_fmt_string() which should be expanded to usual %d on 32-bit architecture and to UINT64_FORMAT on 64-bit. -- Teodor Sigaev E-mail: [EMAIL

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Heikki Linnakangas
Bruce Momjian wrote: Tom Lane wrote: Had a bitmap-index patch arrived in my inbox this morning, as had been promised to me for three weekends running, I might have been willing to drop all else and review it. But, no patch. This item is dead for 8.2. Do not even think of suggesting otherwise.

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Bruce Momjian
Zeugswetter Andreas DCP SD wrote: > > > >> The existing geometric containment tests seem to be nonstrict, so > if > > >> we wanted to leave room to add strict ones later, it might be best > to > > >> settle on > > >> > > >> x @>= y x contains or equals y > > >> x <=@ y x is co

Re: [HACKERS] Simplifying "standby mode"

2006-09-06 Thread Bruce Momjian
Simon Riggs wrote: > On Sat, 2006-09-02 at 09:14 -0400, Bruce Momjian wrote: > > Simon Riggs wrote: > > > > > > OK, I'll submit a C program called pg_standby so that we have an > > > approved and portable version of the script, allowing it to be > > > documented more easily. > > > > I think we ar

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Bruce Momjian
Peter Eisentraut wrote: > Am Dienstag, 5. September 2006 03:07 schrieb Bruce Momjian: > > Here are the open items for 8.2: > > > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This host seems to be offline. What about using the wiki? The host is fine. postgresql.org DNS is broken.

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Dienstag, 5. September 2006 05:58 schrieb Tom Lane: >> A couple of recently discussed FE/BE protocol issues are: not storing a >> plan at all for unnamed-statement cases, and thus allowing bind >> parameters to be treated as constants; allowing para

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Tom Lane
"Zeugswetter Andreas DCP SD" <[EMAIL PROTECTED]> writes: >> Hm, I've never seen anyone spell "less than or equal to" as >> "=<", so I'm not sure where you derive "=<@" from? Not >> saying "no", but the other seems clearer to me. > Yes, but to me too =<@ seems more natural since we started with

Re: [HACKERS] [COMMITTERS] pgsql: Fix compiler warnings on 64-bit boxes:

2006-09-06 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > It might seem a minor quibble, but it seems like a more reliable approach > might be to cast to a 64 bit type and user a 64 bit int formatter. int64 is a real pain to use in error messages because of the machine-dependence of the format string --- the tra

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Magnus Hagander") wrote: >> > Here are the open items for 8.2: >> > >> >http://momjian.postgresql.org/cgi-bin/pgopenitems >> >> This host seems to be offline. What about using the wiki? > > The problem is with the postgresql.org

[HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Michael Meskes
It seems ECPG regression tests trigger a bug in OpenBSD libc. Please try the attached test case. I should give ERANGE as error, but on OpenBSD errno is set to 0. I tried this test case on Linux, where it works, and OpenBSD 3.8 and 4.0 (that is HEAD). On both these systems it doesn't. Now the quest

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Dave Cramer
On 6-Sep-06, at 3:27 AM, Magnus Hagander wrote: Yes they are using a connection pool. A java based one. Since java has it's own protocol implementation, this is totally unrelated to any libpq error messages. Another important point that we've not been given information on: when pgAdmin/li

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Magnus Hagander
> > Here are the open items for 8.2: > > > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This host seems to be offline. What about using the wiki? The problem is with the postgresql.org DNS servers. Something weird is afoot around the hub.org nameservers, from what I can tell. Serv

Re: [HACKERS] patching question

2006-09-06 Thread Gevik Babakhani
On Wed, 2006-09-06 at 13:50 +0200, Martijn van Oosterhout wrote: > On Wed, Sep 06, 2006 at 01:37:51PM +0200, Gevik Babakhani wrote: > > Sorry to ask this question here... > > How do I include newly created files in a patch with difforig or patch > > Thank you. > > The -N option to diff treats non-

Re: [HACKERS] patching question

2006-09-06 Thread Martijn van Oosterhout
On Wed, Sep 06, 2006 at 01:37:51PM +0200, Gevik Babakhani wrote: > Sorry to ask this question here... > How do I include newly created files in a patch with difforig or patch > Thank you. The -N option to diff treats non-existant files as empty. So "diff -crN" should do it. Have you read the deve

Re: [HACKERS] wartho failing

2006-09-06 Thread Martijn van Oosterhout
On Wed, Sep 06, 2006 at 01:32:53PM +0200, ohp@pyrenet.fr wrote: > Hi, > > Warthog has been failing for the last 12 hours or so on contrib/sslinfo > > It seems that readline and termcap should not be linked with. > > What can I do to help? Classic putting-non-PIC-code-in-a-shared-library error.

Re: [HACKERS] ECPG regression failures on OpenBSD

2006-09-06 Thread chrisnospam
> Michael, if you want shell access to guppy, just contact me privately. > Warning: guppy too, is somewhat dated (1:10 hours for the make step) :/ Michael, did you receive my private mail yesterday? (just want to make sure it wasn't blocked by an overzealous spam filter) Bye, Chris. -- Chris M

[HACKERS] patching question

2006-09-06 Thread Gevik Babakhani
Sorry to ask this question here... How do I include newly created files in a patch with difforig or patch Thank you. ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] wartho failing

2006-09-06 Thread ohp
Hi, Warthog has been failing for the last 12 hours or so on contrib/sslinfo It seems that readline and termcap should not be linked with. What can I do to help? Also, now that beta is approaching, warthog runs his HEAD buikd every 8 hours. Do we need it more often? Regards, -- Olivier PRENAN

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Devrim GUNDUZ
Hello, On Wed, 2006-09-06 at 13:04 +0200, Peter Eisentraut wrote: > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This host seems to be offline. It is suffering from a DNS problem. > What about using the wiki? Wiki has the same problem, too. Regards, -- The PostgreSQL Comp

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Peter Eisentraut
Am Dienstag, 5. September 2006 03:07 schrieb Bruce Momjian: > Here are the open items for 8.2: > > http://momjian.postgresql.org/cgi-bin/pgopenitems This host seems to be offline. What about using the wiki? -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [HACKERS] Open items for 8.2

2006-09-06 Thread Peter Eisentraut
Am Dienstag, 5. September 2006 05:58 schrieb Tom Lane: > A couple of recently discussed FE/BE protocol issues are: not storing a > plan at all for unnamed-statement cases, and thus allowing bind > parameters to be treated as constants; allowing parameter types to go > unresolved rather than throwin

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Matteo Beccati
Tom Lane wrote: The existing geometric containment tests seem to be nonstrict, so if we wanted to leave room to add strict ones later, it might be best to settle on x @>= y x contains or equals y x <=@ y x is contained in or equals y reserving @> and <@

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Magnus Hagander
> > server sent data ("D" message) without prior row description ("T" > > message) > > During the connection attempt? I don't think libpq can report that > message until it tries to do a regular query (might be wrong > though). > Is the client using some application that's going to issue a query

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Zeugswetter Andreas DCP SD
> >> The existing geometric containment tests seem to be nonstrict, so if > >> we wanted to leave room to add strict ones later, it might be best to > >> settle on > >> > >> x @>= yx contains or equals y > >> x <=@ yx is contained in or equals y > >> > >> reserving @> a

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Michael Paesold
Magnus Hagander wrote: > Another point that at least I don't know - what kind of connection pool > is it? Is it an external one (like pgpool) to which the java app > connects (using FE/BE protocol, emulating a "proper postmaster" but > pooling access to the database), or is it running inside the a

Re: [HACKERS] Win32 hard crash problem

2006-09-06 Thread Magnus Hagander
> Yes they are using a connection pool. A java based one. > >>> Since java has it's own protocol implementation, this is > totally > >>> unrelated to any libpq error messages. > >> Another important point that we've not been given information > on: > >> when pgAdmin/libpq starts failing like t

Re: [HACKERS] [PATCHES] BUG #2600: dblink compile with SSL missing libraries

2006-09-06 Thread Albe Laurenz
Chris Browne wrote: >>> I also seem to recall, in past discussions about "library matters," >>> that AIX is more sticky about requiring that libraries be named >>> expressly. >> >> ecpglib has >> >> SHLIB_LINK = -L../pgtypeslib -lpgtypes $(libpq) \ >> $(filter -lintl -lssl -lcrypto -lkrb5 -