Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-02 Thread Purusothaman A
any pattern to corrupt the file objects. Regards, Purusothaman A On 6/2/07, Tom Lane [EMAIL PROTECTED] wrote: Paolo Bizzarri [EMAIL PROTECTED] writes: Any hint? Please provide a reproducible test case ... regards, tom lane

Re: [GENERAL] Corruption of files in PostgreSQL

2007-05-30 Thread Purusothaman A
corruption. You also confirm you problem like this. And I strongly believe that, there is some bug in PostgreSQL. Kindly don't forget to alert me once u find solution/cause. Regards, Purusothaman A On 5/30/07, Paolo Bizzarri [EMAIL PROTECTED] wrote: On 5/30/07, Richard Huxton [EMAIL PROTECTED

Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.

2007-05-24 Thread Purusothaman A
? Is it bug in Posstgresql or is they any way to solve this problem. Thanks. Regards, Purusothaman A On 5/24/07, Richard Huxton [EMAIL PROTECTED] wrote: Purusothaman A wrote: Richard Huxton, Thanks for your detailed reply. I am maintaining various database of same kind in postgresql. Here

Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.

2007-05-23 Thread Purusothaman A
. (this could be reason?...) This problem occurs only few weeks after uploading files. Regards, Purusothaman A On 5/16/07, Richard Huxton [EMAIL PROTECTED] wrote: Purusothaman A wrote: Hi all, I am using Postgresql 8.2. 8.2.which? I am using client side api to upload/download files to/from

Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.

2007-05-23 Thread Purusothaman A
uploaded to postgresql. Usually this problem arises only after the database become large. Any suggestion to rectify this problem would be nice of you. Thanks. Regards, Purusothaman A On 5/23/07, Richard Huxton [EMAIL PROTECTED] wrote: Purusothaman A wrote: Thanks Richard Huxton for your

Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.

2007-05-23 Thread Purusothaman A
valuable suggestion. Thanks. Regards, Purusothaman A On 5/23/07, Richard Huxton [EMAIL PROTECTED] wrote: Purusothaman A wrote: Dear Richard Huxton, Thanks for your quick reply. only the first 3 values(HX, MASK, Rockey4ND) are file object's oid value. the other two are are not oid values

[GENERAL] OIDs - file objects, are damaged by PostgreSQL.

2007-05-15 Thread Purusothaman A
problem? Regards, Purusothaman A -- http://PurusothamanA.wordpress.com/

[GENERAL] OID - file object, are damaged by PostgreSQL.

2007-05-14 Thread Purusothaman A
problem? Regards, Purusothaman A

[GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Purusothaman A
Hi all,I am using a Fedora Core 5 system.I want to know what is the default username password for PostgreSQL, which was installed with FC5.:)Purusothaman A

Re: [GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Purusothaman A
Thanks for your immediate reply.I created new role db1 and database db1.but I cannot login using psql -Udb1 -ddb1 -hlocalhostresultsFatal Error : Ident authentication failed for user db1. Waiting for your valuable suggestion.Thanks in advance.:)Purusothaman AOn 10/27/06, Martijn van Oosterhout

Re: [GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Purusothaman A
Thanks for all of your valuable replies.Please tell me, what should i do to login with syntax psql -Uusername -h192.168.2.2 -dusername(database name).Because I should be able to login from any login and also from any system. :)Purusothaman AOn 10/27/06, Martijn van Oosterhout kleptog@svana.org

Re: [GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Purusothaman A
problem.Thanks for u all and your replies.:)Purusothaman AOn 10/27/06, Purusothaman A [EMAIL PROTECTED] wrote: Thanks for all of your valuable replies.Please tell me, what should i do to login with syntax psql -Uusername -h192.168.2.2 -dusername(database name).Because I should be able to login from any

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-12 Thread Purusothaman A
Thank you Marco Bizzarri.My solution would be C API.Thanks for you prompt response.:)Purusothaman AOn 9/11/06, Marco Bizzarri [EMAIL PROTECTED] wrote: On 9/11/06, Purusothaman A [EMAIL PROTECTED] wrote: Hi Marco Bizzarri and Martijn van Oosterhout, Thanks for your valuable reply. I am trying

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Purusothaman A
is the value 131072? How can I get this vlaue?According to PostgreSQL documentation, they gave C Syntax as client side function. Should I use those C API calls?:)Purusothaman AOn 9/11/06, Marco Bizzarri [EMAIL PROTECTED] wrote:I will try to explain it with a sample session: this is for creating and writing

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Purusothaman A
give example or equivalent client side function syntax?Thanks in advance.:)Purusothaman A On 9/9/06, Martijn van Oosterhout kleptog@svana.org wrote: On Sat, Sep 09, 2006 at 05:19:26PM +0530, Purusothaman A wrote: I usually log in to postgresql server with admin username. But whatever its, according

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Purusothaman A
Thanks Martijn van Oosterhout,So, I have to write my own wrapper function upon the functions below. 1. Oid lo_import(PGconn *conn, const char *filename); 2. int lo_export(PGconn *conn, Oid lobjId, const char *filename); Am I right?:)Purusothaman AOn 9/11/06, Martijn van Oosterhout kleptog

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Purusothaman A
sql statements.:)Purusothaman AOn 9/11/06, Martijn van Oosterhout kleptog@svana.org wrote:On Mon, Sep 11, 2006 at 03:27:09PM +0530, Purusothaman A wrote: Thanks Martijn van Oosterhout, So, I have to write my own wrapper function upon the functions below. 1. Oid lo_import(PGconn *conn, const char

[GENERAL] Problem with lo_export() and lo_import() from remote machine.

2006-09-09 Thread Purusothaman A
type.The above query works, if I enter from PostgreSQL server machine. But the same query fails, if I enter from any other client machine in my LAN.All other queries work well from remote machine, which do not deal OID data type column.any suggestions would be appreciated. :)Purusothaman A

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-09 Thread Purusothaman A
PostgreSQL server/client are Windows XP machines.Any suggestion???:)Purusothaman AOn 9/9/06, Milen A. Radev [EMAIL PROTECTED] wrote: Purusothaman A написа: Hi all, I have problem while using lo_export() and lo_import() from remote system. eg: select lo_export(img_file, 'E:\\temp\\1001.jpg

[GENERAL] Win2000 professional / Error message while installing PostgreSQL Failed to create process: 2! .

2006-08-26 Thread Purusothaman A
-09/msg00059.phpThanks in advance.:)Purusothaman A