[GENERAL] regarding select into

 Hello,   Is it not possible to write such an sql statement:   select ser into val1, count(*) into val2 from tab1 where id = $1;   do i need to perform the 2 selects separately ..wont that impact the performance?   in the table tab1, id is the primary key.   Thank You   Regards Surabhi Ahuja

[GENERAL] insertion becoming slow

i have seen that after insertion say (20 k rows) the insertion to tables becomes slow..why is it?   is there any way in which u can stop the performance from degrading

[GENERAL] insertion becoming slow

 thanks for the help.. i removed a few indexes, but i cant remove the primary key and uniqye key constraints ..whoch means that indexes will be made on these 2 attributes.   i have four tables, each having such 2 attributes, one which is the primary key and the other is the uniqu key.   and the

[GENERAL] insertion becoming slow

 it is the commit call to postgres that suddently takes more time than normal(as observed for other inserts) it seems as if postgres does some activity (on its own) after some installs.   thats why i have observed this pattern i.e. commit taking less time for some installs (eg 1000) ..then s

[GENERAL] insertion becoming slow

 is it some logging information that is being written into some file at the end of some transactions (each intsall is one transaction for me)   the data directory is containing these folders..   base/    pg_clog/ pg_ident.conf  pg_subtrans/  PG_VERSION  postgresql.conf  postmaster.pidglobal

[GENERAL] postmaster does not shut down

 when i grep for postmaster ps -aef | grep postmaster   it says: /usr/bin/postmaster -D /export/home1/sdc_image_pool/dbx -p 5432   when i try to stop postmaster doing   /usr/bin/pg_ctl -D /export/home1/sdc_image_pool/dbx/ stop the following is displayed: waiting for postmaster to shut down..

[GENERAL] server , client encoding issue

 hi all   i am facing a problem and here it is:   i install the following (postgres) rpms as root postgresql-libs-8.0.0-1PGDG.i686.rpm postgresql-8.0.0-1PGDG.i686.rpm and postgresql-server-8.0.0-1PGDG.i686.rpm   now i try to create a database   /usr/bin/createdb temp   when i connect to it it sho

Re: [GENERAL] server , client encoding issue

issue ***Your mail has been scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:> when i connect to it> it shows: server_encoding : LATIN9> and client_encoding: LATIN9> > from where did it get these values From your environment -

Re: [GENERAL] server , client encoding issue

quot;LATIN9" From: Richard Huxton [mailto:[EMAIL PROTECTED]Sent: Tue 10/18/2005 6:04 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] server , client encoding issue ***Your mail has been scanned by InterScan VirusWall.***-***s

[GENERAL] server , client encoding issue

   hi all   i am facing a problem and here it is:   i install the following (postgres) rpms as root postgresql-libs-8.0.0-1PGDG.i686.rpm postgresql-8.0.0-1PGDG.i686.rpm and postgresql-server-8.0.0-1PGDG.i686.rpm   now i try to create a database   /usr/bin/createdb temp   when i connect to it it s

Re: [GENERAL] server , client encoding issue

***Your mail has been scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:> i checked the locale it is giving:> >  LANG=en_US.iso885915> LC_CTYPE="en_US.iso885915"If you Google for "ISO-8859-15 Latin9" the top two results seem to

[GENERAL] a stored procedure ..with integer as the parameter

 i have a stored procedure   insert_table(integer)  which does "insert into table (x) value ($1)";   now in my client i call the stored procedure as   select insert_table("3");   it works fine and inserts 3 into the table   but suppose i give   select insert_table("");   it gives an error ...saying

[GENERAL] insert a value into a table

 i have a fiels - varchar(100)   to this fiels i am trying to insert   "abc\def\xyz'   but it is not inserting the whole thing ...   how can i ensure that the whole string including the backslashes get inserted into the table   thanks regards surabhi

Re: [GENERAL] a stored procedure ..with integer as the parameter

Your mail has been scanned by InterScan VirusWall.***-***On Fri, 21 Oct 2005, surabhi.ahuja wrote:>  i have a stored procedure>> insert_table(integer)>  which does "insert into table (x) value ($1)";>> now in my client i call the stored procedure as

Re: [GENERAL] a stored procedure ..with integer as the parameter

has been scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:> from the client I get : "200", "surabhi", "10"> now i have to make a call to the stored procedure using the above received strings.> will not the "200" be converted to

Re: [GENERAL] a stored procedure ..with integer as the parameter

Huxton; Stephan Szabo; pgsql-general@postgresql.orgSubject: Re: [GENERAL] a stored procedure ..with integer as the parameter ***Your mail has been scanned by InterScan VirusWall.***-***Am Dienstag, den 25.10.2005, 10:24 +0530 schrieb surabhi.ahuja:>  oop

Re: [GENERAL] a stored procedure ..with integer as the parameter

scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:> what do u suggest i do then in that case?> i mean how should i make a query - i mean how do i make a command?You should always provide well-defined escaping to all data coming froma non-trusted source (i.e. outsid

[GENERAL] Postmaster failing to start on reboot

Hello everyone,   I reboot my machine while postmaster is up.   after the m/c gets rebooted , I grep for the process "postmaster", and it does not find it.   So,  I try starting postmaster. and it displays the following error message: HINT:  If you're sure there are no old server processes stil

Re: [GENERAL] Postmaster failing to start on reboot

quot;$PGCTL stop -D $PGDATA -s -m immediate" > /dev/null 2>&1    fi    fi    echo} case $action in  start)    start    ;;  stop)    stop    ;;  *)    echo "Usage: $0 {start|stop|status|restart|condrestart|reload|force-reload}"  

Re: [GENERAL] Postmaster failing to start on reboot

d 11/9/2005 8:23 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] Postmaster failing to start on reboot ***Your mail has been scanned by InterScan VirusWall.***-***surabhi.ahuja wrote:> Hello everyone,>> I reboot my machine while

Re: [GENERAL] Postmaster failing to start on reboot

ahuja  From: Tom Lane [mailto:[EMAIL PROTECTED]Sent: Wed 11/9/2005 9:23 PMTo: Richard HuxtonCc: surabhi.ahuja; pgsql-general@postgresql.orgSubject: Re: [GENERAL] Postmaster failing to start on reboot ***Your mail has been scanned by InterScan VirusWall

Re: [GENERAL] Postmaster failing to start on reboot

Title: Re: [GENERAL] Postmaster failing to start on reboot  hi,   in the script ithe statement to start and stop postmsater as the root is commented. thats how i saw the script( has been written by some one else)   will using 8.0.4 ensure proper starting and stopping of postmsater.   what

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

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

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

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

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

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

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

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

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

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

[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

[GENERAL] regarding the apostrophe character

 hello everyone,   in case i need to give a value which has apostrophe as one of the characters i need to escape it. and similary for the characters such as backslash.   what other characters need to be escaped. Is there any list published?   cant this be fixed in postgres?   thanks regards Sura

[GENERAL] regarding postmaster.pid file

 i have a small query. when i start postmaster the postmaster.pid file is created by default in the PGDATA directory. but in case that directory gets full if i try to restart postmaster ... it fails because there is not enough space to create the postmaster.pid file/   My question is that wh

[GENERAL] postmaster does not come up

 this is in continuation of the problem i was facing some time back.   if i try to start postmaster ...it times out. what can be the possible cause of it . I also have seen a core file being generated.   in case such a thing happens ... what shuld i be doing? how can i recover my database in suc

Re: [GENERAL] regarding the apostrophe character

ubject: Re: [GENERAL] regarding the apostrophe character ***Your mail has been scanned by InterScan VirusWall.***-***On Nov 25, 2005, at 13:12 , surabhi.ahuja wrote:> in case i need to give a value which has apostrophe as one of the > characters i ne

Re: [GENERAL] postmaster does not come up

: [GENERAL] postmaster does not come up *** Your mail has been scanned by InterScan VirusWall. ***-*** On 11/25/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote: if i try to start postmaster ...it times out. what can be the possible cause of

Re: [GENERAL] regarding the apostrophe character

@postgresql.orgSubject: Re: [GENERAL] regarding the apostrophe character ***Your mail has been scanned by InterScan VirusWall.***-***On Nov 25, 2005, at 13:40 , surabhi.ahuja wrote:> in which version will the use of "Escape string syntax " be &g

[GENERAL] postgres log file

 hi I start postmaster by giving the following command   /usr/bin/pg_ctl -w -l postgreslog -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start   however nothing gets looged in postgrelog.   if i see postgreslog it shows me only this: LOG:  logger shutting downLOG:  logger shutting downL

Re: [GENERAL] memory leak under heavy load?

even i have observed memory leaks ... is it happening in postgres side   i can send the valgrind logs  From: [EMAIL PROTECTED] on behalf of hubert depesz lubaczewskiSent: Wed 11/30/2005 12:59 PMTo: Jim C. NasbyCc: PostgreSQL GeneralSubject: Re: [GENERAL] memory leak under heavy load?

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

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

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

[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

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

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

[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

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

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

[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

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

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

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

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

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

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

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

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(

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

[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

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

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

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

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

[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

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

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

  1   2   >