I recently posted a SOPW titled 'regex question' and all was fine until I clicked 'new' after previewing.

Then I was taken to the question page for Joe who had previously asked a question with the same title, and my question was lost???

A bit of hasty back, back, back saved the tears, but this implies there is no checking of the primary key of the node table???

So if I accidentally use the same title things go pear shaped?

Replies are listed 'Best First'.
RE: SOPW titles
by chromatic (Archbishop) on Nov 10, 2000 at 23:55 UTC
    Titles aren't used as primary keys in the node table -- lots of nodetypes allow duplicate titles. The node_id column is the primary key.

    I don't have the special PM source handy, but the newest Everything code has logic to redirect itself internally to a freshly-created node (by node_id, not title) whenever it encounters the 'new' opcode.

    (Internally, titles aren't used much for the simple reason that they're not guaranteed to be unique.)

[reply]

Back to Perl Monks Discussion