Re: [BUGS] BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"

On Wed, Dec 29, 2010 at 7:09 PM, Gabe Nell wrote: > > Launching psql fails: > > ubu...@host:~$ /opt/PostgreSQL/9.0/bin/psql -Upostgres > Password for user postgres: > psql (9.0.2) > Type "help" for help. > > Cannot read termcap database; > using dumb terminal settings. > Aborted > ubu...@host:~$ >

[BUGS] Re: to_timestamp returns the incorrect result for the DST fall over time.

I am afraid this may not give the result I am looking for. The sp x(text) gives me the result always will be UTC time zone. My requirement here is, that i should pass the UTC time in text as a parameter and should return local timestamp with timzone for that UTC time. select x('2010-03-28 01:00

[BUGS] Re: to_timestamp returns the incorrect result for the DST fall over time.

Gouse wrote: > I am afraid this may not give the result I am looking for. It sounds like you didn't even try it. That's bad form. I'm wondering why you bring to_timestamp into it at all, though. Are you aware of the behavior of casting?: test=# select '2011-01-15 00:00:00.0 UTC'::timesta

Re: [BUGS] BUG #5641: Can not create any python language

Hi, I'm facing the same issue in the same environment and the solution given by Ashesh Vashi is not working. :( Once I have copied plpython.dll as plpython3.dll, I still can't create the language plpython3u for a database. Is there another work around? Thanks, Alban. -- View this message in c

Re: [BUGS] BUG #5641: Can not create any python language

Hi Alban, Can you please open the plpython.dll (now, plpython3.dll) in the dependency walker and check if it satisfies all the required dlls? You can find the dependency walker @ dependencywalker.com. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company

Re: [BUGS] BUG #5641: Can not create any python language

On Thu, Jan 6, 2011 at 9:08 AM, areveille wrote: > I'm facing the same issue in the same environment and the solution given by > Ashesh Vashi is not working. :( > Once I have copied plpython.dll as plpython3.dll, I still can't create the > language plpython3u for a database. I guess the obvious q

Re: [BUGS] BUG #5641: Can not create any python language

It shows you all the dependent dlls (present or missing) in it. It also shows the exported functions by that particular dll. That gives you idea, if something is wrong with your environment or some dlls are missing. You can check more details on http://dependencywalker.com/ (NOTE: bottom of the p

Re: [BUGS] BUG #5641: Can not create any python language

Hi, I used dependency walker in order to see which dependencies could be unsatified in plpython.dll and indeed some of them were missing : - python26.dll (I had python2.7 installed but obviously it requires 2.6.) - some .dll that are in the bin folder of posgreSQL So I installed python 2.6 and

Re: [BUGS] BUG #5641: Can not create any python language

The result is still the same (means "ERREUR: n'a pas pu charger la bibliothèque « C:/Program Files/PostgreSQL/9.0/lib/plpython3.dll » : unknown error 126" = Can't load C:/Program Files/PostgreSQL/9.0/lib/plpython3.dll -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG

Re: [BUGS] BUG #5641: Can not create any python language

And, make sure you create the plpythonu language not plpython3u. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Thu, Jan 6, 2011 at 8:46 PM, A

Re: [BUGS] BUG #5641: Can not create any python language

This warning will be there for any dlls. So - you can ignore them. If you have renamed the plpython.dll to plpython3.dll, then please revert it back to original one. And, then try to create the language. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company

Re: [BUGS] BUG #5641: Can not create any python language

In fact I always had plpython.dll since I duplicated the file (one named plpython.dll and the other plpython3.dll). Anyways, now I have deleted plpython3.dll (so I just have plpython.dll) and "create language plpython;" answers : ERREUR: n'a pas pu charger la bibliothèque « C:/Program Files/Post

Re: [BUGS] BUG #5641: Can not create any python language

Are the python binaries in your system level PATH environment? If not, you need to make sure the bin folder of python should be in your system level PATH variable. Check this link for the reference: http://geekswithblogs.net/renso/archive/2009/10/21/how-to-set-the-windows-path-in-windows-7.aspx Th

Re: [BUGS] BUG #5641: Can not create any python language

This was the final step : it worked out. Thanks for your time, your understandable explanations! Alban, -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5641-Can-not-create-any-python-language-tp2801518p3330632.html Sent from the PostgreSQL - bugs mailing list archi

Re: [BUGS] BUG #5809: bigserial duplicate value

 i relying on PostgreSQL to supply a default value, i  have application at  hospital and application appear error about duplicate value. There was a primary key on this columns but i found error form my application about duplicate value and can`t insert value then i remove the primary key cons

[BUGS] BUG #5813: Cross Database Access in the same server using DBlink

The following bug has been logged online: Bug reference: 5813 Logged by: Peevee Email address: peeve...@yahoo.com PostgreSQL version: 9.0.2 Operating system: Windows 7 Description:Cross Database Access in the same server using DBlink Details: I have created a table

[BUGS] certification courses for postgreSQL......

dear sir/madam, i m the beginner of postgreSQL database.and want to become expert in this database. is theer any certification courses for postgreSQL database available? kindly guide me . thanx in anticipation regards harshad हर्षद वाजार

[BUGS] BUG #5814: documentation bug

The following bug has been logged online: Bug reference: 5814 Logged by: Antje Petersen Email address: antje.peter...@desy.de PostgreSQL version: 8.1.21 Operating system: Scientific Linux 5 Description:documentation bug Details: According to the documentation create

[BUGS] BUG #5815: connecting to Atllassian products

The following bug has been logged online: Bug reference: 5815 Logged by: kapil Email address: kapil_bo...@yahoo.com PostgreSQL version: 8.4 Operating system: windows Description:connecting to Atllassian products Details: hello I have connected postgreSql with Atlla

[BUGS] BUG #5816: index not used in function

The following bug has been logged online: Bug reference: 5816 Logged by: frank Email address: fr...@ros-i.com PostgreSQL version: 8.3.7 Operating system: linux Description:index not used in function Details: Linux: Linux 2.6.24-24-server #1 SMP Tue Jul 7 20:21:17 U

[BUGS] BUG #5817: Language problem...

The following bug has been logged online: Bug reference: 5817 Logged by: Email address: jeng...@hotmail.com PostgreSQL version: any, so far Operating system: Windows 7 Description:Language problem... Details: I use a W7 english operating system, with Norwegian inpu

Re: [BUGS] BUG #5813: Cross Database Access in the same server using DBlink

"Peevee" wrote: > Select TableName from TestTableB LIMIT 1 > ERROR: relation "testtableb" does not exist Identifiers containing uppercase letters must be quoted. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postg

Re: [BUGS]certification courses for postgreSQL......

"harshad" wrote: > i m the beginner of postgreSQL database.and want to become expert > in this database. > > is theer any certification courses for postgreSQL database > available? Welcome to the world of PostgreSQL! However, this is clearly not a bug report, so it doesn't belong on the bugs

Re: [BUGS] BUG #5817: Language problem...

On Wed, Jan 5, 2011 at 10:02 PM, wrote: > > The following bug has been logged online: > > Bug reference:      5817 > Logged by: > Email address:      jeng...@hotmail.com > PostgreSQL version: any, so far > Operating system:   Windows 7 > Description:        Language problem... > Details: > > I us

Re: [BUGS] BUG #5815: connecting to Atllassian products

"kapil" wrote: > I have connected postgreSql with Atllassian products. > i receiving the follwing error.:: > java.sql.SQLException: Connections could not be acquired from > the underlying database. This doesn't sound like a bug, at least not a PostgreSQL bug. You might do better to

Re: [BUGS] BUG #5816: index not used in function

"frank" wrote: > WHERE upper("thisColumn") like $1 The function's plan is kept from one execution to another, and it can't know what will be in the first parameter -- perhaps '%X%'? If you build up the statement in a string and EXECUTE it, you might get the desired behavior. Anyway, next ti

Re: [BUGS] BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"

> There was a change in 9.0.2 to use libedit instead of readline for > this (readline is GPL, which is not acceptable to some people who wish > to use Postgres in other products). One of my colleagues has tested > the issue reported and confirmed that installing the OS's termcap > package should so

Re: [BUGS] BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"

On Thu, Jan 6, 2011 at 8:54 PM, Gabe Nell wrote: >> There was a change in 9.0.2 to use libedit instead of readline for >> this (readline is GPL, which is not acceptable to some people who wish >> to use Postgres in other products). One of my colleagues has tested >> the issue reported and confirme

Re: [BUGS] BUG #5809: bigserial duplicate value

On Wed, Jan 5, 2011 at 12:38 AM, Melzaiady wrote: >  i relying on PostgreSQL to supply a default value, > i  have application at  hospital and application appear error about > duplicate value. > There was a primary key on this columns but i found error form my > application about duplicate value a

Re: [BUGS] BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"

If you install libtermcap then it will start working good. We have tested it at our end. On Fri, Jan 7, 2011 at 2:24 AM, Gabe Nell wrote: >> There was a change in 9.0.2 to use libedit instead of readline for >> this (readline is GPL, which is not acceptable to some people who wish >> to use Postg

Re: [BUGS] BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"

> If you install libtermcap then it will start working good. We have > tested it at our end. Thanks Dharmendra, however in Ubuntu there is no package called libtermcap, though it has been suggested that the libncurses5-dev package provides this [1]. However I tried this and I still get the same er