FAQ

Search Discussions

95 discussions - 333 posts

  • Can anybody help get me started here? I've downloaded the 8-beta .msi file and ran set up on my XP Home laptop. Now I have no clue what to do. I followed Carlo's web tutorial and got almost all the ...
    Jeff SkeithJeff Skeith
    Aug 13, 2004 at 2:21 am
    Aug 16, 2004 at 12:33 pm
  • I read the posts on pgsql functions and transactions from the Novice list, and I think they are saying "PGSQL functions do not support transactions". Is this correct? Or is the idea that functions ...
    Betsy BarkerBetsy Barker
    Aug 26, 2004 at 5:25 pm
    Sep 4, 2004 at 3:57 am
  • In PGSQL, is it possible to lock the entire database??!! This could be done with locking with individual table locking, but any way to lock the entire db?? If this is the only way, how do i get the ...
    BenjaminBenjamin
    Aug 5, 2004 at 5:45 am
    Aug 11, 2004 at 6:53 am
  • Hello, Ill assume I have the correct mailing list since my question regards the tip located in the 7.4 user docs on arrays. It says that searching for specific array elements can be a sign of bad ...
    A GilmoreA Gilmore
    Aug 8, 2004 at 5:15 am
    Aug 9, 2004 at 2:52 pm
  • I run a Perl/CGI driven website that makes extensive use of PostgreSQL (7.4.3) for everything from user information to formatting and display of specific sections of the site. The server itself, is a ...
    Martin FosterMartin Foster
    Aug 3, 2004 at 6:19 pm
    Aug 4, 2004 at 7:09 pm
  • I have a view from which I select values, but I need to do a 'SELECT DISTINCT' query on a 'varchar' column and order by lower case eg: SELECT DISTINCT name FROM someview ORDER BY lower(name) ...
    Jake StrideJake Stride
    Aug 10, 2004 at 11:23 am
    Aug 27, 2004 at 12:05 am
  • I know I know, this topic is probably a cliche by now, but I am looking for real world developers' and DBAs' experiences from people who have managed/ developed for both. I've developed for MySQL ...
    KunalKunal
    Aug 24, 2004 at 10:50 am
    Aug 24, 2004 at 7:49 pm
  • Hi, Saw the new Beta of PostgreSQL had a Windows installer, so I took a stab at it. My machine is running Windows XP on a Dell 2GHz 512MB RAM laptop. I ran the postgresql-8.0-beta1-20040809.msi ...
    Chris MeansChris Means
    Aug 10, 2004 at 7:05 pm
    Aug 12, 2004 at 4:39 am
  • PostGreSql 7.4.3 I noticed that there was a change in the way that 7.4 handled trailing spaces in CHAR/VARCHARS, so upgraded from 7.2.4, I still seem to get the same problem - putting a CHAR(250) ...
    Steve TucknottSteve Tucknott
    Aug 2, 2004 at 2:05 pm
    Aug 3, 2004 at 3:06 pm
  • PostGreSQL 7.4.3 I have a table that 'translates' codes between two types. The structure is: recno | integer | not null default nextval('public.kah_kahxlate_recno_seq'::text) kahcode | character(25) ...
    Steve TucknottSteve Tucknott
    Aug 22, 2004 at 12:53 pm
    Sep 15, 2004 at 10:21 pm
  • PostGreSql 7.4.3 Am I right in assuming that a foreign key on a table does not explicity create an index on that column on the foreign table? I can see via the \d on the table that the foreign key ...
    Steve TucknottSteve Tucknott
    Aug 27, 2004 at 8:27 am
    Aug 27, 2004 at 8:11 pm
  • Hi Okay... you guys said "No question is too simple here", so here I go... I see 4 directories/ folders in /binary/v7.4.5/srpms/ fedora-core-1 fedora-core-2 redhat-9 rhel-3 Which one of those do I ...
    KunalKunal
    Aug 24, 2004 at 8:09 am
    Aug 25, 2004 at 8:50 am
  • Hi, Does a function executed by a trigger know which table fired the trigger? I'm using the same function for several triggers on different tables. Now, I'm passing the table name as argument: CREATE ...
    Raphael BauduinRaphael Bauduin
    Aug 11, 2004 at 7:45 am
    Aug 12, 2004 at 12:11 pm
  • I had a-couple of questions regarding the text formatting in the pg_dump file. First, when dumping my database, I seem to be getting inconsistent end-of-line characters. Some lines end with the ...
    John BrowneJohn Browne
    Aug 24, 2004 at 6:26 pm
    Aug 28, 2004 at 6:11 pm
  • I have a table with a text column and I'd like to find entries matching "pattern*" in that column. When using a between i get: sd= explain analyze select id,name, shortname from tr where shortname ...
    Jesper KroghJesper Krogh
    Aug 25, 2004 at 2:00 pm
    Aug 26, 2004 at 7:27 am
  • Hello. I have a function that creates a long TEXT string that looks like this: ...
    Betsy BarkerBetsy Barker
    Aug 24, 2004 at 9:14 pm
    Aug 24, 2004 at 10:35 pm
  • Hi, I'm using PostgreSQL 7.4.3 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.4 (Debian 1:3.3.4-3). I'm fine with most things except I simply don't understand how authentication works ...
    Tim hallTim hall
    Aug 24, 2004 at 2:15 am
    Aug 24, 2004 at 2:57 pm
  • It has been impossible to install PostgreSQL, an open source software, from my SUSE 8.0 . Although it tells you its been installed, each time i try to start it using SysV-Init Editor, i get the ...
    Eyinagho NewtonEyinagho Newton
    Aug 21, 2004 at 5:38 pm
    Aug 24, 2004 at 12:29 pm
  • I did a search for this error *dup(0) failed after 3195 successes: Bad file descriptor* and came up empty as far as resolutions. Some references on postgresql.org archives seem to indicate it isn't ...
    Operationsengineer1Operationsengineer1
    Aug 20, 2004 at 2:19 am
    Aug 20, 2004 at 3:14 pm
  • Hi, I am having a table something like this.... CREATE TABLE(PointId integer, PointName varchar(50),PointType integer, createtime bigint); where createtime is the current timestamp when the tuple is ...
    Pradeepkumar, Pyatalo (IE10)Pradeepkumar, Pyatalo (IE10)
    Aug 12, 2004 at 2:51 pm
    Aug 17, 2004 at 4:21 am
  • Hi everybody out there using Postgres. I am using PgAdminIII & I would like that my query results that appears on the console might be redirected to a file or to a temporary table. Someone suggested ...
    Eduardo Vázquez RodríguezEduardo Vázquez Rodríguez
    Aug 10, 2004 at 3:26 pm
    Aug 11, 2004 at 10:43 am
  • Is there a way of doing: RETURNS INTEGER, CHAR(5), VARCHAR(200),..... IE return multiple values from a PL/PGSQL function? (From what I can see so far, you only have 1 return field - although that can ...
    Steve TucknottSteve Tucknott
    Aug 8, 2004 at 6:57 pm
    Aug 9, 2004 at 3:12 pm
  • With lots of help from folks on this mailing list, the readme files and other net sources, i've found a simple process for seeting up an WinXP box as PHP/PostgreSQL development environment. Just as I ...
    Operationsengineer1Operationsengineer1
    Aug 24, 2004 at 8:44 pm
    Aug 26, 2004 at 5:23 pm
  • Hi All I have a script that went haywire and created 2 databases with what looks like empty names OR names made up of spaces. Here is the output of my psql -l command excluding the 1,2,3,4. As you ...
    Jonathon BatsonJonathon Batson
    Aug 19, 2004 at 12:38 am
    Aug 19, 2004 at 3:59 am
  • Hello group, I am newbie to postgrSQL and also databases. I am making a database of proteins. In one table I have 4 columns. Is it possible that after some time, I can create as many columns ...
    Kumar SKumar S
    Aug 16, 2004 at 12:51 pm
    Aug 16, 2004 at 6:44 pm
  • We have a need to create temporary tables (within functions); the documentation states that temporary tables last as long as the pg session. What, precisely, does this mean? The length of the active ...
    Taber, MarkTaber, Mark
    Aug 10, 2004 at 6:35 pm
    Aug 11, 2004 at 4:59 pm
  • All, I'm trying to create a regular expression that plays nice with UNICODE strings. I'd like to allow any alphabetic or digit character (as defined by its UNICODE category) in a username. I've ...
    David NorrisDavid Norris
    Aug 4, 2004 at 10:10 pm
    Aug 5, 2004 at 4:50 pm
  • I have a problem that I can't understand. I am using macosx, pg 7.4.3. I had a server running and working. I tried to bring the server down with 'pg_ctl stop', which failed (server running on ...
    Sean DavisSean Davis
    Aug 5, 2004 at 10:33 am
    Aug 5, 2004 at 2:17 pm
  • How are people doing automated comparisons of schemas in different databases? E.g. we have a dev database, a beta database, and a production database. We need to insure that changes in schema are ...
    Frank KurzawaFrank Kurzawa
    Aug 2, 2004 at 10:04 pm
    Aug 3, 2004 at 11:48 am
  • Hi all, I have 2 tables - table1 and table2. Both the tables are related to each other. I have written triggers so that if a tuple is inserted into table1, corresponding values will be inserted into ...
    Pradeepkumar, Pyatalo (IE10)Pradeepkumar, Pyatalo (IE10)
    Aug 2, 2004 at 5:27 am
    Aug 2, 2004 at 4:15 pm
  • Hi all, I am using Postgresql 7.4.3 on Linux 7.2. In my project i am using many user defined functions. All the functions are working fine, no problem with the working. I had stored all the functions ...
    Pradeepkumar, Pyatalo (IE10)Pradeepkumar, Pyatalo (IE10)
    Aug 31, 2004 at 5:54 am
    Aug 31, 2004 at 6:29 am
  • Hi, The recent Postgres7.4.5 mentions a fix for a crash. http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-5 "Repair possible crash during concurrent btree index insertions This ...
    Rajan BhideRajan Bhide
    Aug 30, 2004 at 9:20 am
    Aug 30, 2004 at 2:42 pm
  • hi there, i would like to drop all tables in a database without having to issue individual drop-statements for every table. is there a command that can do this? i can not use the dropdb since i do ...
    Tom TomTom Tom
    Aug 19, 2004 at 9:16 am
    Aug 24, 2004 at 8:07 pm
  • PostGreSQL 7.4.3 (RedHat 8) Is there a 'monitor' utility that shows connected sessions details (ie who is connected, what they are executing etc)? Regards, Steve Tucknott ReTSol Ltd DDI: 01903 828769
    Steve TucknottSteve Tucknott
    Aug 24, 2004 at 9:21 am
    Aug 24, 2004 at 9:47 am
  • Hello, I am about to begin my first installation of PostgreSQL. :-) At the moment I am installing Red Hat Linux ES v3 on a brand new machine for use as a database server. The machine has two RAID ...
    Keith WorthingtonKeith Worthington
    Aug 19, 2004 at 1:32 am
    Aug 19, 2004 at 6:04 am
  • Hello, I have a little problem. I suppose that this question is stupid but... When I start the configure it gave me the following error: checking for shmget in -lcygipc... no checking for readline... ...
    Kaloyan Iliev IlievKaloyan Iliev Iliev
    Aug 18, 2004 at 6:02 pm
    Aug 19, 2004 at 5:46 am
  • hi, i have a btree index on col1 in table1. The column has either values 1,2,3, or 4. 4 does not appear that much in the table (only 5 times). there are about 20 million rows in the table. when i do ...
    Amir ZichermanAmir Zicherman
    Aug 17, 2004 at 9:06 pm
    Aug 18, 2004 at 6:09 pm
  • What is the correct syntax for the following. I have table A joined to table B and C. I also have table A left outer joined to tables D and E and in turn D is joined to F SELECT ...
    Steve TucknottSteve Tucknott
    Aug 14, 2004 at 7:31 am
    Aug 14, 2004 at 4:54 pm
  • I'm at a crossroads with PGSQL. I want to use it with PHP to develop web databases as part of my job. I've developed using Access and Visual Basic, but I like the open source concept better and I ...
    SkeetsSkeets
    Aug 13, 2004 at 12:41 am
    Aug 13, 2004 at 5:43 pm
  • Hi. I am looking for a management tool which can run queries to postgres db and the results could be handled showing graphics, statics, etc. Preferently being free software. Any suggestions are ...
    Eduardo Vázquez RodríguezEduardo Vázquez Rodríguez
    Aug 13, 2004 at 2:19 pm
    Aug 13, 2004 at 2:52 pm
  • Hi, I am migrating a database to postgresql, with a data schema change. I'd need to do some stress testing (on the db design I have, not a general test a la TPC). I'm just starting to look at this, ...
    Raphael BauduinRaphael Bauduin
    Aug 12, 2004 at 1:43 pm
    Aug 13, 2004 at 8:15 am
  • I'm new to SQL and I am having a little difficulty trying to construct a query that will use the first table in the following list: TABLE coaching_relationships: coaching_relationship_id coach_id ...
    ExpoShare.comExpoShare.com
    Aug 11, 2004 at 11:49 pm
    Aug 12, 2004 at 4:53 pm
  • First, thanks for all your responses. The programmers have yet another question. We will be connecting to a single pg db from our intranet application (web-based). Each instance of this application ...
    Taber, MarkTaber, Mark
    Aug 11, 2004 at 2:44 pm
    Aug 11, 2004 at 5:33 pm
  • Once again, ;-) The script is finally done i hope ... i can create my function.... no problem but when i'm calling it up with a SELECT zufall(); statement pgAdmin tells me there is no function with ...
    Marcel BoscherMarcel Boscher
    Aug 10, 2004 at 3:05 pm
    Aug 11, 2004 at 4:16 am
  • Hello all, I wish to know if there is some function soundex on PostgreSQL ? I'm need to make search based on this, and by now what I've made was creating an atribute with the soundex of the name and ...
    Roberto Rezende de AssisRoberto Rezende de Assis
    Aug 10, 2004 at 1:42 pm
    Aug 10, 2004 at 2:54 pm
  • I have unly one database and two disks. In order to use all my hardware resources I want to store (for example) the tables in one of the disks and the indexes in the other one. How can I do that? ...
    Gastón SimoneGastón Simone
    Aug 6, 2004 at 5:50 pm
    Aug 6, 2004 at 6:33 pm
  • Does PostgreSQL not support insert into mytable (row1, row2) values ('a', '1'), ('b', '2'), ('c', '3'), ('d', '4') ? If not, does anyone know why not? Si
    Si ChenSi Chen
    Aug 2, 2004 at 6:26 pm
    Aug 6, 2004 at 3:41 pm
  • Hi, I am trying to install Postgresql 7.4.3 on RedHat Linux 9. After I finished ./configure, I typed 'gmake', then it began to check. It shows 'checking for int ... yes' and a list of checking ...
    Max ChuMax Chu
    Aug 6, 2004 at 3:37 am
    Aug 6, 2004 at 4:57 am
  • Thought I'd try this on the pgsql-general list. Begin forwarded message: The files do exist, for example: /usr/include/libxml2/libxml/xpath.h Cheers, - Joel
    Joel RodriguesJoel Rodrigues
    Aug 1, 2004 at 8:42 am
    Aug 2, 2004 at 9:04 am
  • Dear all, Will installing the beta 2 of win32 be a just next - next button click sequence on windows port or does upgradation requires some tweaking etc -- With Best Regards, Vishal Kashyap. Yahoo IM ...
    V i s h a l Kashyap @ [Sai Hertz And Control Systems]V i s h a l Kashyap @ [Sai Hertz And Control Systems]
    Aug 31, 2004 at 5:19 am
    Aug 31, 2004 at 7:44 am
Group Navigation
period‹ prev | Aug 2004 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions95
posts333
users106
websitepostgresql.org
irc#postgresql

106 users for August 2004

Tom Lane: 34 posts Oliver Elphick: 15 posts Steve Tucknott: 15 posts Operationsengineer1: 13 posts Bruce Momjian: 11 posts Josh Berkus: 11 posts Scott Marlowe: 11 posts Sean Davis: 11 posts Mike G: 10 posts Mike: 9 posts Oliver Fromme: 9 posts Michael Glaesemann: 8 posts Pradeepkumar, Pyatalo (IE10): 8 posts Eduardo Vázquez Rodríguez: 7 posts Gaetano Mendola: 7 posts Ron St-Pierre: 7 posts Arthur van Dorp: 6 posts Betsy Barker: 5 posts Raphael Bauduin: 5 posts Chris Means: 4 posts
show more
Archives