Thanks Dinesh - patch applied.
I noticed one other issue in the role dialogue that I'd like you or Dhiraj
to look at please. On my Mac, if I open the properties for a role with no
VALID UNTIL date set, it's setting the date in the dialogue to the current
date and generating the SQL to make that ch
Thanks, fixed.
On Mon, Aug 19, 2013 at 1:00 PM, Neel Patel wrote:
> Hi Dave,
>
> We just go through code and following are the findings.
>
> *Issue :- *
>
> To find out the constraint we are using pg_constraint class. In PG 9.2
> valid values for "confmatchtype" column in pg_constraint class is
i need to convert some stings in old database, where \ is one letter in
croatian language.
when i'm using
replace ('abcd\efg', '\', 'XX') i got error.
anyone can help how to solver this problem ?
tnx
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/replace-tp57680
Here on 9.2.4 just work fine :
select replace ('abcd\efg', '\', 'XX');
+---+
| replace |
+---+
| abcdXXefg |
+---+
paolo
2013/8/20 ingoos
> i need to convert some stings in old database, where \ is one letter in
> croatian language.
>
> when i'm using
>
> replace ('
9.2.4. ??
i'm using pgAdmin 1.16.1
and error is
WARNING: nonstandard use of escape in a string literal
LINE 1: select replace ('abcd\efg', '\', 'XX');
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of \' in a string literal
L
Put letter E before each string.
E'\'
Like this.
Regards, Alexander Yerenkow
20.08.2013 16:02 пользователь "ingoos" написал:
> 9.2.4. ??
>
> i'm using pgAdmin 1.16.1
>
> and error is
>
> WARNING: nonstandard use of escape in a string literal
> LINE 1: select replace ('abcd\efg', '\', 'XX');
>
Hi,
where does your 'abcd\efg' data resource come from ? if application
program data was passed into database,you should make '\' into '\\', Then,
execute the following command:
select replace ('abcd\\efg', '\\', 'XX');
replace text
1
abcdXXefg
Put letter E bef
