I'm using pgadmin 1.2.0 and created a table that has a field called state and is varchar length of 2 and setting a default value OR. So I put it in there and when I click OK to complete the table I get an parse error at or near OR. My guess is that it needs to have " or ' around it but UNFORTUNATELY I can't do anything about it because the program doesn't let you go in and change anything in the fields. Something needs to be done so that a person can edit the field properties after creation.
Also, I was running a bunch of sql statements through pgadmin II and after about doing 80 or so of them pgadmin started complaining about zero length. I'll try and replicate it to give more information. Just giving a heads up. -- _______________________________________________ Get your free email from www.kittymail.com Powered by Outblaze ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
