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

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

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

cation 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 Po

[ADMIN] How to change datatype of a field

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

[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 I am practicing plpgsql I wrote the following code which is not retrieving data.   declare temprec record; funcs text; funcid integer;   begin funcs := 'success';    for temp

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

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

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

[ADMIN] Pg_acl check Invalid userid 106

i am getting an error when connecting to the postgres thru our web application - Pg-aclcheck Invalid Userid 106 with regards Sreedhar Bhaskararaju 1,2nd Main Road, KotturGardens, Chennai - 600 085 Ph : 4475111 Email : [EMAIL PROTECTED] ---(end of broadcast)-

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 Subj

[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, Sr

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

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

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: Fr

[ADMIN] How can I replace 'Enter Character' to 'balnk space character'

Hi All, May I know how can I replace 'Enter Character' to 'balnk space' character, while retreiving data from my database. 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 mytho

[ADMIN] How can I replace 'Enter Character' to 'balnk space character' in postgre

Hi All, May I know how can I replace 'Enter Character' to 'balnk space' character, while retreiving data from my database. 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 myth

[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' K

[ADMIN] Is There any function to get Difference of Dates

Hi All, Is There any function to get Difference of Dates. Here tdate is of type timestamp If I tried select * from temptbldate WHERE (EXTRACT(EPOCH FROM TIMESTAMP 'now()') - EXTRACT(EPOCH FROM TIMESTAMP tdate) )/ 86400 < 2 I got error as 'Parse error at tdate' select * from temptbldate WHERE

Re: [ADMIN] Is There any function to get Difference of Dates

Hi All, I got solution from the following link. http://techdocs.postgresql.org/techdocs/faqdatesintervals.php Thanks, Sreedhar - Original Message - From: "shreedhar" <[EMAIL PROTECTED]> To: "Postgres" <[EMAIL PROTECTED]> Sent: Thursday, January 16,

[ADMIN] Triggers taking much time to insert data

Hi All, I have table with almost 3,500 records with 9 fields which is similar structure to Table1. From that I am porting to following structure Table 1. T1f1 integer serial (primary key), T1f2 varchar(100) (unique), T1f3 integer default 0, T1f4 text, T1f5 boolean default 'f', T1f6 boolean defau

[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

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

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

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-m

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

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

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

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

- 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

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 >

[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()

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" <[EMAI

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

e itself. su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -i '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null How can I rectify this error. - Original Message - From: "Reid Thompson" <[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 0

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

[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

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: Wednesd