FAQ

PostgreSQL > pgsql-novice > March 2005

Search Discussions

105 discussions - 356 posts

  • Postgresql doesn't do this automatically. A foreign key only functions as a link between tables after it is formed. You must supply the link in the first place by a lookup in the foreign table either ...
    Sean DavisSean Davis
    Mar 1, 2005 at 5:56 pm
    Mar 5, 2005 at 6:34 am
  • I'm quite a newbie with Postgresql - or any databases whatsoever, for that matter. I've been studying the archives and documentation for the past couple of weeks and find it quite fascinating. I must ...
    DavidDavid
    Mar 6, 2005 at 7:11 am
    Mar 10, 2005 at 2:06 am
  • I have French text with accents in it and would rather (for search purposes) be able to search for things with the accents removed. Is there any builtin postgres function which will do this? Here is ...
    Celia McInnisCelia McInnis
    Mar 30, 2005 at 6:30 pm
    Apr 11, 2005 at 12:58 pm
  • Hi! I'm looking for an existing function which allows me to search the nearest neighbours of the requested value. A simple example: if I search the value "2", and my table doesn't contain it, but ...
    Virgile BeddokVirgile Beddok
    Mar 25, 2005 at 6:36 pm
    Mar 28, 2005 at 5:23 pm
  • Hi! I want to choose the destination table by a variable. Something like this: CREATE FUNCTION insert_this(int4, varchar, varchar) RETURNS void AS $$ DECLARE destTable text; BEGIN SELECT INTO ...
    Erik DahlstrandErik Dahlstrand
    Mar 18, 2005 at 3:29 pm
    Mar 19, 2005 at 7:41 am
  • Hello- I am fairly new to postgres, but have been coding for over 20 years and would like to know what, if anything, is available to post data in XML format to postgres. I have read (seemingly) ...
    Greg LindstromGreg Lindstrom
    Mar 16, 2005 at 5:32 pm
    Mar 17, 2005 at 8:02 pm
  • I am building a text email from data in a database table and then delivering it from the database. My question is how do I represent a carriage return or line feed in a plpgsql function? I am ...
    Derrick BettsDerrick Betts
    Mar 8, 2005 at 7:36 pm
    Mar 9, 2005 at 11:07 am
  • Hi all, Sorry if you have received this before. I've tried to post the complete mail, but it is not going through. Warning this is a long e-mail and is across two posts. I'm hoping someone out there ...
    Noel FauxNoel Faux
    Mar 31, 2005 at 3:13 am
    Mar 31, 2005 at 5:52 am
  • I don't know how to assign directly from a record into an element of a multidimensional array. I seem to have to assign to a scalar first. Here's a small program which shows what I can't and can do: ...
    Celia McInnisCelia McInnis
    Mar 17, 2005 at 11:05 pm
    Mar 18, 2005 at 7:44 pm
  • Hi: In a plpgsql procedure is there any way to form an insert command which has some null values for values of the inputs? Currently when I form such a command, the command becomes null if there are ...
    Celia McInnisCelia McInnis
    Mar 15, 2005 at 10:53 pm
    Mar 17, 2005 at 1:10 am
  • Dear group, when I try to insert a statement : INSERT INTO processed_data(exp_id,seq_anno_id,cel_id,proc_symbol,proc_exprs,proc_pval)VALUES((currval('experiment_exp_id_seq')),(SELECT platform_id from ...
    Kumar SKumar S
    Mar 8, 2005 at 2:48 pm
    Mar 9, 2005 at 6:01 pm
  • Hi all, I'm brand new to postgresql (2 weeks) and I'm trying to move a web/PHP application from MySQL. I've searched the PG8 docs and googled but can't seem to find anything which is the equivalent ...
    Kim KohenKim Kohen
    Mar 31, 2005 at 11:59 am
    Apr 6, 2005 at 3:30 pm
  • i need to install PostGreSQL 8.0.1 on my RedHat Enterprise 3 server. i'm using the postgresql-8.01-2PGDG.x86_64.rpm package, and it's paired server package. i get a lot of dependency failures on an ...
    Chris JensenChris Jensen
    Mar 30, 2005 at 6:07 pm
    Mar 31, 2005 at 5:31 pm
  • I can not get pgaccess to run under windows xp. It starts, displays its popup window with a telescope. I can not make it do anything else. There is no oportunity to enter the address of the ...
    LuckydavidLuckydavid
    Mar 24, 2005 at 8:20 pm
    Mar 25, 2005 at 3:48 pm
  • I have configured a .pgpass file, but am having trouble with the hostname portion. If I have robux:*:JED:jed:jed or local:*:JED:jed:jed and I do "psql -U jed" I get the password prompt. If I use ...
    Walker, Jed SWalker, Jed S
    Mar 21, 2005 at 8:49 pm
    Mar 22, 2005 at 2:52 pm
  • Hi All, I am trying to create output that contains a dimension and the user would like to see single quote for feet and double quote for inches. I have not as yet stumbled on the solution. SELECT ...
    Keith WorthingtonKeith Worthington
    Mar 18, 2005 at 9:41 pm
    Mar 21, 2005 at 2:20 pm
  • Ok this is noobish, but I am new to both databases and especially PostgreSQL. I am planning out how I am going to setup my database schema, and I have quite a few fields in the different tables where ...
    Morgan KitaMorgan Kita
    Mar 18, 2005 at 2:18 am
    Mar 19, 2005 at 4:38 am
  • Hi to all. I need download text file from internet, and I'll use plpgsql, but I don't know if this language can do this. Ideas? Where I can find documentation more precisely than postgresql manual? ...
    Dario BilloDario Billo
    Mar 15, 2005 at 9:32 pm
    Mar 16, 2005 at 11:18 am
  • Hi all My table definition : id | fref | mref ------+-----------+---------- 1 | 23 | 25 2 | 24 | 28 3 | 25 | 31 4 | 26 | 34 My problem : i need a query that results in this : id | ref ...
    Steven VerhoevenSteven Verhoeven
    Mar 11, 2005 at 12:36 pm
    Mar 14, 2005 at 2:43 am
  • I'm having problem exporting tables. I'm using the windows version of 8. If I try to execute pg_dump.exe, I get rejected. I'm logged in with admin privileges, so I log out and log in under my ...
    Sean MontagueSean Montague
    Mar 9, 2005 at 5:30 pm
    Mar 9, 2005 at 6:49 pm
  • I am using PostgreSQL 7.4 on a Linux machine, I have built a small DB and PqAdmin III and PgAccess both fail when I try to connect, the same error happens when trying to connect with QT3 I get the ...
    NetSuporteNetSuporte
    Mar 8, 2005 at 1:59 am
    Mar 9, 2005 at 5:14 pm
  • I know that my problem is due to my carelessness and ignorance, but I didn't think that installing PostgreSQL would cause a state of affairs not easily reversed. Please excuse the length of the ...
    Hagop H.Hagop H.
    Mar 4, 2005 at 9:07 pm
    Mar 8, 2005 at 7:07 am
  • Hello all, I am using a laptop and some of my .sql files with insert statements (300K insert statements) take very long time. I user database= \i /home/user/../../../insert.sql this takes a long ...
    Kumar SKumar S
    Mar 6, 2005 at 5:29 am
    Mar 7, 2005 at 3:28 pm
  • Hi Really lost. I have managed to get the prompt working but when I try to make a db nothing happens. (I am on windows XP) template1-# \l List of databases Name | Owner | Encoding ...
    Stephen ChoulartonStephen Choularton
    Mar 29, 2005 at 7:34 am
    Mar 29, 2005 at 3:34 pm
  • I am trying to figure out how to set a variable in psql and use it and how to echo information. in Oracle I can do: define jed = foo prompt This is the value of jed select sysdate, &jed from foo; and ...
    Walker, Jed SWalker, Jed S
    Mar 24, 2005 at 11:30 pm
    Mar 26, 2005 at 1:50 pm
  • Hello again, I'm stuck on another issue. I need to specify in a sql script I'm calling from psql that I want everything to go to an output file. So, I have in my sql file: \o example1.lst \qecho This ...
    Walker, Jed SWalker, Jed S
    Mar 25, 2005 at 5:39 pm
    Mar 26, 2005 at 1:04 pm
  • I have recently migrated from MS Access to PostgreSQL.Previously I had a SQL command ResultSet aGroupResultSet = aGroupPathStmt.executeQuery( "SELECT \"groupID\",\"fullpath\" FROM \"groups\" WHERE ...
    William ShatnerWilliam Shatner
    Mar 11, 2005 at 5:19 pm
    Mar 24, 2005 at 11:17 am
  • ...every psql command I issue gets this response: psql: FATAL: password authentication failed for user "postgres" even though there is no password prompt. This happens for any valid account. ...
    Jon AllenJon Allen
    Mar 23, 2005 at 6:41 pm
    Mar 23, 2005 at 10:17 pm
  • I'm trying to compile 8.0.1 on a 64bit Ubuntu system and get the following error: make[3]: Entering directory `/home/tim/source/postgresql/postgresql-8.0.1/src/pl/plperl' gcc -O2 -Wall ...
    Tim BowdenTim Bowden
    Mar 22, 2005 at 11:41 am
    Mar 23, 2005 at 3:12 am
  • Help - I'm not sure if this is a bug, but I wouldn't call it a feature! :-) Here are my attempts at selecting out the counts for the number of records for each particular day of the week. I'd like to ...
    Celia McInnisCelia McInnis
    Mar 21, 2005 at 5:36 pm
    Mar 22, 2005 at 6:54 pm
  • Hi: plpgsql allows me to define an array: direction TEXT[2]:=array['out','in']; and I can print out the whole array via: RAISE NOTICE 'direction=%',direction; getting: direction={in,out} but how do I ...
    Celia McInnisCelia McInnis
    Mar 11, 2005 at 10:41 pm
    Mar 12, 2005 at 12:44 am
  • Hello, potentially dumb question: if I want to use non-standard Python modules within PL/Python, I guess I have to recompile something (plpython.dll in the /lib folder)? If I would like to avoid ...
    Wolfgang KellerWolfgang Keller
    Mar 6, 2005 at 6:56 pm
    Mar 7, 2005 at 7:33 am
  • Dear group: Is there any tool that can draw a schema diagram from the relations in my database. It has become a pain in the neck to draw a schema every time and i am loosing track of my tables and ...
    Kumar SKumar S
    Mar 29, 2005 at 6:49 pm
    Apr 6, 2005 at 3:24 pm
  • Hi all, After several frustrating hours (all weekend in fact) of trying unsuccessfully to install and run Postgres (version 8.01 binary windows installer from the Postgres ftp site), I have learned ...
    Stephen P. ChristopherStephen P. Christopher
    Mar 28, 2005 at 3:16 am
    Apr 4, 2005 at 12:00 pm
  • Happy Easter to christians! Dear friends, how do you connect to pgsql using vb6. i have already installed pgadminIII in my laptop under windows xp. i tried to use ADO but there is always connection ...
    Ramon OrticioRamon Orticio
    Mar 28, 2005 at 2:41 am
    Apr 3, 2005 at 12:45 pm
  • Hello- I had a query to insert values into a table where some of the entries were empty: INSERT INTO MYTABLE (VALUE_1, VALUE_2) VALUES ('Hello', '') which worked like a champ. I discovered some ...
    Greg LindstromGreg Lindstrom
    Mar 30, 2005 at 3:31 pm
    Mar 30, 2005 at 5:14 pm
  • hi, how do i call a stored procedure i have in postgresql 8.0.1 from php with the necesary parameters or variables? thanx.
    CimaCima
    Mar 29, 2005 at 4:50 pm
    Mar 29, 2005 at 6:46 pm
  • Hi All, Is there any command to display relations between tables? Like, for instance, I would like to know what column in what table is linked with a particular column in other table. I´m working on ...
    Mauricio Siqueira de OliveiraMauricio Siqueira de Oliveira
    Mar 28, 2005 at 11:31 pm
    Mar 29, 2005 at 2:11 am
  • Hi I have installed postgresql but it seems to be password protected. When I try and make any entries at the prompt (I am using winXP and have the prompt in the \bin directory) it asks for a ...
    Stephen ChoulartonStephen Choularton
    Mar 26, 2005 at 11:14 pm
    Mar 28, 2005 at 10:36 pm
  • hi all, i've been looking through the postgresql 7.4 manual (pdf version) and havent been able to find any detailed info on how to write and interact with stored procedures. i've noticed that user ...
    CimaCima
    Mar 25, 2005 at 6:47 am
    Mar 25, 2005 at 1:52 pm
  • hi, i need the pgsql.so file and i cant find it in my installer folder no the installed folder. is there a site where i can download it. im using mandrake 10 and postgresql 8.0.1 with php 4.3.2, just ...
    CimaCima
    Mar 23, 2005 at 5:43 am
    Mar 23, 2005 at 1:42 pm
  • We need to "recreate" our demonstration database about every two hours, and we'd like to develop a cron job, calling scripts, that will accomplish that for us. The problem is.... if someone is on our ...
    Jack MillerJack Miller
    Mar 22, 2005 at 6:48 pm
    Mar 22, 2005 at 7:37 pm
  • I've noticed postgres uses some environment variables such as $PGDATA. Is there a standard postgres environment variable for the current database? I'd like something where we can have aliases and ...
    Walker, Jed SWalker, Jed S
    Mar 17, 2005 at 7:58 pm
    Mar 21, 2005 at 3:36 am
  • Hello i have a column 'id' wich is a sequence incremented by 1 i did a verification on my table and found that i probably got some lines deleted from the table. i compared the count(*) and the ...
    Zouari FouratZouari Fourat
    Mar 20, 2005 at 4:17 am
    Mar 20, 2005 at 5:57 am
  • hi, im working with mandrake 10, using postgresql 7.4 and php to make a web site. i want to be able to upload image files to my database and show the image in a web page later. there seems to be some ...
    CimaCima
    Mar 16, 2005 at 3:15 am
    Mar 16, 2005 at 8:28 am
  • I have a table whose rows are distinguished by a sequence. I'd like to be able to, given a certain value of that sequence, retrieve the next and previous values in relation to the given value. ...
    Christopher NehrenChristopher Nehren
    Mar 15, 2005 at 10:36 pm
    Mar 16, 2005 at 1:38 am
  • Hi, I need to write a function returning a set of integer. I'm basing this example on GetRows from http://techdocs.postgresql.org/guides/SetReturningFunctions Here's the function: create or replace ...
    Raphael BauduinRaphael Bauduin
    Mar 14, 2005 at 3:50 pm
    Mar 14, 2005 at 4:07 pm
  • Hi Sean and group members, with all your help i could upload a part of my dataset successfully into my database. I am queying my database. currently I am querying two tables for data. There are two ...
    Kumar SKumar S
    Mar 11, 2005 at 4:45 pm
    Mar 12, 2005 at 8:54 pm
  • I suspect that, unlike Access, PostgreSQL will intrepret C-style escape sequences (ie: \r, \n, \t) so you'll need to properly escape the backslash in aPath like so: folder1\\folder2\\folder3 Regards, ...
    Shelby CainShelby Cain
    Mar 11, 2005 at 5:31 pm
    Mar 12, 2005 at 9:32 am
  • i'm trying to store documents or links to documents (excel, word, jpgs, etc... everyone uses windoze) that will need to be referenced (eg, written instructions that may need pictures to better ...
    Operationsengineer1Operationsengineer1
    Mar 9, 2005 at 5:39 pm
    Mar 10, 2005 at 1:09 am
Mar 2005
123
Group Navigation
period‹ prev | Mar 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions105
posts356
users111
websitepostgresql.org
irc#postgresql

111 users for March 2005

Michael Fuhr: 31 posts Tom Lane: 27 posts John DeSoi: 23 posts Sean Davis: 20 posts Operationsengineer1: 15 posts Bruno Wolff III: 15 posts Celia McInnis: 13 posts Kumar S: 13 posts Cima: 11 posts David: 11 posts Walker, Jed S: 9 posts Keith Worthington: 8 posts Brew: 5 posts Afton & Ray Still: 5 posts Derrick Betts: 5 posts Ross Gohlke: 5 posts Stephan Szabo: 5 posts Stephen Choularton: 5 posts Andreas Kretschmer: 4 posts George Weaver: 4 posts
show more
Archives