FAQ

PostgreSQL > pgsql-novice > May 2002

Search Discussions

101 discussions - 362 posts

  • Hi all, I'm (still) working on an application to regularly populate my database with some data provided from a third party DB. I'm still having really bad performance problems. There are 300,000 ...
    John TaylorJohn Taylor
    May 22, 2002 at 2:06 pm
    May 27, 2002 at 7:43 pm
  • I found, on http://www.argudo.org/postgresql/soft-tuning-10.html my answer. (Excellent site btw) What I need to do is prefix my SELECT statements for this table with the statement : SET ...
    Gerry SmitGerry Smit
    May 15, 2002 at 5:23 pm
    May 17, 2002 at 6:50 pm
  • I am writing timestamps to file and the formatting is currently 2002-06-06 00:00:00.0. Is there a function to only write the date and also to format it something like MM/dd/yyyy ? Thanks Tom
    Tom AnsleyTom Ansley
    May 3, 2002 at 7:38 pm
    May 11, 2002 at 5:17 pm
  • Hello list... One column in my table contains email addresses - I want to check that any value entered contains a '@'. How do I create a CONSTRAINT or CHECK to ensure this when creating the table? ...
    John-paul delaneyJohn-paul delaney
    May 12, 2002 at 5:07 pm
    May 16, 2002 at 8:36 pm
  • Hi, Currently, I've got a python script using pyPgSQL that parses the CSV record, creates a string that is a big "INSERT INTO VALUES (...)" command, then, execute() it. top shows that this method ...
    Ron JohnsonRon Johnson
    May 21, 2002 at 10:28 pm
    May 22, 2002 at 10:19 pm
  • Hello, If the csv file generated by the application that I am importing from contains quotes around each field, must I write a program to strip these "field-level" quotes before sending the file to ...
    Ron JohnsonRon Johnson
    May 19, 2002 at 11:01 am
    May 20, 2002 at 12:18 am
  • Hi, I need to write a query that returns the number of rows currently stored in a table. I presume that I issue a query against the system tables, but don't know which one(s) to do this against. So a ...
    Tony Griffiths(RA)Tony Griffiths(RA)
    May 30, 2002 at 12:02 pm
    May 30, 2002 at 2:36 pm
  • Hi, As you can see, I "VACUUM VERBOSE ANALYZE" my table, describe the index on the table, then try to find the max() value of the indexed field. However, EXPLAIN still shows that the query wants to ...
    Ron JohnsonRon Johnson
    May 24, 2002 at 1:14 pm
    May 25, 2002 at 8:19 pm
  • Sorry - I seem to be bombarding the list. I AM reading my copy of Bruce Momjian's book quite closely, I promise! I'm trying to make a rule to automatically update the time, date and timestamp ...
    Rory Campbell-LangeRory Campbell-Lange
    May 23, 2002 at 1:38 pm
    May 24, 2002 at 3:13 pm
  • Using PostgreSQL 7.2 with PHP 4.1.2, I would like to use the UPDATE function to add values to a field in a row that already has a value or values, i.e.: in a field named 'sponsor', the current value ...
    Andre DubucAndre Dubuc
    May 8, 2002 at 10:33 am
    May 8, 2002 at 9:24 pm
  • Hi, unfortunately I have forgotten the mpassword of the master user of a db. Is there a way to retrieve it using the user who owns the db template1? Thx Thiemo -- Thiemo Kellner Tösstalstrasse 146 ...
    ThiemoThiemo
    May 19, 2002 at 8:15 am
    Aug 16, 2002 at 12:33 pm
  • Hi all I'm trying to find documentation for postgres/plperl. the online postgres documentation has only two examples in it and i am struggling to find any more that i can make sense of. also most of ...
    Duncan Adams (DNS)Duncan Adams (DNS)
    May 22, 2002 at 11:43 am
    May 23, 2002 at 9:04 am
  • Hi everyone. I am new to this list, and a real novice with databases. A while back I created a database using postgres 7.03 in Mandrake 7.2. It is a catalog for all my books. Although not really ...
    Brian SchroederBrian Schroeder
    May 8, 2002 at 2:23 am
    May 12, 2002 at 11:31 pm
  • I have had a number of years experience with Oracle. I am considering using Postgresql but while there is an enourmous amount of documentation available, none of it seems to answer some questions ...
    Peter GogginPeter Goggin
    May 9, 2002 at 1:47 pm
    May 9, 2002 at 5:38 pm
  • Hi, I'm working on an application, the user enters the customers id or their firstname or their lastname or their firstname and lastname. The problem is when they enter their firstname AND their ...
    Sharon CowlingSharon Cowling
    May 8, 2002 at 5:07 am
    May 8, 2002 at 10:37 pm
  • I have found some errors in my pgsql error file: FATAL 1: Database :"template0" is not currently accepting connections ERROR: Relation 'visits'does not have attribute 'path' ERROR: Bad boolean ...
    PJourdanPJourdan
    May 1, 2002 at 2:58 pm
    May 2, 2002 at 8:22 pm
  • I have the task of designing the office fantasy football system to run on our intranet. The fantasy football game is a game centering around the world cup football tournament. The game is to make up ...
    Rory Campbell-LangeRory Campbell-Lange
    May 29, 2002 at 10:53 am
    May 30, 2002 at 10:36 am
  • Hi, I am using the copy command to create a .csv file, how do I include the table headings, or headings of my choice? The purpose of this paticular .csv file is to enable the users to download data ...
    Sharon CowlingSharon Cowling
    May 25, 2002 at 11:38 pm
    May 28, 2002 at 6:27 am
  • Hi all, I'm trying to use a case statement with a boolean value. i.e. if the value = false then output 'NO', if value = true then output 'YES'. This is what I came up with CASE booking.quiz WHEN ...
    Tom AnsleyTom Ansley
    May 24, 2002 at 3:56 pm
    May 24, 2002 at 7:01 pm
  • Thanks to everyone on the list I'm up and running with postgres. I'm having trouble doing a query: table a | table b ------------------------------ id data | id ------------------------------ 1 2 | 2 ...
    Rory Campbell-LangeRory Campbell-Lange
    May 23, 2002 at 6:56 pm
    May 24, 2002 at 5:23 pm
  • Howdy, I'm trying to import data from an external database that has the date formatted as such: 2002-05-20 00.00.01. When I try to import the data, I get the Bad Timestamp external representation ...
    Patrick HatcherPatrick Hatcher
    May 23, 2002 at 10:42 pm
    May 24, 2002 at 2:50 pm
  • Hi, More generically, how do I best guarantee that any large varchar is unique before inserting? In my application, I need to ensure that each e-mail address and corresponding PGP public key are both ...
    AndreAndre
    May 20, 2002 at 10:10 pm
    May 21, 2002 at 12:53 pm
  • Hi list, Is there a way of casting from a varchar to a numeric type? My problem consists of a varchar(10) that are all numeric. They are telephone numbers and I want to convert them during a select ...
    Tom AnsleyTom Ansley
    May 16, 2002 at 3:49 pm
    May 16, 2002 at 5:47 pm
  • Hello folks, I wrote my first plpgsql-functions for PostgreSQL 7.1.3. I try to convert Ascii-Strings in HTML-conform Strings (Converting 'Äquator' - 'Äquator') ... Now I get a error message like ...
    Hans PlumHans Plum
    May 7, 2002 at 11:20 am
    May 7, 2002 at 5:27 pm
  • I am trying to install PostgreSQL 7.2 under Redhat The installation seems to work without problems. However, when I try to start the program I encounter the following error message There is no such ...
    Kristian Skrede GleditschKristian Skrede Gleditsch
    May 3, 2002 at 12:22 am
    May 6, 2002 at 3:17 pm
  • Hi, I used ./configure --prefix=/home/metaperl/install/pgsql to install postgres and then I did initdb and createdb and started the postmaster just fine. However, attempting to connect via psql is ...
    Terrence BrannonTerrence Brannon
    May 2, 2002 at 12:34 pm
    May 2, 2002 at 9:56 pm
  • I want to run a SQL script in my crontab job which requires using psql without having to input password every time. I am running postgresql 7.2. What is the trick? Thank you. -- Wei Weng Network ...
    Wei WengWei Weng
    May 29, 2002 at 7:56 pm
    May 30, 2002 at 9:10 pm
  • Is there any reason to have databases -not- owned by the users: Postgres or root? Thanks! -- Jillian
    Jillian CarrollJillian Carroll
    May 29, 2002 at 10:25 pm
    May 30, 2002 at 3:44 pm
  • Hi everyone, Here's a strange little problem. A few days ago I wanted to delete a column from my table named 'event'. I followed the advice in the FAQ (select old data into new table minus the column ...
    Tim WilsonTim Wilson
    May 28, 2002 at 5:35 pm
    May 28, 2002 at 7:25 pm
  • Greetings All, I've run into a spot where I think I could use a subselect but I'm not sure how I would (or if I can). This is a simple table which holds strings and their translated counterparts. ...
    Adam EricksonAdam Erickson
    May 27, 2002 at 4:43 am
    May 27, 2002 at 7:53 am
  • Since the cluster command causes so many hassles with PL/pgSQL functions, triggers, constraints, indexes etc I'm asking if this spot of SQL emulates the expected behaviour: CREATE TABLE SoSIDs ( ...
    Joshua b. JoreJoshua b. Jore
    May 24, 2002 at 10:28 pm
    May 24, 2002 at 11:46 pm
  • Gentle Wizards, My PostgreSQL 6.5.3 database is having a serious problem. I have a backup utility that writes backup sets to tape. When a set is written, it is stored as an entry in a table, "sets". ...
    Kevin SternerKevin Sterner
    May 21, 2002 at 10:27 pm
    May 22, 2002 at 3:27 pm
  • Hi folks. We're having a baffling time with Postgres 7.1 I have 4 databases (central, atlantic, quebec, western) with 2 tables each (policy_cross_reference (_d or _b)). The Central tables have about ...
    Gerry SmitGerry Smit
    May 15, 2002 at 2:36 pm
    May 16, 2002 at 5:23 pm
  • Saw some recent discussions about schemas (hacker email sent to another list I read). What are schemas? I have a general/vague idea, but would like to better understand it.
    Francisco ReyesFrancisco Reyes
    May 1, 2002 at 2:17 am
    May 12, 2002 at 2:10 am
  • Hello, Just getting started with postgres. Is there an equivalent sql command to insert multiple rows? In mysql it's: insert into table (a,b,c) values (1,2,3), (4,5,6); I exported 6000 rows from ...
    GG
    May 4, 2002 at 10:36 pm
    May 10, 2002 at 5:57 pm
  • Hello, I have a table with over 1.000.000 records. I'd like to limit the maximum number of records to display, so if one my users opens the whole table, he will see only for example 1000 records. If ...
    WimWim
    May 3, 2002 at 8:47 am
    May 5, 2002 at 12:06 am
  • I would like to know if postgresql has the auditing functionality as in Oracle ,and if so its usage. Thanks, Radha Join the world’s largest e-mail service with MSN Hotmail. Click Here
    V RV R
    May 30, 2002 at 11:17 am
    May 30, 2002 at 3:11 pm
  • Hi all, I'm new to postgreSQL,a dn I'd like to write a script that will insert all my entries (I have almost 800 000 entries)in a pgsql database.so, the question is : which script language can I use, ...
    Annissa MelhenasAnnissa Melhenas
    May 24, 2002 at 8:21 am
    May 24, 2002 at 1:02 pm
  • Hi, While "\d foo" will describe all of the fields and their data types for the table foo, how do I do something similar for an index? test2=# \di i_lane_tx_tmp List of relations Name | Type | Owner ...
    Ron JohnsonRon Johnson
    May 23, 2002 at 11:32 pm
    May 24, 2002 at 12:48 pm
  • Cristi voinicaruCristi voinicaru
    May 3, 2002 at 6:41 am
    May 24, 2002 at 9:38 am
  • I'm making a table to hold a queue of incoming and outgoing email messages. I'm confused about using char, varchar or text fields - I imagine they are searchable (without and index) with decreasing ...
    Rory Campbell-LangeRory Campbell-Lange
    May 23, 2002 at 12:05 pm
    May 23, 2002 at 7:33 pm
  • Hi! I wonder if there is any way to accesing Access97 files using Linux and PostgreSQL. I have Mandrake 8.0. PostgreSQL, ODBC and JDBC drivers installed on it. I would like to use PostgreSQL and drop ...
    Victor Manuel Torres AguirreVictor Manuel Torres Aguirre
    May 22, 2002 at 1:47 am
    May 22, 2002 at 4:14 am
  • Hi all, I'm accessing postgres (7.1) through JDBC. My application performs a number of UPDATEs, and INSERTs to the database. If there are any SQL errors, I catch them and deal with them as ...
    John TaylorJohn Taylor
    May 15, 2002 at 1:34 pm
    May 16, 2002 at 1:30 pm
  • Greetings, I am relatively new to postgres. I would like to know if there is a data type for file such as image files. In otherwords is there a straignt forward way to place references to ...
    Sibusiso xoloSibusiso xolo
    May 16, 2002 at 12:02 am
    May 16, 2002 at 5:16 am
  • Hi, I have tried looking for cascading changes through multiple tables and don't seem to be able to find anything in the documentation. Can anybody point me in the right direction. I just want to ...
    Tom AnsleyTom Ansley
    May 14, 2002 at 5:06 pm
    May 14, 2002 at 9:53 pm
  • Just curious if there's a way in Postgres to take an epoch number (UTC) which is stored as a bigint field and convert it to a timestamp. perl does it like so: $ perl -e 'print ...
    Doug SilverDoug Silver
    May 10, 2002 at 12:30 am
    May 12, 2002 at 7:28 pm
  • I've been working with Postgres for about 2 years now. I've never had to do anything real advanced until now and I'm having a huge problem with some dates. A long time ago, I thought it would be a ...
    John NixJohn Nix
    May 9, 2002 at 7:22 pm
    May 9, 2002 at 7:42 pm
  • Can anyone tell me why the planner is penalizing me for changing ONE value? explain SELECT l.idsubaccount,1 as status,l.type,l.date,l.units,l.rate,l.total,l.text FROM lineitemsnext l, accounts a, ...
    D. DucciniD. Duccini
    May 8, 2002 at 12:31 am
    May 8, 2002 at 4:44 am
  • Is it possible to write a stored procedure which takes a struct as a parameter? I'd like to be able to pass in some info via a struct & return some info via another struct something like this: struct ...
    Wendy PowleyWendy Powley
    May 6, 2002 at 7:05 pm
    May 7, 2002 at 7:16 pm
  • Hi all i have two areas where i get information for my project. one is obtained from a SNMP walk across our systems and the other is captured by support personal. Now i want to be able to compare a ...
    Duncan Adams (DNS)Duncan Adams (DNS)
    May 6, 2002 at 2:20 pm
    May 6, 2002 at 8:20 pm
May 2002
123
Group Navigation
period‹ prev | May 2002 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions101
posts362
users99
websitepostgresql.org
irc#postgresql

99 users for May 2002

Ron Johnson: 30 posts Tom Lane: 29 posts Josh Berkus: 25 posts Joel Burton: 18 posts Joshua b. Jore: 17 posts John Taylor: 14 posts Rory Campbell-Lange: 12 posts Gerry Smit: 11 posts Henshall, Stuart - WCP: 11 posts Andrew McMillan: 10 posts Duncan Adams (DNS): 9 posts Tom Ansley: 8 posts Sharon Cowling: 7 posts Hodges: 5 posts Adam Erickson: 5 posts Francisco Reyes: 5 posts John-paul delaney: 5 posts Oliver Elphick: 5 posts Patrick Hatcher: 5 posts Brian Schroeder: 4 posts
show more
Archives