Re: [GENERAL] About multiple access to a table

hi all rows get implicitly locked.. hope this helps Anand On Fri, Jun 01, 2001 at 01:14:20PM +0200, Jose Manuel Lorenzo Lopez wrote: Hello community, I have a doubt about multiple access to a table in my database. When two people are accessing the same table for insert or update, is the

Re: [GENERAL] Specifying psql password on command line

preety simple.. In ur shell script use psql -h localhost ur_db -U ur_user_name EOF ur_passwd ur_sql_script.sql EOF is this is too much of a botheration u can set the environment variables PGUSER and PGPASSWD Hope this helps Anand On Tue, Jun 05, 2001 at 05:59:28PM -0700, Tauren Mills

Re: [GENERAL] how can i change my table/column constraint

basically copy the table to some other table.. Drop the old table.. recreate it with the constraints changed Repopulate the table.. Hope this helps Anand On Sat, May 05, 2001 at 01:49:31PM +0700, Muhammad Rusydi wrote: Hi, if i have created this tables: create table lab ( kd_lab varchar(4)

Re: [GENERAL] Schema Import

hi Bob, Try psql -h ur_machine db_name -U user_name -f the_schema.sql HTH Anand On Mon, Apr 16, 2001 at 12:36:06PM -0700, Bob McCormick wrote: All, I've found a case tool that will generate a schema based on PostgreSQL syntax and am wondering if it is possible to run this generated SQL

Re: [GENERAL] plpgsql -- arrays/temporary tables?

hi I think create likeddl statements fal under the category of dynamic queries which plpgsql in its native state cant handl.. Try using EXECUTE to execute this query Hope this helps Anand On Wed, Apr 11, 2001 at 12:25:43AM -0400, Steven D. Arnold wrote: The following function doesn't work when

Re: [GENERAL] transaction aborted with error

I dont think so .. Transactions need to be atomic.. Either succeed or fail.. I thik what postgressql does is quite OK only a little irritating if u are issuing command thru the psql terminal.. Anand On Thu, Mar 22, 2001 at 10:15:54AM +0100, DaVinci wrote: Hello. I have a problem with Postgresql

[GENERAL] pg_dump not working..

hi guys I am trying to use pg_dump to get a database dump on a local machine.. However the utility simply hangs without dumping any data. The utitility (pg_dump) however responds if I send a wrong passwd. What surprises me is that i am able to connect to the database on the remote machine thru

Re: [GENERAL] Why SELECT OWNER.TABLENAME.COLUMNNAME not working ?

Hi I guess this is because postgresql doesnt yet support the concept of schemas. Such a select statement will make sense when the database supports schemas.. Hope this helps Anand On Mon, Mar 05, 2001 at 03:01:42PM +0600, Zuev Dmitry wrote: Can anybody tell me why i can't specify OWNER then i

Re: [GENERAL] pg_dump not working..

Sorry for the noise on the list.. It turned out that the internet connectivity at our place balnked out for the few minutes when i was trying it out.. Sorry once again.. Anand On Fri, Mar 16, 2001 at 04:43:43PM +0530, Anand Raman wrote: hi guys I am trying to use pg_dump to get a database dump

Re: [GENERAL] Importing data only

If u dont want to recreate the db , u will have to atleast delete the data before moving on .. Try a delete * from ur_table and then import.. Thanks Anand On Wed, Mar 07, 2001 at 03:58:16PM +0100, Lisa Goulet wrote: Hi, I've set up a secondary server and want to keep the db updated with a

Re: [GENERAL] COPY again...

Hi Tony These things can get on ur nerves and it happened in my case too.. In my case the data simply didnt load into the tables becasue the primary keys which were being referenced in the csv file were not present in the file. Thus it never inserted any rows in thetable.. Also even if part of

Re: [GENERAL] joining databases

Currently there is no way to acces more than one db at a time.. But i heard that there will be implementation of schema pretty soon.. Anand On Tue, Feb 27, 2001 at 06:09:03PM -0600, will trillich wrote: how can i join separate DATABASES? select a.fld1,b.fld2 from

Re: [GENERAL] Find out when a table was last changed ?

No u need to maintain this information in another column such as last_update_date which your application should update everyt time u perform any operation on it.. Hope this helps Anand On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote: Hi, Is there some kind of command or

Re: [GENERAL] strange query results

iced a few fields had '' characters to signify '.. This was creating problems in some jdbc queries. One changing them to single ' and reloading all the data, the problem simply disappered.. Thanks for the help Anand Raman On Tue, Feb 13, 2001 at 10:20:53AM -0500, Tom Lane wrote: Anand Raman [EMAIL

Re: [GENERAL] Case insensitive selects?

Hi use it if u absolutly need it.. Using a function on a column name doesnt use the index associated with that column,.. So exercise this option with some amount of thinking.. Anand On Wed, Feb 14, 2001 at 11:39:47AM -0500, Adam Lang wrote: It is in the list archives several times. All you need

Re: [GENERAL] Tuple is to big

hi Endre U can go upto 32 k on 7.0.x and there is no such limit on 7.1 Try to upgrade.. Regards Anand On Tue, Feb 13, 2001 at 04:11:59PM -0500, Bodoni Endre wrote: I have a little trouble with my PostgreSQL 6.5.1. I use a table with text character type. When I try to insert about 1 character

Re: [GENERAL] jdbc connection pool settings

it depends on what kind of concurrent connections u will be getting.. For admin interfaces the kind of settingu mentioned might be OK but in case it is a heavily loaded site then u need to think.. Anand On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote: I'm in the process of

Re: [GENERAL] strange query results

00 width=12) - Seq Scan on exhibit_distributions (cost=0.00..20.00 rows=1000 width=12) The problem still persists.. I will a drop and recreation of the db just in case.. Thanks for the help Anand On Mon, Feb 12, 2001

[GENERAL] strange query results

hi guys I am trying out some relativly simple queries against my database.. select distinct site_section as "distinct site sections" from exhibit_distributions ; distinct site sections ARCHIVED ARTETC CALENDAR GALLERY POSTCARD (5 rows) select site_section, count(*)

[GENERAL] Re: backend closing connections while executing...

20:23:33 2001 The Data Base System is starting up What is status 139 and how can i avoid it.. Thanks for any help Anand On Thu, Jan 25, 2001 at 01:06:01AM +0530, Anand Raman wrote: hi guys While executing a simple query my the psql session reports that the session has closed abnormally.. Can

[GENERAL] backend closing connections while executing...

hi guys While executing a simple query my the psql session reports that the session has closed abnormally.. Can any one point out why .. The sample sql query is as follows.. arttoday=# select arttoday-# art1.name, arttoday-# CASE WHEN exh.title IS NULL THEN 'Untitled' ELSE exh.title

[GENERAL] \copy not importing in 702...

hi guys I am having a strange problem with \copy .. When i am trying to copy from the a csv file \copy doesnt report any error and quietly returns to the command prompt.. However when i do a select count(*) from the table it returns no rows.,. can anyone help me with this.. A sample dialog

Re: [GENERAL] \copy not importing in 702... (SOLVED)

hi guys I just realized that this is occuring because of a the absence of a primary key in the other table. Thus the copy command exited without any failure notice.. Thanx Anand On Wed, Jan 24, 2001 at 12:29:18AM +0530, Anand Raman wrote: hi guys I am having a strange problem with \copy

Re: [GENERAL] Newbie question

what do u mean by the datadir problem.. if pg_ctl asks for a datadir then ucan set it in /etc/profile and start again.. Hope this helps Anand On Mon, Jan 08, 2001 at 03:44:34PM +0100, MUMCU, Burak wrote: Hi all, I'm using Suse Linux 7.0 and I have installed PostgreSQL. The problem is when I

[GENERAL] connecting in shell scripts ??

elect current_timestamp" passwdfile where passwdfile has the passwd for the connection This isnt working.. I am a little confused for the same thing worked for pg_dump.. Looking forward for ur suggestions.. I am on 7.0.3 Thanx Anand Raman

[GENERAL] \connect

hi guys how to connect as a different user to a different db using the \connect command.. I dont see any option for specifing the password or the host to which i want to connect . Am i missing something.. Thanx for any suggestions Anand

[GENERAL] pg_dump return status..

in a spin which continues even when pg_dump is not able to connect .. Is there anyway around this. I thought of one way was to check stderr for the occurence of the word "failed" and then exit.. Ur suggestions are most welcome version postgresql 702 Regards Anand Raman

Re: [GENERAL] How I can join between the other database's tables?

hi all, I second this opnion.. Coming from a web development environment, it could help us to distribute load on our servers.. regards Anand On Thu, Dec 28, 2000 at 08:21:26AM -0500, Adam Rossi wrote: On Wednesday 27 December 2000 08:44 pm, Adam Haberlach wrote: I'm pretty sure you are

[GENERAL] replacing a word..

hero Juan Carlos Ferrero has withdrawn Is it possible.. I tried using translate() and the ~ operator to no avail.. Could some please shed some light on this.. Thanx Anand Raman

Re: [GENERAL] Max sessions question

hi tim the answer is very much there try out man postmaster.. To increase the number of backends use the -N option. Hope this helps Anand On Fri, Dec 22, 2000 at 11:37:24AM -0800, Tim Barnard wrote: Hello all, I've looked through the docs and I can't find any answers to this question: How can I

Re: [GENERAL] COPY doesnt work on views

hi If getting the output of the query is all u want then u can spol the output of the query to a file.. I think it is done using \o .. Hope this helps Annad On Tue, Dec 12, 2000 at 04:36:10PM +, Steve Heaven wrote: The COPY TO filename doesnt seem to work. Copying a table works OK.

[GENERAL] Postgresql equivalent for nvl

Hi guys Sorry for hitting the button soon but whats the postgresql equivalent for Oracle's nvl(). I tried using ifnull() but then postgresql is cribbing that the function doesnt exist.. Thanx for the help Anand

Re: [GENERAL] postgresql7.0 jdbc driver

he case with $ make jdbc2 Thanx for the assitance Anand Raman - Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: Anand Raman [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, May 02, 2000 6:49 PM Subject: Re: [GENERAL] postgresql7.0 jdbc driver [Charset iso-8859-1 uns