- Original Message -
From: Luis Alberto Amigo Navarro [EMAIL PROTECTED]
To: Neil Conway [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:02 PM
Subject: Re: [HACKERS] a tiny question
A small patch for low performance on NUMA arquitectures could be the
chance
Hello,
I know Ansi C language and SQL. I want to embed a sql statement into a c
source code. Would you please recommend me some web sites or tutorials
regarding this subject.
Thank you for your concern,
Emrah
---(end of broadcast)---
TIP 4:
Hi, all.
I just wanted to give you an update on where my company (PeerDirect) is with
regards to our native Windows port.
We are planning on contributing the code for the native port sometime next
month (in December). We would have liked to contribute it earlier, but our
work schedules here
Hi,
Firstly , sorry about my poor english, I'll do my best to explain what I
want.
Actually, in most cases, We do query via view, in order to improve
the query speed, we'll create index in physical table field that is mapped
in view's where statement. So, I got an idea to store view statement in a
Any thoughts on how to display the domain constraints in psql?
a=# create domain d as integer not null check (value 4);
CREATE DOMAIN
a=# create domain f as text check (value 'bob') check (value 'zip');
CREATE DOMAIN
a=# \dD
List of domains
Schema | Name | Type | Modifier
I've been wondering (and probably should look through
the code, but figured asking would be faster) if there's
any guarantee that I'll see rows inserted by a transaction
I'm waiting on in the middle of a query.
Basically, if I've got a select that's running using
HeapTupleSatisfiesDirty so that
Pedro M. Ferreira [EMAIL PROTECTED] writes:
[ patch for extra_float_digits ]
I've applied this patch along with followup changes to pg_dump (it sets
extra_float_digits to 2 to allow accurate dump/reload) and the geometry
regression test (it sets extra_float_digits to -3).
I find that two
Dear All,
There are differences in the regression tests for PostgreSQL
7.3b2 with handling of times before 1970. I recently sent out a set of
diffs for the changes. I've looked through the datetime.c code, but
it's not obvious to me what the cause of the change is. PostgreSQL 7.2
works
Robert E. Bruccoleri [EMAIL PROTECTED] writes:
There are differences in the regression tests for PostgreSQL
7.3b2 with handling of times before 1970. I recently sent out a set of
diffs for the changes. I've looked through the datetime.c code, but
it's not obvious to me what the cause of
-Original Message-
From: Bruce Momjian [mailto:pgman;candle.pha.pa.us]
Sent: 08 November 2002 04:54
To: Steve Howe
Cc: Katie Ward; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 port
OK, Steve's vote is enough to indicate that most want to wait
for PeerDirect's version
Dear Tom,
Here's the result of your queries:
template1=# set TimeZone TO 'PST8PDT';
SET
template1=# select abstime 'May 10, 1947 23:59:12';
abstime
1947-05-10 22:59:12-08
(1 row)
template1=# select (abstime 'May 10, 1947 23:59:12')::int4;
int4
On 8 Nov 2002 at 11:03, Florian Litot wrote:
yes it's good but can i have the date with each line?
Err.. I don't think so. Sounds like a good addition to me.
Any ideas?
Bye
Shridhar
--
Absentee, n.: A person with an income who has had the forethought to remove
himself from the sphere
HI All,
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I am confused about this patch. I don't see extra_float_digits defined
anywhere. Am I missing a patch ?
Probably! :)
The definition of extra_float_digits was made in float.c and the diff was sent
to the list and Tom
Many thanks Larry,
Sorry I had omited the -Xb (no secret dance) in my report...
On Thu, 7 Nov 2002, Larry Rosenman wrote:
Date: Thu, 07 Nov 2002 15:17:28 -0600
From: Larry Rosenman [EMAIL PROTECTED]
To: Peter Eisentraut [EMAIL PROTECTED], Olivier PRENANT [EMAIL PROTECTED]
Cc: Tom Lane
Steve:
We know that the readline support is missing from the psql client.
It was missing with the cygwin port as well. We made little to no
effort to work on the client, our focus was on the server.
We have no plans to add the readline support to the client and
hope that the hacker community
Pedro M. Frazao F. Ferreira [EMAIL PROTECTED] writes:
Tom Lane wrote:
Evidently. I have the patch and was planning to apply it myself as soon
as Pedro does something with the geometry types...
Its done.
So it is, dunno what I was thinking. Will work on getting it applied.
Larry Rosenman [EMAIL PROTECTED] writes:
+For compilers earlier than the one released with OpenUNIX 8.0.0(UnixWare
+7.1.2), Including the 7.1.1b Feature Supplement, you may need to specify -Xb
+ in CFLAGS or the CC environment variable. The indication of this is an
+error in compiling
Do y'all want a new diff, or can you deal with it when you do the patch?
LER
--On Friday, November 08, 2002 09:45:44 -0500 Tom Lane [EMAIL PROTECTED]
wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
+For compilers earlier than the one released with OpenUNIX 8.0.0(UnixWare
+7.1.2), Including
Shridhar Daithankar [EMAIL PROTECTED] writes:
On 8 Nov 2002 at 11:03, Florian Litot wrote:
yes it's good but can i have the date with each line?
Err.. I don't think so.
Try the log_timestamp GUC option.
Cheers,
Neil
--
Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC
nobody know if it is possible to have the date in th e same time eache line ?
At 11:14 08/11/02, Shridhar Daithankar wrote:
On 8 Nov 2002 at 11:03, Florian Litot wrote:
yes it's good but can i have the date with each line?
Err.. I don't think so. Sounds like a good addition to me.
Any ideas?
On 10/18/02, Neil Conway [EMAIL PROTECTED] wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
The HAS_CRYPT_R is true because the function is available even without the
prototype, but the struct is not. A plain bug in Perl's configury
mechanism.
Yeah, that's true. The question is whether
On Thu, 2002-11-07 at 19:36, Christopher Kings-Lynne wrote:
Even nastier, what about if the different postgres servers in the cluster
run on different architectures! That way you'd get different floating point
results on each machine...
Oh come on! There's no such thing as perfect anywhere.
I don't know if our code compiles with Mingw. I've never tried it.
Right now, all files are built with MS VC++ 6.0 because that's the
environment that I'm used to, so it's where I can code/debug the fastest.
Katie
-Original Message-
From: [EMAIL PROTECTED]
Dave Page wrote:
-Original Message-
From: Bruce Momjian [mailto:pgman;candle.pha.pa.us]
Sent: 08 November 2002 04:54
To: Steve Howe
Cc: Katie Ward; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 port
OK, Steve's vote is enough to indicate that most want to wait
-Original Message-
From: Bruce Momjian [mailto:pgman;candle.pha.pa.us]
Sent: 08 November 2002 16:10
To: Dave Page
Cc: Steve Howe; Katie Ward; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 port
I hope I didn't sound too unappreciative of the great
contribution PeerDirect is
I will deal with it when I apply.
---
Larry Rosenman wrote:
Do y'all want a new diff, or can you deal with it when you do the patch?
LER
--On Friday, November 08, 2002 09:45:44 -0500 Tom Lane [EMAIL PROTECTED]
Patch applied to 7.3 and CVS, with Tom's correction.
---
Larry Rosenman wrote:
Here is diff. Please let me know if you need better wording.
--On Thursday, November 07, 2002 16:50:26 -0600 Larry Rosenman
[EMAIL
On Thu, 7 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
I am loosing tolerance for these last-minute changes. We should not
You might be, I'm not ... when we finally release v7.3, it will be *as
solid* as our previous releases ...
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
I am loosing tolerance for these last-minute changes. We should not
You might be, I'm not ... when we finally release v7.3, it will be *as
On Fri, 8 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
I am loosing tolerance for these last-minute changes. We should not
You might be, I'm not ...
Marc G. Fournier wrote:
On Fri, 8 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Thu, 7 Nov 2002, Bruce Momjian wrote:
I am loosing tolerance for these last-minute changes. We should not
On Fri, 8 Nov 2002, Bruce Momjian wrote:
The urgency is that we should focus on getting to RC1. The issue is
that we don't have anything to focus on, so why delay?
well, right now, we are waiting for an updated 'supported platforms' list
due to having to put out beta5 :(
I'd be interested to hear results of testing CVS tip (now 7.4devel)
on other platforms. Does geometry pass cleanly for you?
Yes for NetBSD-1.5.1/i386, where it previously didn't due to processor
specific math libraries on this platform.
Giles
---(end of
Marc G. Fournier wrote:
On Fri, 8 Nov 2002, Bruce Momjian wrote:
The urgency is that we should focus on getting to RC1. The issue is
that we don't have anything to focus on, so why delay?
well, right now, we are waiting for an updated 'supported platforms' list
due to having to put out
On Fri, 8 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Fri, 8 Nov 2002, Bruce Momjian wrote:
The urgency is that we should focus on getting to RC1. The issue is
that we don't have anything to focus on, so why delay?
well, right now, we are waiting for an updated
Marc G. Fournier wrote:
On Fri, 8 Nov 2002, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Fri, 8 Nov 2002, Bruce Momjian wrote:
The urgency is that we should focus on getting to RC1. The issue is
that we don't have anything to focus on, so why delay?
well, right now, we
Marc G. Fournier [EMAIL PROTECTED] writes:
tom, do you have as much confidence in your changes as bruce? if so, why
didn't we just go to RC1, instead of a beta?
It's not really do I think these changes are risky? --- it's more
do I think we're done yet? To me, an RC label means we think this
If it matters, i re-ran the regression tests on psql 7.3b5, and it
worked flawlessly, all 89 tests passed.
I didn't install, but it passed the last time (b3).
System:
Redhat Linux 6.2, Alpha EV56, handupgraded to kernel 2.4.19-pre6aa1.
Options used:
./configure \
--disable-rpath \
On Thu, 7 Nov 2002, Tom Lane wrote:
Achilleus Mantzios [EMAIL PROTECTED] writes:
After recreating the missing triggers should i upgrade
to 7.2.3??
Make that before.
I frankly suspect pilot error here. Triggers do not simply disappear.
If you did have crash-induced corruption leading to
39 matches
Mail list logo