> 1) There is a confusion between "LATIN5" and ISO 8859-5. LATIN5 is not
>ISO 8859-5, but is actually ISO 8859-9. Should we rename LATIN5 to
>"ISO8859-5" (or whatever) as the encoding name? I think we should.
>For your information, here are the correct mapping between ISO
>8859-n a
Receiving a request to add ISO 8859-15 and 16, I review the multibyte
support code and found several errors in it.
1) There is a confusion between "LATIN5" and ISO 8859-5. LATIN5 is not
ISO 8859-5, but is actually ISO 8859-9. Should we rename LATIN5 to
"ISO8859-5" (or whatever) as the encod
Christopher Kings-Lynne wrote:
>
> I seem to recall that Oracle has all sorts of fancy resource limits that can
> be applied to users. If such resource limits were implemented, then maybe
> the DBA could have the power to limit someone to a maximum of 20% cpu and a
> few transactions per second
Chris,
Current sources for the jdbc driver does support the bytea type.
However the driver for 7.1 does not.
thanks,
--Barry
Chris Bitmead wrote:
> >Use bytea, its for 0-255, binary data. When your client
> >library does not support it, then base64 it in client side
> >and later decode()
>Use bytea, its for 0-255, binary data. When your client
>library does not support it, then base64 it in client side
>and later decode() into place.
Thanks, bytea sounds like what I need. Why no documentation on this
important data type?
Does the Java client library support setting this typ
> As said in another mail, I have tried to add iso-8859-15 (Latin 9) &
> iso-8859-16 (Latin 10) to PostgreSQL, I think I have done mostly all
> that's necessary. But I miss two things :
ISO-8859-15 and 16! I don't know anything beyond ISO-8859-10. Can you
give me any pointer (URL) explaining what
On Wed, Oct 10, 2001 at 11:33:04AM +1000, Chris Bitmead wrote:
> So my question is, I assume TEXT is the best data type to store
> large things in, what precisely is the range of characters that
> I can store in TEXT? Is it only characters ascii <= 127, or is
> it only printable characters, or eve
I seem to recall that Oracle has all sorts of fancy resource limits that can
be applied to users. If such resource limits were implemented, then maybe
the DBA could have the power to limit someone to a maximum of 20% cpu and a
few transactions per second or something.
Chris
> -Original Mess
It should be noted that there is still a limit of about 1GB if I
remember correctly.
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: "Chris Bitmead" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Hi,
Now that postgresql doesn't have field size limits, it seems to
me they should be good for storing large blobs, even if it means
having to uuencode them to be non-binary or whatever. I don't
like the old large object implementation, I need to store very large
numbers of objects and unless thi
In my understanding below row value constructors(I hope this term is
correct) exaples should return true, but PostgreSQL does not.
test=# select (1,0) > (0,0);
?column?
--
f
(1 row)
test=# select (0,1) > (0,0);
?column?
--
f
(1 row)
In my understanding, (a,b) > (c,d) is equ
Tom Lane writes:
> I believe the primary reason why PL languages aren't installed by
> default is security considerations
Well, that argumentation seems to be analogous to giving someone login
access on a multiuser computer system but not letting him execute, say,
perl because he might write rec
Just updated...
peter=# SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');
ERROR: Timestamp with time zone units 'dow' not recognized
This is documented to work.
peter=# SELECT EXTRACT(DOW FROM TIME '20:38:40');
ERROR: Interval units 'dow' not recognized
The expression is nonsensical,
Dave Blasby writes:
> I've noticed that text(bool) isnt a defined function (nor does
> 'true'::bool::text work).
case when value then 'answer if true' else 'answer if false' end
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of bro
I've noticed that text(bool) isnt a defined function (nor does
'true'::bool::text work).
It would be great to have this defined.
Since "select 'false'::bool" gives 'f' and "select 'true'::bool" gives
't', perhaps text(bool) should return 't' or 'f'.
A case can, also, be given for returning 'tr
Ilya,
check your system locale - does simple perl script works properly
Oleg
On Tue, 9 Oct 2001, Korshunov Ilya wrote:
> Hello!
> I have a trouble with PostgreSQL 7.1.3 (and 7.1.2 too). My OS is Solaris 8x86 with
>russian locale. PostgreSQL was builded from sources and configured with
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Jean-Michel POURE writes:
>> It is sometimes tricky for Windows users to install a language remotely on
>> a Linux box (no access to createlang and/or no knowledge of handlers).
> Why not run createlang on the host that the server runs on?
I wasn't
Jean-Michel POURE writes:
> It is sometimes tricky for Windows users to install a language remotely on
> a Linux box (no access to createlang and/or no knowledge of handlers).
Why not run createlang on the host that the server runs on?
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.
Hello!
I have a trouble with PostgreSQL 7.1.3 (and
7.1.2 too). My OS is Solaris 8x86 with russian locale. PostgreSQL was builded
from sources and configured with : --enable-locale --enable-multibyte=WIN.
My problem with sorting lowercase russian
words in the text fields (type - "varchar"
On Mon, 8 Oct 2001, Lamar Owen wrote:
> On Friday 05 October 2001 07:48 pm, John Summerfield wrote:
> > On Fri, 5 Oct 2001, Lamar Owen wrote:
> > I made it clear I was getting frustrated. Read in that context, I think it
> > was pretty mild;-)
>
> But it was done in an uninformed way. Had you
On Mon, 8 Oct 2001, Bruce Momjian wrote:
> Are we ready for beta on Wednesday? I don't know anything holding us up
> at this point. Seems like major work has stopped and everyone is ready
> to start testing.
Well, if that build problem I reported doesn't bother you;-)
I think it's likely to
Hi,
I've seen no answer to your question within four days.
Have you solved it on your own?
I'm interested in the stuff you asked for, too.
Please let me know about the status of the function.
If you haven't got any answer, maybe we should try to get
one using a clearer mail subject.
Regards
22 matches
Mail list logo
