Re: [ADMIN] Fatal error: Allowed memory size of 8388608 bytes exhausted

I am using PHP4 as client side. - Original Message - From: Tom Lane [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Cc: Postgre General [EMAIL PROTECTED]; Postgre Admin [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:44 AM Subject: Re: [ADMIN] Fatal error: Allowed memory size

[ADMIN] PostgreSQL query failed: ERROR: pg_atoi: zero-length string

If I try to delete a record from my table which is giving following error Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in /xxx/database.inc on line 73 What might be the problem. Regards, Sreedhar Bhaskararaju ---(end of

[ADMIN] Fatal error: Allowed memory size of 8388608 bytes exhausted

If I try to insert I got the following error as Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 79 bytes) Where to set that. Regards, Sreedhar Bhaskararaju ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

[ADMIN] Warning: PostgreSQL query failed

Hi All, I am framing Insert statements using PHP from the following information 107-Flash 5cartoons and Games\SMARTSOUND\SOUNDFILES | File Folder | 0 | 02/02/2001 09:33:31 PM 107-Flash 5cartoons and Games\SMARTSOUND\SOUNDFILES\KICKIN'BACK.SDS | OpenOffice.org 5.0 Chart | 13803564 | 11/22/2000

Re: [ADMIN] [GENERAL] How can I set postmaster as a service

/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -i '-p ${PGPORT}' start /dev/null 21 /dev/null How can I rectify this error. - Original Message - From: Reid Thompson [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Sent: Friday, September 05, 2003 11:20 PM Subject: RE: [GENERAL

Re: [ADMIN] [GENERAL] How can I set postmaster as a service

It is RHLinux 7.3. - Original Message - From: Reid Thompson [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:49 PM Subject: RE: [GENERAL] How can I set postmaster as a service what operating system reid -Original Message- From

[ADMIN] How can I set postmaster as a service

How can I set postmaster (database on) as a service and set it while system booting if self? Regards Sreedhar Bhaskararaju ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] [ADMIN] Call to undefined function: pg_connect()

am very sorry for my last mail. The above are the libpq.so available in my RH7.3 + PHP 4.1.2+ Postgre 7.3.2. Is this libpq.so is right combination. Sreedhar - Original Message - From: Gregory S. Williamson [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED]; Joe Conway [EMAIL PROTECTED] Cc

[ADMIN] Call to undefined function: pg_connect()

Hi All, I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to 7.3.2. After updating I could not able to connect database through PHP. So I recompiled PHP4.1.2 (same version which have earlier in my system), even then I am not able to connect through PHP. Is there any other

[ADMIN] Fatal error: Call to undefined function: pg_connect()

Hi All, I updated postgre from 7.2.4 to 7.3.2 in my RHLinux7.3 system and updated current pghba.conf and postgresql.conf files as per my need. But If I try to connect through PHP which was connecting earlier with 7.2.4 is giving the following error Fatal error: Call to undefined function:

[ADMIN] cannot read block 319 - Input/output Error

Why I could not able to take total backup of my database. Either I take backup or Vaccum I am getting error in following table. How Can I solve this problem. NOTICE: --Relation tblprojectfunctions--ERROR: cannot read block 319 of tblprojectfunctions: Input/output errorvacuumdb: vacuum

Re: [ADMIN] Error while loading external data into Postgres table.

Title: Error while loading external data into Postgres table. What is delimiter you had given in you 'Copy' command. Is there any array field in your destination table. Sreedhar - Original Message - From: Bodanapu, Sravan To: PGSQL General (E-mail) Cc: PGSQL Admin

[ADMIN] How can i port data from SQL-Server 2000 to Postgre.

How can i port data from SQL-Server 2000 to Postgre. If I use SQL-Server DTS, I got ODBC call failure error. Which version of ODBC is appropriate for this. Regards, Sreedhar Faith, faith, faith in ourselves, faith, faith in God, this is the secret of greatness. If you have faith in all the three

[ADMIN] Is there any UNIT TESTING tool for postgre

Hi All, Is there any UNIT TESTING tool for postgre like PLSQLUNIT for ORACLE Regards Sreedhar Faith, faith, faith in ourselves, faith, faith in God, this is the secret of greatness. If you have faith in all the three hundred and thirty millions of your mythological gods, and in all the gods

[ADMIN] what is the cause that scan type is showing as 'seq scan' after indexing

Hi All, Before indexing query plan was showing cost as 40.00, after indexing query plan again showing as 'seq scan' and cost as 3060.55. The field which i indexed is primary key to this table. May i know 1) what is the cause that scan type is showing as 'seq scan' after indexing also 2) why it is

[ADMIN] how sub queries and joins differs funcationally

Can any body tell that how sub queries and joins differs funcationally. Because sub queries taking lot of time than joins. Regards, Sreedhar Faith, faith, faith in ourselves, faith, faith in God, this is the secret of greatness. If you have faith in all the three hundred and thirty millions of

[ADMIN] How can I make note of time taken by each query to execute in Triggers

Hi All, I would like read time taken by each query in my triggers. so i created a temporary table and inserted timestamp before i start qurey and inserted again timestamp after completion of the query. But i am getting same time. How can I get the time taken by each query. Regards, Sreedhar

[ADMIN] How can I skip specific characters while retreiving data - postgre

Hi All, May I know how can I replace 'Enter Character' to 'balnk space' character, while retreiving data from my database. While storing data in a field of type text, i am storing with 'Enter' characters, but I have to give to my applciation data with our 'Enter Keys', so I have to skip 'Enter'

[ADMIN] Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED() of SQLServer2000

Is there any eqvivalent or alternative to the following IF UPDATE(column) or IF(COLUMNS_UPDATED()) of SQLServer2000. IF UPDATE (column) Tests for an INSERT or UPDATE action to a specified column and is not used with DELETE operations. More than one column can be specified. Because the table name

Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000

Sorry, Because it is some problem in my system. So, it has shown Fri, 15 Mar 2002 17:27:30 +0530. Kindly any body give solution to my problem. Sreedhar. - Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 11:03 PM

Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000

Dear Momjian, I need solution for the problem stated in subject. (i.e.) any method to know whether a record is Previously updated or not ? Sreedhar - Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Sent: Friday, December 27, 2002 10:41 AM Subject

[ADMIN] StreamServer Port : bind() failed : How to solve this problem

Hi All, I install Postgre database which comes with RH7.3. If I stop database with 'CTRL-c' and run database using postmaster -i -D /usr/local/pgsql/data i am getting following error message. StreamServer Port : bind() failed : Address already in use. is another postmaster already running on

Re: [ADMIN] Disabling triggers on a relation.

Hi Bhuvan Mallah, Have you checked desabling of triggers. What reltriggers represent. If we set it as '0' to enable by what value it has to be updated. Sreedhar - Original Message - From: Bhuvan A [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 02, 2002 3:16 PM Subject:

[ADMIN] What will be the entry in pg_hba.conf to connect as LocalHost

To Connct database as the following parameters. host : 'localhost' username : 'xxx' password : 'xxx' database : 'xx' What will be the entry in pg_hba.conf I gave the entry as host all 127.0.0.1 255.255.255.0 password. Which is rejecting user xxx. User 'xxx' is already in pg_shadow. Cheers,

[ADMIN] Where can i get souce of pgsqlODBC.

Hi All, Where can i get souce of pgsqlODBC. Regards, Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : 4475111 Email : [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

[ADMIN] Is Postgre can configure with IIS

Is Postgre can configure with IIS. thanks Regards Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : 4475111 Email : [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

[ADMIN] Ident authentication problem

Hi all, I installed Postgresql from RHLinux7.3. I modified pg_hba.conf as local alltrust host all 192.168.0.0 255.255.0.0 trust I have crated a user 'sreedhar' with password 'sreedhar' If tried to install

[ADMIN] Doubt in Plpgsql

Hi all, I am sorry for putting this question in this list. Hope some body may know 'plpgsql' in postgres. As Iam practicing plpgsql I wrote the following code which is not retrieving data. declaretemprec record;funcs text;funcid integer; beginfuncs := 'success'; for temprec in select

[ADMIN] How to change datatype of a field

Is there any possibility to change datatype of a field. regards, S Baskar

[ADMIN] How can i drop a foreign key relation

Hi all, How can i drop a foreign key relation. In my database I gave reverse relation ships which i should alter. thanks alot, with best regards, baskar

[ADMIN] Problem in User Securities

can i set pg_hba.conf which will restrict either 'local' or 'host' not to enter with our giving password. thanks alot. with best regards, S Baskar On Mon, 2002-05-20 at 10:32, shreedhar wrote: Hello All, I am new to Postgres, While I was checking 'User Securities' in postgres I got

[ADMIN] Problem in 'User Securities' in postgres

Hi All, I gave my previous mail on 'user securities' with subject 'probelm in usersecurities'. In that i mentioned that access to database on localhost is allowed without password. I got suggestion that to go through 'clinet authentication'. As per that document i changed the 'pg_hba.conf'

[ADMIN] Problem in User Securities

Hello All, I am new to Postgres, While I was checking 'User Securities' in postgres I got the following problem. I created a user using 'createuser' command and gave superuser permissions. but while accessing database, even if we have not given '-W' password option it is entering into

[ADMIN] problem using trigger

Hi All, It is not a Admin question, But it is part of Administration. I would like store details of groups as well as users in to my dummy table as i inserted into pg_user as well as pg_group. for that i created a dummy table for pg_group with same structure. gdump; i created a function