This is the problem:
***
./expected/rules.out Fri May 3
08:32:19 2002--- ./results/rules.out Sun Jun 23 14:08:37
2002** 1005,1012 SELECT * FROM shoe_ready
WHERE total_avail >= 2; shoename | sh_avail
| sl_name | sl_avail | total_avail
+---
I'm looking at implementing IS DISTINCT FROM, among other things. It has
the unusual behavior that it compares elements for a tuple by
considering two NULLs to be equal (hence non-distinct) rather than
"unknown". So the rules for comparison seem to be:
a) if the rows compared have different lengt
> hi all. i want to begin contributing work to stuff on the todo list. i have
> worked on suns for a long time.
I have a dual processor 180MHz Pentium Pro which is adequate for
building and testing PostgreSQL, though I find I use my newer laptop
more often nowadays. I'd expect that any machine su
J. R. Nield wrote:
> One other point:
>
> Page pre-image logging is fundamentally the same as what Jim Grey's
> book[1] would call "careful writes". I don't believe they should be in
> the XLOG, because we never need to keep the pre-images after we're sure
> the buffer has made it to the disk. In
> However, others don't believe constraints other than foreign keys
> should go unchecked.
>
> That said, is this functionality wanted outside of pg_dump /
> pg_restore?
pg_dump should reload a database as it was stored in the previous database.
If your old data is not clean, pg_dump / restore
On Thu, 2002-06-20 at 21:58, Bruce Momjian wrote:
> I was wondering, how does knowing the block is corrupt help MS SQL?
> Right now, we write changed pages to WAL, then later write them to disk.
> I have always been looking for a way to prevent these WAL writes. The
> 512-byte bit seems interest
Scott Marlowe <[EMAIL PROTECTED]> writes:
> During the discussion of bools and hash index and partial indexes and
> index growth and everything else, I tried to make a partial index on a
> bool field and got the error that "data type bool has no default operator
> for class hash..."
Well, no.
hi all. i want to begin contributing work to stuff on the todo list. i have
worked on suns for a long time. i plan to buy a used pc to begin helping out
with postgresql. my question is, what would be a good buy? what is the
oldest model of PC that i could buy and be able to use to work on stuff
With the pg_depend / pg_constraint implementation foreign keys are
applied to dumps via alter table / add foreign key (retains inter
table dependencies).
Some have expressed that this could be quite slow for large databases,
and want a type of:
SET CONSTRAINTS UNCHECKED;
However, others don't b
On Fri, 21 Jun 2002, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > And now you know which parts of your page got written, and which
> > parts didn't.
>
> Yes ... and what do you *do* about it?
Ok. Here's the extract from _Inside Microsoft SQL Server 7.0_, page 207:
torn pag
10 matches
Mail list logo
