Page 1 of 1

Will this error?

Posted: Thu Jan 15, 2009 10:53 am
by swraman
Is this query suposed to error?

pg_query("INSERT INTO tr_projects() VALUES()");

Or under what circumstances will it error?

Thanks

Re: Will this error?

Posted: Thu Jan 15, 2009 11:57 am
by Mark Baker
I'd expect it to error under every circumstance, with the sole possible exception of every column in the tr_projects table having a default or an autoincremented field, or being populated by a triggered function.

Re: Will this error?

Posted: Thu Jan 15, 2009 12:44 pm
by swraman
is there any way to check if the db is set to make default values?

I didnt write this code, and its my first time working with pgsql, so im a but clueless.

Thanks