[GENERAL] INSERT OR UPDATE?

2005-10-09 Thread smorrey
Hello all, I am writing an app in PHP that uses a PostGres database. One thing i have noticed is that what should/could be a single line of SQL code takes about 6 lines of PHP. This seem wasteful and redundant to me. Here is a sample of what I'm talking about ($db is a PDO already defined and cr

[GENERAL] multiple default values specified for column?

2005-10-07 Thread smorrey
Hello pgsql is complaining and I can't seem to figure out what the error is talking about. Basically it's claiming that multiple default vaues are being specified, but nowhere in statement below is there one single place where I can see an error. Please help! SQL error: ERROR: multiple default v