> -----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.