[GENERAL] any api in libpq to get the number of connections

Hi, is ther any api avaiable in libpq so that i can get the number of connections that exists with the database thanks, regards surabhi This message has been scanned by the Trend Micro IGSA and found to be free of known security risks

Re: [GENERAL] installation problem, for Postgres 8.2.0

I did it however i get the same error message should i reboot? thanks surabhi From: Shoaib Mir [mailto:[EMAIL PROTECTED] Sent: Mon 12/11/2006 4:34 PM To: surabhi.ahuja Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] installation problem, for Postgres

Re: [GENERAL] installation problem, for Postgres 8.2.0

the o/p for ldconfig -p | grep libreadline it is ibreadline.so.4 (libc6) => /usr/lib/libreadline.so.4 thanks, regards Surabhi From: Shoaib Mir [mailto:[EMAIL PROTECTED] Sent: Mon 12/11/2006 4:26 PM To: surabhi.ahuja Cc: pgsql-general@postgresql.org Subj

[GENERAL] installation problem, for Postgres 8.2.0

I am trying to install Postgre 8.2.0 on my mc FC4 first i installed the libs next when i tried installing: postgresql-8.2.0-2PGDG.i686.rpm it gave me this error: error: Failed dependencies: libreadline.so.5 is needed by postgresql-8.2.0-2PGDG please tell me what to do thanks, regard

[GENERAL] Postgres 8.1.5, 64 bit server running on FC4

Hi I had installed Postgres 8.1.5 , , 64 bit server running on FC4. I had seen that the performance is much slower than the corresponding 32 bit one Why is it so? (i have donr explain analyse, before performing the tests, also the num of rows etc were similar) Another thing that i want to me

[GENERAL] delete in PG 8.1.5 is slow

I have two similar datasets, on two diffrent m/cs. One m/c has PG 8.0.0 installed the other has PG 8.1.5 installed i vaccum analyzed both and i see that the delete performance in PG 8.1.5 is one third and sometimes one fifth of PG 8.0.0 please see that the number of rows etc is similar and bo

Re: [GENERAL] sudden drop in delete performance

alyze' after you did the update? Make sure you have the correct indexes in place on your foreign keys. Did you have fsync off on your previous installation? Give some more details and I'm sure people will be able to give better advice than me. Regards, Ben "&quo

[GENERAL] sudden drop in delete performance

I was using Postgres 8.0.0 I have upgraded it to Postgres 8.1.5 I have seen that the delete performance has degraded considerably. Nothing else has changed. Please help thanks regards Surabhi

Re: [GENERAL] IN clause

__ From: [EMAIL PROTECTED] on behalf of A. Kretschmer Sent: Fri 11/24/2006 2:59 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] IN clause am Fri, dem 24.11.2006, um 14:42:30 +0530 mailte surabhi.ahuja folgendes: > Hi, > > i have a table > and i have the query se

[GENERAL] IN clause

Hi, i have a table and i have the query select * from table where col_name is null; it returns some rows now, say i have to implement the same query using the in clause how shold it be done? select * from table where col_name in (null); but it does not return any rows. Can you please

Re: [GENERAL] dependency on 32 bit libpq.so on 64 bit Postgres server.

: surabhi.ahuja; pgsql-general@postgresql.org Subject: RE: [GENERAL] dependency on 32 bit libpq.so on 64 bit Postgres server. > let me explain with an example > say i have a 32 bit exceutable called Installer > > it dynamically links to 4 libraries which are called: > libdbx1, it

Re: [GENERAL] dependency on 32 bit libpq.so on 64 bit Postgres server.

659:1436573184 | DMF | 0 | ERROR | [EMAIL PROTECTED] | DMFConcreteRepositoryCreatorFactory.cxx:122 | Un known repository: dbexpress thanks regards Surabhi From: Albe Laurenz [mailto:[EMAIL PROTECTED] Sent: Thu 11/16/2006 2:54 PM To: surabhi.ahuja; pgsql-gene

Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC4

i have been able to generate the rpms for both 32 bit and 64 bit architectures, for postgres 8.1.5 FC4 thanks, regards Surabhi From: Devrim GUNDUZ [mailto:[EMAIL PROTECTED] Sent: Thu 11/16/2006 11:16 AM To: surabhi.ahuja Cc: Clodoaldo Pinto Neto; pgsql-general

Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC4

, regards Surabhi From: Devrim GUNDUZ [mailto:[EMAIL PROTECTED] Sent: Wed 11/15/2006 1:50 PM To: surabhi.ahuja Cc: Clodoaldo Pinto Neto; pgsql-general@postgresql.org Subject: Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC4 Hello, On Wed, 2006-11-15

[GENERAL] dependency on 32 bit libpq.so on 64 bit Postgres server.

Hi I have downloaded Postgres 8.1.4 for FC4 x86_64 bit arch. and installed on my m/c Earlier this machine had Postgres 8.0.0. However that time It was the normal 32 bit server. I build my project (which has dependency on libpq.so) and so i have the libraries which i copy onto the above machi

Re: [GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC 4

downlaoding PostgreSQL 8.1.5 for FC 4 2006/11/14, surabhi.ahuja <[EMAIL PROTECTED]>:>>  hi> I am trying to download PostgreSQL 8.1.5>> however this link does not contain anything:> http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/&g

[GENERAL] help needed, PG 8.0.0 ERROR: index is not a btree is solved in 8.0.9

  From: [EMAIL PROTECTED] on behalf of surabhi.ahujaSent: Fri 11/10/2006 12:03 PMTo: pgsql-general@postgresql.orgSubject: [GENERAL] how can i prove that this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree is solved in 8.0.9 hi I am using Postgres 8.0.0 and we found this i

[GENERAL] libpq.so full name?

 hi I had Postgres 8.0.0 installed on my m/c and now i have installed Postgresql 8.1.4 (FC 4) x86 , 64 bit arch.   i rebuild my executable giving -L$(ROOT)/postgres/lib/ -lpq   the directory $(ROOT)/postgres/lib contains libpq.so with size = 133320   it gives an error (linking error i think), ho

[GENERAL] empty folder for downlaoding PostgreSQL 8.1.5 for FC 4

 hi I am trying to download PostgreSQL 8.1.5   however this link does not contain anything: http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/ moreover the link http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4/ is just containing the dri

[GENERAL] how can i prove that this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree is solved in 8.0.9

hi I am using Postgres 8.0.0 and we found this issue "ERROR:  index "patient_pkey" is not a btree" I have been informed that we should shift to Postgres 8.0.9   I discussed this with my team member and they are asking if we can upgrade to the latest Postgres version i.e. 8.1.5   I have some

[GENERAL] reproducing this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree

 hi I am using Postgres 8.0.0 and we found this issue "ERROR:  index "patient_pkey" is not a btree" I have been informed that we should shift to Postgres 8.0.9   I discussed this with my team member and they are asking if we can upgrade to the latest Postgres version i.e. 8.1.5   I have some que

[GENERAL] delete performance is extremely slow

I am using postgresql 8.0.0   i have 4 tables a, b, c, d. with foreign key constraints. between table b and a between c and b and between d and c   I am doing delete from a   the total number of rows in table a is around 10 table b is around 20, similarly table c has around 20. table d however

Re: [GENERAL] postmaster slowing down

@postgresql.orgSubject: Re: [GENERAL] postmaster slowing down surabhi.ahuja wrote:> I am using postgres 8.0.0> In my program I have a single connection to a database.> in side this connection i do the following> > 1. begin transaction> 2. insert rows to table/s. (max number of tables = 4)> 3

[GENERAL] postmaster slowing down

PROTECTED]Sent: Mon 11/6/2006 12:20 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] upgrade to 8.0.9 Hi,On Mon, 2006-11-06 at 10:58 +0530, surabhi.ahuja wrote:> I am currently using 8.0.0 and I want to upgrade to 8.0.9 Please tell> if i can just install the rp

[GENERAL] upgrade to 8.0.9

Hi, I am currently using 8.0.0 and I want to upgrade to 8.0.9 Please tell if i can just install the rpms for 8.0.9   Will I not have to rebuild my application with new libpq.so? or does the libpq.so still remain the same.   Thanks, regards Surabhi

[GENERAL] start up and shut down script

I am using PostgreSQL 8.0.0.    i have noted the following lines in the script to start or shut down postmaster. Can you please let me know why they are needed   if [ "`uname`" = "Linux" ]; then   INITD=/etc/rc.d/init.d   . $INITD/functions   # Get config.   . /etc/sysconfig/networkfi and   i

[GENERAL] ERROR: index "patient_pkey" is not a btree

hi i am having postgres version 8.0.0 installed, on my machine   i created a database and the tables and the stored procedures for the same   however i get this error, while trying to execute an insert command, in postgreslog     PL/pgSQL function "insert_patient" line 20 at SQL statement<2006-

Re: [GENERAL] [JDBC] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend

scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:> org.postgresql.util.PSQLException: An I/O error occured while sending to> the backend.> Caused by: java.net.SocketException: Broken pipeThis is a network error that the driver can't do anything about

[GENERAL] PSQLException: An I/O error occured while sending to the backend

hi all, I am using Postgres 8.0.0 I am getting the following exception in my code, please help as to what may be going wrong. thanks, regards Surabhi   org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at org.postgresql.core.v3.QueryExecutorImpl.execute(Que

[GENERAL] org.postgresql.util.PSQLException: An I/O error occured while sending to the backend

Title: Re: [JDBC] question regarding upgrade from pg74.215.jdbc3.jar to hi, I am using Postgres 8.0.0, i am getting the following exception in my code, can you please suggest at to what may be going wrong? The postgres logs do not tell anything.   thanks, regards Surabhi     org.postgres

[GENERAL] error code when database does not exist

Title: [JDBC] Invalid column display size. Cannot be less than zero   i want to know what error code will be returned if the database does not exist.   i have the following list, howvere do not know which one shall be returned when database itself does not exits   http://www.postgresql.org/

Re: [GENERAL] psql seems to hang during delete query

free no single byte, as deleting is done with marking the row as deleted. Read up on multi version concurrency why this has to be that way. To reclaim space: vacuum freezeSo, to get space, you have to have space first. Delete something else. Harald On 7/20/06, surabhi.ahuja <[EMAIL

[GENERAL] psql seems to hang during delete query

i am using postgresql 8.0.0   my disk is 100% full   i have a database called x   i do the following psql x delete from table;     nothing happens   i try to see the top output   i see the following 1768 sdc   25   0 41860  32m  30m R 99.7  0.8  11:29.35 postmasteri also saw this appearing  

Re: [GENERAL] cant connect to the database, even after doing start

:44 PMTo: surabhi.ahujaCc: pgsql generalSubject: RE: [GENERAL] cant connect to the database, even after doing start ***Your mail has been scanned by InterScan VirusWall.***-***On Fri, 2006-07-14 at 02:48, surabhi.ahuja wrote:> this is what is happen

Re: [GENERAL] cant connect to the database, even after doing start

t MarloweSent: Thu 7/13/2006 9:27 PMTo: surabhi.ahujaCc: pgsql generalSubject: Re: [GENERAL] cant connect to the database, even after doing start ***Your mail has been scanned by InterScan VirusWall.***-***On Thu, 2006-07-13 at 01:20, surabhi.ahuja wrote:>

Re: [GENERAL] Delete Problem

Title: Re: [GENERAL] Delete Problem even i have seen this problem   i am using postgres 8.0.0   i open psql   and there i try to do delete from   it seems that psql gets stuck.   even after 5 mins or something, no deletion happens.   generally this happens when the disk is nearing to ful

[GENERAL] cant connect to the database, even after doing start of postmaster using a script

Hi all, i have a script to stop and start postmaster   However i have noticed this many a time sdnow. I stop postmaster using that script and then start using a script.   However if i try to do psql , it gives me an error saying that the postmaster is not up.   Why is it that the postmaster went

[GENERAL] error while installing the 8.1.4 rpms on my m/c

, surabhi.ahuja wrote:> it is ok if i uninstall the current version of postgres 8.0.0No. Please read this before you proceed:http://pgfoundry.org/docman/?group_id=148>  i am trying to install the rpms for 8.1.4 FC(4) Where can i find the> instaructions to download the r

Re: [GENERAL] planning to upgrade to 8.1

my m/c.   thanks, regards Surabhi From: Richard Broersma Jr [mailto:[EMAIL PROTECTED]Sent: Tue 6/27/2006 7:38 PMTo: surabhi.ahuja; pgsql-general@postgresql.orgSubject: Re: [GENERAL] planning to upgrade to 8.1 > I am currently using 8.0.0, i heard that 8.1 can help in performance bo

[GENERAL] planning to upgrade to 8.1

Title: [GENERAL] Preformace boost -- by 8.0.4 upgrade to 8.1.4 I am currently using 8.0.0, i heard that 8.1 can help in performance boost especially if the system is multi core processor. i am also planning to upgrade. To which version should i upgrade? Also Please tell if ther will be a

Re: [GENERAL] B+ versus hash maps

6/16/2006 1:49 AMTo: surabhi.ahujaCc: Michael Fuhr; pgsql-general@postgresql.orgSubject: Re: [GENERAL] B+ versus hash maps On Jun 15, 2006, at 8:07 AM, surabhi.ahuja wrote:> is there any way of specifying wht type of index i want, say hash > maps instead of the B+ trees.> someone tol

[GENERAL] B+ versus hash maps

.***-***On Mon, Jun 12, 2006 at 12:54:15PM +0530, surabhi.ahuja wrote:> i have four tables in my database> TAB1, has one primary key T1> > TAB2 , has 2 fields, one is the primary ley T2 and the other one> is the foreign key T1(from TAB1)> > TAB3 also has

Re: [GENERAL] delete seems to be getting blocked

: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] delete seems to be getting blocked ***Your mail has been scanned by InterScan VirusWall.***-***On Mon, Jun 12, 2006 at 12:54:15PM +0530, surabhi.ahuja wrote:> i have four tables in my datab

[GENERAL] delete seems to be getting blocked

hi, I am using postgresql 8.0.0. i have four tables in my database TAB1, has one primary key T1   TAB2 , has 2 fields, one is the primary ley T2 and the other one is the foreign key T1(from TAB1)   TAB3 also has 2 fields, one is the primary ley T3 and the other is the foreign key T2(from TAB2)  

[GENERAL] date value not geting inserted properly

i have a cloumn in my table which is date type   i parse a file to get the date from there,   and then i form a call to the stored procedure, with the above data as the parameter.   but however it seems that when i form this call, something is messing up, and the value for the birth date, gettin

[GENERAL] foreign key violation

i have 2 tables.   the first table "TAB1", has a primary key "id", which is the foreign key in the second table "TAB2"   i have 2 stored procedures, 1 stored procedure does   check if there is a row already present in TAB1 with col 2 = $1; if not present then insert into TAB1(col2)  values ($1 )

[GENERAL] latest release of 8.0.8

Title: Re: [GENERAL] postgreslog - panic message where can i download the rpms for the PostgreSQL version 8.0.8 till now we have been using 8.0.0.   thanks, regards Surabhi

[GENERAL] postgreslog - panic message

hi, i am getting the following error messages:   <2006-05-24 15:28:08 CDT%>LOG:  could not bind IPv4 socket: Address already in use<2006-05-24 15:28:08 CDT%>HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.<2006-05-24 15:28:08 CDT%>WARNING:  could

[GENERAL] postgreslog-semctl(7438339, 4, SETVAL, 0) failed:

I am using postges, 8.0.0 on that system , it seems that there are two databases, i am not sure if the same postmaster is used to connect to both the databases,     i am seeing these logs in postgreslog   <2006-04-19 01:13:25 IST%>LOG:  connection received: host=[local] port=<2006-04-19 01:13:2

[GENERAL] remove another version of postgreSQL

i did ps -aef | grep postmaster and i saw :   surabi   31787 28525  0 Apr24 pts/20   00:00:00 /usr/local/pgsql/bin/postmaster -D /homes/surabi/data/postgres  6603 1  0 01:42 ?    00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/datapostgres 10887 10638  0 11:39 pts/17   00:00:00

[GENERAL] disk full scenario

if disk is near to full   and i establish a connection with postgres and read a table and then close the following error logs comes in postgreslog:   17:10:47 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress<2006-04-05 17:10:47 CDT%idle>LOG:  disconnection: session ti

FW: [GENERAL] code to cancel a running query, worker thread

  Help needed,   i have the following peice of code, which is meant for cancelling queries in between   import java.sql.*; public class QueryExecutor implements Runnable {  /**  * @param args  */ private Thread worker; private Params params; private Results results; private volatile boolean

[GENERAL] some error messages in postgeslog

I use PostgreSQL 8.0.0   it seems that the disk was close to full,   i executed a program (in C++) which opens a connection to Postgres using PQConnectdb.   and then it reads from a particluar table, and simply displays the values on the console.   after doing that it will close the connection

[GENERAL] code to cancel a running query, worked thread

i have the following peice of code, which is meant for cancelling queries in between   import java.sql.*; public class QueryExecutor implements Runnable {  /**  * @param args  */ private Thread worker; private Params params; private Results results; private volatile boolean cancelRequest; privat

Re: [GENERAL] catch SQLException, error code for Foeign key violation,

, ***Your mail has been scanned by InterScan VirusWall.***-***On Mon, 17 Apr 2006, surabhi.ahuja wrote:> The question is that is from this SQLException can i detect if it is a> foreign key violation,>You should check the value of SQLException.getSQLState(

[GENERAL] i have a core file on running gdb the op

  this is the op on running gdb.   Is it possible that i can send the core file?       Type "show copying" to see the conditions.There is absolutely no warranty for GDB.  Type "show warranty" for details.This GDB was configured as "i386-redhat-linux-gnu"...(no debugging symbols found)...    

[GENERAL] catch SQLException, error code for Foeign key violation,

i am working with PostgreSQL 8.0.0   and the programming lang used is java   i have a stored procedure which inserts a row in a table   to this stored procedure i pass the values which have to be inserted in that row.   now, i execute this query(which is a call to stored procedure)   this execut

Re: [GENERAL] hard shutdown of system

lto:[EMAIL PROTECTED]Sent: Mon 4/17/2006 1:14 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] hard shutdown of system ***Your mail has been scanned by InterScan VirusWall.***-***On 4/17/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:>&

[GENERAL] hard shutdown of system

the user tries to do kill -9 -1 and log in again   in the startup script i do the following   /sbin/pidof -s postmaster   and it still displays some value,   however ps -aef | grep postmaster does not display anything   is it ok if i do the following  pid1=`/sbin/pidof -s postmaster` pid2=`ps -

[GENERAL] hard shut down of system

if postmaster is running and i do,   kill -9 -1 i.e. i did abrupt shut downnow when i brought back the system i am not able to start postmaster actually i want to simulate, the scenario is which the user will do 'hard shut down / Power off'while system is in working state.. and i want to ens

FW: [GENERAL] postmaster going down own its on

did start, then how come it suddently went down.will provide u with more info on the same,thanks,regardssurabhi-Original Message-From: Tom Lane [mailto:[EMAIL PROTECTED]]Sent: Fri 4/7/2006 8:51 PMTo: Douglas McNaughtCc: Martijn van Oosterhout; Richard Huxton; surabhi.ahuja; pgsql-gener

Re: [GENERAL] postmaster going down own its on

did start, then how come it suddently went down.will provide u with more info on the same,thanks,regardssurabhi-Original Message-From: Tom Lane [mailto:[EMAIL PROTECTED]]Sent: Fri 4/7/2006 8:51 PMTo: Douglas McNaughtCc: Martijn van Oosterhout; Richard Huxton; surabhi.ahuja; pgsql-gener

Re: [GENERAL] postmaster going down own its on

s, regards surabhi -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Fri 4/7/2006 8:51 PM To: Douglas McNaught Cc: Martijn van Oosterhout; Richard Huxton; surabhi.ahuja; pgsql-general@postgresql.org Subject: Re: [GENERAL] postmaster going down own its on ***

[GENERAL] postmaster going down own its on

hi, is it possible for postmaster to go doen on its own?   all what the logs say is FATAL: terminating connection dur to administrator's command.   thanks, regards Surabhi

[GENERAL] stored proc vs sql query string

i have heard somewhere that writing a stored procedure, is much better than firing a sql query(such as select * from table_name) onto the database. is it true and if yes how?   also i want to know that is the performnance in java slower as compared to cpp, given that the same things is being do

[GENERAL] 32 bit applications against 64 bit postgres server

hi all please tell if it is possible to Run your 32-bit applications against the 64-bit installed postgres server. I am using postgres 8.0.0 and for building my application i use the 32 bit postgres server. However those application will be running with the 64-bit installed postgres server.   w

Re: [GENERAL] back slash separated values

Title: Re: [GENERAL] back slash separated values SHOW server_version; server_version 8.0.6(1 row)   the stored procedure is :   CREATE OR REPLACE FUNCTION update_exam_modality(bigint, varchar(16)) RETURNS text AS'DECLARE    mod_of_study varchar(16);    mod_pattern varcha

Re: [GENERAL] partial resultset in java

Title: Re: [GENERAL] partial resultset in java   on which object is this method "cancel()" avaialble. the peice of code that i am looking at right now is :   Statement stmt_ = this.dbSession_.getDBConnection().createStatement();String queryStr = dbxQuery.createQuery(DBObject.getLevelNumber(

[GENERAL] back slash separated values

mod_pattern := mod_of_study || ''\\'' ||  $2;   is giving me syntax error, please tell how i can concat a backslah cgaracter.   Thanks, regards Surabhi

Re: [GENERAL] partial resultset in java

2006 11:23 AMTo: Michael SchmidtCc: surabhi.ahuja; PostgreSQL GeneralSubject: Re: [GENERAL] partial resultset in java *** Your mail has been scanned by InterScan VirusWall. ***-*** I believe you should restrict number of rows that needs to be re

[GENERAL] partial resultset in java

hi, i have a small question I have a table, with one of the fields called x (x is not the primary key, here)   now i have to make a query like this: select * from table where x = 1;   the number of rows retrieved from the above query is of the order of 20,000 or more.   the result is contained in

Re: [GENERAL] out of memory

Title: Re: [GENERAL] out of memory using Postgres with Spring/Hibernate/Java hi i use postgres 8.0.0 i have a test program in c++, which tries to insert rows into the tables of my database.   is there any way that i can check that there are no memory leaks etc happening.   i ran valgrind o

[GENERAL] FATAL: terminating connection due to administrator command

  please see the following snippet   Feb 27, 2006 6:23:51 .DMException: java.sql.SQLException: FATAL: terminating connection due to administrator command this error message is in one of the log files, and because of the above error the desired job does not get executed   i tried to see the p

[GENERAL]

please see the following snippet   Feb 27, 2006 6:23:51 .DMException: java.sql.SQLException: FATAL: terminating connection due to administrator command this error message is in one of the log files, and because of the above error the desired job does not get executed   i tried to see the postg

[GENERAL] regarding contains operator

 i have a field whose type is varchar(16)   and the field is multivalued, in the sense it is of the form   abc\def\tez (i.e. backslash separed values)   please tell me is there any operator available which enables me to do the following:   field contains   eg field contains "abc" should return

[GENERAL] backslash separated values for a field

Hi,    i have a field "x" which can be of the form   abc\def\123   i.e. they are back slash separated fields   is there any operator in postgres which can process a query like give me all xs where x is abc   is ther any opeartor like contain, so i can form a query of the form:   select * from

Re: [GENERAL] r trim of characters other than space

im of characters other than space ***Your mail has been scanned by iiitb VirusWall.***-***"surabhi.ahuja" <[EMAIL PROTECTED]> writes:> i want to make the following check,> if it is having carets in the end, then those carets be removed.

[GENERAL] r trim of characters other than space

Hi  hi i have varchar type fiels in a table.   i want to make the following check,   if it is having carets in the end, then those carets be removed.   so if i get a string like abc def   i should be able to get abc def   how should i do this.   thanks, regards Surabhi

Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"

ed 2/8/2006 4:48 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index" ***Your mail has been scanned by iiitb VirusWall.***-***surabhi.ah

Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"

ion_o_c_o_index" ***Your mail has been scanned by iiitb VirusWall.***-***surabhi.ahuja wrote:> i am trying to install postgresql-8.0.1Why? The most recent release for 8.0 is 8.0.6 and you're clearlycompiling from source, so why have you deliberately

[GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"

i am trying to install postgresql-8.0.1 i am now trying to do /usr/local/pgsql/bin/initdb -D data/   however this is what i get:   The files belonging to this database system will be owned by user "surabi".This user must also own the server process. The database cluster will be initialized with lo

[GENERAL] pg_dump, pg_restore

 i am trying to do :   pg_dump -f op.tar -F t database_name   then i do   dropdb database_name   and then i do pg_restore op.tar   and when i do psql database_name   it says database does not exist.   where am i going wrong?   thanks, regards Surabhi

[GENERAL] accidentally deleted rows

 hi,   i have acidentally deleted rows from a table. is it possible to recover them   i have read somewhere that the source code can be modified to recover them, can some one tell me the way so that it can be done.   Please note that i have no back up of the data, is it not possible to recover

[GENERAL] 2 instances of postmaster with different data directories

 Hi,   I am going to integrate my dtabase into a system. That system also has another database and uses postgres.   However they have their own data directory and start postmaster by specifying that.   I have seen that it is possible to run multiple postmasters on multiple ports by specifying di

Re: [GENERAL] FATAL: terminating connection due to administrator command

[mailto:[EMAIL PROTECTED]Sent: Tue 1/24/2006 8:22 PMTo: Richard HuxtonCc: surabhi.ahuja; pgsql-general@postgresql.orgSubject: Re: [GENERAL] FATAL: terminating connection due to administrator command ***Your mail has been scanned by iiitb VirusWall

Re: [GENERAL] FATAL: terminating connection due to administrator command

timestamps, for each log/warning etc. How do i do that? thanks, regards Surabhi -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Fri 1/13/2006 8:56 PM To: surabhi.ahuja Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] FATAL: terminating connection due to administrator

Re: [GENERAL] logging connections

TECTED] on behalf of surabhi.ahuja Sent: Mon 1/23/2006 2:04 PM To: Nikola Ivanov Cc: Tom Lane; pgsql-general@postgresql.org Subject: Re: [GENERAL] logging connections *** Your mail has been scanned by iiitb VirusWall. ***-*** i did the above, however still no l

Re: [GENERAL] logging connections

. similarly say if i do psql database_name this is also another connection, and shd get logged. however by the changes u suggested, i am not able to do so. thanks, reagrds surabhi -Original Message- From: [EMAIL PROTECTED] on behalf of Nikola Ivanov Sent: Fri 1/20/2006 7:41 PM To: surabhi.ahuja

[GENERAL] logging connections

Title: logging connections i want to know, how i can log connections to postgres. the sample log file is: LOG:  shutting down LOG:  database system is shut down LOG:  database system was shut down at 2006-01-17 18:18:24 CST LOG:  checkpoint record is at 0/B035D0 LOG:  redo record is at 0/B03

[GENERAL] FATAL: terminating connection due to administrator command

Title: FATAL: terminating connection due to administrator command i am seeing the following in the postgreslog why is it coming: FATAL:  terminating connection due to administrator command thanks, regards Surabhi

Re: [GENERAL] regarding triggers

delete a row from x, will the trigger still be called? -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Tue 1/10/2006 9:58 PM To: John McCawley Cc: surabhi.ahuja; pgsql-general@postgresql.org Subject: Re: [GENERAL] regarding triggers *** Your mail has b

[GENERAL] regarding triggers

Title: regarding triggers is there an advantage of using a trigger? when the same job can be performed by a stored procedure? one more question is as follows: suppose i have a table x, with a primary attribute 'a' and i have a table y, with the primary attribute 'b', and a foreign key 'a'.

[GENERAL] a few questions

 I have a few questions: 1. what is pg_xlog someone told me that i can move pg_xlog to a different parttion in order to boost the performance? Does it work and how     2. there is a parameter in postgresql.conf called max_connections. which is 100 be default. i want o decrease it to 20. by doin

[GENERAL] valgrind output

Hi i have a test runner and i am using valgrind to analyse memory leak: i use is as follows:    valgrind --tool=memcheck --leak-check=yes --log-file=op ./dbExpressInstall -r "dbexpress" -s "/gsp-dist/blr/developer/surabi/images/mr/im152" 1 1 1   here is the output:    ==6214== ERROR SUMMARY:

[GENERAL] how to check if a database exists programatically

 i have to write a shell script in which i have to check if the database "abc" exists or not   how should i do it ? some select query   select * from ??? where database_name = 'abc';

[GENERAL] is there any way of specifying "i want x GB of space to be avaialble for my database"

 here is a question   say i have a database and all the files(data files) indexes etc must be going to the PGDATA directory   The question is this: is there any way by which i can specify : to reserve x GB amount of space to this database (this x includes all the space which the database wi

[GENERAL] postmaster does not come up

hi all.. sometime back i had asked a question is ther no way to recove the database in case postmaster fails to come up??   i dont remember what was there in the log file ... i had seen it sometime back ...for which i dont have the logs   i dint check if by restarting the system the problem woul

Re: [GENERAL] postgres log file

s log file ***Your mail has been scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:>  the postgreslog has permission - 777, so anyone is able to write in it.> that s why it is atleast showing> >> LOG:  logger shutting down>> but

Re: [GENERAL] postgres log file

ton [mailto:[EMAIL PROTECTED]Sent: Tue 11/29/2005 5:40 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] postgres log file ***Your mail has been scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:>  hi> I start postmaster by g

[GENERAL] regarding Solaris 10

Title: Re: [GENERAL] errors with 8.1 make on Solaris i was using Postgre8.0 on linux. and was using the libpq libraries. i have to port the existing code now, to solaris 10, X86 architecture. are the libpq libraries still the same and the other api called to libpq, or they have to be changed?

  1   2   >