Search Discussions

48 discussions - 169 posts

  • Hello: I have several scripts I would like to run against a database. With mysql, I can pass the password to the database in the command line call to the terminal client. Is there a way to do that ...
    Neil AggarwalNeil Aggarwal
    Feb 15, 2007 at 1:13 am
    Feb 15, 2007 at 2:53 am
  • Is there a connection timeout? I'm using DBD::Pg (1.47) in perl to access 8.2.1 database. I've got a rather long running script; it does a bit of database access, then did some other crunching for ...
    Frank BaxFrank Bax
    Feb 3, 2007 at 6:29 pm
    Feb 4, 2007 at 6:25 pm
  • Hi, I'm a bit confused about the handling of transactions and savepoints withing reallife applications. It's theoretically all pretty neat and I understand what's the point of transactions in ...
    Feb 9, 2007 at 5:20 am
    Feb 9, 2007 at 8:28 pm
  • Hello: I have a Java program that is trying to import over 8 million rows from a text file. When the program starts up, it runs fine, but after a while it begins to crawl. This is usually symptomatic ...
    Neil AggarwalNeil Aggarwal
    Feb 28, 2007 at 2:50 am
    Feb 28, 2007 at 2:52 pm
  • Hello. I use PostgreSQL on jobs. When I carried out SQL sentence in PostgreSQL7.3.8 environment, PostgreSQL outputs the following error messages. ============================== pq_flush: send() ...
    Yumiko IzumiYumiko Izumi
    Feb 13, 2007 at 2:23 am
    Feb 28, 2007 at 5:15 pm
  • Hello I have a table that has a boolean column telling if that particular record has been billed already. So most of the time that column holds only true values. To select the unbilled record I use ...
    Ron ArtsRon Arts
    Feb 12, 2007 at 12:43 am
    Feb 12, 2007 at 4:24 pm
  • Hi all, I set the postgres user's password sometime ago. Now I've forgoten it. How can I reset it? Cheers, Noel -- Research Assistant / PhD Student Department of Biochemistry and Molecular Biology ...
    Noel FauxNoel Faux
    Feb 8, 2007 at 1:41 am
    Feb 8, 2007 at 2:36 am
  • Thanks for your time. I need to notify a user that data has changed. To accomplish this I'd like to create a trigger that watches the specified table, that on change, sends the results returned by a ...
    Brian stapelBrian stapel
    Feb 1, 2007 at 2:54 pm
    Feb 3, 2007 at 8:15 pm
  • Hello Novices, i wrote a function "historische_zeitstempel_berechnen(date) returns setof date..." which computes 20 dates corresponding to the date of the argument: olsim@traffic_nrw_0_3_0=# select ...
    Johannes BruegmannJohannes Bruegmann
    Feb 8, 2007 at 5:24 pm
    Feb 12, 2007 at 5:05 pm
  • Hello: My code needs to be able to allow the user to select which database to connect to. Is there a programmatic way to get a list of the databases managed by a pgsql server? Thanks, Neil -- Neil ...
    Neil AggarwalNeil Aggarwal
    Feb 27, 2007 at 4:53 am
    Feb 27, 2007 at 2:54 pm
  • Anthony CarmodyAnthony Carmody
    Feb 12, 2007 at 1:12 am
    Feb 22, 2007 at 6:48 am
  • does anyone know how to do this? I need to reset the primary key after I copy a bunch of data to postgres. The other option would be to start my tables primary key at a high number, like 3000000. Any ...
    Don GuernseyDon Guernsey
    Feb 12, 2007 at 5:35 pm
    Feb 12, 2007 at 6:00 pm
  • Hello all, I have a table containing transaction entries. These contain transaction dates, and how much was transferred. I want to find out which week(s) have had the maximum total transfer, and how ...
    Jan DanielssonJan Danielsson
    Feb 7, 2007 at 3:31 pm
    Feb 7, 2007 at 7:46 pm
  • Hi I have been using Postgres for about 7 months now on a part-time basis and have been using the PDF "PostgreSQL 8.1.0 Documentation" and a commercial book as my only sources of documentation. So ...
    Feb 2, 2007 at 7:06 pm
    Feb 6, 2007 at 5:45 pm
  • Dear PG users, I'm attempting to create a stored procedure which returns a result set from the handset table to the caller. This stored proc will eventually be called by JDBC application. I'm using ...
    Rob ShepherdRob Shepherd
    Feb 1, 2007 at 4:57 pm
    Feb 6, 2007 at 10:18 am
  • I have two plpgsql functions. first_function() calls the second one with a repetitive EXECUTE second_func() statement. Every time the second_func() is called, it creates a record in the table and ...
    Burak SeydiogluBurak Seydioglu
    Feb 2, 2007 at 2:45 am
    Feb 2, 2007 at 10:01 pm
  • Thanks but no. I think because it's description~ (like) rather than description= therefore it has to search the whole string in each description. From the output below it seems to search the 'go' ...
    Ann hedleyAnn hedley
    Feb 1, 2007 at 5:23 pm
    Feb 1, 2007 at 6:30 pm
  • Hey folks, I have a newbie developer question. I'm currently taking a course called Database Systems & Implementation at Rochester Institute of Technology and we've split up into groups and are ...
    Matthew CampbellMatthew Campbell
    Feb 1, 2007 at 3:38 am
    Feb 1, 2007 at 5:57 pm
  • hello novice list, can somebody show me where my mistake is with this trigger. everything is fine, but they don't fire...... [postgres@www ~]$ pg_ctl --version pg_ctl (PostgreSQL) 8.1.3 [postgres@www ...
    Joseph speigleJoseph speigle
    Feb 26, 2007 at 1:44 am
    Feb 26, 2007 at 10:24 am
  • Dear PG Novice List, http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#3.1 says to remove cygwin\bin from the path before running "the installer or the installed version of postgresql", ...
    Alf LacisAlf Lacis
    Feb 22, 2007 at 1:34 am
    Feb 22, 2007 at 3:35 am
  • Hi everyone! I really am a newbie to Postgres, and I have few questions... mainly security orientated, which I'm hoping I can get a definitive answer on. 1) listen_addresses in postgresql.sql - The ...
    John GardnerJohn Gardner
    Feb 20, 2007 at 4:28 pm
    Feb 20, 2007 at 5:33 pm
  • Hi I have a doubt about the performance of my db design . I have this situation: - One schema base containing 20 tables whit data of all users of my system. (These tables will contain a lot of rows ...
    Feb 16, 2007 at 3:46 pm
    Feb 19, 2007 at 1:58 pm
  • Hi all! I'm trying to use array inside a pl/pgsql function and I'm having some problems using the all array at the same time. Let me give you an example: ident text[]; BEGIN ident = $1; -- $1 is a ...
    Luis SilvaLuis Silva
    Feb 15, 2007 at 2:08 pm
    Feb 15, 2007 at 5:17 pm
  • Are there any explicit instructions anywhere on installing either a compiled source package or binaries of 8.2.3 under ubuntu 6.1 with list of dependencies?
    Michael DeanMichael Dean
    Feb 14, 2007 at 5:12 am
    Feb 15, 2007 at 6:52 am
  • Dear Postgre users, Im from Argentina and I have a question. im development a client-server application and i have a performance dude. I have a Db whit 10 tables. The server could attend a lot of ...
    Feb 12, 2007 at 11:20 am
    Feb 12, 2007 at 2:11 pm
  • Hello, I want to create a table with a primary key composed of 2 auto increment (serial) value. I don't speak english very well so I'gonna write you an example to let you understand what's my ...
    Feb 5, 2007 at 5:19 pm
    Feb 6, 2007 at 10:11 am
  • -- Ann "In a world without walls and fences - who needs Windows and Gates ?" (unknown)
    Ann hedleyAnn hedley
    Feb 1, 2007 at 7:41 am
    Feb 1, 2007 at 5:25 pm
  • Hi All, I need to dump a modified column (rpad(id, 19 ) || 'X' AS data) of a table to a text file after that table has been updated. I thought that a trigger might work but I would like an external ...
    Keith WorthingtonKeith Worthington
    Feb 28, 2007 at 4:32 am
    Feb 28, 2007 at 4:16 pm
  • Is there a way to revoke the right of a given user from creating tables? By preference I'd restrict only creating non-temporary tables. I've tried both REVOKE CREATE ON DATABASE dbase FROM user; and: ...
    Brian HurtBrian Hurt
    Feb 27, 2007 at 3:26 pm
    Feb 27, 2007 at 4:07 pm
  • Hi. I'm new to postgresql so please be patient. I'm recieving strange error while installing postgresql from binary package. By now I installed: postgresql-8.2.3-1mdv2007.1 ...
    Piotr PrzeworskiPiotr Przeworski
    Feb 26, 2007 at 9:33 am
    Feb 26, 2007 at 5:51 pm
  • Hello, I've trying to sum up distinct columns. But it's summing them prior to the distinct taking effect. -- CREATE TABLE t1 ( id integer, value1 integer, value2 integer, value3 integer ); INSERT ...
    A GilmoreA Gilmore
    Feb 20, 2007 at 4:21 am
    Feb 22, 2007 at 7:52 am
  • Hi All, I enabled postgres to log with the following settings: log_min_messages = error log_min_error_statement = error In one of the daily logs, I saw this message: !reg_match_c I searched online to ...
    Saranya SivakumarSaranya Sivakumar
    Feb 21, 2007 at 8:43 pm
    Feb 22, 2007 at 6:42 am
  • Hey folks: I've been working with a group trying to implement UNIQUE index functionality in GiST (we started with hash, and have branched out to try and understand some of the other indexing ...
    Matthew CampbellMatthew Campbell
    Feb 12, 2007 at 6:27 am
    Feb 12, 2007 at 6:34 am
  • I have two tables, from one of which I wish to obtain the sum of several columns (return1,....return7) and insert the result into the other. Here are the tables layout: CREATE TABLE investments ( ...
    Oscar Alberto Chavarria MarinOscar Alberto Chavarria Marin
    Feb 12, 2007 at 3:16 am
    Feb 12, 2007 at 4:25 am
  • Hello, I need to run a query that retrieves all rows in a table and passes off the information to another app, it involves a many-to-many relation, that I'm handling with a subselect. Obviously this ...
    A GilmoreA Gilmore
    Feb 10, 2007 at 7:24 pm
    Feb 11, 2007 at 12:42 am
  • Hi everyone I want to change the next values of max_connections, work_men, shared_buffers, and other parameters in postgres.conf. Is there a store procedure to achive this goal? Thanks for your ...
    Jennifer llerenaJennifer llerena
    Feb 9, 2007 at 10:31 pm
    Feb 9, 2007 at 11:01 pm
  • Hi, Here is my pg_hba.conf file configuration: What should I change so that it reads my /home/postgres/.pgpass file when I execute a psql -Upostgres databasename? # TYPE DATABASE USER CIDR-ADDRESS ...
    Mick McElarneyMick McElarney
    Feb 1, 2007 at 3:51 am
    Feb 6, 2007 at 5:30 am
  • Ok, then how do I make sure my query uses plpsql? I have tried IF 1 = 1 THEN update contacts set deleted = TRUE END IF; LANGUAGE 'plpgsql'; But I still get the same error. -----Original Message----- ...
    Greg QuinnGreg Quinn
    Feb 4, 2007 at 6:52 pm
    Feb 4, 2007 at 7:06 pm
  • What does your pg_hba.conf look like?
    Andrej Ricnik-BayAndrej Ricnik-Bay
    Feb 26, 2007 at 7:10 pm
    Feb 26, 2007 at 7:10 pm
  • Why? Just add your field and do your select in the desire order? It's just a matter of represenatation. Cheers
    Andrej Ricnik-BayAndrej Ricnik-Bay
    Feb 25, 2007 at 7:27 am
    Feb 25, 2007 at 7:27 am
  • 0


    I think you are right. I changed the commas to '~' except the comma inside the array and it worked.
    Feb 23, 2007 at 3:50 pm
    Feb 23, 2007 at 3:50 pm
  • Hi , I have a program already working on LAMP architecture. Now since the business logic is in PostgreSQL. We were interested to build the front end on VB.net. Would like to know the readiness of ...
    Feb 21, 2007 at 6:43 pm
    Feb 21, 2007 at 6:43 pm
  • Ran into a strange problem that seems to appear randomly, and I haven't been able to pin down the conditions under which it appears. I have 2 functions that I use to access my database. These ...
    Allan SullivanAllan Sullivan
    Feb 21, 2007 at 6:21 pm
    Feb 21, 2007 at 6:21 pm
  • Hello, I have a table containing date column (dt), category, amount of money transferred. Someone on this list helped me put this together: -------------------------- SELECT ...
    Jan DanielssonJan Danielsson
    Feb 11, 2007 at 6:47 pm
    Feb 11, 2007 at 6:47 pm
  • If you read the first few paragraphs of http://gborg.postgresql.org/project/mysql2psql/faq/faq.php?faq_id=181 there is told how to install 2 different postgres servers on the same system, running at ...
    Joe speigleJoe speigle
    Feb 6, 2007 at 9:45 am
    Feb 6, 2007 at 9:45 am
  • Perhaps what you actually want is the CASE function - it performs what most people with previous programming experience would expect from IF Cheers, -p -----Original Message----- From: ...
    Phillip SmithPhillip Smith
    Feb 4, 2007 at 9:49 pm
    Feb 4, 2007 at 9:49 pm
  • Hello, I get this error #error 1 ERROR: syntax error at or near "," at character 525 LINE 15: FETCH curs INTO id, set_values; ^ from this function drop function sx(varchar) ; CREATE OR REPLACE ...
    Joe speigleJoe speigle
    Feb 1, 2007 at 6:04 pm
    Feb 1, 2007 at 6:04 pm
  • -----Original Message----- From: Duncan Garland Sent: 01 February 2007 12:53 To: ann hedley Cc: pgsql-novice-owner@postgresql.org Subject: RE: query efficiency - Can I speed it up? Does putting an ...
    Duncan GarlandDuncan Garland
    Feb 1, 2007 at 2:34 pm
    Feb 1, 2007 at 2:34 pm
Group Navigation
period‹ prev | Feb 2007 | next ›
Group Overview
grouppgsql-novice @

64 users for February 2007

Tom Lane: 25 posts Phillip Smith: 10 posts Andrej Ricnik-Bay: 9 posts Neil Aggarwal: 9 posts Richard Broersma Jr: 6 posts Andreas Kretschmer: 5 posts Jan Danielsson: 5 posts Burak Seydioglu: 4 posts Sean Davis: 4 posts Andreas: 3 posts Ann hedley: 3 posts Frank Bax: 3 posts Gustavo: 3 posts Joe speigle: 3 posts Johannes Bruegmann: 3 posts Joseph speigle: 3 posts Matthew Campbell: 3 posts Michael Fuhr: 3 posts Noel Faux: 3 posts Ron Arts: 3 posts
show more