Re: mysql autoincs

2002-07-16 Thread Peter Haworth
On Mon, 15 Jul 2002 16:07:53 +0100, Roger Burton West wrote: On or about Mon, Jul 15, 2002 at 04:03:41PM +0100, Mark Fowler typed: Without starting a massive database war, is there anyway to get mysql to forget about autoincremented values. IME the way MySQL generates an auto-increment value

Re: mysql autoincs

2002-07-16 Thread Roger Burton West
On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: Surely you shouldn't rely on sequences being contiguous, anyway? Who cares if your test eats up some values; their only purpose should be to ensure uniqueness. Contiguity becomes important when you're doing things like

RE: mysql autoincs

2002-07-16 Thread Pierre Denis
Having a staging environment with a daily dump of live data and software would be nice. you can mess with the data as much as you want. Obviously that involves a lot of work to set-it up the first time and probably extra hardware. The other advantage is to have nice release procedure where you

RE: mysql autoincs

2002-07-16 Thread Mark Fowler
On Tue, 16 Jul 2002, Pierre Denis wrote: Having a staging environment with a daily dump of live data and software would be nice. you can mess with the data as much as you want. Sure, but at some point I have to make the code go live. And when I do that I want to run the modules tests on

Re: mysql autoincs

2002-07-16 Thread pdcawley-london . 0dd185
Michael Stevens [EMAIL PROTECTED] writes: On Tue, Jul 16, 2002 at 10:47:23AM +0100, Roger Burton West wrote: On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: Surely you shouldn't rely on sequences being contiguous, anyway? Who cares if your test eats up some values;

[JOB / Recommendation] Evil documentation

2002-07-16 Thread Jonathan Peterson
My company needs some security policies and procedures documentation. You know, the kind of thing that says in writing Users must change passwords every 30 days and Changes to firewall configuration must be approved in writing by the CTO and so on. I have no intention of reducing my own

password expiry (was Re: [JOB / Recommendation] Evil documentation)

2002-07-16 Thread Nicholas Clark
On Tue, Jul 16, 2002 at 01:24:22PM +0100, Jonathan Peterson wrote: My company needs some security policies and procedures documentation. You know, the kind of thing that says in writing Users must change passwords every 30 days and Changes to firewall configuration must be Personally I

Re: password expiry (was Re: [JOB / Recommendation] Evil documentation)

2002-07-16 Thread Jonathan Peterson
Michael Stevens wrote: On Tue, Jul 16, 2002 at 01:34:19PM +0100, Nicholas Clark wrote: I'm not convinced that frequent password changing is good, because I find it seems to lead to either frequent password resetting by administrators (with inherent social engineering vulnerability) or

RE: mysql autoincs

2002-07-16 Thread Pierre Denis
Having a staging environment with a daily dump of live data and software would be nice. you can mess with the data as much as you want. Sure, but at some point I have to make the code go live. And when I do that I want to run the modules tests on the live server (who knowns what subtle

Re: [JOB / Recommendation] Evil documentation

2002-07-16 Thread Chris Benson
On Tue, Jul 16, 2002 at 01:24:22PM +0100, Jonathan Peterson wrote: My company needs some security policies and procedures documentation. I have no intention of reducing my own sanity by actually sitting down to write all this. So, does anyone know of any freelancers or cheap Good move

Re: mysql autoincs

2002-07-16 Thread Alex McLintock
At 10:47 16/07/02, Roger Burton West wrote: On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: Surely you shouldn't rely on sequences being contiguous, anyway? Who cares if your test eats up some values; their only purpose should be to ensure uniqueness. Contiguity

Re: mysql autoincs

2002-07-16 Thread Nic Gibson
On Tue, Jul 16, 2002 at 03:56:23PM +0100, Alex McLintock wrote: At 10:47 16/07/02, Roger Burton West wrote: On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: Surely you shouldn't rely on sequences being contiguous, anyway? Who cares if your test eats up some values;

Re: mysql autoincs

2002-07-16 Thread Dave Cross
On Tue, Jul 16, 2002 at 03:56:23PM +0100, Alex McLintock ([EMAIL PROTECTED]) wrote: At 10:47 16/07/02, Roger Burton West wrote: On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: Surely you shouldn't rely on sequences being contiguous, anyway? Who cares if your test

Re: mysql autoincs

2002-07-16 Thread Struan Donald
* at 16/07 15:51 +0100 Dave Cross said: On Tue, Jul 16, 2002 at 03:56:23PM +0100, Alex McLintock ([EMAIL PROTECTED]) wrote: For the record I hit this sort of problem doing some perl web stuff with Oracle. It seemed that because Oracle was multiprocessor each oracle process would

currval in a transaction

2002-07-16 Thread Rafiq Ismail (ADMIN)
Does anyone know whether, whilst using postgres, if a an insert followed by a select currval on the index of the last insert, will give a not yet defined in this session error on the select, when both statements are a part of the same transaction? *Deep breath* Cheers, Fiq

ISP Spammers through ignorance

2002-07-16 Thread Barbie
Can anyone recommend a higher authority that can force an (US) ISP to get their act together, and stop spamming me with their misconfigured mail software? I have previously contacted earthlink.net over a spammer who is spoofing my email address, yet despite explaining that I am not the spammer,

Re: mysql autoincs

2002-07-16 Thread S. Joel Bernstein
At 16/07/2002 15:59 [], you wrote: snip RDBMSs not correctly [fsvo] auto-incrementing IDs /snip MSSQL works in the expected manner. It's about the only one I can think of. This sets off alarm bells along the lines of MSSQL does this right...All the other (and generally faster, etc..BETTER)

Hungy Minds?

2002-07-16 Thread Dave Hodgkinson
Has anyone who signed up to write for Hungry Minds heard from them recently? Dave // Feeling paranoid

Re: Hungy Minds?

2002-07-16 Thread Dave Hodgkinson
Roger Burton West [EMAIL PROTECTED] writes: Haven't seen any money yet. Heh. A returnd email would be nice. -- Dave Hodgkinson, Wizard for Hire http://www.davehodgkinson.com Editor-in-chief, The Highway Starhttp://www.thehighwaystar.com Interim Technical Director, Web

Re: mysql autoincs

2002-07-16 Thread Paul Makepeace
On Tue, Jul 16, 2002 at 11:10:37AM +0100, Mark Fowler wrote: Sure, but at some point I have to make the code go live. And when I do that I want to run the modules tests on the live server (who knowns what subtle differences may have snuck in) before I turn it live live. Presumably you have

Re: mysql autoincs

2002-07-16 Thread Roger Burton West
On or about Tue, Jul 16, 2002 at 05:03:57PM +0100, Chris Ball typed: - Chris, who has been forced to use Perl to play with Sybase and MSSQL today, and hasn't wanted to kill people. Yet. FreeTDS? Roger

Re: Hungy Minds?

2002-07-16 Thread Roger Burton West
On Tue, Jul 16, 2002 at 06:17:08PM +0100, Chris Benson wrote: Perhaps we should sort out which chapters we have and put it up on london.pm.org? Perhaps we should get definite information on what's up with them before we do that? Anyone got any contacts at Wiley, which owns HM? Roger

Re: mysql autoincs

2002-07-16 Thread Jonathan Stowe
On Tue, 16 Jul 2002, Nic Gibson wrote: On Tue, Jul 16, 2002 at 03:56:23PM +0100, Alex McLintock wrote: At 10:47 16/07/02, Roger Burton West wrote: On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: Surely you shouldn't rely on sequences being contiguous, anyway?

Re: mysql autoincs

2002-07-16 Thread Jonathan Stowe
On Tue, 16 Jul 2002, Roger Burton West wrote: On or about Tue, Jul 16, 2002 at 05:03:57PM +0100, Chris Ball typed: - Chris, who has been forced to use Perl to play with Sybase and MSSQL today, and hasn't wanted to kill people. Yet. FreeTDS? It's getting there - it will work against SQL

Re: AxKit suggestions?

2002-07-16 Thread Nicholas Clark
On Tue, Jul 16, 2002 at 06:03:37PM +0100, Alex McLintock wrote: [interesting stuff, but no quotes from any previous messages] we've done the jepordy quoting is evil rant, we've skirted close to the reply-to-list is evil flamewar, am I allowed to do the hitting reply is bad complaint without

Re: Hungy Minds?

2002-07-16 Thread Dave Hodgkinson
Chris Benson [EMAIL PROTECTED] writes: Anyone interested in converting it to SGML so it can be published sensibly? Doing me no good right now so... -- David Hodgkinson, Wizard for Hirehttp://www.davehodgkinson.com Editor-in-chief, The Highway Star

Re: Hungy Minds?

2002-07-16 Thread Chris Benson
On Tue, Jul 16, 2002 at 09:29:22PM +0100, Roger Burton West wrote: On Tue, Jul 16, 2002 at 06:17:08PM +0100, Chris Benson wrote: Perhaps we should sort out which chapters we have and put it up on london.pm.org? Perhaps we should get definite information on what's up with them before we

Re: Hungy Minds?

2002-07-16 Thread Roger Burton West
On Tue, Jul 16, 2002 at 09:50:03PM +0100, Chris Benson wrote: I was thinking ahead to when it was clear they'd defaulted on the contract :-) (He said hastily in case any NooYawk lawyers were reading the list). At such point as the contracts are void (bearing in mind that my contracts, at