Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-01 Thread Purusothaman A
find 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
before 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, Richa

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

2007-05-24 Thread Purusothaman A
15\012 (631 rows) Have you noticed the bolded strings? What could have caused to damage that part? 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

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

2007-05-23 Thread Purusothaman A
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 va

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

2007-05-23 Thread Purusothaman A
hat I 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 H

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

2007-05-23 Thread Purusothaman A
Value" field as var char instead of oid. (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?

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

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

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

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

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 b

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

2006-10-27 Thread Purusothaman A
tog@svana.org> wrote: On Fri, Oct 27, 2006 at 11:43:26AM +0200, A. Kretschmer wrote:> am  Fri, dem 27.10.2006, um 15:01:09 +0530 mailte Purusothaman A folgendes:> > Thanks for your immediate reply.> >> > I created new role "db1" and database "db1". > &g

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

2006-10-27 Thread Purusothaman A
aman AOn 10/27/06, Martijn van Oosterhout < kleptog@svana.org> wrote:On Fri, Oct 27, 2006 at 02:45:57PM +0530, Purusothaman A wrote: > 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

[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] [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

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

2006-09-11 Thread Purusothaman A
ated a new large object, and stored a string of 4bytes inside of it.RegardsMarcoOn 9/11/06, Purusothaman A < [EMAIL PROTECTED]> wrote:> Thanks Martijn van Oosterhout and Marco Bizzarri.>> But, according to syntax of client side lo_import and lo_export, we should> have 2 variable PG

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

2006-09-11 Thread Purusothaman A
side 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

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

2006-09-11 Thread Purusothaman A
to open the file and copy it over using the lo_ functions. There no way (IIRC) to access the contents of large objects from just SQL.Hope this helps,On Mon, Sep 11, 2006 at 02:45:10PM +0530, Purusothaman A wrote:> Hi Martijn van Oosterhout,>> Thanks for your valuable reply. >> Yes I misun

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.>> B

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

2006-09-09 Thread Purusothaman A
.Both 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.>>

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

2006-09-09 Thread Purusothaman A
here emp_id = '1001';Here column "img_file" is OID data 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

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

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