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
[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:
postgresql-9.3.1-1-windows-x64.exe
-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
-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
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 pre-sorted input within
-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
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
://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 Geoghegan
-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
-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 for
-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
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:
-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
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,
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
-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 from 31 to 63 characters
-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/2011 04:20
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;
-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
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
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
-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
Francis Markham wrote:
Thank
Maybe this can be helpful:
http://sourceforge.net/search/?type_of_search=softwords=fingerprint
http://sourceforge.net/search/?type_of_search=softwords=image+recogniti
on
-Original Message-
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-
ow...@postgresql.org] On Behalf
-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 11:22
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
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
-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
I checked
-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 2009
:
=
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, April 28, 2009 3:21 PM
To: Dann Corbit
Cc: Andrew Dunstan; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Building Postgresql under Windows question
Dann Corbit dcor
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
-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 wrote:
Pg_ctl.exe is exiting
-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 wrote:
Pg_ctl.exe is exiting
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++)
{
-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 Corbit wrote:
In this function:
static bool
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 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,
-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:
1. A single database?
2
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
-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
On Mon, Apr 6, 2009 at 9:32
-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
-Original Message-
From: Dave Page
-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
On Fri, Apr 10, 2009 at 8:29
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:
-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,
Le 4 mars 09 à 21:17, 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]
-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 commpression
-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; Gregory
-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 Smith; pgsql-
[EMAIL PROTECTED
-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 PROTECTED]
Subject: Re: [HACKERS
-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@postgresql.org
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
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 (, =, , =,
-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 '' query
Dann Corbit [EMAIL PROTECTED] writes
-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 '' query
Dann Corbit [EMAIL PROTECTED] writes
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 for a
-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:
-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 ?
-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 Bradetich
-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.
Dann Corbit wrote:
CREATE
-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.
Dann Corbit wrote
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
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
-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 finish my
-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 Thu,
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
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?
-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 reported
-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?
2008/1/30 Dann Corbit [EMAIL
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
-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 interval
-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 had an
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
-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 Corbit wrote:
As long as sorting
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
-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]
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,002
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
-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_INT64_TIMESTAMP
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_INT64_TIMESTAMP
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
-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] Selecting a constant question
SELECT 1 FROM test.dbo.a_003
gets about 60,000 records per second
SELECT '1' FROM test.dbo.a_003
gets about 600 records per second.
The cause is that postgres describes the return column as unknown
length 65534 in the 2nd case.
Since the value is a constant, it seems rather
-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 PROTECTED] writes:
SELECT 1 FROM test.dbo.a_003
-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 PROTECTED] writes:
The issue
-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:
Our application is using the libPQ
-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] Selecting a constant question
-Original Message
-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
Dann Corbit [EMAIL PROTECTED] writes
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
-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 question
Dann Corbit wrote
-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 question
On Mon, Jun 11, 2007
-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 reiterate.
Dann Corbit [EMAIL
-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 constant question
Dann Corbit wrote
-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 constant question
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.
On Mon, 11 Jun 2007, 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
thought I would reiterate.
Dann
-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, Larry
-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 wrote:
4)
-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 reiterate.
Dann Corbit [EMAIL
-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] Selecting a constant question
Larry McGhaw
-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 question
Dann Corbit [EMAIL PROTECTED
-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, E, 2007-06-11 kell 13:38, kirjutas
1 - 100 of 437 matches
Mail list logo
