[BUGS] ERROR: relation "pg_catalog.pg_user" does not exist

2007-02-22 Thread guru
we have installed Linux advanced server-4 and the postgres-7.4.6. when we execute \d command following error is displaying ERROR: relation "pg_catalog.pg_user" does not exist The database otherwise works correctly. I can create tables, load data, etc. re

[BUGS] socket error while creating database in windows98

2004-02-12 Thread Sh A Guru Prasad
host localhost and accepting TCP/IP connection on port 5432. Please kindly help us in solving this problem. regards guru ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] substring problem

2003-12-31 Thread Sh A Guru Prasad
select trn_id,substr(hoa_id,1,13) from tbill_master where substr(hoa _id,1,13)='2202031040006'; trn_id |substr +--- 25001203000416 | 2202031040006 25001203000417 | 2202031040006 25001203000418 | 2202031040006 25001203000419 | 2202031040006 250012030

[BUGS] (none)

2003-12-30 Thread Sh A Guru Prasad
Hi, How to convert number format (with decimal) into integer only ex:to conver 100.00 to 100. One more Do we have any code to convert number to words ex: 1234 to one thousand two hundredn and thirty four. (I want to use for indian currency only, i will use crores instead of billions) Thank you

[BUGS] decimal to integer, number to words

2003-12-30 Thread Sh A Guru Prasad
Hi, How to convert number format (with decimal) into integer only ex:to conver 100.00 to 100. One more Do we have any code to convert number to words ex: 1234 to one thousand two hundredn and thirty four. (I want to use for indian currency only, i will use crores instead of billions) Thank you

[BUGS] date validation problem

2003-12-29 Thread Sh A Guru Prasad
sir, in postgresql 7.3.2 when we are trying to query like select to_date('66555','ddmm'); the output is 5559-09-06 it is not validating the day and month and unknown format is the output.. any help regarding this is greatful... thank you ---(end of b

[BUGS] pg_connect() problem

2003-12-22 Thread Sh A Guru Prasad
After upgrading postgres from 7.1 to 7.3.2 PHP 4.0.6 was working fine but after upgrading PHP from 4.0.6 to 4.3.2 version it was unable to connect to database as pg_connect() was not working. bye guru ---(end of broadcast)--- TIP 8

[BUGS] installation problem

2003-12-08 Thread Sh A Guru Prasad
I am finding it difficult to install postgresql7.3.2 on linux advanced server. Repeatedly its asking for some or other files. Please let me know the exact procedure and what are the dependency files required for the same. bye guruprasad ---(end of broadcast)--