[GENERAL] [Fwd: Postfix SMTP server: errors from avalanche.netmar.com[198.69.224.177]]

Can someone tell me if I'm blocking spam here of if I'm somehow blocking some of the emails from this list? I'm definitely getting email, but I keep getting these messages popping up on my servers. Does anyone know why? Original Message Return-Path: <[EMAIL PROTECTED]> X-Orig

[GENERAL] grant user access

I'm stuck. How do I grant select, insert, delete, update rights to an entire database? I tried this: GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE foo TO bar; and it returns ERROR: syntax error at or near "INSERT" at character 14 I'm just not getting it, it sure looks like I should be able to.

Re: [GENERAL] Sql injection attacks

Jim Seymour wrote: Bill Moran <[EMAIL PROTECTED]> wrote: [snip] I agree with Bill. Years ago (more years than I care to recall) I read a book on structured systems design (IIRC) that advised one should condition/convert data as early as possible in the process, throughout the design. Amongst the

Re: [GENERAL] Sql injection attacks

Geoff Caplan wrote: Hi folks Seems we have two schools of thought: 1) The validation/escaping approach, supported by Bill and Jim 2) The "don't mix data with code" approach supported by Peter and Greg. As I learn more about the issues, I am increasingly veering towards the second approach. Now I a

[GENERAL] serial data type

Can I use the serial data type in lieu of an 'auto_number' field? I asked something like this some months ago and it seems that auto_number fields were addressed through a combination of triggers and procedures to ensure that there were do duplicate KEYS generated. Is it realistic to use the ser

Re: [GENERAL] serial data type

Doug McNaught wrote: Is it realistic to use the serial data type as a KEY? Lots and lots of people do. If you're just looking for a unique key column for a single table, it works fine. -Doug This is essentially what I'm looking for. Any idea how to set up a timestamp=now on every insert/update ?

<    1   2