Yesterday I was a bit worried... I switched to SuSE just 2 weeks ago...
my newly installed databse server was waitinI thought that I would have
to wait so much to have RPMs for SuSE and today I see v7.4 compiled for
many flavors of SuSE, even for X86-64. Wow :)
Thanks :)
--
Daniele Orlandi
whose behaviour would be always consistent,
locale-indepentent... (like the very-first C's strcmp).
Which do you think should be the correct approach ?
Thanks in advance!
Best regards!
--
Daniele Orlandi
Planet Srl
---(end of broadcast
rows)
template1=# explain select * from a where a=true;
QUERY PLAN
--
Index Scan using a_a on a (cost=0.00..2.01 rows=1 width=11)
Index Cond: (a = true)
(2 rows)
Bye!
--
Daniele Orlandi
Planet Srl
Stephan Szabo wrote:
On Thu, 21 Nov 2002, Daniele Orlandi wrote:
Are those two syntaxes eqivalent ?
select * from users where monitored;
select * from users where monitored=true;
If the answer is yes, the optimimer probably doesn't agree with you :)
That depends on the definition
IS TRUE and var IS FALSE (not var
IS NOT ...) which already are special syntax cases if I am not wrong.
--
Daniele Orlandi
Planet Srl
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
, including aborting open
transaction to allow for better connection pooling and reusing, maybe
giving the client the ability to switch between users...
Bye!
--
Daniele Orlandi
Planet Srl
---(end of broadcast)---
TIP 2: you can get off all lists
?
Anyway... may I suggest adding CRCs to the data ? I just discovered that
I had a faulty HD controller and I fear that something could have been
written erroneously (this could also help to detect faulty memory,
though only in certain cases).
Bye!
--
Daniele Orlandi
Planet Srl
---
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
---
with -e and with "set datestyle" with no
change.
Context: Postgresql 7.0.3 on RedHat Linux 7.0 - Kernel 2.4.0-test10 -
Glibc 2.1.94 and 2.2
Thanks!
Bye!
--
Daniele Orlandi
:)
Bye!
--
Daniele
---
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
---
!
--
Daniele Orlandi
"Ross J. Reedstrom" wrote:
Not to mention the recent thread here about people recovering data that
was accidently deleted, or from damaged db files: the old tuples serve
as redundant backup, in a way. Not a real compelling reason to keep a
non-overwriting smgr, but still a surprise bonus
Alfred Perlstein wrote:
If you're talking about vacuum, you really don't want to do this,
No, I'm not talking about vacuum as it is intended now, it's only a
process that scans tables to find available blocks/tuples. It is
virtually optional, if it doesn't run, the database will behave just
Sébastien Bonnet wrote:
Hi all, and mainly postresql developpers,
I've been reading old posts about the libpq interface related to multi-process
application. The main problem being that after a fork, each process has a DB
connexion, actually the same. If one closes it, the other one
need to reveal an error, I would consider it enought.
Bye!
--
Daniele
---
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
---
Daniele
-------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
---
Nathan Myers wrote:
It wouldn't help you recover, but you would be able to report that
you cannot recover.
While this could help decting hardware problems, you still won't be able
to detect some (many) memory errors because the CRC will be calculated
on the already corrupted data.
Of course
17 matches
Mail list logo