FAQ

Search Discussions

100 discussions - 285 posts

  • I created the following function below. It hangs when I need to do the table update. Originally I wrote this function in MS SQL using cursors. However reading the documentation, I couldn't figure out ...
    Patrick HatcherPatrick Hatcher
    Feb 13, 2002 at 1:29 am
    Feb 15, 2002 at 3:34 am
  • I have a table that has two foreign keys to the same table. - operator_id_start - operator_id_stop Both point to the operator table. When displaying the row from the table how do I join so that I can ...
    BrianBrian
    Feb 16, 2002 at 9:16 pm
    Mar 9, 2002 at 9:14 am
  • I am writing a CGI-Perl script that connects to PostgreSQL. For this I use the module Pg. I connect to PostgreSQL using the command Pg::connectdb("dbname=test user=johndoe password=pass"); but ...
    Arifin purbaArifin purba
    Feb 13, 2002 at 5:28 pm
    Feb 14, 2002 at 12:05 pm
  • SELECT td.transaction_id FROM transactions_detail td WHERE EXISTS (SELECT transaction_id FROM transactions t WHERE t.transaction_id = td.transaction_id AND t.enter_date CAST('2002-02-02' AS DATE ); ...
    Andrew McMillanAndrew McMillan
    Feb 22, 2002 at 9:56 pm
    Feb 23, 2002 at 12:23 am
  • Hi, After I used 'create user', Is there a database to keep all the information about users? How can i check the existence of users? Thanks, Yan Get your FREE download of MSN Explorer at ...
    Annie BaiAnnie Bai
    Feb 3, 2002 at 12:18 am
    Feb 3, 2002 at 3:18 am
  • I'm a bit confused about the use of indexes with postgresql. I've a number of questions that are probably obvious when you know the answer, but I can't find in the documentation. 1) It seems that I ...
    John TaylorJohn Taylor
    Feb 8, 2002 at 4:56 pm
    Mar 13, 2002 at 9:16 am
  • Hi, If I am running a query I know could return 1000's of rows; is there a PG way to say to just return the first, say, 50 rows? cheers steve
    Stephen IngramStephen Ingram
    Feb 20, 2002 at 8:09 pm
    Feb 20, 2002 at 9:23 pm
  • I am new to postgresql -- coming from Oracle -- Is there an equivalent "Hot" Backup in postgresql -- or is the only backup utility available pg_dump & pg_dumpall. thanks
    Pam WamplerPam Wampler
    Feb 11, 2002 at 6:54 pm
    Feb 12, 2002 at 9:43 pm
  • Hello, Is it possible to connect the postgresql program psql to an oracle7 database ? When I tried I got: bash$ psql -h nan -p 1526 satbase psql: PQconnectDB() -- couldn't read postmaster response: ...
    Dominique DuflosDominique Duflos
    Feb 6, 2002 at 3:08 pm
    Feb 8, 2002 at 12:32 pm
  • Hi everyone, I'm new to PostgreSQL, i'm using version 7.1.3 on Mac OS X.1.2. It works perfectly when I connect through localhost but when I try to connect from other machine on the network i can't. ...
    FOlkeNFOlkeN
    Feb 7, 2002 at 12:52 pm
    Feb 7, 2002 at 5:28 pm
  • Hello, I have a C function that takes 4 arrays, does some math* to them, and ends up with an array of floats. I'd like to return this in standard postgres array form (ala SELECT) to be used in an ...
    Bill TriplettBill Triplett
    Feb 11, 2002 at 3:34 pm
    Jul 24, 2002 at 8:38 pm
  • Is it possible to determine which column(s), if any, are constrained with PRIMARY KEY? Thanks, Damon
    Damon FaschingDamon Fasching
    Feb 28, 2002 at 2:30 am
    Mar 1, 2002 at 6:01 am
  • I use phppgadmin and I don't really like it! Are there some other frontends for beginners to admin postgres? -- Jochen
    Jochen KaechelinJochen Kaechelin
    Feb 28, 2002 at 12:24 am
    Feb 28, 2002 at 2:20 pm
  • Hello List... How do I change a column from date type to text? thanks /j-p. ---------------------- JUSTATEST Art Online www.justatest.com
    John-paul delaneyJohn-paul delaney
    Feb 22, 2002 at 4:18 pm
    Feb 22, 2002 at 7:12 pm
  • I have a table where one of the attributes is the time a row was inserted: 'updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP'. Is there a way to define this attribute so that a user cannot override the ...
    Michael KlattMichael Klatt
    Feb 11, 2002 at 9:59 pm
    Feb 20, 2002 at 10:39 pm
  • if I have a column that's gonna be between 5-300 charactors... should I go with a a charactor? varchar? or a text? what's the performance penalty going with a text instead of a varchar... or a char? ...
    Singer WangSinger Wang
    Feb 12, 2002 at 8:20 pm
    Feb 12, 2002 at 10:36 pm
  • hi, I came across this information in http://www.ch.postgresql.org/news.html: The maximum number of keys in an index or arguments to a function is now configurable, with default limit of 16, rather ...
    V RV R
    Feb 4, 2002 at 10:24 am
    Feb 7, 2002 at 4:17 pm
  • I have a trigger on a table called stock_count (which has a column barcode) which needs to update a value in a table called theoretical_stock_count on either an insert, update or delete. However, I ...
    RobRob
    Feb 11, 2002 at 12:28 pm
    Mar 22, 2002 at 4:08 am
  • Hi, I'm new here so please let me know if this is not on topic or I do anything else wrong. On my old system I used to use PGAccess to view data on a remote system. Now I get the error: Conversion ...
    Frank HoltFrank Holt
    Feb 27, 2002 at 2:57 pm
    Mar 4, 2002 at 5:20 pm
  • I have a simple table model for a many-many r'ship between keys and sigs: KEYS table has columns: key, keyID SIGS table has columns: sig, sigID KEYS_SIGS has columns: keyID, sigID For a given key X, ...
    Phil MitchellPhil Mitchell
    Feb 26, 2002 at 6:29 pm
    Feb 28, 2002 at 4:16 pm
  • I have a table (my_table) with this structure: codlm varchar(7) The records are: 45122AD 45122AD 45123AC 440331B 430332C 440222X I want to change the first 2 letters from 45 to 22 something like ...
    CristiCristi
    Feb 26, 2002 at 6:45 am
    Feb 27, 2002 at 6:19 am
  • Hi All, my problem is the following i created a function the code is the following: CREATE FUNCTION add_one (integer) RETURNS INTEGER AS ' BEGIN RETURN $1 + 1; END; ' LANGUAGE 'plpgsql'; the code is ...
    Ivan HorvathIvan Horvath
    Feb 14, 2002 at 3:59 pm
    Feb 18, 2002 at 1:39 pm
  • When I try to do a createlang plpgsql template1 (or any other pl...) I get a message about the plpgsql_call_handle doesn't exist?? I get the same error if I try to plpgsql long-hand by doing a CREATE ...
    Patrick HatcherPatrick Hatcher
    Feb 16, 2002 at 8:12 pm
    Feb 16, 2002 at 9:58 pm
  • Hello All, I am a real novice to postgresql and am having trouble creating a new table in my existing database through the psql monitor. I have read the programmers guide, the create table syntax, ...
    Christopher A. GoodfellowChristopher A. Goodfellow
    Feb 11, 2002 at 4:24 pm
    Feb 11, 2002 at 5:02 pm
  • I have 2 questions concerning COPY FROM: 1 - I've successfully imported a comma-delimited file that contain no quotes (" "). I now have to import a FileMaker export where all fields contain quotes. ...
    Patrick HatcherPatrick Hatcher
    Feb 6, 2002 at 9:29 pm
    Feb 7, 2002 at 3:14 pm
  • Is there an opensource Mac equivalent to pgAdmin or pgAccess? I have looked for a few days and don't seem to find anything. Perhaps it means doing a compile myself for pgAdmin or pgAccess since they ...
    Philip NeukomPhilip Neukom
    Feb 6, 2002 at 3:31 pm
    Feb 6, 2002 at 6:23 pm
  • Hello. I'm trying to create my first function. However, when I try to compile, I get an error message: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql' Any help would be greatly ...
    Patrick HatcherPatrick Hatcher
    Feb 6, 2002 at 5:37 am
    Feb 6, 2002 at 6:10 am
  • When doing a select with a LIKE in the where clause, I always get 0 rows if I do not use a wildcard [_%]. LIKE should act like = in this case (and the docs say so). A select without a from correctly ...
    John J. AllisonJohn J. Allison
    Feb 27, 2002 at 11:42 pm
    Mar 5, 2002 at 9:58 pm
  • How do I get rid of all column headings in an SQL query? I just want to print out the raw data without any headings. David
    David J. LinesDavid J. Lines
    Feb 28, 2002 at 9:19 pm
    Feb 28, 2002 at 10:49 pm
  • How can i Migrate a table from oracle which cointain CLOB data ? Thanks
    Olivier de bardonnecheOlivier de bardonneche
    Feb 28, 2002 at 11:27 am
    Feb 28, 2002 at 4:44 pm
  • Good time of the day! Perhaps this list is not an exact place to ask, but I haven't found an answer in the PHP-specific lists and boards... So I'll give a try... It's easy to work with Postgres from ...
    Dmitri TouretskyDmitri Touretsky
    Feb 28, 2002 at 1:32 am
    Feb 28, 2002 at 5:40 am
  • Hi, Thank you to Oliver for that help with my password questions. I have a couple more questions: 1. Can I have entries in pg_hba.conf for specific databases and then end with an entry for all so ...
    David J. LinesDavid J. Lines
    Feb 26, 2002 at 10:48 pm
    Feb 27, 2002 at 12:34 am
  • Pg ver: 7.2 I'm trying to do a COPY function from a tab delimited file into a table defined as such: CREATE TABLE "mdc_priceschedule" ( "keyp_price" int4 NOT NULL, "keyf_products" int4 NOT NULL, ...
    Patrick HatcherPatrick Hatcher
    Feb 26, 2002 at 10:46 pm
    Feb 26, 2002 at 11:54 pm
  • Hi, I can get today's date in postgres using the current_date function, but I need to get the date one month ago from the current date. Is there any way to do this? Thanks Rob -- He who dies with the ...
    RobRob
    Feb 25, 2002 at 1:02 pm
    Feb 25, 2002 at 5:16 pm
  • Hi ! I have a general design question: We plan to collect sales events / data from approx. 50 outlets (shops). We are expecting 200 000 events annually. Would it be wiser to have a table for each ...
    Aarni Ruuhimäki / Megative Tmi / KYMI.comAarni Ruuhimäki / Megative Tmi / KYMI.com
    Feb 20, 2002 at 12:42 pm
    Feb 22, 2002 at 7:33 pm
  • Hi, All of my indexes disappeared, and the permissions changed on my tables after I ran the CLUSTER command on one of the indexes. Is this normal? Have I just started a war in some third world ...
    Jon HassenJon Hassen
    Feb 20, 2002 at 9:57 pm
    Feb 22, 2002 at 5:39 pm
  • I was wondering if anyone has installed the pglogd program. It is a program that sends Apache web server log information to a Postgresql database. I have successfully compiled it and have the other ...
    Keller, SidKeller, Sid
    Feb 21, 2002 at 7:56 pm
    Feb 22, 2002 at 12:19 pm
  • When I create a table & insert records, I am getting the wrong timezone info (-04) When I insert using now() -- the timezone is right (-05) I am on EST. Please help -- example: insert into foo values ...
    Pam WamplerPam Wampler
    Feb 20, 2002 at 2:25 pm
    Feb 20, 2002 at 3:30 pm
  • How does one cause pg_dump to save groups and users in the backup file? If I use -C to create the database, psql complains that it cannot find such and such a group or user. psql builds the database, ...
    John HerreshoffJohn Herreshoff
    Feb 18, 2002 at 3:27 pm
    Feb 19, 2002 at 12:43 am
  • Quick question. Does initdb deletes the old database? I will be upgrading shortly to 7.2 and the steps will be: pg_dumpall from 7.13 install 7.2 initdb psql to read old data I am wondering if initdb ...
    Francisco ReyesFrancisco Reyes
    Feb 15, 2002 at 5:12 pm
    Feb 15, 2002 at 9:00 pm
  • I'm writing an application program which uses Postgresql functionality via calls to the library libpq. One of the things I'd like to do is present the user with a list of possible database names to ...
    William C BrennanWilliam C Brennan
    Feb 15, 2002 at 1:55 pm
    Feb 15, 2002 at 3:29 pm
  • I'm working on a sync conduit (for memos) from a Palm pilot to a postgresql database I'll simplify things a bit to convey my question. I have the main database table (notes) that has a note_id ...
    Brian JohnsonBrian Johnson
    Feb 13, 2002 at 7:14 pm
    Feb 14, 2002 at 9:31 pm
  • Could someone tell me the SQL for an equivalent table in PostgreSQL? CREATE TABLE palm_addressbook ( cal_id int(11) NOT NULL default '0', account_id int(11) NOT NULL default '0', palm_rec_id int(11) ...
    Brian JohnsonBrian Johnson
    Feb 11, 2002 at 9:52 pm
    Feb 11, 2002 at 11:55 pm
  • I'd like to write a sort of functional API for my database by writing custome functions. It looks like if I want to return a result set I need to declare the return type as a 'SETOF tablename'. The ...
    Joshua b. JoreJoshua b. Jore
    Feb 5, 2002 at 4:49 pm
    Feb 8, 2002 at 2:15 pm
  • Hi, I have a query which I need to check if a person has a forest associated with them. Problem is that I need an outer join on the line that has: and t.permit_id = fk.permit_id as there may not be a ...
    Sharon CowlingSharon Cowling
    Feb 4, 2002 at 8:04 pm
    Feb 5, 2002 at 3:40 pm
  • I got some very helpful suggestions last time I posted and have reworked my entire db as a result. I did away with a bunch of tbName for tables type stuff and a ton of pkName and fkName for key ...
    Lewis BergmanLewis Bergman
    Feb 4, 2002 at 3:11 pm
    Feb 4, 2002 at 7:30 pm
  • hi all i'm trying to get 3 tables in a left join is this possible? please excuse the english and spelling not my natural language. postgres@vodanam:~ psql -V psql (PostgreSQL) 7.1.3 i found this. ...
    Duncan Adams (DNS)Duncan Adams (DNS)
    Feb 4, 2002 at 10:53 am
    Feb 4, 2002 at 1:30 pm
  • If there function besides COPY that will let me import data from a flat file and continue if an error occurs? This was a great functionality of the MS SQL import that would log the offending error ...
    Patrick HatcherPatrick Hatcher
    Feb 28, 2002 at 10:22 pm
    Mar 1, 2002 at 5:47 pm
  • Denis, There is no ELSEIF in PL/pgSQL. You have to use nested IF ... THEN ... ELSE statements instead. -Josh
    Josh BerkusJosh Berkus
    Feb 28, 2002 at 4:42 pm
    Feb 28, 2002 at 9:18 pm
  • Hello, What would be the rtype for a function to return tuples selected over more than one table? The closest I can find is setof but this rtype is for all columns of only one table. Example: states ...
    Clinton AdamsClinton Adams
    Feb 28, 2002 at 12:52 am
    Feb 28, 2002 at 9:04 am
Group Navigation
period‹ prev | Feb 2002 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions100
posts285
users83
websitepostgresql.org
irc#postgresql

83 users for February 2002

Josh Berkus: 44 posts Tom Lane: 29 posts Patrick Hatcher: 18 posts Pam Wampler: 13 posts Stephen Ingram: 10 posts Oliver Elphick: 8 posts Jason Earl: 6 posts Arifin purba: 5 posts Duncan Adams (DNS): 5 posts John-paul delaney: 5 posts Brian Johnson: 4 posts Doug Silver: 4 posts Joshua b. Jore: 4 posts PG Explorer: 4 posts Travis Hoyt: 4 posts Denis: 3 posts Andrew McMillan: 3 posts Annie Bai: 3 posts Brett W. McCoy: 3 posts Damon Fasching: 3 posts
show more
Archives