Thread: Segmentation fault

hello team ,

i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
error

fm_db_Server1-# insert into mmsuper.notification
values('101','12','13','Segmentation Fault

and comes out of postgres prompt....
also when i am trying to press up arrow key , then also it is giving me
above error.

But in Linux this is working fine ..without any error

Please help it is very very urgent..



Thanks
Akshat



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Segmentation-fault-tp5794571.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

ajay <akmani1987@gmail.com> writes:
> hello team ,
> i am trying to enter this insert command in postgres
> insert into mmsuper.notification
> values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
> balance',5);
> now when i am trying to paste this in postgres in Solaris , it is giving me
> error

> fm_db_Server1-# insert into mmsuper.notification
> values('101','12','13','Segmentation Fault

> and comes out of postgres prompt....
> also when i am trying to press up arrow key , then also it is giving me
> above error.

This suggests you've got a broken readline library.  Can you do the
paste successfully when psql is started with the --no-readline switch?
If so, you need to get a more up-to-date copy of libreadline and relink
psql against that.

            regards, tom lane

On 03/04/2014 03:03 AM, ajay wrote:
> hello team ,
>
> i am trying to enter this insert command in postgres
> insert into mmsuper.notification
> values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
> balance',5);
> now when i am trying to paste this in postgres in Solaris , it is giving me
> error
>
> fm_db_Server1-# insert into mmsuper.notification
> values('101','12','13','Segmentation Fault
>
> and comes out of postgres prompt....
> also when i am trying to press up arrow key , then also it is giving me
> above error.
>
> But in Linux this is working fine ..without any error

Well this has encoding/locale issues written all over it.

So what is the encoding/locale for your Linux machine vs the Solaris
machine?

The same for the Postgres instances on each or are you inserting into
the same Postgres instance?

>
> Please help it is very very urgent..
>
>
>
> Thanks
> Akshat
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Segmentation-fault-tp5794571.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 03/04/2014 07:39 AM, Adrian Klaver wrote:

CCing list:

> <quote author='Adrian Klaver-4'>
> On 03/04/2014 03:03 AM, ajay wrote:
>> hello team ,
>>
>> i am trying to enter this insert command in postgres
>> insert into mmsuper.notification
>> values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
>> balance',5);
>> now when i am trying to paste this in postgres in Solaris , it is giving
>> me
>> error
>>
>> fm_db_Server1-# insert into mmsuper.notification
>> values('101','12','13','Segmentation Fault
>>
>> and comes out of postgres prompt....
>> also when i am trying to press up arrow key , then also it is giving me
>> above error.
>>
>> But in Linux this is working fine ..without any error
>
> Well this has encoding/locale issues written all over it.
>
> So what is the encoding/locale for your Linux machine vs the Solaris
> machine?
>
> The same for the Postgres instances on each or are you inserting into
> the same Postgres instance?
>
>>
>> Please help it is very very urgent..
>>
>>
>>
>> Thanks
>> Akshat
>>

> thanks for the reply ,..
>
> When i am trying to enter anything else other then some Arabic , Hindi
> .. that case it does not give this error.
>
> like if i enter..
> insert into table values('welcome',1);
> then it does not give any error and get successfully

I would try Toms suggestion about readline. If that does not work then
we are back to questions I asked above about the encodings you are
working with.

>
> Thank


--
Adrian Klaver
adrian.klaver@aklaver.com

thanks for the reply ,..

When i am trying to enter anything else other then some Arabic , Hindi ..
that case it does not give this error.

like if i enter..
insert into table values('welcome',1);
then it does not give any error and get successfully

Thanks



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Segmentation-fault-tp5794571p5794624.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.