Re: [SQL] Insert only if not found

It's also desirable that you use TRIM along with UPPER or LOWER. Roger. Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html ---(end of

Re: [SQL] auto vacuuming

Sumeet escribió: > Then do i need to still provide the auto vacumming options in the > postgres.conf file or these options are automatically taken care of. You have to enable the autovacuum setting in postgresql.conf. It is not enabled by default. -- Alvaro Herrera

Re: [SQL] auto vacuuming

Then do i need to still provide the auto vacumming options in the postgres.conf file or these options are automatically taken care of. Thanks, Sumeet. On 4/5/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Sumeet escribió: > Hi all is there a way i can find if the pg_autovacuum module is install

Re: [SQL] auto vacuuming

Sumeet escribió: > Hi all is there a way i can find if the pg_autovacuum module is installed on > my server?? > The postgres version im using is 8.1.4 > I tried searching the contrib module and dint see the pg_autovacuum > directory there pg_autovacuum no longer exists. Autovacuum is now integrat

[SQL] auto vacuuming

Hi all is there a way i can find if the pg_autovacuum module is installed on my server?? The postgres version im using is 8.1.4 I tried searching the contrib module and dint see the pg_autovacuum directory there I checked m source Thanks, Sumeet

[SQL] SOLVED - Another date range join problem

I've managed to come up with a solution that works, and embellished it to give exactly what I want. create view availability_details as select aid, asid, asdate, afdate, adays, count(rsgid) as allocated, adays-count(rsgid) as afree from ( select aid, asid, asdate, afdate, coalesce(adays,af

Re: [SQL] Generating dates prior to generate_series

On Wed, 2007-04-04 at 07:00, Roger Tannous wrote: > I'm using PostgreSQL version 7.3.2, and generate_series() is not > available, so this is a function to generate a series dates. > > The function goes backwards if the second argument is less than the first > one. Check the two select statements a

Re: [SQL] LOG: unexpected EOF on client connection

<[EMAIL PROTECTED]> writes: > FATAL: sorry, too many clients already You need a larger max_connections setting. > LOG: unexpected EOF on client connection I think pgbench just dies ungracefully if it gets a connection failure. regards, tom lane ---

[SQL] Another date range join problem

Hi folks, me again. I'm back with my availability and roster tables again. I have: Table "public.availability" Column |Type ---+ aid | serial primary key asid | integer asdate| date afda

[SQL] LOG: unexpected EOF on client connection

Hi list, I am doing a benchmark in my database but it is spent too much time. I was looking for my log file but I could not understad clearly what it says. The log is like this: INT: Consider increasing the configuration parameter "checkpoint_segments". LOG: checkpoints are occurring too fre

Re: [SQL] slow query

On Thu, Apr 05, 2007 at 01:47:03AM -0400, Tom Lane wrote: > [ shrug... ] If the damage is already done, lazy VACUUM won't fix it. > Also, if there are enough open transactions at any one time and sufficient churn in the table, lazy VACUUM may not be able to keep up. (We had that experience with

Re: [SQL] Insert only if not found

I think i spoke to soon. It works. But if i change a letter from capital to simple it inserts my record 2 times. So i have 2 records for "Shavonne" and "shavonne". So i thought i would do the select in uppercase. INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC, TE_

[SQL] Insert only if not found

Hello everyone.. Here is the result of my Insert. and also the insert works ok. INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC, TE_LUONASC, TE_DTNASC, TE_PROVSTATO, TE_PROV, TE_PATERNITA, TE_RICHIESTA, USERNAME, DATE_INSERTED, TIME_INSERTED) VALUES ('12700120074510

Re: [SQL] Insert only if not found

am Thu, dem 05.04.2007, um 11:47:35 +0200 mailte Shavonne Marietta Wijesinghe folgendes: > I think i spoke to soon. It works. But if i change a letter from capital to > simple it inserts my record 2 times. So i have 2 records for "Shavonne" and > "shavonne". So i thought i would do the select i

Re: [SQL] Insert only if not found

wow thanks. i managed to paste it to fit my code.. yea ^^ Shavonne Wijesinghe www.studioform.it - Original Message - From: "A. Kretschmer" <[EMAIL PROTECTED]> To: Sent: Thursday, April 05, 2007 10:53 AM Subject: Re: [SQL] Insert only if not found am Thu, dem 05.04.2007, um

Re: [SQL] slow query

"A. Kretschmer" <[EMAIL PROTECTED]> writes: > am Thu, dem 05.04.2007, um 1:27:25 -0400 mailte Tom Lane folgendes: >> I'm betting the problem is poor vacuuming practice leading to lots of >> dead space. There's no way it takes 22 sec to read 10 rows if the >> table is reasonably dense. > This wa

Re: [SQL] Insert only if not found

am Thu, dem 05.04.2007, um 10:38:21 +0200 mailte Shavonne Marietta Wijesinghe folgendes: > Hello everyone.. > > Here is the result of my Insert. and also the insert works ok. > > INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC, > TE_LUONASC, TE_DTNASC, TE_PROVSTAT