Обсуждение: [pgsql]Bug

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
defaultvalue 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
guessis that it needs to have " or ' around it but UNFORTUNATELY I can't do anything about it because the program
doesn'tlet you go in and change anything in the fields. Something needs to be done so that a person can edit the field
propertiesafter creation. 

Also, I was running a bunch of sql statements through pgadmin II and after about doing 80 or so of them pgadmin started
complainingabout 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

> -----Original Message-----
> From: K Anderson [mailto:msmouse@kittymail.com]
> Sent: 29 August 2002 05:46
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] [pgsql]Bug
>
>
> 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.

pgAdmin will let you edit the default value, provided the version of
PostgreSQL you're running supports doing so. Just right-click the column
in the treeview (NOT in the Table Properties dialogue) and edit away.
Newer versions of PostgreSQL allow more editting of properties, so I've
been adding these to the dev versions of pgAdmin.

Regards, Dave.