[SQL] Trigger para fazer log

Oi lista,   tenho um trigger que deve validar alguns campos para entrada/saida de funcionarios e que deve fazer um "log" do que vai acontecendo.   Por exemplo: quando é o início do expediente, o trigger deverá guardar algo assim no "log": Cadastro da Entrada-1: Data 2003-02-06  Horário: 09:51

[SQL] Getting sequence value after inserting many rows at a time

Hi,   I have a PHP script that do something like this:   INSERT INTO table_with_sequence (field1, field2, fieldn) SELECT field1, field2, ..., fieldn FROM table,table WHERE condition, condition   My doubt: Will the rows just inserted in "table_with_sequence" always be sequencial? (won't

Re: [SQL] Different size in the DATA directory

I do daily vacuums on the production server | > Hi, in my production server a "du -hs" in the DATA directory | > returns 21GB | > in a newly installed server, after I restored the dumps from the | > production server, the "du -hs" gives me just 8GB | > | > why is there such a diference??? | >

[SQL] Different size in the DATA directory

Hi, in my production server a "du -hs" in the DATA directory returns 21GB in a newly installed server, after I restored the dumps from the production server, the "du -hs" gives me just 8GB   why is there such a diference???   what should I do (besides buying bigger and bigger HDs) ???   []'