[GENERAL] partitioning : replicate_partition doesn't seem to be working

Quoted from http://www.nabble.com/Group-Sets-For-Replication-w--Partition-d19369646.html Basically, what you would need to do, weekly, is to run a slonik execute script script where the SQL script consists of something similar to what's in tests/testpartition/gen_ddl_sql.sh: - create the

Re: [GENERAL] partitioning : replicate_partition doesn't seem to be working

Hmm... seems like a SNAFU on my part. I didn't know that I need to execute it using EXECUTE SCRIPT via slonik. I was doing it via pgadmin psql. Reading this : http://lists.slony.info/pipermail/slony1-general/2008-October/008929.html and trying it found the issue. Thanks and sorry for the

Re: [GENERAL] auto insert data every one minute

searchelite wrote: I have an sql script consists of insert statement data. I want to insert every row of data every one minute. How can i do that using batch file in windows How about using pg_sleep ? INSERT ; COMMIT; SELECT pg_sleep(60); INSERT...; COMMIT; SELECT

Re: [GENERAL] auto insert data every one minute

how about windows task scheduler ? (cron-ish thing) -- GJ

Re: [GENERAL] server install recommendations?

Roberto Scattini wrote: in a couple of days i will reinstall an offline database server. It's a old HP Proliant DL580 G3 with three disks (147 GB each). Currently it has a debian Sarge in a RAID5 hardware array ( with HP Smart Array 6i, [RAID bus controller: Compaq Computer Corporation Smart

Re: [GENERAL] auto insert data every one minute

Grzegorz Jaśkiewicz wrote: how about windows task scheduler ? (cron-ish thing) If the OP wants to do the exact same insert every minute, then the OS scheduler sure does the job. That's not how I understood the question, though. My interpretation is that he has a SQL script with an

[GENERAL] parser: tokens in tsearch2

I need to glue codes to concatenate them as a single lexeme to other tsvectors in a way that a code won't be split but will remain one lexeme. eg. if input is ab12 456/z7_92$44'a37 I don't want it get parsed into {ab12} {456} {z7} {92} {44} {a37} but I want to keep the highest possible number of

[GENERAL] IS NULL seems to return false, even when parameter is NULL

I have a strange problem with the following condition in a SELECT: AND ((TableData = inDate) OR (inDate IS NULL)) it works perfectly when the input date in the function (inDate) matchs a date in the table, but it does not work when the parameter inDate is NULL. I recall the function with pgadmin

Re: [GENERAL] IS NULL seems to return false, even when parameter is NULL

Lucazeo [EMAIL PROTECTED] writes: It seems that (inDate IS NULL) never returns true, even when the parameter is null... Exceedingly unlikely. What's wrong? You have not provided enough context for anyone to guess. regards, tom lane -- Sent via pgsql-general mailing