FAQ

PostgreSQL > pgsql-novice > April 2009

Search Discussions

33 discussions - 129 posts

  • I'm experiencing bug 4608 http://archives.postgresql.org/pgsql-bugs/2009-01/msg00062.php I have tried using the Windows one-click installer for both 8.3.x and 8.4. At the end of the process it says ...
    Robert CampbellRobert Campbell
    Apr 22, 2009 at 12:18 pm
    Apr 23, 2009 at 1:46 pm
  • We've got an application to install on PostgreSQL 8.2 and the requirements say "Please make sure that PL/pgsql and FuzzyStringMatch library is installed." Can anyone tell me which RPM packages ...
    John GardnerJohn Gardner
    Apr 3, 2009 at 11:52 am
    Jul 23, 2009 at 9:23 pm
  • Hello everyone, I need to retrieve PK (r.id in the query) for row with MIN(r.start_date), but with a twist: I need to select only one record, the one with minimum date. Doing it like this does not ...
    Marcin KrolMarcin Krol
    Apr 29, 2009 at 12:43 pm
    May 1, 2009 at 8:19 am
  • Hello All, I am trying to get a list of the functions built into postgreSQL. I know to use the \df command w/n psql, but paging through that is painful. Is there a way to send the \df output to a ...
    CraigCraig
    Apr 1, 2009 at 2:14 pm
    Apr 3, 2009 at 9:39 am
  • Hello, I want write a query that will insert a record in a person table, insert a record in a presentation table, and then insert a record into a bridge table that contains the keys of both of the ...
    Carol WalterCarol Walter
    Apr 23, 2009 at 2:24 pm
    Jul 6, 2009 at 6:19 pm
  • Hello: CentOS 5.2 PostgreSQL Server (eth1: 192.168.1.1): I got the PostgreSQL server installed. The following modules are installed: postghresql-libs-8.3.7, postgresql-8.3.7, postgresql-server-8.3.7 ...
    Just E. MailJust E. Mail
    Apr 13, 2009 at 2:18 pm
    Apr 14, 2009 at 12:05 pm
  • I have a table that defines a programmed service that does something automatically every time interval (days, weeks, months) from a beginning date to a ending date. How can I do this in postgresql? I ...
    André SilvaAndré Silva
    Apr 9, 2009 at 12:13 am
    Apr 19, 2009 at 11:08 am
  • Hello: This is the simplest question on this form but I have pulled all my hair trying figuring it out. PLEASE HELP! I have installed PostgreSQL V8.3.7 (RPM) on a CentOS 5.2 system. PostgreSQL server ...
    Just E. MailJust E. Mail
    Apr 8, 2009 at 10:28 pm
    Apr 9, 2009 at 1:13 pm
  • Hello all I want to copy the data from one table to other table. These tables reside in two different databases. I am thinking of using following query insert into table2 (select * from table1) but ...
    Preetam PalwePreetam Palwe
    Apr 27, 2009 at 10:30 am
    Apr 29, 2009 at 3:52 pm
  • How to drop a table which is part of a non-public schema? drop table myschema.mytable does not work. -- Regards PK -------------------------------------- http://counter.li.org #402424
    P KapatP Kapat
    Apr 7, 2009 at 1:37 am
    Apr 7, 2009 at 4:35 pm
  • Hello: My first try installing PostgreSQL (CentOS 5.2). I am following the "Installing PostgreSQL on Red Hat Enterprise LINUX / Fedora Core". This document says that to install a PostgreSQL Server, I ...
    Just E. MailJust E. Mail
    Apr 5, 2009 at 3:28 pm
    Apr 5, 2009 at 9:12 pm
  • I want to just get the number of seconds and not have to use extract for seconds, minutes, hours, days, months, years, etc. Is that possible?
    A BA B
    Apr 8, 2009 at 3:14 pm
    Apr 9, 2009 at 7:48 am
  • Hello, i am searching for the scripts mentionend at one of the first chapters of the SQL-tutorial (Part II of the manuals) http://www.postgresql.org/docs/8.3/interactive/tutorial-sql-intro.html My ...
    MaxMax
    Apr 8, 2009 at 2:53 pm
    Apr 8, 2009 at 4:14 pm
  • Hello: My first posting! I am trying to install PostgreSQL on a CentOS 5.2 server. PostgreSQL 8.0 comes packaged with CentOS. The latest version of PostgreSQL is 8.3.7. Since I am a novice, my ...
    Just E. MailJust E. Mail
    Apr 3, 2009 at 10:43 am
    Apr 3, 2009 at 1:44 pm
  • Hi All, I'm attempting to implement an auto complete text field on a site I run. The plan is to return a maximum of 5 rows where the name of the location *begins* with the contexts of the text field ...
    Neil SaundersNeil Saunders
    Apr 28, 2009 at 4:31 pm
    Apr 28, 2009 at 4:55 pm
  • I've been handed a table that reminds me of a sparse matrix and I'm thinking that there should be some SQL way to simplify it. Assume table like (a column for every department, separate rows for each ...
    Bryan EmrysBryan Emrys
    Apr 27, 2009 at 8:09 pm
    Apr 27, 2009 at 8:19 pm
  • Hi list, How do I get all the tables which contains a specific column name? For example, I want to get all tables that has an `is_active` column in them? Thanks, Ridvan -- リヅバン バルヨス ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Apr 22, 2009 at 6:52 am
    Apr 22, 2009 at 7:16 am
  • Hi, I'm currently having a problem with my PostgreSQL, i'm running a DSpace application working under Solaris OS. Everything was fine, but I began to receive repeatedly the following error messages ...
    Juan Jose De LeonJuan Jose De Leon
    Apr 20, 2009 at 7:34 pm
    Apr 21, 2009 at 7:08 pm
  • Hello, I've created this function: CREATE OR REPLACE FUNCTION subcategories(int) RETURNS setof int AS ' DECLARE -- declarations category ALIAS FOR $1; category_current record; BEGIN -- function body ...
    SlapoSlapo
    Apr 11, 2009 at 8:47 pm
    Apr 11, 2009 at 9:30 pm
  • Hello, I have three tables that create a many-to-many relationship between two of them. One of them has person data and one of them has contact data, and, of course, the other is the bridge table. I ...
    Carol WalterCarol Walter
    Apr 8, 2009 at 1:03 pm
    Apr 8, 2009 at 4:55 pm
  • Hi, I'd like to use a lookup-table that contains text-values and their keys. There is a data-table with entities that have (among others) 2 attributes which could nicely be represented by numbers. ...
    AndreasAndreas
    Apr 29, 2009 at 9:37 pm
    Apr 30, 2009 at 9:57 pm
  • Hello, i have two questions a) how can i export database schema structure and data so that they can be imported to another server - into different database, different tablespace and with a different ...
    Jana VasseruJana Vasseru
    Apr 5, 2009 at 11:48 pm
    Apr 6, 2009 at 12:17 am
  • let me take a gander there is no REPLACE function like mySQL ?? I will have to to check to see if the data exists if it does UPDATE it if not INSERT it ?? Boy here I thought postgresql was the way to ...
    Jeffrey Lake - AdminJeffrey Lake - Admin
    Apr 1, 2009 at 5:47 am
    Apr 1, 2009 at 5:56 am
  • Adam RuthAdam Ruth
    Apr 23, 2009 at 11:01 pm
    Apr 23, 2009 at 11:01 pm
  • We are now working on database check mechanism in our application. The situation is when server shutdown abnormally, the postmaster.pid still exists when reboot, But the PostgreSQL database itself ...
    Chen, Dongdong (GE Healthcare)Chen, Dongdong (GE Healthcare)
    Apr 21, 2009 at 5:44 am
    Apr 21, 2009 at 5:44 am
  • Hello all, I've been doing a little bit of reading on the difference between large objects and bytea. Bytea feels a little bit more like what I'm use to with Oracle, MSSQL, etc. However, I'm leaning ...
    David SaraciniDavid Saracini
    Apr 15, 2009 at 2:04 am
    Apr 15, 2009 at 2:04 am
  • Greetings! I am occupying the time used by PGAdmin to count the 22 million records in a table I just clicked on by asking the list how to tell PGAdmin not to count the 22 million records in a table ...
    Radcon EntecRadcon Entec
    Apr 13, 2009 at 12:44 pm
    Apr 13, 2009 at 12:44 pm
  • Well, is there a file "/tmp/.s.PGSQL.5432"? If not, does stopping and restarting the PG server make it come back? If that does fix it, then the most likely bet is that you have an over-aggressive ...
    Tom LaneTom Lane
    Apr 5, 2009 at 9:29 pm
    Apr 5, 2009 at 9:29 pm
  • Hello: I am in the process of setting up a LVS system. Initially there will be two (later more) Real Servers accessing two PostgreSQL data servers in the backend. PostgreSQL data servers are in ...
    Just E. MailJust E. Mail
    Apr 5, 2009 at 12:26 pm
    Apr 5, 2009 at 12:26 pm
  • Hello: I noticed that there are several GUI applications available to manage PostgreSQL. I want a recommendation,which is the better of the lot. Here is what I am trying to do: I am going to setup a ...
    Just E. MailJust E. Mail
    Apr 3, 2009 at 1:27 pm
    Apr 3, 2009 at 1:27 pm
  • Hi all, I do the following : DROP TABLE IF EXISTS xprod; CREATE TABLE xprod( dm1 INTEGER d5 INTEGER value DOUBLE); ALTER TABLE xprod ADD CONSTRAINT xprod_p_key PRIMARY KEY (dm1,d5) If I run this ...
    Mary AndersonMary Anderson
    Apr 3, 2009 at 1:01 am
    Apr 3, 2009 at 1:01 am
  • Got it. There was another table with constraint xprod_p_key. Mary
    Mary AndersonMary Anderson
    Apr 3, 2009 at 12:58 am
    Apr 3, 2009 at 12:58 am
  • I suspect that I already know the answer to my question but I'm looking for confirmation from experts. I have moved my pg_xlog and pgsql_tmp directories to a separate disk array to distribute IO. ...
    Robert SchnabelRobert Schnabel
    Apr 2, 2009 at 4:23 pm
    Apr 2, 2009 at 4:23 pm
Apr 2009
Group Navigation
period‹ prev | Apr 2009 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions33
posts129
users46
websitepostgresql.org
irc#postgresql

46 users for April 2009

Tom Lane: 15 posts Just E. Mail: 12 posts Robert Campbell: 10 posts Andreas Kretschmer: 8 posts Bruce Momjian: 6 posts Jasen Betts: 5 posts Carol Walter: 4 posts Obe, Regina: 4 posts Sean Davis: 4 posts Adam Ruth: 3 posts Craig: 3 posts John Gardner: 3 posts Michael Lush: 3 posts P Kapat: 3 posts Slapo: 2 posts A B: 2 posts Andreas Kretschmer: 2 posts David Gardner: 2 posts Devrim Gündüz: 2 posts Jeffrey Lake - Admin: 2 posts
show more
Archives