[EMAIL PROTECTED] writes:
Hmm, a little late here, but why not just unbuffer stdout, or are there
reasons to preserve some buffering?
Would that resolve the interlaced output issues with readline?
I doubt it, but you could try it to see ...
I am more inclined to go with the rewrite of
On Mon, 2003-07-28 at 17:27, Alvaro Herrera wrote:
The processes with the W status are swapped out. In some Linux versions
and maybe some other platforms, swapped out processes have the
/proc/pid/cmdline file truncated, so ps uses the /proc/pid/exe
symlink instead, which does know what
LitelWang wrote:
It is useful for me to use Chinese tone sort order .
Any version on Cygwin?
Thanks for any advice .
I never try GB18030 in Cygwin, but in Linux or other Unix system,
you may use gb18030 as client side encoding and use UNICODE as
backend encoding, and it's pretty good.
Ron thank you for your comments, sorry of the slow response - i
actually replied to you on saturday but i think the list was having
trouble again?!
Your questions are answered below...
On Fri, 2003-07-25 at 07:42, [EMAIL PROTECTED] wrote:
As mentioned previously I have a large text database
[EMAIL PROTECTED] writes:
Hmm, a little late here, but why not just unbuffer stdout, or are there
reasons to preserve some buffering?
Would that resolve the interlaced output issues with readline?
I doubt it, but you could try it to see ...
regards, tom lane
On Mon, Jul 28, 2003 at 12:36:29PM +0200, Andre Truter wrote:
I have PostgreSQL 7.3.2 server running.
I could normally view the sessions by doing
'ps auxww | grep ^postgres' like the documentation states.
But, recently it is not showing me expected output anymore.
THis is what I get:
Hi @ all,
i've a little problem with two tables and FOREIGN KEYs. I've read about
this long time ago, but didn't remember me where. Well, I hope you can
help me.
I've create two TABLEs counties and cities. Countries have a row
capital is REFERENCEd cities. cities have a row country
Bruce Momjian [EMAIL PROTECTED] writes:
Now, adding a YYMMDDD mode (not to be confused with MMDD) to
datestyle is a feature addition to me. I am not sure if anyone wants
it, though.
Well, we now saw one person besides me who wants it, so that's good
enough for me ;-). I'll take
Hi!
I have a doubt, I have somethigs same this...
init transaction
update from tabla1 set estado=1 where art=0;
update from tabla1 set estado=estado+1 where estado=1
final trasaction
The second update take the first updates if we are in the same transaction?
Tk
Date: Mon, 28 Jul 2003 10:11:52 -0400
From: Tom Lane [EMAIL PROTECTED]
That was what the pre-7.2 coding did, and it was broken. Types abstime
and char are counterexamples in one direction, and float8 and numeric
are counterexamples in the other. (And that's not even considering
kay-uwe.genz wrote:
Hi @ all,
i've a little problem with two tables and FOREIGN KEYs. I've read about
this long time ago, but didn't remember me where. Well, I hope you can
help me.
I've create two TABLEs counties and cities. Countries have a row
capital is REFERENCEd cities. cities have a
kay-uwe.genz wrote:
Hi @ all,
i've a little problem with two tables and FOREIGN KEYs. I've read
about this long time ago, but didn't remember me where. Well, I hope
you can help me.
I've create two TABLEs counties and cities. Countries have a row
capital is REFERENCEd cities. cities have a
On Mon, 28 Jul 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Now, adding a YYMMDDD mode (not to be confused with MMDD) to
datestyle is a feature addition to me. I am not sure if anyone wants
it, though.
Well, we now saw one person besides me who wants it, so that's
On Mon, 28 Jul 2003, kay-uwe.genz wrote:
i've a little problem with two tables and FOREIGN KEYs. I've read about
this long time ago, but didn't remember me where. Well, I hope you can
help me.
I've create two TABLEs counties and cities. Countries have a row
capital is REFERENCEd cities.
Is there an easy way to remove 'traditional-cpp' from the whole build?
See src/template/darwin. Whatever change is needed, it probably will be
in that file or src/makefiles/Makefile.darwin (or possibly
src/include/port/darwin.h). Let us know what you find out ...
BTW: the template file is
Hunter Hillegas [EMAIL PROTECTED] writes:
Jaguar 10.2.6.
Okay, I think I was still on 10.2.4. I won't be able to try 10.2.6 till
my laptop gets fixed.
Is there an easy way to remove 'traditional-cpp' from the whole build?
See src/template/darwin. Whatever change is needed, it probably will
any chance of 7.3.4 rpms anytime soon?
i looked at trying to build something myself, but the source distribution
doesn't seem to include the mechanisms. many of the defaults (like
--prefix) seem to be tweaked a little.
also, it'd be nice to have a source RPM somewhere, i'm looking at building
Jaguar 10.2.6.
The differences is most likely the latest compilers, GCC 3.3 from Apple. You
can get them from their developer site.
Supposedly the new compiler generates MUCH better PPC code, so I was hoping
to use it.
Is there an easy way to remove 'traditional-cpp' from the whole build?
On Mon, 2003-07-28 at 11:28, [EMAIL PROTECTED] wrote:
Ron thank you for your comments, sorry of the slow response - i
actually replied to you on saturday but i think the list was having
trouble again?!
Your questions are answered below...
On Fri, 2003-07-25 at 07:42, [EMAIL PROTECTED]
Hi,
surely you are right. I´m still using 7.2.3 as production database, so I
have no experience with .pgpass. Where to put .pgpass if you use pg_dump
from a PHP script and the database user is not a system user?
Greetings,
Frank Finner
On Fri, 25 Jul 2003 17:17:26 -0400 Andrew Sullivan
[EMAIL
Stephan Szabo wrote:
On Mon, 28 Jul 2003, kay-uwe.genz wrote:
i've a little problem with two tables and FOREIGN KEYs. I've read about
this long time ago, but didn't remember me where. Well, I hope you can
help me.
I've create two TABLEs "counties" and "cities". "Countries" have
Jonathan Bartlett wrote:
Why not just drop the references clause? I mean, the point of having
transactions is to guarantee integrity within a transaction, if you're not
going to have that, why even bother with the clause?
Quite the opposite - the point is to guaratee the integrity *outside*
the
scott.marlowe wrote:
On Mon, 28 Jul 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Now, adding a YYMMDDD mode (not to be confused with MMDD) to
datestyle is a feature addition to me. I am not sure if anyone wants
it, though.
Well, we now saw one person
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
So this means that when you have YMD, that 03-01-01 is Jan 1, 2003?
That's the idea.
I assume that the datestyle has to be set to YMD for this to work as
outlined above, right, and that 97-01-01 will throw an error unless the
datestyle
Title: iColony - Departamento de Projetos
Paulo Fabrício Puga
MirandaDesenvolvimento de TIfabricio
@icolony.com.br(31) 9691-3494
Bruce Momjian [EMAIL PROTECTED] writes:
So this means that when you have YMD, that 03-01-01 is Jan 1, 2003?
That's the idea.
BTW, is the second version of Greg's patch on your unapplied-patches
page the latest one? I wasn't keeping track.
regards, tom lane
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Now, adding a YYMMDDD mode (not to be confused with MMDD) to
datestyle is a feature addition to me. I am not sure if anyone wants
it, though.
Well, we now saw one person besides me who wants it, so that's good
enough for me
have a table
title, description, keywords
which I am searching (from PHP) using a keyword
What I want to do is sort the results based on the number of hits nd scoring
based on where the hit is. For example, a hit in keywords is worth 5, title is
worth 3, description is worth 1.\
I
Why not just drop the references clause? I mean, the point of having
transactions is to guarantee integrity within a transaction, if you're not
going to have that, why even bother with the clause?
Most of my databases don't even user references, just because I like the
flexibility, and I have
--On Monday, July 28, 2003 15:48:39 -0400 Bruce Momjian
[EMAIL PROTECTED] wrote:
scott.marlowe wrote:
On Mon, 28 Jul 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Now, adding a YYMMDDD mode (not to be confused with MMDD) to
datestyle is a feature addition to me. I am
Hi there:
I am just wondering if this is a doable method to
clone a database to other machine. I have three identical linux serves with
postgresql server installed at the same location. I have a new customized
database and initial data load into server 1. Can I just copy all of the
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I assume that the datestyle has to be set to YMD for this to work as
outlined above, right, and that 97-01-01 will throw an error unless the
datestyle is YMD.
Right, no more heuristics (other than assuming -MM-DD if the first
Bruce Momjian [EMAIL PROTECTED] writes:
I assume that the datestyle has to be set to YMD for this to work as
outlined above, right, and that 97-01-01 will throw an error unless the
datestyle is YMD.
Right, no more heuristics (other than assuming -MM-DD if the first
field is written with
33 matches
Mail list logo