FAQ

PostgreSQL > pgsql-general > December 1998

Search Discussions

101 discussions - 239 posts

  • Hi, I'm using FreeBSD and PostgreSQL 6.4. I tell my advisor to try PostgreSQL, but he said:"Why PostgreSQL is better than other commercial softwares? If you could give me ten reasons, and I will give ...
    Albert ChenAlbert Chen
    Dec 17, 1998 at 9:04 am
    Dec 18, 1998 at 9:43 am
  • No. Vacuum will still exclusively lock relation. But I'll fix vacuum to unlock pg_class (when vacuuming all tables in database). And note - this will be not row level locking, but multi-version ...
    Vadim MikheevVadim Mikheev
    Dec 10, 1998 at 9:05 am
    Dec 16, 1998 at 3:00 am
  • I've BSDi 3.1 & BSDi 4.0 . I always get same error messages when I compiling postgresql 6.4. The error messages : /usr/bin/yacc -d gram.y /usr/sbin/yacc: f - maximum table size exceeded ...
    IbrahimIbrahim
    Dec 4, 1998 at 6:15 am
    Dec 5, 1998 at 12:42 pm
  • Hi, Here is a very general question: How good is PostgreSQL at hosting nearly pure text based databases ? Is it possible to search mutilple cols for the same keyword ? How well would it handle ...
    Nicholas HumfreyNicholas Humfrey
    Dec 2, 1998 at 5:48 pm
    Dec 4, 1998 at 3:33 pm
  • Hello, I'm creating a list of all my files anywhere in a 60' diameter on any possible media around me. For such purpose I'm planning to use PostgreSQL. The main table might look like : create table ...
    Jan VicherekJan Vicherek
    Dec 26, 1998 at 4:58 pm
    Dec 26, 1998 at 8:38 pm
  • Greetings, When I run the following set of statements in postgres v6.4 (built on Debian Linux): create table tmp (v1 date, v2 datetime); insert into tmp values ('06-01-1999', '06-01-1999'); select ...
    Tim WilliamsTim Williams
    Dec 17, 1998 at 5:47 pm
    Dec 30, 1998 at 11:41 am
  • Hi, I'm having real problem to get postgres 6.4.1 to run on Alpha. It compiled with only one minor problem, but when I try to do anything (createdb, or psql template1) i get the following Connection ...
    Adriaan JoubertAdriaan Joubert
    Dec 22, 1998 at 2:25 pm
    Dec 24, 1998 at 5:31 am
  • Hi, As it seems Postgres doesn't use index when the where clause contains "like" operator. It only uses it in case of "=" operator. for example : test= create table essai (nom varchar(50)); CREATE ...
    Jerome doucerainJerome doucerain
    Dec 4, 1998 at 11:14 am
    Dec 4, 1998 at 5:08 pm
  • On several occasions I've heard my father, an old cobol hack, cry that none of the current databases nor programming languages have an "88". Since he's my dad I often ignored him, but finally, some 5 ...
    Clark EvansClark Evans
    Dec 22, 1998 at 1:54 am
    Jan 7, 1999 at 2:15 pm
  • I've just setted up my PostGreSQL database on a Linux machine and it seems to work fine with the radius daemon i'm currently working on. Now I need to interface it with MSAccess to access data about ...
    Valerio SantinelliValerio Santinelli
    Dec 18, 1998 at 3:10 pm
    Dec 21, 1998 at 3:44 pm
  • See the TODO list on the support page, or see the HISTORY file in the 6.4 distribution. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a ...
    Bruce MomjianBruce Momjian
    Dec 4, 1998 at 11:13 pm
    Dec 10, 1998 at 5:32 pm
  • Hi! How can I obtain information about tables' structure and list of tables using psql.lib or Pg.pm (perl package)? Thanx. ------------------------ Paul E Mookhachov paul@pmfd.ru System administrator ...
    Paul MookhachovPaul Mookhachov
    Dec 4, 1998 at 7:19 am
    Dec 8, 1998 at 10:08 pm
  • Here's the problem: [rschutt@jin logs]$psql transfer NOTICE: SIAssignBackendId: discarding tag 2147482551 Connection to database 'transfer' failed. FATAL 1: Backend cache invalidation initialization ...
    Ryan SchuttRyan Schutt
    Dec 3, 1998 at 8:02 pm
    Dec 6, 1998 at 4:51 pm
  • Hi. When I try to use postgres 6.4 I get this error: Connection to database 'mydb' failed. Unsupported frontend protocol. I don't have the root password, nor the postgress account access. ANy ideas ...
    U253825U253825
    Dec 28, 1998 at 7:05 am
    Dec 29, 1998 at 11:59 am
  • Tamas Nyitrai wrote: [in relation to 6.3.2, where this happens: test= select * from test; name ---- abc bca cab (3 rows) test= select * from test where name like 'a%'; name ---- (0 rows)] Has anyone ...
    Oliver ElphickOliver Elphick
    Dec 13, 1998 at 1:16 am
    Dec 15, 1998 at 8:16 am
  • Hi again, I have this 3 tables: esame= select * from prestito\g id_libro|id_utente|data_prestito|visto|notifica1|notifica2|notifica3 ...
    ZioBuddaZioBudda
    Dec 4, 1998 at 6:11 pm
    Dec 4, 1998 at 11:16 pm
  • I've recently compiled and put into service Posgresql v6.4. All is working well. I am looking for information on locating, compiling, and implementing a Perl DBD or DBI for Postgresql. Can anyone ...
    Bob KrugerBob Kruger
    Dec 4, 1998 at 8:16 pm
    Dec 4, 1998 at 10:57 pm
  • Let's say you've got the following relation in a database: CREATE TABLE foo ( descr VARCHAR(32), content OID ); and you do a INSERT INTO foo (descr, content) VALUES ('obj1', ...
    JaggedJagged
    Dec 30, 1998 at 6:09 pm
    Dec 31, 1998 at 5:59 pm
  • Hi there. I have some problems with importing a large txt db into postgres ... I try to use the \copy db from xyz to import from a tabulator spaced textfile ... it takes 2-3sec then a "broken pipe" ...
    Marc EggenbergerMarc Eggenberger
    Dec 28, 1998 at 2:28 pm
    Dec 29, 1998 at 3:36 pm
  • Hi, I have an other question relative to large object. I have a field where I save images. Is there's a way as simple as pg_dump to make a backup of these objects and to restore them ? Friendly, ...
    DaroldDarold
    Dec 23, 1998 at 9:33 am
    Dec 28, 1998 at 5:02 pm
  • I'm (1) new to postgres & (2) trying to "convert" the sample db found in "The Practical SQL Handbook" Bowman, et al. to postgres. When trying to create the following table I get "parser: parse error ...
    Bill SneedBill Sneed
    Dec 8, 1998 at 2:25 pm
    Dec 24, 1998 at 2:06 pm
  • Hi all, I'm looking for a function similar to dtrunc() to return the decimal part of a float. dtrunc(12.34) returns 12, I need something that returns 34 Does anyone knows how to do this thing? Thanks ...
    Sferacarta SoftwareSferacarta Software
    Dec 15, 1998 at 4:00 pm
    Dec 21, 1998 at 1:31 pm
  • Is there a port to Windows95/98? I tried to compile using cygnus but the compilation fails because a template is missing. Then, I tried to create a template based on "generic" and "linux" but then ...
    Paulo da SilvaPaulo da Silva
    Dec 19, 1998 at 5:52 pm
    Dec 20, 1998 at 7:50 pm
  • I' m trying to perform some simple arithmetic with a field datatype, money. For example, select part_id, cost from parts; gives the id and cost in dollars... select part_id, cost+1.00 from parts; ...
    Bill SneedBill Sneed
    Dec 12, 1998 at 10:05 pm
    Dec 14, 1998 at 1:02 am
  • Hi all I am using postgres 6.3.2 and I experience problems using a union on views In short, I have the following views defined: create view vstockpart as select 'StockPart' as vpisource, pspid as ...
    Wim CeulemansWim Ceulemans
    Dec 9, 1998 at 2:17 pm
    Dec 10, 1998 at 8:05 pm
  • Now that I have a database functional, I need to allow other users to have access. Using createuser I can give other users access to the postmaster, but I need to give them access to my database as ...
    Glenn SullivanGlenn Sullivan
    Dec 8, 1998 at 6:56 pm
    Dec 8, 1998 at 9:58 pm
  • Hi, i have this query: select * from libro where id_libro_key in (select id_libro from libro_autore where id_auto re in (select id_autore from autore where ((cognome = 'King' and nome = 'Stephen') OR ...
    ZioBuddaZioBudda
    Dec 4, 1998 at 6:10 pm
    Dec 4, 1998 at 10:47 pm
  • Hi there, Is it possible to define the string type in a different way from text or varchar[]? I'm developing an ArcView application on a PostgreSQL database. But ArcView does not understand text or ...
    Maria Teresa FagaMaria Teresa Faga
    Dec 2, 1998 at 2:32 pm
    Dec 2, 1998 at 4:52 pm
  • Hey all, I have been trying to figure out how to divide a data field of type 'money'. And, I've been unsuccesful. So, I have a couple of questions to ask. When I query my database, using 'select ...
    Bob DusekBob Dusek
    Dec 1, 1998 at 7:11 pm
    Dec 2, 1998 at 1:49 pm
  • The recent report of success for NetBSD-m68k reminded me that there are a few platforms on our "supported list" which have not had reports of success for Postgres-v6.4 (or if there were reports I ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 29, 1998 at 3:08 pm
    Jan 6, 1999 at 8:18 am
  • Having a bit of a problem gettin 6.4.1 running on RH 5.1. Source went into /usr/src/pgsql and runtime into /var/lib/pgsql [RH default dir for postgresql]. Everything went without a problem until the ...
    Bill SneedBill Sneed
    Dec 26, 1998 at 10:20 pm
    Jan 1, 1999 at 3:16 pm
  • I'm working on a wrapper for libpq to fill a couple of holes, such as: o Ability to send formatting strings to a query a la printf() o Internal error logging and handling o Ability to return column ...
    Simon DrabbleSimon Drabble
    Dec 30, 1998 at 2:18 pm
    Dec 31, 1998 at 6:39 pm
  • Carl RichesCarl Riches
    Dec 29, 1998 at 6:12 pm
    Dec 29, 1998 at 6:18 pm
  • Hi, Just wondering when the result of the function PQstatus() gets updated? Can I expect it to be updated while connected even without performing any transactions/communications with the backend? I ...
    Richi PlanaRichi Plana
    Dec 29, 1998 at 3:00 pm
    Dec 29, 1998 at 5:27 pm
  • Just wondering if there is a script anywhere for cleanly shutting down the postmaster. thanks Bob -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au World Music ...
    Robert ChalmersRobert Chalmers
    Dec 29, 1998 at 2:47 am
    Dec 29, 1998 at 11:07 am
  • Here are the list of changes for 6.4.1. If your 6.4.1 pgsql/HISTORY file does not contain this at the top, you have a faulty 6.4.1 distribution. I recommend you go to ftp.postgresql.org or ...
    Bruce MomjianBruce Momjian
    Dec 25, 1998 at 2:31 am
    Dec 29, 1998 at 1:07 am
  • The 6.1 db.out has a line in it that looks like this; CREATE TABLE categories (category varchar(30)) archive = none; If I remove the " archive = none" bit, then all works ok. Excellent. bob -- ...
    Robert ChalmersRobert Chalmers
    Dec 28, 1998 at 2:18 am
    Dec 28, 1998 at 2:27 am
  • Hi, I have tried this query to check if a field is empty: SELECT * FROM t_table WHERE s_string=''; where s_string is declared as text. But this doesn't work, why? Is there's an other way to do that ? ...
    DaroldDarold
    Dec 23, 1998 at 9:26 am
    Dec 23, 1998 at 9:37 am
  • I wonder if vacuum runs as a separate process and where does it have it's lock file. I'd like to know it because everytime I try to issue a vacuum command, it says: elmu= vacuum analyze ns_log; ...
    MemphistoMemphisto
    Dec 21, 1998 at 9:40 am
    Dec 21, 1998 at 2:28 pm
  • Hi, I am currently writing an application which gathers some data from machine data files and inserts it into a postgres database. The problem is that some of these file can be quite large (eg. 2M) ...
    Lincoln SpiteriLincoln Spiteri
    Dec 21, 1998 at 9:41 am
    Dec 21, 1998 at 10:11 am
  • Hi, For a month I was working on a NS-proxy parser that moved all necessary information into a postgreSQL relation. The problem is that this app is run every midnight so supposed to be process the ...
    MemphistoMemphisto
    Dec 19, 1998 at 10:20 am
    Dec 19, 1998 at 11:44 am
  • Hi there folks, I am a new user with Linux and Postgres, and I am investigating the possibilities of using Postgres as my main dB for Data Acquisition applications over a network. I would like the ...
    Constantine ManoussakisConstantine Manoussakis
    Dec 16, 1998 at 8:38 am
    Dec 16, 1998 at 8:59 am
  • Sorry, I'm sure someone must have asked this before, but searching through my mailing lists revealed nothing. Does anyone know where RPMs of PostgreSQL 6.4 are? -- Nick Urbanik, Dept. of Electrical & ...
    Nick UrbanikNick Urbanik
    Dec 14, 1998 at 12:34 pm
    Dec 14, 1998 at 8:34 pm
  • Thank you all who responded to my last e-mail. It's wonderful to have such a responsive group of forward thinking people to work with. :) My last post was made prematurely with less thought than what ...
    Clark EvansClark Evans
    Dec 13, 1998 at 11:37 pm
    Dec 13, 1998 at 11:58 pm
  • Hello. My name is Clark Evans. I'm starting a project to create an "accounting/bookeeping" project using PostgreSQL. I am one of the founders of jos.org and became frustrated with the management of a ...
    Clark EvansClark Evans
    Dec 13, 1998 at 6:57 am
    Dec 13, 1998 at 2:33 pm
  • subscribe
    Laurent DELVAUXLaurent DELVAUX
    Dec 10, 1998 at 10:21 am
    Dec 11, 1998 at 10:47 pm
  • Hi Everybody! We develop university information system under Linux using DBMS Postgres, Linux-clients (SWI-Prolog,C), MS-Windows-clients. For analysis of running postgres-processes we need get ...
    Blashko AlexanderBlashko Alexander
    Dec 11, 1998 at 9:29 am
    Dec 11, 1998 at 4:29 pm
  • Hello, I'm running postgreSQL on BSDI-3.1 And I have two questions: 1. if i grant permissin to table to someone, then I can't do this that table before I grant permission to myself: ser= \z Database ...
    Sergei ChernevSergei Chernev
    Dec 9, 1998 at 4:04 am
    Dec 9, 1998 at 4:29 am
  • Hi again, I have this query : select prestito.*, libro.tipo,libro.id_libro from prestito,libro where prestito.id_libro = libro.id_libro_key that return me (correct!): ...
    ZioBuddaZioBudda
    Dec 4, 1998 at 6:11 pm
    Dec 4, 1998 at 6:20 pm
  • I've been testing how fast I am able to insert entries in a simple table, and I am shocked how slow postgres gets when the table gets large. My test program takes one day of syslog messages (~400k) ...
    Petter ReinholdtsenPetter Reinholdtsen
    Dec 2, 1998 at 5:33 pm
    Dec 4, 1998 at 6:06 pm
Dec 1998
123
Group Navigation
period‹ prev | Dec 1998 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions101
posts239
users107
websitepostgresql.org
irc#postgresql

107 users for December 1998

Bruce Momjian: 24 posts ZioBudda: 10 posts The Hermit Hacker: 9 posts Clark Evans: 7 posts Sferacarta Software: 7 posts Bob Dusek: 6 posts Dustin Sallings: 6 posts Vadim Mikheev: 6 posts Jackson, DeJuan: 5 posts Oliver Elphick: 5 posts Bill Sneed: 4 posts Gregory Maxwell: 4 posts Herouth Maoz: 4 posts Jan Vicherek: 4 posts Kaare Rasmussen: 4 posts Oleg Broytmann: 4 posts Thomas G. Lockhart: 4 posts Adriaan Joubert: 3 posts Carl Riches: 3 posts Chris Williams: 3 posts
show more
Archives