Bruce Momjian <[EMAIL PROTECTED]> writes:
> We added GUC update_process_title (default is 'on') in 8.2 based on
> tests Tom ran showing that there was a performance impact for the
> process title. With the new use of strlcpy(), is there still an impact
> from process title? Tom, would you run you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, Sep 30, 2006 at 01:00:05PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
[...]
> Oh BTW: 10^14 is not enough dynamic range --- those guys push around
> *serious* amounts of money. Bill Gates' net wealth is somewhere north
>
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> I think the switches are confusing ... when you are using libedit, you
>> certainly don't want readline as well, so it seems natural to disable
>> it. I understand that what --without-readline really does is turn the
>> line-editing c
Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> It seems I am unable to compile libedit support in -HEAD
>
> On what platform, and with what version of libedit? I built HEAD just
> yesterday on a vanilla Darwin/Intel 10.4.7 machine with Apple's libedit.
>
>> Configured with:
>
We added GUC update_process_title (default is 'on') in 8.2 based on
tests Tom ran showing that there was a performance impact for the
process title. With the new use of strlcpy(), is there still an impact
from process title? Tom, would you run your tests again? Thanks.
--
Bruce Momjian [EM
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I think the switches are confusing ... when you are using libedit, you
> certainly don't want readline as well, so it seems natural to disable
> it. I understand that what --without-readline really does is turn the
> line-editing capability off in gener
Stefan Kaltenbrunner wrote:
> Tom Lane wrote:
> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> >> It seems I am unable to compile libedit support in -HEAD
> >
> > On what platform, and with what version of libedit? I built HEAD just
> > yesterday on a vanilla Darwin/Intel 10.4.7 machine with A
Josh Berkus writes:
> Some change which was made in the last couple weeks broke select for update
> with an outer join:
> NestedException: org.postgresql.util.PSQLException: ERROR: SELECT FOR
> UPDATE/SHARE cannot be applied to the nullable side of an outer join
What SQL query is it complainin
Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> It seems I am unable to compile libedit support in -HEAD
>
> On what platform, and with what version of libedit? I built HEAD just
> yesterday on a vanilla Darwin/Intel 10.4.7 machine with Apple's libedit.
we have (a bit of) buil
All,
Some change which was made in the last couple weeks broke select for update
with an outer join:
Please examine the SQLException for more information.
NestedException: org.postgresql.util.PSQLException: ERROR: SELECT FOR
UPDATE/SHARE cannot be applied to the nullable side of an outer join
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> It seems I am unable to compile libedit support in -HEAD
On what platform, and with what version of libedit? I built HEAD just
yesterday on a vanilla Darwin/Intel 10.4.7 machine with Apple's libedit.
> Configured with:
> ./configure --with-libedit
There'll also times a country may transit from one currency to
another. Even a currency (currency of most continental European
countries before Euro) is no more being used, it may still need to
be supported.
The "money" type is far too simplistic to model this kind of thing. A
really sophistic
That seems right, there won't be a performance impact unless the warnings are
issued.
- Luke
Msg is shrt cuz m on ma treo
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 30, 2006 01:48 PM Eastern Standard Time
To: Stephen Frost
Cc: pgsq
Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> Here is adminpack...
>
> Applied with minor corrections (the .sql file is DATA not DATA_built,
> as you'd have found out if you'd tried "make clean"). Likewise for
> the pgrowlocks script.
Noted, thanks.
>
>
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Here is adminpack...
Applied with minor corrections (the .sql file is DATA not DATA_built,
as you'd have found out if you'd tried "make clean"). Likewise for
the pgrowlocks script.
regards, tom lane
Hello,
It seems I am unable to compile libedit support in -HEAD
t -lpgport -L../../../src/interfaces/libpq -lpq -L../../../src/port
-Wl,-rpath,'/usr/local/pgsql/lib' -lpgport -lz -lcrypt -ldl -lm -o psql
input.o: In function `pg_send_history':
input.c:(.text+0x10d): undefined reference to `add_
"Claudio Natoli" <[EMAIL PROTECTED]> writes:
> Magnus Hagander writes:
>> Now, I still twist my head around the lines:
>> if ((fd = _open_osfhandle((long) h, fileFlags & O_APPEND)) < 0
>> ||
>> (fileFlags & (O_TEXT | O_BINARY) && (_setmode(fd,
>> fileFlags & (O_TEXT | O_BINARY)) < 0)))
> Without h
Stephen Frost <[EMAIL PROTECTED]> writes:
> When loading a rather large data set I started getting errors along
> these lines:
> psql:/home/sfrost/school/cs750/reality/dump-anonymized.postgres.sql:262:
> WARNING: nonstandard use of escape in a string literal
> LINE 1: ...XX ,9:9:99
David Fetter <[EMAIL PROTECTED]> writes:
> The "money" type is far too simplistic to model this kind of thing. A
> really sophisticated representation of money would have to take time,
> inflation/deflation, pairwise exchange rates, etc. into account. It
> would look more like a schema with a lar
On Sat, Sep 30, 2006 at 11:36:04AM -0400, Xiaofeng Zhao wrote:
> >I feel silly for even mentioning this, but there are less than 256
> >countries in the UN, and as far as I know, each has at most one
> >currency, so you could use 8 bits instead of 15.
> >
> That's not always true, e.g. China has RM
I feel silly for even mentioning this, but there are less than 256
countries in the UN, and as far as I know, each has at most one
currency, so you could use 8 bits instead of 15.
That's not always true, e.g. China has RMB and HKD. Also Taiwan is not a
member country of UN but I don't think one
Hi, Tom,
Tom Dunstan wrote:
>> On a unix box, when you're really crazy, and want to ignore all security
>> restrictions, you could even install pg_dump via inetd, and then
>> everyone connecting via TCP on the appropriate port gets a dump of the
>> database. :-)
>
> Oh, man, my head just explode
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Sep 29, 2006 at 10:43:53PM -0700, David Fetter wrote:
> On Sat, Sep 30, 2006 at 04:42:13AM +, [EMAIL PROTECTED] wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Fri, Sep 29, 2006 at 12:19:07PM +0200, Martijn van Oost
23 matches
Mail list logo
