Re: [SQL] Inserting into table only if the row does not already
* C. Bensend <[EMAIL PROTECTED]> [2004-10-15 08:14:51 -0500]: > Concurrency shouldn't be an issue - this is a perl script running > from cron. The only concurrency that will ever happen is if I'm a > bonehead and I run the script manually right as cron kicks off > another copy. Even cron'd scripts can run amok. Lock files are great as a CYA measure even if you're relatively certain there will be no opportunity for one copy to step on the next. I once had a cron'd script mail upper management every hour I was on vacation. You can imagine how long it was until I got another vacation request approved. ;) -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [SQL] Database backup
* sreejith s <[EMAIL PROTECTED]> [2004-10-17 08:49:44 +0530]: > How to take Database backup from an application developed in Visual > Basic thats running at Windows Client and Database resting at Linux > Server. THanx pg_dump -U your_username your_database > your_database.sql -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [SQL] Hi
* vasundhar <[EMAIL PROTECTED]> [2004-11-06 22:45:36 -0800]: > Hi I am using REL on which only 7.3.2 PG only available and I want > to upgrade it to the latest and also integrate it with Perl but my > system is also not supporting the DBI any suggestions please My suggestion would be to determine why your system won't support DBI and fix it. -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
