Just a reminder that I assume all Hackers readers are subscribed to
either the PostgreSQL announce or general lists.
I just posted something to those lists about this URL:
http://candle.pha.pa.us/oreilly/
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PRO
Embedded zeroes aren't supported in
> char/varchar/text fields,
> and cannot be supported in a portable fashion, since
> these datatypes
> rely on functions like strcoll() that don't allow
> embedded nulls in
> strings. It wouldn't surprise me too much if there
> are inconsistent
> behaviors bet
m w <[EMAIL PROTECTED]> writes:
> I think this exposes a bug in postgres where either
> index or table scans (I'm not sure which just yet)
> treat a zero differently than a non-zero in a varchar.
Embedded zeroes aren't supported in char/varchar/text fields,
and cannot be supported in a portable f
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> m w <[EMAIL PROTECTED]> writes:
> > Here is the problem: Depending on whether there is
> an
> > index or not, 'like' behaves differently.
>
> Please provide a complete, self-contained example
> with which
> we can reproduce the problem.
I am trying to c
Bruce Momjian <[EMAIL PROTECTED]> writes:
> *** src/interfaces/ecpg/preproc/pgc.l 2001/01/24 19:43:29 1.73
> --- src/interfaces/ecpg/preproc/pgc.l 2001/02/02 18:13:17
> ***
> *** 35,40
> --- 35,45
> #undef yywrap
> #endif /* yywrap */
> + #ifdef __QNX__
> + /* For
"Barnes, Sandy (Sandra)" <[EMAIL PROTECTED]> writes:
>> Normally, this works fine, but sometimes we get the error
>>
>> "Database 'products', OID nnn, has disappeared from pg_database"
>>
>> where nnn is some number, and forever afterwards we can't access a
>> database with that name. Removing
m w <[EMAIL PROTECTED]> writes:
> Here is the problem: Depending on whether there is an
> index or not, 'like' behaves differently.
Please provide a complete, self-contained example with which
we can reproduce the problem.
regards, tom lane
I acknowledged the bad nature of the money field (pretty clearly stated in
my email, I think).. I agree, it shouldn't contain a sign of anything.. My
applications are used in the US and in the US only so I don't have issue
with the currency symbol. I don't use the money type anyway (the example I
On Sat, Feb 03, 2001 at 11:39:29AM -0500, Mitch Vincent wrote:
> What's the standard on Money type (if there is one) and if it doesn't
> include the $ (of course that would change based on what currency you were
> using) then is it any different than numeric(9,2)? numeric(9,2) is what I
> use for
On Sat, 3 Feb 2001, Peter Mount wrote:
> It's been a while since I delved into the backend, but unless it's
> changed from fork() to threading, I don't really see this happening,
> unless someone who knows C that well knows of a portable way of
> communicating between two processes - other than R
Peter Mount writes:
> Thats correct. Basically you are talking of something like PL/Java. The
> Java side would be simple, but its linking the JVM to the backend that's
> the problem.
I've tried that recently, here's how it looks as far as Linux JVMs go:
* Kaffe has a very polluted name space.
Just a question on this for my own personal satisfaction...
What's the standard on Money type (if there is one) and if it doesn't
include the $ (of course that would change based on what currency you were
using) then is it any different than numeric(9,2)? numeric(9,2) is what I
use for all fields
Jun Kuwamura writes:
> (1) KTH-KRB4(Kerberos4) require -lresolve to configure.
Exact name of the symbol required?
> (2) No OpenSSL library path in generated Makefile in
> src/interfaces/python. -L/usr/local/ssl/lib must be
> added by hand.
Will fix that.
--
Peter Eisentraut [EMAIL
On Wed, 31 Jan 2001, Bruce Momjian wrote:
> A San Francisco company wants to hire a PostgreSQL developer to work on
> improving the database, and to do some work for the company. I am here
> at LinuxWorld right now with the CIO of the company.
>
> The candidate should be based in North America
I have tested and works well.
.
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Maurizio" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 7:21 PM
Subject: Re: [HACKERS] 7.1 beta 3 CHANGES FOR QNX
> I have applied the following patch for QN
It works! Our production controlling system seems to work with
7.1beta4. In addition, I solved the conversion function problem which was
described in one of my last mails. The problem was I used malloc() instead
of palloc(). Thanks to all of you who developed 7.1 and helped solving the
conversion
At 12:55 02/02/01 -0400, The Hermit Hacker wrote:
>On Fri, 2 Feb 2001, Peter T Mount wrote:
>
> > When did the MONEY type change it's output format?
> >
> > While working on the JDBC test suite, Money broke. It seems to output:
> > $10.99
> > ($10.99) for negative values
> >
> > While since ages p
At 12:07 02/02/01 -0500, Mitch Vincent wrote:
>hhs=> select version();
>version
>---
>PostgreSQL 6.4.2 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2.
[snip]
> If it changed, it looks like it changed a long time ago! :-)
Hmm,
At 14:57 02/02/01 -0500, Alex Pilosov wrote:
>On Fri, 2 Feb 2001, tomasz konefal wrote:
>
> > could someone please clarify what "Allow Java
> > server-side programming" actually means? what are the
> > limitations of using java and jdbc with pgsql?
>
>It means to embed Java interpreter inside p
19 matches
Mail list logo
