Re: [Tutor] Operational Error. --HELP

2009-03-31 Thread David
bijoy franco wrote: I tried following query as well. code: infunction_curs.execute('SELECT * FROM table_book') This also throws the same error Bijoy Why did you try that? -- Powered by Gentoo GNU/LINUX http://www.linuxcrazy.com pgp.mit.edu ___ Tu

Re: [Tutor] Operational Error. --HELP

2009-03-31 Thread bijoy franco
I tried following query as well. code: infunction_curs.execute('SELECT * FROM table_book') This also throws the same error Bijoy On Wed, Apr 1, 2009 at 12:42 AM, bob gailer wrote: > bijoy franco wrote: >> >> Hi, >> >> When used in psql interface directly, all Database operation queries >> w

Re: [Tutor] Operational Error. --HELP

2009-03-31 Thread bijoy franco
Hi, When used in psql interface directly, all Database operation queries works perfectly fine. Pls find the full code and error below code: import pgdb __metaclass__=type class addbook:     conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1')     curs=c

Re: [Tutor] Operational Error. --HELP

2009-03-31 Thread bob gailer
bijoy franco wrote: Hi, When used in psql interface directly, all Database operation queries works perfectly fine. So now we have a different query than the first time! I serioiusly doubt that SELECT book_name FROM table_book WHERE book_name=fgfd works in the interface. Or if it does wor

Re: [Tutor] Operational Error. --HELP

2009-03-31 Thread bob gailer
bijoy franco wrote: > > Hi, > > Python throws OperationalError while trying to do any database operations. I am using pgdb module. > > Code: > > import pgdb > > __metaclass__=type > > class addbook: > > conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1')

[Tutor] Operational Error. --HELP

2009-03-31 Thread bijoy franco
Hi, Python throws OperationalError while trying to do any database operations. I am using pgdb module. * **Code:*import pgdb __metaclass__=type class addbook: conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1') curs=conn.cursor() def addBook(sel