Re: [GENERAL] Error while loading sql file

2011-12-26 Thread Alban Hertroys
On 26 Dec 2011, at 8:22, Adarsh Sharma wrote: > Dear all, > > I am facing a unique issue when I try to load an sql into a postgresql > database :- Actually, your issue isn't unique at all. You'll find it reoccurs on this list regularly, although perhaps less frequent these days. > I faced an

[GENERAL] invalid memory alloc request size

2011-12-26 Thread Ben Chobot
Yesterday I had a problem on a 64-bit 9.1.1 install: # select version(); version ---

Re: [GENERAL] postgresql triggers - defining a global resource (java)

2011-12-26 Thread Aman Gupta
Hey Alban, Thanks for the reply. I had a follow up question w.r.t listen/notify: I am planning to associate a NOTIFY with an update on a table - a trigger is associated with the update, and we execute NOTIFY in the trigger code. The NOTIFY directly goes to a remote server and contains the updated

[GENERAL] Re: Unable to connect to PostgreSQL server : Could not get socket error status

2011-12-26 Thread Shankar Palaniappan
On Dec 23, 7:51 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: > On Friday, December 23, 2011 1:32:49 am Shankar Palaniappan wrote: > > > Hi John, > > > Thanks for your response. > > > I am able to connect to the database through psql command. Please find > > the commands that I have tried thro

Re: [GENERAL] Re: Unable to connect to PostgreSQL server : Could not get socket error status

2011-12-26 Thread Raymond O'Donnell
On 24/12/2011 12:54, Shankar Palaniappan wrote: > On Dec 23, 7:51 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: >> On Friday, December 23, 2011 1:32:49 am Shankar Palaniappan wrote: >> >>> Hi John, >> >>> Thanks for your response. >> >>> I am able to connect to the database through psql comman

Re: [GENERAL] Re: Unable to connect to PostgreSQL server : Could not get socket error status

2011-12-26 Thread Adrian Klaver
On Saturday, December 24, 2011 4:54:04 am Shankar Palaniappan wrote: > On Dec 23, 7:51 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote: > > On Friday, December 23, 2011 1:32:49 am Shankar Palaniappan wrote: > > > Hi John, > > > > > > Thanks for your response. > > > > > > I am able to connect to

Re: [GENERAL] Error while loading sql file

2011-12-26 Thread Adarsh Sharma
Thanks for the Explaination, I find it hard to determine the way to store data in different encodings to store in postgresql, below is the demo of some data :- INSERT INTO conceptnet_frame VALUES(3884,'ja','{1}?{2}???',16,3,2140,NULL,NULL,NULL); INSERT INTO conceptnet_frame VALUES(3885,'j

Re: [GENERAL] Error while loading sql file

2011-12-26 Thread John R Pierce
On 12/26/11 9:32 PM, Adarsh Sharma wrote: Above link shows the above encoding schemes is in utf16 format but postgresql-8.4 doesn't support it. Is there any way to store data in different encoding in a utf-8 database. afaik, anything in UTF16 can be represented by UTF8, but the inverse is not