Segmentation fault

Started by ajayabout 12 years ago5 messagesgeneral
Jump to latest
#1ajay
akmani1987@gmail.com

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: ajay (#1)
Re: Segmentation fault

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Adrian Klaver
adrian.klaver@aklaver.com
In reply to: ajay (#1)
Re: Segmentation fault

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4ajay
akmani1987@gmail.com
In reply to: Adrian Klaver (#3)
Re: Segmentation fault

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#5Adrian Klaver
adrian.klaver@aklaver.com
In reply to: ajay (#4)
Re: Segmentation fault

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general