[GENERAL] Re: ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist

2015-08-28 Thread ss
right then collation is used to sort the data) ..may be he mean sorting the data on alphabetical order or something similar On Aug 27, 2015 11:00 PM, "Adrian Klaver-4 [via PostgreSQL]" < ml-node+s1045698n5863613...@n5.nabble.com> wrote: > On 08/27/2015 06:47 AM, ss wrote: > >

[GENERAL] ERROR: collation "latin1_general_ci" for encoding "UTF8" does not exist

2015-08-27 Thread ss
I have started writting query since a day on postGreS my query is : CREATE TABLE IF NOT EXISTS utilisateurs ( SEQU_NK SERIAL PRIMARY KEY NOT NULL UNIQUE, UTILISATEUR_NK bigint NOT NULL, NOM varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '', PASSE varchar(40) C

Re: [GENERAL] Compile of Pgmail function fails

2006-02-12 Thread indu ss
uot; gets $mySock name puts $mySock "rcpt to: $toemailaddress" gets $mySock name puts $mySock "data" gets $mySock name puts $mySock "To: $mailto" puts $mySock "From: $mailfrom" puts $mySock "Subject: $mailsubject" puts $mySock "" puts $mySock

[GENERAL] Compile of Pgmail function fails

2006-02-06 Thread indu ss
Hello, I want to send mail on update of a field in a table. I'm using pgmail() function (from sourceforge) . I'm calling this function from another function which is called by trigger on update of the field. On executing the update statement i get error CONTEXT: compile of PL/pgSQL function "pg

[GENERAL] error calling pgmail function

2006-02-03 Thread indu ss
Hello, I want to send mail on update of a field in a table. I'm using pgmail() function (from sourceforge) . I'm calling this function from another function which is called by trigger on update of the field. On executing the update statement i get error CONTEXT: compile of PL/pgSQL function "p