Hi all,
I have my pgsql 7.0.2 with such configure
--enable-locale --enable-multibyte=EUC_TW
and I created a db with "createdb -E EUC_TW testdb,
however, I got "¦w" instead of "¦W" in chinese display.
any idea?
Thanks
Dave
Hello,
What would be the most effective way of preforming a case-insensitive LIKE
query? I've notived that MySQL somehow ALWAYS does it case insensitive,
which is not very smart, but I should expect this feature to exist without
reasonable pain on the programmer;s end?
Yann
--
---
On Mon, Oct 30, 2000 at 07:59:06PM -0500, Keith L. Musser wrote:
> "(SELECT messages.msgid FROM messages, subject_index WHERE
> ((subject_index.word='Hello' or subject_index.word='There') and
> (subject_index.msgid = messages.msgid))
> GROUP BY messages.msgid HAVING count(messages.msgid)=2)
> INTE
> Whenever a query is executed (not found in cache, etc.), the caching
> system would simply store the query, the results, and a list of tables
> queried. When a new query came in, it would do a quick lookup in the
query
> hash to see if it already had the results. If so, whammo. Whenever
I was the original poster. Really my confusion stemmed
from the fact that upgrading from RH6.0 to RH7.0, 7.0
complained (during boot) that my Postgress verision was outdated
I need to upgrade. This threw me off.
In general I am pretty pissed at RH attitude to system
upgrade, if I were working
> >(Incidentally, we've toyed around with developping a
query-caching
> > system that would sit betwen PostgreSQL and our DB libraries.
>
> Sounds amazing, but requires some research, I guess. However, in
many
> cases one would be more than happy with cahced connections. Of
cour
Adam Lang wrote:
> Which leads me to a question. Why do so many people ask the list where the
> most current RPMS for Redhat are located? Not trying to start trouble, but
> doesn't it seem obvious to check the Redhat site? Just wierd that so many
> people ask where to find them...
Well, we mai
At 06:31 PM 31/10/00, Lamar Owen wrote the following message:
Bryan White wrote:
> pg_check is a command line tool I have written to aid is diagnosing and
> recovering from PostgreSQL table corruptions. See the ReadMe file for more
> information.
Fascinating. Looks like a possible framework f
Yeah I know. I mentioned the redhat website when I first replied to the
post.
Which leads me to a question. Why do so many people ask the list where the
most current RPMS for Redhat are located? Not trying to start trouble, but
doesn't it seem obvious to check the Redhat site? Just wierd that
Hi,
Is there any convenient way to get what input qualifies as valid data
for a CHECK constraint? I'm trying to generalise an interface which
allows data entry through the Web. I'd like to be able to find out
what data is allowed in a field, and then generate a pick-list based
on that. It look
> As programmers, we naturally want to throw things into databases for
> three reasons. First, it's easy to get data in. Second, it's easy to get
> relevant data out. And third, it's "cool". We don't want to work with
> flat files, now do we? ; )
Kiddin', eh? :) Actually, the third re
shawn everett wrote:
> I may be horriblly out of my element here but, I'm going to jump in anyway
> :)
>
> If you mount a floppy and copy a large file to it, you will get a prompt
> back fairly quickly.
>
> If you type: sync right after
>
> The sync command writes everything to the floppy as expe
Steve Wolfe wrote:
>
> > Even after that, you have a long way to go before you will hit 1000
> > transactions per second from any SQL database.
>I guess they could always buy a few Sun E1's on the backend, and a
> large room of rack-mountable PC's for web/CGI serving. Nothing like
> plo
> Even after that, you have a long way to go before you will hit 1000
> transactions per second from any SQL database.
I guess they could always buy a few Sun E1's on the backend, and a
large room of rack-mountable PC's for web/CGI serving. Nothing like
plopping down ten or twenty millio
> Even after that, you have a long way to go before you will hit 1000
> transactions per second from any SQL database.
Since my last post probably wasn't too useful, here's some information
that might be a little more help. It's a little long, I know, but hopefully
it will be of use to som
Hello!
I run pgsql on one host just to host phorum (excellent php-based forum
package - www.phorum.org) and today I noticed this in errlog:
NOTICE: Unrecognized variable query_limit
Since I only use phorum there I checked with grep if phorum tries to use
some unknown commands, but co
> Or they could buy a single IBM S/390, run Linux/390 and PostgreSQL on
> that. Probably would cost less, and be more reliable. And they can
> always load another Linux/390 VM -- an S/390 can run something like
> 41,000 virtual machines each running Linux/390 and Apache.
Yeah I'm very opt
"Gary Howland (During daytime)" wrote:
> Just a quickie - I heard that linux does not have a working fsync()
> call (it has no concept of raw devices). In other words, fsync cannot
> be used to ensure that data is on disk (try it with a floppy - it
> returns IMMEDIATELY!!! - long before the writ
I may be horriblly out of my element here but, I'm going to jump in anyway
:)
If you mount a floppy and copy a large file to it, you will get a prompt
back fairly quickly.
If you type: sync right after
The sync command writes everything to the floppy as expected.
Shawn
On Tue, 31 Oct 2000, ma
"Gary Howland (During daytime)" wrote:
> Hi,
>
> Just a quickie - I heard that linux does not have a working fsync() call
> (it has no concept of raw devices). In other words, fsync cannot be used
> to ensure that data is on disk (try it with a floppy - it returns IMMEDIATELY!!! -
>long before
Arnold Gamboa wrote:
> Hi,
>
> For users of large PostgreSQL and PostgreSQL builders, this is for you.
>
> I'm having a terrible time deciding now. :(
>
> We're about to build a "huge" website now. I got tied up in signing the
> contract without really getting enough information about PgSQL sinc
Bryan White wrote:
> pg_check is a command line tool I have written to aid is diagnosing and
> recovering from PostgreSQL table corruptions. See the ReadMe file for more
> information.
Fascinating. Looks like a possible framework for building a standalone
dumping utility.for migration
-
> Fascinating. Looks like a possible framework for building a standalone
> dumping utility.for migration
It could be turned into that. It already does all the parsing, you would
just have to change the output functions for the desired format.
> I tried to increase the block size from 8K to 32K and received a IPC
error.
> Now IPC is compiled into the Kernel so why would I get this error. I
> switched it back to 8K and it runs fine.
Did you dump your database(s) before the change and initdb/reload them
after? I presume this is needed a
I sent this to the 'announce' list earlier but it did not show up. My guess
is that list is moderated so I will post again here.
--
pg_check is a command line tool I have written to aid is diagnosing and
recovering from PostgreSQL table corruptions. See the ReadMe file for more
information.
It
I tried to increase the block size from 8K to 32K and received a IPC error.
Now IPC is compiled into the Kernel so why would I get this error. I
switched it back to 8K and it runs fine.
Mark
On Tue, 31 Oct 2000, Steve Wolfe wrote:
> Interesting... trying to start postgres 7.0.2 with the "-F" simply returns
> a list of options to me, as if it can't understand it. It sure does sound
> appealing to me, though. With a few hundred megs of disk cache (between the
> kernel and the RAID
> Use the "-F" option.
>
> I start PostgreSQL with this line:
> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o
> '-i -B 4096 -o -F' start >/dev/null 2>&1" < /dev/null
Interesting... trying to start postgres 7.0.2 with the "-F" simply returns
a list of options to me, a
Use the "-F" option.
I start PostgreSQL with this line:
su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o
'-i -B 4096 -o -F' start >/dev/null 2>&1" < /dev/null
Poul L. Christiansen
Kevin O'Gorman wrote:
>
> I must have missed that one. How do you turn off fsync()??
> I
I must have missed that one. How do you turn off fsync()??
I have lots of batch loading to do during which ACID is of no use.
++ kevin
"Poul L. Christiansen" wrote:
>
> Strange.
>
> I did a test on Redhat Linux 7.0 with fsync() turned off and my
> batchfile of inserts ran 10 times as fast.
Where can I download the 7.1 snapshot?
Thanks
Douglas
On 9 Oct 2000 23:46:29 -0400, [EMAIL PROTECTED] (Tom Lane) wroth:
>"Ally" <[EMAIL PROTECTED]> writes:
>> However, I've read that Postgres 7.1 / 7.2 will accomodate larger row sizes
>> and was wondering if there was a ballpark ETA / release da
Hello,
My company is thinking about converting from Sybase to PostgresQL. We have
PostgresQL 7.0.2 installed and are trying to convert our tables, triggers and
stored procedures to it.
We are having the most trouble with triggers and stored procedures (functions).
If anyone could answer our quest
"Sergio A. Kessler" wrote:
> i was reading in the docs that that for syslog
> (ie. syslog = 2 in pg_options) to effectively work, you need to build
> postgres with --enable-syslog
PostgreSQL 7.0.2 has no --enable-syslog switch. 7.1 (and, apparently
7.0.3) will have such a configure switch (it ex
Adam Lang wrote:
>
> But it don't help if you downloaded the OS. ;)
If you downloaded the RedHat CD ISO images, OR the ftp dirs, you got the
postgresql RPM's, unless you specifically excluded them.
And you can certainly get them from RedHat's ftp site, as busy as it is.
--
Lamar Owen
WGCR Inter
Strange.
I did a test on Redhat Linux 7.0 with fsync() turned off and my
batchfile of inserts ran 10 times as fast. But that was on an slow PC
with a slow IDE harddrive.
What Linux distribution and kernel version are you running?
Poul L. Christiansen
"Gary Howland (During daytime)" wrote:
>
>>Frank asked: What's this 'CONFIRM' message all about anyway?
>
>Scappy replied: It was just me attempting to fix ppls
>subscription settings after the upgrade, without realizing
>it would email out to everyone ... sorry about that :(
>>Frank: Does this mean we don't actually do the CONFIRM's
On Tue, 31 Oct 2000 [EMAIL PROTECTED] wrote:
> I tried the links and got an error that said postgresql.org didn't exist or
>something of that nature. Anybody else get that and what do you do to correct it?
>Thanks.
It was easiest to respond by mail so I never even tried the web interface.
Vi
"Adam Lang" <[EMAIL PROTECTED]> writes:
> But it don't help if you downloaded the OS. ;)
You can of course find it on the ftp site as well, in the RPMS directory.
--
Trond Eivind Glomsrød
Red Hat, Inc.
38 matches
Mail list logo
