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 of 8388608 bytes exhausted shreedhar [EMAIL PROTECTED] writes: 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) There is not, and never has been, any error message of that wording in the PG backend. You must be looking at some client-side failure. But since you didn't tell us what client-side code you're using, it's hard to say more than that... regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
[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 broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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 commands go to [EMAIL PROTECTED]
[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 01:15:54 PM as below. If I execute, I am getting a warning message in between as follows. But data has been inserted into the table. insert into tblFile (filename, filesize, filetype, modifieddate, parentid, catalogid) values ('SOUNDFILES', 0 , ' File Folder ', '02/02/2001 09:33:31 PM', 69454, 61) Warning: PostgreSQL query failed: ERROR: parser: parse error at or near BACK at character 53 in /usr/local/apache/htdocs/info/diskcat/database.inc on line 48 insert into tblFile (filename, filesize, filetype, modifieddate, parentid, catalogid) values ('KICKIN\'BACK.SDS', 13803564 , ' OpenOffice.org 5.0 Chart ', '11/22/2000 01:15:54 PM', 69455, 61) How can I handle this warning message. Regards, Sreedhar Bhaskararaju ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [ADMIN] [GENERAL] How can I set postmaster as a service
I already had postgresql file in /etc/rc.d/init.d. I run the following ln commands as specified. if I boot my system it is opening database. But failing while opening database by remote host. May be -i option is missing. If I use the following line in postgresql file su -l postgres -s /bin/sh -c /usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start /dev/null 21 /dev/null I could able to start database but I could not able to connect through remost host. If I change the option -o to -i I am getting an error while starting database itself. su -l postgres -s /bin/sh -c /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] How can I set postmaster as a service basically, mod the start script as necessary for your system. cp it to /etc/init.d as postgresqlscript or whatever you want to call it cd to /etc/rc3.d ln -s ../init.d/postgresqlscript S95postgresql ln -s ../init.d/postgresqlscript K94postgresql reid -Original Message- From: shreedhar [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:31 AM To: Postgre Admin; Reid Thompson Subject: Re: [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: shreedhar [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 7:26 AM To: Postgre Admin; Postgre General Subject: [GENERAL] 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 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
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: shreedhar [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 7:26 AM To: Postgre Admin; Postgre General Subject: [GENERAL] 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 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[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()
-rw-r--r--1 root root99586 Aug 6 20:37 libpq.a lrwxrwxrwx1 root root 12 Aug 6 20:37 libpq.so - libpq.so.3.0 lrwxrwxrwx1 root root 12 Aug 6 20:37 libpq.so.3 - libpq.so.3.0 -rwxr-xr-x1 root root92088 Aug 6 20:37 libpq.so.3.0 I 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: Postgre Admin [EMAIL PROTECTED]; Postgre General [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:03 PM Subject: RE: [GENERAL] [ADMIN] Call to undefined function: pg_connect() I don't have a clue about which is which, but I bet providing some dates (ls -l) would help figuring out which is the most recent vs. oldest) ... might provide helpful information to people who know more about compiling this beast. Greg Williamson -Original Message- From: shreedhar [mailto:[EMAIL PROTECTED] Sent: Thu 8/7/2003 12:13 AM To: Joe Conway Cc: Postgre Admin; Postgre General Subject: Re: [GENERAL] [ADMIN] Call to undefined function: pg_connect() /usr/lib/libpq.so.2 /usr/lib/libpq.so.2.0 /usr/lib/libpq.so.2.2 /usr/lib/libpq.so I have the above versions of libpq.so in my system. Which I have to use. Suppose it might have to chage any config files where I should change. Thanks alot, With best regards, Sreedhar - Original Message - From: Joe Conway [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Cc: Postgre Admin [EMAIL PROTECTED]; Postgre General [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 10:24 AM Subject: Re: [GENERAL] [ADMIN] Call to undefined function: pg_connect() shreedhar wrote: 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 package has to be installed for this connection. If I remember correctly, this is because libpq.so changed from libpq.so.2 to libpq.so.3. Is there an old copy of libpq.so.2 hanging around that is getting linked with instead of libpq.so.3? Did you re-run configure and do a `make clean` on PHP before rebuilding it? If you are really desperate, try creating a libpq.so.2 symlink from libpq.so.3. HTH, Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[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 package has to be installed for this connection. Please some body help me out regarding. I am breaking my head since two days. Thanks for any idea. Regards, Sreedhar Bhaskararaju ---(end of broadcast)--- TIP 8: explain analyze is your friend
[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: pg_connect() Can any body encounter the same problem earlier can help me that in solving. Thanks alot, Sreedhar Bhaskararaju ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 pmnew_4 failed Thanks alot, Sreedhar Bhaskararaju
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 (E-mail) Sent: Monday, June 02, 2003 12:13 PM Subject: [ADMIN] Error while loading external data into Postgres table. Hi Gurus, I was trying to load data ( from flat file ) to postgres table using "copy" utility in postgres. It throws out an error "ERROR: copy: line 1, array_in: Need to specify dimension" and fails. I tried with couple of changes and nothing worked. Please advice me accordingly. Thanks, - Sravan. This message, including any attachments, contains confidential information intended for a specific individual and purpose and is protected by law. If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies. You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The sender accepts no liability for any damage caused by any virus transmitted by this email. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.
[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 hundred and thirty millions of your mythological gods, and in all the gods which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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 showing cost as high value compare to previous. pmnport2=# explain select * from tblpermissions where accountid in (296,290,292 ,293) and raccountid not in (296,290,292,293); NOTICE: QUERY PLAN: Seq Scan on tblpermissions (cost=0.00..40.00 rows=19 width=8) EXPLAIN pmnport2=# create index tblpermissions_accountid_idx on tblpermissions (account id); CREATE pmnport2=# explain select * from tblpermissions where accountid in (296,290,292 ,293) and raccountid not in (296,290,292,293); NOTICE: QUERY PLAN: Seq Scan on tblpermissions (cost=0.00..3060.55 rows=1459 width=8) EXPLAIN pmnport2=# With Best 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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[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 your mythological gods, and in all the gods which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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' Keys while retreiving. I searched for character set in postgre. But I could not able to find it. 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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 is specified in the ON clause, do not include the table name before the column name in an IF UPDATE clause. To test for an INSERT or UPDATE action for more than one column, specify a separate UPDATE(column) clause following the first one. IF UPDATE will return the TRUE value in INSERT actions because the columns have either explicit values or implicit (NULL) values inserted. IF (COLUMNS_UPDATED()) Tests, in an INSERT or UPDATE trigger only, whether the mentioned column or columns were inserted or updated. COLUMNS_UPDATED returns a varbinary bit pattern that indicates which columns in the table were inserted or updated. Thanks And 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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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 Subject: Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000 Your email is dated: Date: Fri, 15 Mar 2002 17:27:30 +0530 -- - shreedhar wrote: 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 is specified in the ON clause, do not include the table name before the column name in an IF UPDATE clause. To test for an INSERT or UPDATE action for more than one column, specify a separate UPDATE(column) clause following the first one. IF UPDATE will return the TRUE value in INSERT actions because the columns have either explicit values or implicit (NULL) values inserted. IF (COLUMNS_UPDATED()) Tests, in an INSERT or UPDATE trigger only, whether the mentioned column or columns were inserted or updated. COLUMNS_UPDATED returns a varbinary bit pattern that indicates which columns in the table were inserted or updated. Thanks And 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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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: Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000 Sure. As root, use the 'date' command to fix it. -- - shreedhar wrote: 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 Subject: Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000 Your email is dated: Date: Fri, 15 Mar 2002 17:27:30 +0530 -- - shreedhar wrote: 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 is specified in the ON clause, do not include the table name before the column name in an IF UPDATE clause. To test for an INSERT or UPDATE action for more than one column, specify a separate UPDATE(column) clause following the first one. IF UPDATE will return the TRUE value in INSERT actions because the columns have either explicit values or implicit (NULL) values inserted. IF (COLUMNS_UPDATED()) Tests, in an INSERT or UPDATE trigger only, whether the mentioned column or columns were inserted or updated. COLUMNS_UPDATED returns a varbinary bit pattern that indicates which columns in the table were inserted or updated. Thanks And 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 which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. (III. 190) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 port 5432 If not, wait a few seonds, and retry postmaster : cannot create INET stream port. If halt from system and restart then only it is working. May I know what might be the problem. Can I have to change any settings. Regards, Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : 4475111 Email : [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
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: Re: [ADMIN] Disabling triggers on a relation. What is the correct method of temporarily disabling all triggers from a table? Disable: db=# update pg_class set reltriggers = '0' where relname = 'your_table'; Enable: db=# update pg_class set reltriggers = (select count(*) from pg_trigger where pg_class.oid = tgrelid) where relname = 'your_table'; also is there any command/function to show the trigger defination ? like pg_index_def does for indexes? Not sure. regards, bhuvaneswaran ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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, 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 unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 PROTECTED]
[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 data into database which had already created psql database /filename I got the following error ' Ident authentication failed for user 'sreedhar'' may i know what might be the cause. because i am not using pg_ident file all. thanks, with best regards, Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : 4475111 Email : [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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 * from tbldefaultaccounts loop -- if record belongs to project functionif temprec.isfunction = 't' thenfuncid := 1;select functionid into funcid from tblFunctionHierarchy where HierarchyName = temprec.fname; funcs := funcs || ', ' || funcid ; end if; end loop; return funcs;end; Can any body say what is problem with this code. I hope it might have problem after where condition. where tbldefaultaccounts is daccid serial; fname varchar(50); and tblFunctionHierarchy is functionid serial; name varchar(50);
[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
Hi all, I went through pg_hba.conf, I tried to change 'local' and 'Host' permissions. I gave permissions like local all password host all x.x.x.x x.x.x.x password if i tried to login using my database password i got an error like 'password authentication failed'. can any body tell how 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 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 database. So who knows Unix administrator password can enter into any database if they know corresponding login name and they work with the same permissions.. And also i observed that even we can enter into template1 with out giving any username or password. I doubt there will be a way to restrict this. Can any body help me regarding this. Look at $PGDATA/pg_hba.conf, which defines your access control. -- Oliver Elphick [EMAIL PROTECTED]Isle of Wight http://www.lfix.co.uk/oliverGPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "For all that is in the world, the lust of the flesh, and the lust of the eyes, and the pride of life, is not of the Father, but is of the world." I John 2:17
[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' file as follows. local all password while accessing database it is asking for password, if i give database password, i am getting error as 'password authentication failure for user '' ' . host all x.x.x.x x.x.x.x password If i try to connect through pg_access (tcp/Ip) connection. If I supplied user password i got same above error. In case of 'trust' connection it is allowing every body without password checking. How can i use password authentication. Another question shall we use 'unixsecurities' using Postgres like 'windows-nt and sqlserver'. and what security protocol is maintaining by postgres. thanks alot for any suggestion. with best regards, bhaskar
[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 database. So who knows Unix administrator password can enter into any database if they know corresponding login name and they work with the same permissions.. And also i observed that even we can enter into template1 with out giving any username or password. I doubt there will be a way to restrict this. Can any body help me regarding this. Thanks alot, With best Regards bhaskararaju ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 aa_insertgdump with the following script No input parameters, return value is integer, language plpgsql declare gid integer; begin select max(grosysid) into gid from pg_group; insert into gdump select * from pg_group where grosysid = gid); return 1; end; I thought of executing this function using a trigger after insertion into pg_group. create trigger gdumptable after insert on pg_group for each row execute procedure aa_insertgdump(); but, it is giving error as can't create trigger for system relation pg_group. Can any one suggest what is the solution to my problem. regards, bhaskarraju. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])