Re: [ADMIN] Altering WAL Segment File Size

2005-10-04 Thread Sivakumar K
    I believe the parameter which needs to be changed is XLOG_SEG_SIZE inside src/include/pg_config_manual.h.     Also go through the comments embedded in the file.       Please feel free to correct me.     Regards, Siva Kumar.K -Original Message-

Re: [ADMIN] Reg:sql command

2005-08-24 Thread Sivakumar K
gre; Sivakumar K Subject: Re: [ADMIN] Reg:sql command On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote: > Hi, > Is there any equivalent command for '\d tablename'. > Inorder to get the table structure is there any SQL query in postgres? > use psql -E to see the SQL commands that

Re: [ADMIN] Reg:sql command

2005-08-24 Thread Sivakumar K
, 2005 2:47 PM To: sandhya Cc: postgre; Sivakumar K Subject: Re: [ADMIN] Reg:sql command On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote: > Hi, > Is there any equivalent command for '\d tablename'. > Inorder to get the table structure is there any SQL query in postgres? > use

Re: [ADMIN] error codes in postgresql

2005-08-22 Thread Sivakumar K
, August 22, 2005 7:12 PM To: Sivakumar K Cc: postgre; sandhya Subject: Re: [ADMIN] error codes in postgresql   Hi, I have one doubt,   Inorder to get the field type in a table i am using pg_field_type(res,col_no)   Col_no : Is the field no. for which i have to know the

Re: [ADMIN] error codes in postgresql

2005-08-17 Thread Sivakumar K
-Original Message- From: sandhya [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 17, 2005 6:16 PM To: Sivakumar K Cc: postgre; sandhya Subject: Re: [ADMIN] error codes in postgresql   Thank you Sivakumar. ExecStatusType PQresultStatus(const PGresult *res); Will

Re: [ADMIN] error codes in postgresql

2005-08-17 Thread Sivakumar K
Hi sandhya,   You can use PQresultStatus API to get the result status of the command execution   And PQresStatus to convert the enumerated type returned by PQresultStatus to a string constant.   For more information you can check the libpq API documentation   http://www