FAQ

PostgreSQL > pgsql-general > November 1998

Search Discussions

130 discussions - 266 posts

  • Here is something I totally don't understand. And i need this one to be fixed... Here is a transcript of a session, with a test-table containing only one oid-column.... [jeroen@rulgfu sql]$ psql -f ...
    Jeroen SchaapJeroen Schaap
    Nov 12, 1998 at 1:59 pm
    Nov 13, 1998 at 12:08 pm
  • Hello, I've installed postgresql-v6.4 on BSDI-3.1 But, there are two problems with PL/pgSQL: First: I have to install plpgsql language on every database, I wonder, if I can install it for everyone. ...
    Sergei ChernevSergei Chernev
    Nov 11, 1998 at 3:12 pm
    Dec 13, 1998 at 5:24 am
  • Oracle has a facility for loading in massive data files, sqlload I think is the name. I'd like to load some big data into PostgreSQL 6.4 for testing purposes. Is there a way built in or would a perl ...
    John HollandJohn Holland
    Nov 25, 1998 at 2:45 pm
    Nov 29, 1998 at 5:05 pm
  • Hi A 'contains' search in postgreSQL is: select * from tablex where name = '%test%'; When I want exactly the same but case insensitive, how do I do that? By searching through the mail archive I came ...
    Wim CeulemansWim Ceulemans
    Nov 9, 1998 at 9:30 am
    Nov 10, 1998 at 4:55 am
  • Hi, I installed postgres v3.4 but cannot connect to it, as I always get user authentication failures. I've already wittled my pg_hba.conf down to host all 127.0.0.1 255.255.255.255 trust host all ...
    Adriaan JoubertAdriaan Joubert
    Nov 6, 1998 at 12:01 pm
    Nov 7, 1998 at 7:36 am
  • The following psql session terminates with a backend problem. Does somebody has an idea what went wrong? Can't use `group by' in views, perhaps? ...
    Ulf MehligUlf Mehlig
    Nov 4, 1998 at 10:44 pm
    Nov 30, 1998 at 5:44 pm
  • I'm working on integrating Large Objects into a database. I'm courious about a couple of different things. 1) Can you view large objects from the psql interface? 2) Is there a way to reference the ...
    David GiffinDavid Giffin
    Nov 19, 1998 at 10:36 pm
    Nov 22, 1998 at 6:01 am
  • Dear All, For those of you who don't want to wade through the details, here's the question: "How do I get the date portion of a datetime field for ALL ENTRIES in a table regardless of whether the ...
    Stuart RisonStuart Rison
    Nov 26, 1998 at 4:22 pm
    Nov 29, 1998 at 10:32 am
  • Does anyone have exeperiences with AIX4.2/postgreSQL 6.3.2? Now I'm unable to compile it I've got the following error message: bash-2.01$ gmake Making postgres.imp ./backend/port/aix/mkldexport.sh ...
    MemphistoMemphisto
    Nov 9, 1998 at 10:47 am
    Nov 10, 1998 at 2:35 pm
  • Hi all, i've got this annoying problem : if you create a table with an uppercase name, postgres transforms it in lower case. After that, if you try to retrieve the primary keys for this table ( still ...
    Charles-Edouard RuaultCharles-Edouard Ruault
    Nov 17, 1998 at 8:25 pm
    Nov 18, 1998 at 8:48 am
  • how many levels of rollbacks can postgres handle? Is it set to only rollback changes for the last transaction done on a database, or can you specify how many transactions to rollback to. lorenzo
    Lorenzo HuertaLorenzo Huerta
    Nov 10, 1998 at 11:36 pm
    Nov 12, 1998 at 7:32 pm
  • Hi Everybody, i had many problems getting postgres 6.4 to work properly under irix 6.5.1. - destroydb fails, pg_dump does not work and other things seem to be broken. I have tried to compile with ...
    Fuad AbdallahFuad Abdallah
    Nov 10, 1998 at 9:56 am
    Nov 11, 1998 at 8:22 am
  • Hey there, I've got a more simplified version of a previous question I asked: does anyone know how to take a value of type timespan and convert it into a single float8 or int value? I'm really having ...
    Bob DusekBob Dusek
    Nov 6, 1998 at 2:37 am
    Nov 6, 1998 at 9:03 pm
  • A few weeks ago there was lots of messages about a port to WinNT of postgres 6.4. Is this still the case and will it be available for download? If not..is there any time frame when it will be. Thanks ...
    Chris WilliamsChris Williams
    Nov 3, 1998 at 1:28 pm
    Nov 6, 1998 at 3:15 am
  • We plan to release PostgreSQL, version 6.4, within the next week. An announcement will be made as soon as it is ready. You can see the changes for this release on our web site at the bottom of the ...
    Bruce MomjianBruce Momjian
    Nov 3, 1998 at 12:26 am
    Nov 3, 1998 at 1:07 pm
  • pg_dump seems to be getting a little confused on ACLs, look at this: REVOKE ALL on "cat" from PUBLIC; GRANT ALL on "nobody" to "nobody"; For everything that has any differing priveleges, it does the ...
    Dustin SallingsDustin Sallings
    Nov 9, 1998 at 7:24 am
    Dec 12, 1998 at 9:01 pm
  • Hello, I've kind of run into a wall, just now, and I don't know if I can climb it with Postgres. In order to fully explain my problem, I've got to actually go into detail about my database setup... ...
    Bob DusekBob Dusek
    Nov 24, 1998 at 9:59 pm
    Nov 25, 1998 at 11:02 pm
  • I'm in the process of loading a database on a virtual server. Because I do not have root privileges (technically it is a shared machine), I am encountering all sorts of hiccups. Trying the copy ...
    Gilley, Charles H.Gilley, Charles H.
    Nov 20, 1998 at 1:59 pm
    Nov 20, 1998 at 6:37 pm
  • First off, I would like to take this opportunity to thank everyone who worked on the new postgres v6.4. I have it up and working here, and most all appears well. I do have two questions. Firstly, I ...
    Bob KrugerBob Kruger
    Nov 9, 1998 at 4:03 pm
    Nov 9, 1998 at 9:58 pm
  • Hello again, I am using the age() function to determine the average shelf-life of inventory items that are being stored in my database. And, I think the function is definitely worth having around. It ...
    Bob DusekBob Dusek
    Nov 5, 1998 at 11:49 am
    Nov 5, 1998 at 10:55 pm
  • Greetings, great thanks to Oleg Broytmann for his useful advice, I've understood the proper fromat for input data at last and the problem with copying DB from file was successfully solved. Well, I ...
    Dmitry Iv PopovDmitry Iv Popov
    Nov 27, 1998 at 10:55 pm
    Nov 30, 1998 at 7:29 am
  • unsubscribe
    Jiang FengJiang Feng
    Nov 14, 1998 at 12:38 am
    Nov 24, 1998 at 1:15 pm
  • I have tried to create a min(oid) aggregate, but when I use it, I get the message `ERROR: fmgr_info: function 108994: cache lookup failed'. What does this mean, please? I created it thus: create ...
    Oliver ElphickOliver Elphick
    Nov 23, 1998 at 2:18 pm
    Nov 24, 1998 at 6:56 am
  • Morning... I've just merged the User Gallery and Third Party software into one, as well as begun work on rebuilding the interfaces to it. The end goal is to get it such that someone who submit'd an ...
    The Hermit HackerThe Hermit Hacker
    Nov 23, 1998 at 3:06 am
    Nov 24, 1998 at 3:07 am
  • Greetings, would you be so kind to give me an advice: how can I connect/convert Visual FoxPro database to PostgreSQL and read data from it from my Java applet (i.e. is there JDBC public driver)? ...
    Dmitry Iv PopovDmitry Iv Popov
    Nov 22, 1998 at 10:25 pm
    Nov 23, 1998 at 10:07 pm
  • Hello, I'm currently looking for any documentation anyone on the list knows of that shows the performance of Linux on any Intel hardware (preferrably a dual PII) for serving web/database services. I ...
    Matthew HixsonMatthew Hixson
    Nov 19, 1998 at 9:26 am
    Nov 19, 1998 at 6:51 pm
  • Hello everyone, I apologize if this seems elementary to you, but I just spent quite a bit of time searching the archives and the documentation for a way to do this. I may have been looking wrong, but ...
    Bob DusekBob Dusek
    Nov 5, 1998 at 3:33 am
    Nov 5, 1998 at 11:52 am
  • Hi, I'd like to know if there's an operator that converts from float8 to text. It should be because PGSQL can print a float8 number. ...
    MemphistoMemphisto
    Nov 2, 1998 at 3:27 pm
    Nov 3, 1998 at 11:23 am
  • Hi, I am running Postgres 6.3.2 on Caldera Linux 2.0.35. There are a few scripts written in Perl using Pg.pm which tune up the database nightly. They've been running for more than three months. ...
    Anand SureliaAnand Surelia
    Nov 30, 1998 at 7:49 pm
    Dec 1, 1998 at 1:40 pm
  • Greetings, great thanks to Paul Ramsey, Mr. Ramaswamy, Ulf Mehlig and Peter Mount for their useful advices! Well, now I have the following problem: base exported from VFoxPro (with delimiters '|') ...
    Dmitry Iv PopovDmitry Iv Popov
    Nov 26, 1998 at 7:48 pm
    Nov 27, 1998 at 1:07 pm
  • Okay, trying to turn on web access to my table. Pending some changes to the pg_hba.conf file, I have the following on my tables: ...
    Gilley, Charles H.Gilley, Charles H.
    Nov 25, 1998 at 9:23 pm
    Nov 26, 1998 at 9:47 am
  • Hi, The November 16, 1998 issue of "Information Week" mentions Postgres in an article on page 186 called "Red Hat Linux: Almost Free, And Full of Functions". Quoting from the article... "Red Hat even ...
    Byron NikolaidisByron Nikolaidis
    Nov 25, 1998 at 4:39 pm
    Nov 25, 1998 at 5:41 pm
  • I am trying to add prices together using either the monetary type or float4 type. Monetary doesn't seem to add, and float4 renders results out to 7 decimal places. Also, float4 doesn't display prices ...
    Rob ClevelandRob Cleveland
    Nov 20, 1998 at 8:06 pm
    Nov 21, 1998 at 1:31 am
  • Hi, I have been using EPCG since 6.3.2 with no problems. I am extending some code written in my 6.3.2 days which is now targeting a newly built 6.4. I now have a problem connecting to my database. ...
    Lincoln SpiteriLincoln Spiteri
    Nov 19, 1998 at 2:36 pm
    Nov 19, 1998 at 3:00 pm
  • i've just gotten around to upgrading to 6.4 on a couple of FreeBSD (2.2.7) servers, and i'm having problems creating databases in alternate locations. basically, here's what i did: 1) dumped the data ...
    Jeff HoffmannJeff Hoffmann
    Nov 13, 1998 at 5:49 pm
    Nov 13, 1998 at 7:21 pm
  • (copying to GENERAL because that's where it seems to belong) Let's clarify the terms first: The only STORAGE METHOD used by postgres is a regular file or a set of files. Objects are stored and ...
    Gene Selkov Jr.Gene Selkov Jr.
    Nov 11, 1998 at 4:55 pm
    Nov 12, 1998 at 8:21 am
  • -------------------------------------------------------------------------------- Sebestyén Zoltán AKA Memphisto It all seems so stupid, it makes me want to give up. szoli@netvisor.hu But why should I ...
    MemphistoMemphisto
    Nov 11, 1998 at 3:25 pm
    Nov 11, 1998 at 4:33 pm
  • I have the following problem: A Netscape Enterprise web server is running on an AIX where I installed a PostgreSQL DBMS. The web server is running on 'wwwin' account and it's cgis must have access to ...
    MemphistoMemphisto
    Nov 9, 1998 at 2:56 pm
    Nov 9, 1998 at 3:23 pm
  • Hi, first of all i must say that i have just started reading this list so please excuse if am off topic. I have just compiles postgres-6.4 under irix 6.5.1 with the SGI cc v7.2.1 and everything seems ...
    Fuad AbdallahFuad Abdallah
    Nov 9, 1998 at 2:25 pm
    Nov 9, 1998 at 3:19 pm
  • Is there any facility to convert "Epoch time <- DATE" as that would be rather useful..... James (james@linuxrocks.co.uk) Vortex Internet My Windows unders~1 long filena~1, and yours?
    A James LewisA James Lewis
    Nov 5, 1998 at 6:29 pm
    Nov 5, 1998 at 7:25 pm
  • Hi, I've got this little problem: I've got two relations: groups(name text); -- This one contains the name of usergroups; users (username text, groupid oid, constraint grid primary key(username)); -- ...
    MemphistoMemphisto
    Nov 5, 1998 at 1:01 pm
    Nov 5, 1998 at 6:33 pm
  • After 5 intense months of development, the PostgreSQL Global Development Group is pleased to announce the release of v6.4, a much improved release of the popular PostgreSQL ORDBMS. As always, there ...
    The Hermit HackerThe Hermit Hacker
    Nov 5, 1998 at 3:08 am
    Nov 5, 1998 at 1:46 pm
  • Is there any way to enter a large object (Binary) into a database using psql... or any other tool I can run from a shell script... Ideally I need to be able to take stdin and put it in a particular ...
    A James LewisA James Lewis
    Nov 4, 1998 at 2:46 am
    Nov 4, 1998 at 6:59 am
  • Does Postgres support images or binary files in a database? Is this what the large objects are for? chg
    Gilley, Charles H.Gilley, Charles H.
    Nov 3, 1998 at 1:53 pm
    Nov 4, 1998 at 6:47 am
  • I just tried to upgrade a production server to 6.4 today. I do a psql -e template1 < dump psql complains about the query being too long and eventually segfaults. I reloaded 6.3.2 and it works find. I ...
    Gregory MaxwellGregory Maxwell
    Nov 30, 1998 at 8:02 pm
    Nov 30, 1998 at 8:02 pm
  • The Hermit HackerThe Hermit Hacker
    Nov 30, 1998 at 3:10 pm
    Nov 30, 1998 at 3:10 pm
  • OK, after the armaggedon I was talking about in my previous post I managed to make a clean reinstallation (moved the data dirs, reinstalled postgres, imported back the data dirs) and now things are ...
    Fabrizio ErminiFabrizio Ermini
    Nov 30, 1998 at 1:57 pm
    Nov 30, 1998 at 1:57 pm
  • Excuse me the hype - It seems that ALL my postgres site went down and I'm not able to make it work again!!! I've 6.3.2 here, on a 2.0.31 Slackware Linux box - always worked fine. Today a query ...
    F ErminiF Ermini
    Nov 30, 1998 at 12:32 pm
    Nov 30, 1998 at 12:32 pm
  • unsubscribe pgsql-general-digest subscribe pgsql-general
    Colin SmithColin Smith
    Nov 28, 1998 at 9:50 pm
    Nov 28, 1998 at 9:50 pm
  • -----BEGIN PGP SIGNED MESSAGE----- I'm working with a PHP-based application that is using PostgreSQL in the background. One of the tables in the application has been used for double-duty which is ...
    Roland RobertsRoland Roberts
    Nov 27, 1998 at 10:34 pm
    Nov 27, 1998 at 10:34 pm
Nov 1998
123
Group Navigation
period‹ prev | Nov 1998 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions130
posts266
users117
websitepostgresql.org
irc#postgresql

117 users for November 1998

Bruce Momjian: 12 posts Memphisto: 12 posts The Hermit Hacker: 11 posts Dustin Sallings: 10 posts Bob Dusek: 9 posts Herouth Maoz: 9 posts Ulf Mehlig: 9 posts 송기원: 7 posts A James Lewis: 7 posts Jeroen Schaap: 7 posts Peter T Mount: 7 posts Gilley, Charles H.: 5 posts Jeff Hoffmann: 5 posts Anatoly K. Lasareff: 4 posts Constantin Teodorescu: 4 posts Jackson, DeJuan: 4 posts Oleg Broytmann: 4 posts Oliver Elphick: 4 posts Postgres DBA: 4 posts Sergei Chernev: 4 posts
show more
Archives