Erwin Brandstetter wrote:
[EMAIL PROTECTED] wrote:
Sounds like it thinks you're editting a numeric value. Are you sure
you weren't?
/D
I am sure. Try the test case.
But I guess you found the root of the problem right there: pgadmin
probably thinks it is editing a numeric value, though it is text.
I have checked on the docs. I quote from
http://www.postgresql.org/docs/8.1/static/sql-set.html
http://www.postgresql.org/docs/8.2/static/sql-set.html
/>value/
> New value of parameter. Values can be specified as string
constants, identifiers, numbers, or comma-separated lists of these.
DEFAULT can be used to specify resetting the parameter to its default
value.
Identifiers are text. I suspect pgadmin expects numbers, regardless.
Regards
Erwin
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
