FAQ

PostgreSQL > pgsql-novice > March 2001

Search Discussions

96 discussions - 264 posts

  • Hi, I'm having trouble with an obviously simple query that just doesn't perform quite good IMO. I have two tables: httplog=# \d hits Table "hits" Attribute | Type | Modifier ...
    Lukas ErtlLukas Ertl
    Mar 28, 2001 at 8:23 pm
    Mar 30, 2001 at 9:22 am
  • Hi all, I'm brand-new to postgres. I have installed version 6.5 on RHL 6.1 (the rpm). when I try to create a database, I get: ...
    BillBill
    Mar 6, 2001 at 11:53 pm
    Mar 12, 2001 at 7:52 pm
  • Can anyone assist please? In Oracle it is possible to enter variables at run time with a query as follows SELECT name, salary, dept FROM emp WHERE empid = &empid; On running the query you will be ...
    Phil HaywardPhil Hayward
    Mar 10, 2001 at 6:53 pm
    Mar 15, 2001 at 10:53 pm
  • Moderator, please don't approve the other two posts I've made...just this one is plenty...;^) Hi All, I haven't posted a silly question in a while, and didn't want to break my streak... I have a ...
    Ken CoreyKen Corey
    Mar 13, 2001 at 10:59 am
    Mar 14, 2001 at 3:59 pm
  • Can anyone recommend an ISP who uses Cold Fusion and gives you Telnet access into your PostgreSQL account? Frank Hilliard
    Frank HilliardFrank Hilliard
    Mar 9, 2001 at 3:16 am
    Mar 14, 2001 at 3:07 pm
  • Ok, I went into the "ports" directory and dowloaded what I thought was PostGreSQL. 1. Ok, we downloaded and un-tared the postgresql on our new virgin FreeBSD system. 2. Result of which, put the ...
    John DraperJohn Draper
    Mar 4, 2001 at 11:21 pm
    Mar 6, 2001 at 7:48 pm
  • How can I get Last ID inserted ??? The problem is for a multiuser(symultans) database. Exist a statment SQL witch get the last id inserted for a session ? Thanks !
    Catalin CIOCOIUCatalin CIOCOIU
    Mar 2, 2001 at 3:51 pm
    Mar 2, 2001 at 6:50 pm
  • Two comments on the web site: 1. The search feature sucks. I hate to be blunt, but I just did a search for "odbc" and got...NOTHING. 2. The site is very slow (not just today, but every day for the ...
    Donald BramanDonald Braman
    Mar 2, 2001 at 6:59 pm
    Mar 6, 2001 at 3:15 pm
  • Hi ALL, My Configure "./configure --with-perl --with-odbc" generated this messages: creating cache ./config.cache checking host system type... i586-pc-linux-gnu checking echo setting... checking ...
    Daniel A. MeloDaniel A. Melo
    Mar 14, 2001 at 1:39 pm
    Mar 15, 2001 at 4:27 pm
  • Hey everybody, whenever I do a 'select * from profil_ext2;' I get FATAL 1: Memory exhausted in AllocSetAlloc() pqReadData() -- backend closed the channel unexpectedly. This probably means the backend ...
    Thomas HeinisThomas Heinis
    Mar 14, 2001 at 12:42 pm
    Mar 14, 2001 at 4:31 pm
  • Dax DuskinDax Duskin
    Mar 13, 2001 at 3:49 pm
    Mar 13, 2001 at 7:09 pm
  • Hi all, (short) is there any possibility to count the number of rows resulting from a grouped query (from a view containing a grouped query) ? (long) CREATE TABLE tmp (a int, b int, c text); INSERT ...
    Nabil SayeghNabil Sayegh
    Mar 9, 2001 at 6:03 pm
    Mar 13, 2001 at 2:37 pm
  • Hi, How do I grant permissions on everything in the selected databes? GRANT doesnt take as on object database name nor does it accept wild chars.... -- Nothing Like the Sun
    Boulat KhakimovBoulat Khakimov
    Mar 6, 2001 at 4:59 pm
    Mar 13, 2001 at 2:20 am
  • Running Red Hat 7.0, Have installed the following all from rpms postgresql-devel-7.0.2-17 postgresql-python-7.0.2-17 postgresql-7.0.2-17 postgresql-jdbc-7.0.2-17 postgresql-perl-7.0.2-17 ...
    Colby MeyerColby Meyer
    Mar 27, 2001 at 4:21 pm
    Apr 4, 2001 at 7:22 am
  • Hi all, I've got a new installation of Postgres 7.0.3 under Red Hat 7.0, have got as far as the postmaster seems to be working OK, but when I try and create a user account I get the following error: ...
    Mo HolkarMo Holkar
    Mar 23, 2001 at 12:41 am
    Mar 26, 2001 at 8:46 am
  • Hi! My first posting seems to get no response, but I have been researching my problem a little more. This evening I cleaned out all postgres related stuff, and reinstalled, using yast1. From the ...
    Lars ForsethLars Forseth
    Mar 20, 2001 at 9:06 pm
    Mar 22, 2001 at 9:39 pm
  • Hi all, I did a search and found some pages indeed some man pages) indicating that pg_dump and and a (new utility ?) pg_restore now supported BLOBs - one page had an example with a --blobs flag. ...
    Mark, TerryMark, Terry
    Mar 12, 2001 at 8:47 pm
    Mar 16, 2001 at 8:16 pm
  • Hi everybody: I created a table using pgaccess and put some sample data in it. When I went to run a query on it psql I found that there was no relation. "Relation does not exist." It looks like I ...
    Dax DuskinDax Duskin
    Mar 14, 2001 at 5:58 pm
    Mar 14, 2001 at 6:33 pm
  • Hi all, I´m getting compilation errors. The configure could not find some headers files (limits.h, netdb.h, pwd.h...) . i searched for them and they are in "/usr/src/linux-2.2.17/include/linux" and " ...
    Daniel A. MeloDaniel A. Melo
    Mar 8, 2001 at 2:55 pm
    Mar 8, 2001 at 4:09 pm
  • How can I see the list the tables for a database ? There is a query like "show tables" ? I have the same problems witdh other objects: triggers procedures. What is the method for seeing this ? thanks ...
    Catalin CIOCOIUCatalin CIOCOIU
    Mar 8, 2001 at 3:23 pm
    Mar 8, 2001 at 3:56 pm
  • I made a download of postgresql packages .rpm for suse64. I stoped postgresql and started to install the packages. The first package I tried to install was postgres-7.0.3-1suse64-i386.rpm I received ...
    José LuizJosé Luiz
    Mar 30, 2001 at 11:22 pm
    Mar 31, 2001 at 6:14 pm
  • Hi folks, I have the problem that I can't delete datasets out of my tables. It's like that: I have a table: tblshop ID_Shop oid with sequence ------- Sh_Name ID_Country ... there is an index on ...
    chris Güntherchris Günther
    Mar 30, 2001 at 2:27 pm
    Mar 31, 2001 at 2:37 pm
  • Hi, I am using suse linux 6.4, and when I installed linux I installed postgresql distributed by suse. I installed but I did not used (neither started it). Now I downloaded the new postgresql version ...
    José LuizJosé Luiz
    Mar 28, 2001 at 10:30 pm
    Mar 30, 2001 at 3:32 pm
  • I want to know how to use jdbc for postgresql in red hat linux 7.0. I have installed red hat linux 7.0 completely and there are four jdbc.jar files of different version.There are no postgresql.jar ...
    Seema NoorSeema Noor
    Mar 25, 2001 at 6:12 pm
    Mar 26, 2001 at 1:51 am
  • I am setting up a web-based app on Apache, JServ and PostgreSQL 7.0 running on freeBSD. Occasionally I get a "Too many clients" exception, which I can work around by rebooting Apache. I understand ...
    Richard EhrlichRichard Ehrlich
    Mar 24, 2001 at 12:01 am
    Mar 24, 2001 at 2:23 pm
  • Here is an interesting one.. I'm trying to perform the following.. this is a simpler version of what I"m actually working with.. SELECT p.name, c.mostrecentthingbought FROM parent p, child c WHERE ...
    Scott MuirScott Muir
    Mar 24, 2001 at 1:53 am
    Mar 24, 2001 at 3:26 am
  • testdb= testdb= select * from test1; c|i -+- A|2 B|3 C|4 (3 rows) testdb= select * from test2; c|i -+- A|6 C|7 (2 rows) testdb= I'd like to get (test1.i + test2.i) like this: c|sum -+--- A|8 B|3 C|11 ...
    Timo TuomiTimo Tuomi
    Mar 18, 2001 at 11:43 am
    Mar 22, 2001 at 12:10 pm
  • Is there any way to authenticate users against the /etc/passwd (or /etc/shadow) file rather than the pg_shadow table? Is there any good reason for *not* wanting to do this (other than the general ...
    Adrian JacksonAdrian Jackson
    Mar 21, 2001 at 3:33 pm
    Mar 22, 2001 at 6:04 am
  • Hello all, I have encountered a weird problem I can't seem to understand. It involves a correlated subquery, where the rows returned seem to depend upon the order I specify my conditions. I can't see ...
    Mark, TerryMark, Terry
    Mar 20, 2001 at 4:06 pm
    Mar 20, 2001 at 5:12 pm
  • testdb= testdb= select * from test1; c|i -+- A|2 B|3 C|4 (3 rows) testdb= select * from test2; c|i -+- A|6 C|7 (2 rows) testdb= I'd like to get (test1.i + test2.i) like this: c|sum -+--- A|8 B|3 C|11 ...
    Timo TuomiTimo Tuomi
    Mar 18, 2001 at 8:10 pm
    Mar 19, 2001 at 3:37 am
  • I can't figure out how to make the following query: Table = circles_proc subject text, arm char, rep int, cycle int I'd like to find the unique subject, arm, and rep tuples where the rep has exactly ...
    G. Anthony ReinaG. Anthony Reina
    Mar 14, 2001 at 9:44 pm
    Mar 15, 2001 at 12:38 am
  • Hi all, I'm having some trouble setting a column to use arrays. Here's an example of what I am trying to do: create table tablename (index INTEGER, numarray INTEGER[]); insert into tablename ...
    Dax DuskinDax Duskin
    Mar 12, 2001 at 5:57 pm
    Mar 13, 2001 at 3:55 pm
  • I have a (probably generic) problem: a table like create table a ( id serial, foo text, bar text, unique( foo, bar ) ); From a PHP script, I do an INSERT and then check by the return value of ...
    Arcady GenkinArcady Genkin
    Mar 10, 2001 at 12:27 pm
    Mar 13, 2001 at 1:38 pm
  • Hi, I am running PostgreSQL 7.0.3 on a Linux 2.4.0 using PHP4 (that is might not relevant here). What I am running into is this. I am trying to pick out rows from the database which contains a ...
    Gabor SzilagyiGabor Szilagyi
    Mar 12, 2001 at 8:34 pm
    Mar 13, 2001 at 5:37 am
  • Hello everyone I am a complete newbie to postgre. I am having a problem logging into the postgre user file in RH 7.0 when I try to do su postgre I get a bash prompt. Also on the postgre website the ...
    Steve BradleySteve Bradley
    Mar 8, 2001 at 6:12 am
    Mar 8, 2001 at 4:44 pm
  • Hi there, I'll begin admitting I'm quite a novice **both** in pgSQL and Linux OS. :) Besides that, I tried to install PG on my Debian (Potato) GNU/Linux PC (x386) and, after very little troubles, ...
    Paolo SinigagliaPaolo Sinigaglia
    Mar 8, 2001 at 10:19 am
    Mar 8, 2001 at 3:36 pm
  • I haven't a problem that I'm sure isn't related to postgres, but I've gotten good answers here before and no one seems to be answering/have a solution for me on the php lists, so if you're a php or ...
    Eric NielsenEric Nielsen
    Mar 8, 2001 at 3:30 am
    Mar 8, 2001 at 3:07 pm
  • Hi, I'm trying to do a LEFT JOIN and I'm getting an error telling me that it's not supported. The log looks something like this: Mar 1 16:36:25 mars logger: StartTransactionCommand Mar 1 16:36:25 ...
    Eugene LeeEugene Lee
    Mar 1, 2001 at 11:14 pm
    Mar 2, 2001 at 6:59 am
  • Hi ! Sorry for my English! I'm a beginner Linux and PostgreSQL, so I haven't much experience. I'm using Redhat Linux 7.0 Now I want to use Postgres as frontend to connect to MS SQL server on a ...
    DhninhDhninh
    Mar 30, 2001 at 2:23 pm
    Apr 2, 2001 at 5:53 pm
  • Is there any way to do this kind of query in PGSQL? SELECT count0, count1 FROM ( SELECT COUNT(*) AS count0 FROM measurement WHERE responseTime = 0 GROUP BY responseTime ), ( SELECT COUNT(*) AS count1 ...
    Steven O'TooleSteven O'Toole
    Mar 30, 2001 at 8:26 pm
    Mar 31, 2001 at 5:58 am
  • Hi! I'm back with a new problem! Having made Postgres start an run properly, I discover that I have no support for the norwegian special characters/letters (like ø,æ, or å). I.e when I try to enter a ...
    Lars ForsethLars Forseth
    Mar 30, 2001 at 2:32 pm
    Mar 30, 2001 at 6:28 pm
  • i use a "create rule on insert" in order to obtain the sum on the column montant in the column cumul. but the last record of the table is never updated. why ? DROP CREATE DROP CREATE CREATE 9606604 1 ...
    Ernest ChiarelloErnest Chiarello
    Mar 26, 2001 at 3:27 pm
    Mar 29, 2001 at 7:56 am
  • Hi! This is my little sum of what I did to get postgres to start up. First, thanks to tosi (suse-linux-e list) and Aarni Ruuhhimki (pgsql-novice list). First, from Tosi I got this little hint: "In ...
    Lars ForsethLars Forseth
    Mar 21, 2001 at 9:21 pm
    Mar 25, 2001 at 7:24 pm
  • Hello to all, I compiled postgresql with unicode support: ./configure --enable-multibyte=UNICODE later I create the DB: createDB JMdict -R UNICODE \encoding shows UNICODE so far, so good... As java ...
    Chris CzeykaChris Czeyka
    Mar 22, 2001 at 1:21 pm
    Mar 25, 2001 at 7:09 pm
  • Hi! My troubles are not over! Postgres are up and running, but I receive the following error message in pgaccess when I try to import a file into a table in postgres: "COPY "Gravtype" FROM ...
    Lars ForsethLars Forseth
    Mar 25, 2001 at 1:03 pm
    Mar 25, 2001 at 4:48 pm
  • The subject says it all really. I have a phone no. field of type VARCHAR(15) and would like to add a check that says 'only allow numbers or the space character in this field'. Can I do this with a ...
    Tom StricklandTom Strickland
    Mar 25, 2001 at 12:29 pm
    Mar 25, 2001 at 4:46 pm
  • I'm having touble increasing of the number of client connection to my database. I've tried two different ways : 1. Start w/ postgresql start -i -N 64 -B 128 2.Use configure -with-maxbackends=128 I ...
    Bill HowellBill Howell
    Mar 19, 2001 at 5:21 pm
    Mar 21, 2001 at 12:55 am
  • Hello all, I know there is a Postgres-ODBC listserv, but I have the feeling this is a blindingly obvious question and thus this is the best place to put it. I'm trying to connect to my PostgreSQL ...
    Laurel WilliamsLaurel Williams
    Mar 16, 2001 at 6:07 pm
    Mar 19, 2001 at 1:40 am
  • Hi all, I've just started learning SQL, wich is great fun. However, there's something I don't understand, wich has to do with references. Take this example: CREATE TABLE test ( id serial ); CREATE ...
    Bas van der LindenBas van der Linden
    Mar 16, 2001 at 5:55 pm
    Mar 16, 2001 at 8:02 pm
  • Hello, I've been having problems getting queries from perl to run with Pg.pm. My database connection works and the database is opened fine. However when I execute a query like "$result = $conn- ...
    Dax DuskinDax Duskin
    Mar 15, 2001 at 2:52 pm
    Mar 15, 2001 at 4:28 pm
Mar 2001
12
Group Navigation
period‹ prev | Mar 2001 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions96
posts264
users113
websitepostgresql.org
irc#postgresql

113 users for March 2001

Tom Lane: 25 posts Dax Duskin: 12 posts Brett W. McCoy: 8 posts D. Duccini: 8 posts Vijay Deval: 7 posts Bill: 6 posts Daniel A. Melo: 6 posts Lars Forseth: 6 posts Louis Bertrand: 6 posts Oliver Elphick: 6 posts Catalin CIOCOIU: 5 posts David Olbersen: 5 posts Scott Muir: 5 posts Boulat Khakimov: 4 posts Lukas Ertl: 4 posts Luke Tudor - RSG: 4 posts Mikhail malamud: 4 posts ADBAAMD: 3 posts Anthony E . Greene: 3 posts Chuck Kimber: 3 posts
show more
Archives