[HACKERS] remapped localhost causes connections to localhost to fail using Postgres

2015-12-04 Thread Dann Corbit
Using a Windows computer, editing the file: C:\WINDOWS\system32\drivers\etc\hosts the localhost entry was remapped to the machine name by adding the following line: 127.0.0.1 After this change, Postgres would not allow access using the address localhost. Only using the machine name to acce

[HACKERS] Re: [GENERAL] postgresql-9.3.1-1-windows-x64.exe does not install correctly for me

2013-10-31 Thread Dann Corbit
From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Thursday, October 31, 2013 5:03 PM To: Dann Corbit; 'pgsql-gene...@postgresql.org' Subject: Re: [GENERAL] postgresql-9.3.1-1-windows-x64.exe does not install correctly for me On 10/31/2013 11:53 AM, Dann Corbit wrote: > p

Re: [HACKERS] New regression test time

2013-06-29 Thread Dann Corbit
-Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Josh Berkus Sent: Saturday, June 29, 2013 3:00 PM To: Andrew Dunstan Cc: Alvaro Herrera; pgsql-hackers@postgresql.org; Robins Tharakan Subject: Re: [HACKERS] New regression

Re: [HACKERS] ancient sequence point bug

2013-04-16 Thread Dann Corbit
-Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Tuesday, April 16, 2013 7:52 PM To: Peter Eisentraut Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] ancient sequence point bug >Peter Eisentraut wr

[HACKERS] Re: Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-09 Thread Dann Corbit
-Original Message- From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark Sent: Saturday, March 09, 2013 5:16 PM To: Dann Corbit Cc: Bruce Momjian; Peter Geoghegan; Robert Haas; Tom Lane; PG Hackers Subject: Re: Why do we still perform a check for pre-sorted input

[HACKERS] Re: Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-09 Thread Dann Corbit
http://en.wikipedia.org/wiki/Selection_algorithm#Linear_general_selection_algorithm_-_Median_of_Medians_algorithm -Original Message- From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark Sent: Saturday, March 09, 2013 1:21 PM To: Dann Corbit Cc: Bruce Momjian; Peter Geog

[HACKERS] Re: Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-09 Thread Dann Corbit
"A Machine-Checked Proof of the Average-Case Complexity of Quicksort in Coq" By Eelis van der Weegen and James McKinna Institute for Computing and Information Sciences Radboud University Nijmegen Heijendaalseweg 135, 6525 AJ Nijmegen, The Netherlands Contains a formal proof, validated by machine

[HACKERS] Re: Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-09 Thread Dann Corbit
-Original Message- From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark Sent: Saturday, March 09, 2013 11:39 AM To: Dann Corbit Cc: Bruce Momjian; Peter Geoghegan; Robert Haas; Tom Lane; PG Hackers Subject: Re: Why do we still perform a check for pre-sorted input

[HACKERS] Re: Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-09 Thread Dann Corbit
Original Message- >From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark >Sent: Friday, March 08, 2013 4:59 PM >To: Dann Corbit >Cc: Bruce Momjian; Peter Geoghegan; Robert Haas; Tom Lane; PG Hackers >Subject: Re: Why do we still perform a check for p

Re: [HACKERS] Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-08 Thread Dann Corbit
-Original Message- From: Peter Geoghegan [mailto:peter.geoghega...@gmail.com] Sent: Friday, March 08, 2013 12:00 PM To: Bruce Momjian Cc: Dann Corbit; Robert Haas; Tom Lane; PG Hackers Subject: Re: [HACKERS] Why do we still perform a check for pre-sorted input within qsort variants? On

Re: [HACKERS] Why do we still perform a check for pre-sorted input within qsort variants?

2013-03-08 Thread Dann Corbit
>-Original Message- >From: pgsql-hackers-ow...@postgresql.org >[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Bruce Momjian >Sent: Friday, March 08, 2013 11:22 AM >To: Peter Geoghegan >Cc: Robert Haas; Tom Lane; PG Hackers >Subject: Re: [HACKERS] Why do we still perform a check f

Re: [HACKERS] [help] Is it possible to support remote COPY operation on PG?

2012-10-23 Thread Dann Corbit
You can use the libpq API: http://www.postgresql.org/docs/9.2/interactive/libpq-copy.html The Postgresql JDBC driver exposes COPY, IIRC. From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Xiong He Sent: Tuesday, October 23, 2012 11:55 PM To: Postgr

Re: [HACKERS] CUDA Sorting

2012-02-15 Thread Dann Corbit
-Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Gaetano Mendola Sent: Wednesday, February 15, 2012 2:54 PM To: Peter Geoghegan; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] CUDA Sorting On 15/02/2012 23:11, Peter

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Dann Corbit
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Michael Nolan Sent: Tuesday, September 13, 2011 11:51 AM To: Joshua D. Drake Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] What Would You Like To Do? On Tue, Sep 13, 2011 at 12:26 PM, Josh

Re: [HACKERS] What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?

2011-04-26 Thread Dann Corbit
> -Original Message- > From: Jeff Davis [mailto:pg...@j-davis.com] > Sent: Tuesday, April 26, 2011 11:44 AM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] What was the exact version of PostgreSQL where > the column name length changed fro

[HACKERS] What was the exact version of PostgreSQL where the column name length changed from 31 to 63 characters?

2011-04-26 Thread Dann Corbit
I need to know so that I can handle cases like: Create table foolongcols( nevermindthefurthermorejustpleadinselfdefense char(5), nevermindthefurthermorejustpleadguilty char(5) ); I assume that other object names (table name, function name, etc.) are similarly affected. Is that

Re: [HACKERS] ORDER BY 1 COLLATE

2011-04-18 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Andrew Dunstan > Sent: Monday, April 18, 2011 1:43 PM > To: Tom Lane > Cc: Peter Eisentraut; pgsql-hackers > Subject: Re: [HACKERS] ORDER BY 1 COLLATE > > On 04/18/20

Re: [HACKERS] [GENERAL] Postgres 9.1 - Release Theme

2011-04-01 Thread Dann Corbit
Smells like April first to me. http://en.wikipedia.org/wiki/April_Fools'_Day From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rajasekhar Yakkali Sent: Friday, April 01, 2011 10:08 AM To: dp...@postgresql.org Cc: pgsql-gene...@postgresql.org; pgsql

Re: [HACKERS] would hw acceleration help postgres (databases in general) ?

2010-12-10 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Hamza Bin Sohail > Sent: Friday, December 10, 2010 3:10 PM > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] would hw acceleration help postgres (databases in >

Re: [HACKERS] Proposal: First step towards Intelligent,integrated database

2010-12-01 Thread Dann Corbit
I am probably just being thick, but how is your idea different from create domain: http://www.postgresql.org/docs/current/static/sql-createdomain.html From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of ghatpa...@vsnl.net Sent: Wednesday, December 0

Re: [HACKERS] Implementation of Date/Time Input Interpretation

2010-06-22 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:and...@dunslane.net] > Sent: Tuesday, June 22, 2010 7:47 PM > To: Francis Markham > Cc: Dann Corbit; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Implementation of Date/Time Input Interpretation > > &g

Re: [HACKERS] Implementation of Date/Time Input Interpretation

2010-06-22 Thread Dann Corbit
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Francis Markham Sent: Tuesday, June 22, 2010 7:13 PM To: pgsql-hackers@postgresql.org Subject: [HACKERS] Implementation of Date/Time Input Interpretation Greetings all, I am currently implementing a

Re: [HACKERS] GSoC

2010-03-29 Thread Dann Corbit
Maybe this can be helpful: http://sourceforge.net/search/?type_of_search=soft&words=fingerprint http://sourceforge.net/search/?type_of_search=soft&words=image+recogniti on > -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Beh

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Rayson Ho > Sent: Tuesday, February 16, 2010 9:39 AM > To: David Fetter > Cc: Andrew Dunstan; PG Hackers > Subject: Re: [HACKERS] OpenVMS? > > On Tue, Feb 16, 2010 at

[HACKERS] MonetDB test says that PostgreSQL often has errors or missing results

2010-01-19 Thread Dann Corbit
See: http://monetdb.cwi.nl/SQL/Benchmark/TPCH/ If the result is correct, then the problem queries should be added to the regression test suite. If the result is not correct, then perhaps they could get assistance on proper configuration of PostgreSQL and rerun the tests. -- Sent via pgsql-hacke

[HACKERS] Source code for pg_bulkload

2010-01-14 Thread Dann Corbit
How can I obtain the source code for pg_bulkload? I am interested in writing an API version, so that I can imbed this loading facility into programs. The page http://pgfoundry.org/projects/pgbulkload/ has links to the binaries, but I want the source. -- Sent via pgsql-hackers mailing list (pgs

Re: [HACKERS] planner or statistical bug on 8.5

2010-01-12 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Pavel Stehule > Sent: Monday, January 11, 2010 11:55 PM > To: PostgreSQL Hackers > Cc: Tom Lane > Subject: [HACKERS] planner or statistical bug on 8.5 > > Hello > >

Re: [HACKERS] boolean in C

2009-07-16 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Bernd Helmle > Sent: Thursday, July 16, 2009 8:47 AM > To: Grzegorz Jaskiewicz > Cc: pgsql-hackers Hackers > Subject: Re: [HACKERS] boolean in C > > --On 16. Juli 200

Re: [HACKERS] Throw some low-level C scutwork at me

2009-05-01 Thread Dann Corbit
s, but having the same manner for all human souls: in short, behaving as if you were in Heaven, where there are no third-class carriages, and one soul is as good as another. For comparison, here is a recent message from Tom addressed to me, along with my response:

Re: [HACKERS] Building Postgresql under Windows question

2009-04-28 Thread Dann Corbit
Pg_ctl.exe is exiting with a success code from line 1946 of PG_CTL.C This is not appropriate behavior for a service unless shutdown has been requested. > -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Da

Re: [HACKERS] Building Postgresql under Windows question

2009-04-28 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:and...@dunslane.net] > Sent: Tuesday, April 28, 2009 2:27 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Building Postgresql under Windows question > > > > Dann Corb

Re: [HACKERS] Building Postgresql under Windows question

2009-04-28 Thread Dann Corbit
In this function: static bool test_postmaster_connection(bool do_checkpoint) This code will never succeed: snprintf(connstr, sizeof(connstr), "dbname=postgres port=%s connect_timeout=5", portstr); for (i = 0; i < wait_seconds; i++) {

Re: [HACKERS] Building Postgresql under Windows question

2009-04-28 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:and...@dunslane.net] > Sent: Tuesday, April 28, 2009 12:42 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Building Postgresql under Windows question > > > > Dann Corbit wr

Re: [HACKERS] Building Postgresql under Windows question

2009-04-28 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:and...@dunslane.net] > Sent: Tuesday, April 28, 2009 12:42 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Building Postgresql under Windows question > > > > Dann Corbit wr

[HACKERS] Building Postgresql under Windows question

2009-04-28 Thread Dann Corbit
We are still having trouble with the service controller pg_ctl.exe vanishing after some period of time. Hence I am doing debug builds from the source tree according to the instructions found at: http://developer.postgresql.org/pgdocs/postgres/install-win32-full.html Specifically, I am using this

Re: [HACKERS] Windows installation service

2009-04-10 Thread Dann Corbit
> -Original Message- > From: Dave Page [mailto:dp...@pgadmin.org] > Sent: Friday, April 10, 2009 1:58 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org; Bill Luton; Larry McGhaw; Mike McKee; > Brian Fifer > Subject: Re: [HACKERS] Windows installation service >

Re: [HACKERS] Windows installation service

2009-04-10 Thread Dann Corbit
> -Original Message- > From: Dann Corbit > Sent: Friday, April 10, 2009 12:30 PM > To: 'Dave Page' > Cc: pgsql-hackers@postgresql.org; Bill Luton; Larry McGhaw; Mike McKee; > Brian Fifer > Subject: RE: [HACKERS] Windows installation service > > > -

Re: [HACKERS] Windows installation service

2009-04-10 Thread Dann Corbit
> -Original Message- > From: Dave Page [mailto:dp...@pgadmin.org] > Sent: Friday, April 10, 2009 8:16 AM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org; Bill Luton; Larry McGhaw; Mike McKee; > Brian Fifer > Subject: Re: [HACKERS] Windows installation service >

[HACKERS] Windows installation service

2009-04-10 Thread Dann Corbit
The Windows installation service uses pg_ctl to perform the network start-up operation. This program starts up the postmaster and exits. The net effect of performing the operation in this manner is that the Windows service manager sees the service as "not running" a few minutes after the startup is

[HACKERS] FW: Multiple character encodings within a single database/table?

2009-04-10 Thread Dann Corbit
> -Original Message- > From: Dann Corbit > Sent: Monday, March 23, 2009 3:50 PM > To: pgsql-gene...@postgresql.org > Subject: Multiple character encodings within a single database/table? > > If I have the C locale, can I have multiple character encodings within: &g

[HACKERS] One click installer and pgInstaller collide

2009-04-10 Thread Dann Corbit
If you install with the PostgreSQL group's installer for Windows: http://www.postgresql.org/ftp/binary And then install a second instance of PostgreSQL using the EnterpriseDB one click installer: http://www.enterprisedb.com/products/pgdownload.do#windows An error may occur. It will occur, probab

Re: [HACKERS] Is there an official log reader for PostgreSQL?

2009-03-04 Thread Dann Corbit
> -Original Message- > From: Dimitri Fontaine [mailto:dfonta...@hi-media.com] > Sent: Wednesday, March 04, 2009 12:28 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Is there an official log reader for PostgreSQL? > > Hi, > &

[HACKERS] Is there an official log reader for PostgreSQL?

2009-03-04 Thread Dann Corbit
I am interested in doing a near real time transaction processor. If there is a place to find the specification for the log reader, I would be keen to know it. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

[HACKERS] Kerberos V5 required for PostgreSQL installation on Windows

2009-02-26 Thread Dann Corbit
If Kerberos V5 is not installed on a Windows platform, the following error dialog is returned upon attempted installation: Posgres.exe - Unable to Locate Component This application has failed to start because krb5_32.dll was not found. Re-installing the application may fix this problem. [OK] --

Re: [HACKERS] Is a plan for lmza commpression in pg_dump

2009-02-04 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Bruce Momjian > Sent: Wednesday, February 04, 2009 3:28 PM > To: Stanislav Lacko > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Is a plan for lmza commpre

Re: [HACKERS] 8.4 release planning

2009-01-26 Thread Dann Corbit
> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Joshua D. Drake > Sent: Monday, January 26, 2009 7:42 PM > To: KaiGai Kohei > Cc: Tom Lane; Ron Mayer; Josh Berkus; Robert Haas; Merlin Moncure; > Jonah H. Harris; Gre

Re: [HACKERS] Simple postgresql.conf wizard -- Statistics idea...

2008-11-25 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 25, 2008 5:33 PM > To: Dann Corbit > Cc: Gregory Stark; Decibel!; Robert Haas; Bruce Momjian; Mark Wong; > Heikki Linnakangas; Josh Berkus; Greg Smith; pgsql- > [EMAIL PRO

Re: [HACKERS] Simple postgresql.conf wizard

2008-11-25 Thread Dann Corbit
> -Original Message- > From: Greg Stark [mailto:[EMAIL PROTECTED] On Behalf Of > Gregory Stark > Sent: Tuesday, November 25, 2008 5:06 PM > To: Decibel! > Cc: Tom Lane; Dann Corbit; Robert Haas; Bruce Momjian; Mark Wong; > Heikki Linnakangas; Josh Berkus; Greg S

Re: [HACKERS] Simple postgresql.conf wizard

2008-11-19 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Robert Haas > Sent: Wednesday, November 19, 2008 5:05 PM > To: Bruce Momjian > Cc: Mark Wong; Tom Lane; Heikki Linnakangas; Gregory Stark; Josh > Berkus; Greg Smith; pgsql-hackers@postgres

[HACKERS] Installation oddity -- installer insists that PostgreSQL has failed to start, even though it is started and functioning correctly

2008-11-18 Thread Dann Corbit
Sorry about the HTML post, but I wanted to include the error form. When trying to perform an upgrade with PostgreSQL 8.3.5 over 8.3.4, the installer insists that PostgreSQL has failed to start. However, I can see the processes in memory (it has indeed started) and even attach with PG Admin

Re: [HACKERS] Strange query behavior where clause produces odd behavior on '>' query

2008-10-30 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 30, 2008 6:34 PM > To: Dann Corbit > Cc: [HACKERS]; Sherry Griffin > Subject: Re: [HACKERS] Strange query behavior where clause produces odd > behavior on '>'

Re: [HACKERS] Strange query behavior where clause produces odd behavior on '>' query

2008-10-30 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 30, 2008 5:31 PM > To: Dann Corbit > Cc: [HACKERS]; Sherry Griffin > Subject: Re: [HACKERS] Strange query behavior where clause produces odd > behavior on '>'

[HACKERS] Strange query behavior where clause produces odd behavior on '>' query

2008-10-30 Thread Dann Corbit
The following query: SELECT * FROM Customers_connxstore where customerid > 'specd' Returns the row containing Customers_connxstore.customerid == 'SPECD' I would expect to get that row if the query was: SELECT * FROM Customers_connxstore where customerid >= 'specd' The other operators (<, <=, >,

Re: [HACKERS] Multi CPU Queries - Feedback and/or suggestions wanted!

2008-10-29 Thread Dann Corbit
>Hi Simon, > >He is going to do some investigation in the methods and >write down the possibilities and then he is going to implement >something from that for PostgreSQL. > >When will this work be complete? We are days away from completing main >work on 8.4, so you won't get much discussion on this

Re: [HACKERS] Plugin system like Firefox

2008-08-12 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Bruce Momjian > Sent: Tuesday, August 12, 2008 9:04 PM > To: Robert Haas > Cc: Markus Wanner; Matthew T. O'Connor; Tom Lane; Greg Sabino Mullane; > pgsql-hackers@postgresql.org > Subject:

Re: [HACKERS] [RFC] Unsigned integer support.

2008-07-25 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2008 1:28 PM > To: Dann Corbit > Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql- > [EMAIL PROTECTED] > Subject: Re: [HACKERS] [RFC] Unsigned integer support. > &

Re: [HACKERS] [RFC] Unsigned integer support.

2008-07-25 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2008 1:11 PM > To: Dann Corbit > Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql- > [EMAIL PROTECTED] > Subject: Re: [HACKERS] [RFC] Unsigned integer support. > &

Re: [HACKERS] [RFC] Unsigned integer support.

2008-07-25 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Friday, July 25, 2008 12:32 PM > To: Ryan Bradetich > Cc: Gregory Stark; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] [RFC] Unsigned integer support. > > "Ryan B

Re: [HACKERS] Whence cometh the data in src/test/regress/data/streets.data ?

2008-07-25 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Friday, July 25, 2008 12:52 PM > To: Bjorn Munch > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Whence cometh the data in > src/test/regress/data/streets.data

Re: [HACKERS] Research/Implementation of Nested Loop Join optimization

2008-07-23 Thread Dann Corbit
From: Manoel Henrique [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 1:47 PM To: Dann Corbit Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Research/Implementation of Nested Loop Join optimization The nodeMergejoin.c is the code for the Merge Join isn`t it? I am trying

Re: [HACKERS] Research/Implementation of Nested Loop Join optimization

2008-07-23 Thread Dann Corbit
When you install the source tree (e.g. in folder \postgresql-8.3.x) you will want to examine nodeMergejoin.c typically found in a path similar to this: \postgresql-8.3.x\src\backend\executor\nodeMergejoin.c Here are the comments from the version on my machine: /* * INTERFACE ROUTINES *

Re: [HACKERS] [PATCH]-hash index improving

2008-07-22 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Xiao Meng > Sent: Tuesday, July 22, 2008 7:57 PM > To: Simon Riggs > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] [PATCH]-hash index improving > > Well, I'll do it after I fi

Re: [HACKERS] [PATCH]-hash index improving

2008-07-17 Thread Dann Corbit
-Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Riggs > Sent: Thursday, July 17, 2008 4:10 PM > To: Jonah H. Harris > Cc: Xiao Meng; pgsql-hackers@postgresql.org; Kenneth Marshall > Subject: Re: [HACKERS] [PATCH]-hash index improving > > > On

Re: [HACKERS] TIMESTAMP and daylight savings time question

2008-03-14 Thread Dann Corbit
We figured the problem out. Our older version did not have the OS patch: http://www.postgresqlforums.com/wiki/2007_Daylight_Savings_Time From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dann Corbit Sent: Wednesday, March 12, 2008 6:06 PM To

[HACKERS] TIMESTAMP and daylight savings time question

2008-03-12 Thread Dann Corbit
It appears that the older versions of PostgreSQL (7.x) do not consider the daylight savings time when using TIMESTAMP WITH TIMEZONE but the most recent versions do (8.x). Can someone tell me the exact PostgreSQL version number where the behavior changed?

Re: [HACKERS] bug in numeric_power() function

2008-03-11 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Richard Wang > Sent: Tuesday, March 11, 2008 7:38 PM > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] bug in numeric_power() function > > I expected 0 ^ 123.3 to be 0, but it repor

Re: [HACKERS] Will PostgreSQL get ported to CUDA?

2008-01-30 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Christopher Browne > Sent: Wednesday, January 30, 2008 9:56 AM > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] Will PostgreSQL get ported to CUDA? > &g

[HACKERS] Will PostgreSQL get ported to CUDA?

2008-01-29 Thread Dann Corbit
http://www.scientificcomputing.com/ShowPR~PUBCODE~030~ACCT~300100~IS SUE~0801~RELTYPE~HPCC~PRODCODE~~PRODLETT~C.html http://www.nvidia.com/object/cuda_learn.html http://www.nvidia.com/object/cuda_get.html

Re: [HACKERS] operator suggest " interval / interval = numeric"

2008-01-09 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Wednesday, January 09, 2008 10:00 PM > To: Warren Turkal > Cc: Brendan Jurd; Ilya А. Кovalenko; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] operator suggest " in

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-20 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Brian Hurt > Sent: Thursday, December 20, 2007 6:42 AM > To: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Sorting Improvements for 8.4 > > While we're blue skying things, I've ha

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-19 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Gregory Stark > Sent: Wednesday, December 19, 2007 5:26 PM > To: Jeff Davis > Cc: Mark Mielke; Michał Zaborowski; Simon Riggs; Ron Mayer; pgsql- > [EMAIL PROTECTED] > Subject: Re: [HACKERS

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-19 Thread Dann Corbit
P.S. A beautiful paper on replacement selection is found here: http://students.fim.uni-passau.de/~fickensc/Proseminar/Proseminar.pdf ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-19 Thread Dann Corbit
> -Original Message- > From: Jeff Davis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 19, 2007 3:10 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Sorting Improvements for 8.4 > > On Wed, 2007-12-19 at 14:41 -0800, Dann C

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-19 Thread Dann Corbit
As long as sorting improvements are being considered, may I suggest an experiment that uses a very simple model? Assuming that you have K subfiles created by the initial sorting pass, insert the top record of each file into a priority queue. Then, emit records from the queue until the priority qu

Re: [HACKERS] Current code for function j2date does not have the same correct dynamic range as older code.

2007-12-12 Thread Dann Corbit
From: Dann Corbit Sent: Tuesday, December 11, 2007 5:58 PM To: pgsql-hackers@postgresql.org Subject: Current code for function j2date does not have the same correct dynamic range as older code. > It may not matter to the PostgreSQL group, since nothing goes > wrong until the year is 1,465,

Re: [HACKERS] [GENERAL] Dumb question about binary cursors and #ifdefHAVE_INT64_TIMESTAMP

2007-12-11 Thread Dann Corbit
> -Original Message- > From: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 11, 2007 1:11 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org; [EMAIL PROTECTED] > Subject: Re: [GENERAL] Dumb question about binary cursors and > #ifdefHAVE_INT6

Re: [HACKERS] [GENERAL] Dumb question about binary cursors and #ifdefHAVE_INT64_TIMESTAMP

2007-12-11 Thread Dann Corbit
> -Original Message- > From: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 11, 2007 1:11 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org; [EMAIL PROTECTED] > Subject: Re: [GENERAL] Dumb question about binary cursors and > #ifdefHAVE_INT6

[HACKERS] Dumb question about binary cursors and #ifdef HAVE_INT64_TIMESTAMP

2007-12-11 Thread Dann Corbit
If I create a binary cursor on a recent version of PostgreSQL, how can I tell if the timestamp data internally is an 8 byte double or an 8 byte integer? I see an #ifdef that changes the code path to compute timestamps as one type or the other, but I do not know how to recognize the internal format

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Dann Corbit
> -Original Message- > From: Larry McGhaw > Sent: Tuesday, June 12, 2007 1:40 PM > To: Martijn van Oosterhout > Cc: Andrew Dunstan; Hannu Krosing; Tom Lane; Alvaro Herrera; Dann Corbit; > Gregory Stark; pgsql-hackers@postgresql.org > Subject: RE: [HACKERS] Selectin

[HACKERS] Selecting a constant question: A summary

2007-06-12 Thread Dann Corbit
First a comment: At CONNX Solutions Inc., we believe sincerely that we should do whatever is necessary to make our customers prosper. This means creation of excellent tools and being responsive to customer needs. Secondly, we believe that we should treat the customers the way that we want to be

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Hannu Krosing [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 10:43 PM > To: Larry McGhaw > Cc: Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van > Oosterhout; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS]

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Hannu Krosing [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 8:42 PM > To: Dann Corbit > Cc: Tom Lane; Gregory Stark; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selecting a constant question > > Ühel kenal päeval,

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:35 PM > To: Dann Corbit > Cc: Gregory Stark; Martijn van Oosterhout; pgsql-hackers@postgresql.org; > Larry McGhaw > Subject: Re: [HACKERS] Selecting a constant quest

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 5:32 PM > To: Larry McGhaw > Cc: Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van Oosterhout; > pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selectin

Re: [HACKERS] Got no response last time on setsockopt post, so I thought I would reiterate.

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 5:12 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org; Larry McGhaw > Subject: Re: [HACKERS] Got no response last time on setsockopt post, so I > thought I would

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Andrew Dunstan > Sent: Monday, June 11, 2007 5:12 PM > To: Larry McGhaw > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selecting a constant question > > > > Larry McGhaw wr

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Kris Jurka > Sent: Monday, June 11, 2007 5:04 PM > To: Larry McGhaw > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selecting a constant question > > > > On Mon, 11 Jun 2007

Re: [HACKERS] Got no response last time on setsockopt post, so I thought I would reiterate.

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 4:35 PM > To: Dann Corbit > Cc: Tom Lane; pgsql-hackers@postgresql.org; Larry McGhaw > Subject: Re: [HACKERS] Got no response last time on setsockopt post, so I > thou

Re: [HACKERS] Got no response last time on setsockopt post, so I thought I would reiterate.

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Greg Smith [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 4:09 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Got no response last time on setsockopt post, so I > thought I would reiterate. >

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:50 PM > To: Dann Corbit > Cc: Martijn van Oosterhout; Alvaro Herrera; Gregory Stark; pgsql- > [EMAIL PROTECTED]; Larry McGhaw > Subject: Re: [HACKERS] Selecting a constan

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:44 PM > To: Dann Corbit > Cc: Tom Lane; Gregory Stark; Martijn van Oosterhout; pgsql- > [EMAIL PROTECTED]; Larry McGhaw > Subject: Re: [HACKERS] Selecting a consta

Re: [HACKERS] Got no response last time on setsockopt post, so I thought I would reiterate.

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:41 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org; Larry McGhaw > Subject: Re: [HACKERS] Got no response last time on setsockopt post, so I > thought I would

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:29 PM > To: Dann Corbit > Cc: Alvaro Herrera; Gregory Stark; pgsql-hackers@postgresql.org; Larry > McGhaw > Subject: Re: [HACKERS] Selecting a constant questio

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 3:16 PM > To: Dann Corbit > Cc: Gregory Stark; Martijn van Oosterhout; pgsql-hackers@postgresql.org; > Larry McGhaw > Subject: Re: [HACKERS] Selecting a constant ques

[HACKERS] Got no response last time on setsockopt post, so I thought I would reiterate.

2007-06-11 Thread Dann Corbit
These two calls make our remote queries via libpq about twice as fast on average. It seems to me like it might be a nice addition to the core product's libpq (I poked it into the spot where the Nagle algorithm is turned off, but another place would be fine too). Can anyone give me a reason why it

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Gregory Stark [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 2:41 PM > To: Dann Corbit > Cc: Martijn van Oosterhout; pgsql-hackers@postgresql.org; Larry McGhaw > Subject: Re: [HACKERS] Selecting a constant question > > "D

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Dann Corbit > Sent: Monday, June 11, 2007 1:52 PM > To: Martijn van Oosterhout > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selectin

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 1:46 PM > To: Dann Corbit > Subject: Re: [HACKERS] Selecting a constant question > > On Mon, Jun 11, 2007 at 01:29:37PM -0700, Dann Corbit wrote: > > O

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 1:32 PM > To: Dann Corbit > Cc: Gregory Stark; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selecting a constant question > > "Dann Corbit" <[EMAIL

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Dann Corbit
> -Original Message- > From: Gregory Stark [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 12:48 PM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Selecting a constant question > > "Dann Corbit" <[EMAIL PROT

  1   2   3   4   5   >