FAQ

Search Discussions

327 discussions - 1,067 posts

  • Thought this may be of interest to some... http://www.phpbuilder.com/columns/tim20001112.php3 Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio
    Michael ForkMichael Fork
    Nov 13, 2000 at 4:39 am
    Dec 12, 2000 at 2:31 pm
  • Sorry if this is a repost, but it appears the postgre mailing list filtered my original mail without warning. I have a bunch of questions, and I've looked through the documentation without any ...
    Joe KisloJoe Kislo
    Nov 29, 2000 at 5:01 pm
    Dec 12, 2000 at 11:00 am
  • I am trying to set up a database system where each user has his/her own database without access outside of it of any kind. This seemed simple, but I cannot figure out how to create a user who cannot ...
    Jeff DavisJeff Davis
    Nov 29, 2000 at 2:44 am
    Dec 4, 2000 at 7:47 pm
  • Is there any reason to not use Perl & DBI or the Pg.pm module? Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --------------------------------------------------------------------------- ...
    Brett W. McCoyBrett W. McCoy
    Nov 27, 2000 at 7:38 pm
    Dec 4, 2000 at 8:20 pm
  • I plan to convert a Foxpro system to client/server - hopefully using PostGreSQL (about 100 tables / 300 mb / 100 users) Firstly I heard a rumour that p-sql doesn't process queries in parellel, i.e. ...
    Martin ChantlerMartin Chantler
    Nov 30, 2000 at 2:51 pm
    Dec 1, 2000 at 4:46 am
  • Er, did anybody notice trouble when starting Postgres if a password has been set for user pgsql? On my FreeBSD 5.0-20000528-CURRENT box, psql -l (from pg_ctl) sucks down a big 28% cpu. Here is the ...
    GHGH
    Nov 26, 2000 at 9:25 pm
    Dec 9, 2000 at 8:13 pm
  • I am running with configure --with-perl make clean make cc -b elf -o ecpg preproc.o pgc.o type.o ecpg.o ecpg_keywords.o output.o keywords.o c_keywords.o ../lib/typename.o descriptor.o variable.o -lPW ...
    Dave SmithDave Smith
    Nov 21, 2000 at 1:29 pm
    Nov 21, 2000 at 9:54 pm
  • Ever since I upgraded to 6.5.2 I've had problems upgrading to the 7.x series. I'm running Red Hat 6.1 (2.2.17 kernel) on this box. Now I'm trying to upgrade to 7.0.3 via the rpm. When I tried both ...
    Rich ShepardRich Shepard
    Nov 15, 2000 at 1:39 am
    Nov 17, 2000 at 6:11 pm
  • Hello, I recently installed Redhat 7.0 and Postgres 7.0.2 on a new server... the install (of both) went better than expected, and I was able to get DBD and DBI up and running. When I copied my ...
    James HallJames Hall
    Nov 7, 2000 at 3:50 pm
    Nov 7, 2000 at 7:28 pm
  • I get the following error trying to make my backups: !2188 marauder@bofh:~$ pg_dump -h tweedledee -D ds ds_1108.sql getTypes(): SELECT failed. Explanation from backend: 'ERROR: Relation 'pg_user' ...
    Matt BeauregardMatt Beauregard
    Nov 8, 2000 at 1:39 am
    Nov 9, 2000 at 5:26 am
  • Is there a way to synchronize data between postgresql on a local machine and postgresql on a remote web server? Maybe use the TCP/IP Connection with SSH somehow? Anyone done this or have any good ...
    JoeJoe
    Nov 6, 2000 at 6:50 pm
    Nov 7, 2000 at 3:41 pm
  • The previous thread regarding stored procedures made me wonder: what is the difference between a stored procedure and a view? I understand postgres uses query rewriting for views, is there a ...
    Jeff DavisJeff Davis
    Nov 13, 2000 at 5:29 am
    Dec 11, 2000 at 4:14 pm
  • [I have looked in the archives, I just can't find anything useful in there.] I have largish table of text files (about 10K or so each), which I need to make searchable in the normal keyword search ...
    Colman ReillyColman Reilly
    Nov 9, 2000 at 4:48 pm
    Nov 13, 2000 at 7:07 pm
  • Thanks for responding, I suppose what I was really asking is if PostGreSQL works 'as good' as other databases like Oracle. The rumour I heard implied that I would have problems trying to run ...
    Martin ChantlerMartin Chantler
    Nov 30, 2000 at 4:04 pm
    Nov 30, 2000 at 9:12 pm
  • I have a web application that needs to generate a report. Said report requires a lot of calcuations so that hard coding them is a pain. I would like to set up a view does does all the apropriate ...
    Shawn everettShawn everett
    Nov 28, 2000 at 12:28 am
    Nov 28, 2000 at 10:24 pm
  • ... nevertheless I hav one :-) I have installed postgresql 7.0 on NT. I've done all the necessary cygwin and cygipc stuff but when I start up postres by entering postgres -D ../data I keep getting an ...
    Alexander JerusalemAlexander Jerusalem
    Nov 17, 2000 at 12:58 am
    Nov 17, 2000 at 7:55 pm
  • Hello ! I want to do a VACUUM ANALYSE on some tables but when i do : EDEN= VACUUM ANALYSE cvdb; ERROR: parser: parse error at or near "cvdb" But cvdb is a working table. Does someone have a idea of ...
    Mickaël JouanneMickaël Jouanne
    Nov 8, 2000 at 5:38 pm
    Nov 9, 2000 at 6:36 am
  • This is part question, part short, sad tale. Working on my database, I had a view that would lock up the machine (eats all available memory, soon goes belly-up.) Turned out to be a recursive view: ...
    Joel BurtonJoel Burton
    Nov 25, 2000 at 8:42 pm
    Nov 29, 2000 at 10:27 pm
  • I'm trying to migrate from PostgreSQL 6.3.2 under IRIX to version 7.0.2 under RedHat 7.0. I've dumped my old database with "pg_dumpall -o db.backup", but I'm having problems restoring this data to ...
    George ArmholdGeorge Armhold
    Nov 22, 2000 at 7:18 pm
    Nov 24, 2000 at 5:47 pm
  • Hi, I'am running several postmaster on different machines, accessing the same database in parallel. Is this a good idea? Do the postmaster lock each other or do they work independent? Thanks Steffen
    Steffen SchmidtSteffen Schmidt
    Nov 23, 2000 at 3:58 pm
    Nov 23, 2000 at 8:24 pm
  • however, per the below example, the union and the select distinct are not the same in postgres 7.0.2. is joe missing somehting here? or am i? thanks --e-- CREATE TABLE "has_some_dupes" ( "a_col" ...
    Edward Q. BridgesEdward Q. Bridges
    Nov 14, 2000 at 1:32 am
    Nov 14, 2000 at 4:04 pm
  • When are the 7.0.3 RPM's expected to be released? Most of my production servers use the RPM install and I would like to keep it that way, however I would also like to move up to 7.0.3 some time soon. ...
    MatthewMatthew
    Nov 13, 2000 at 5:48 pm
    Nov 14, 2000 at 7:23 am
  • When I do a vacuum analyze on a table, it tries to allocate a crazy amount of memory before it is killed by the system.. 14377 postgres 1 60 0 2070M 1376M run 0:15 6.44% postgres Yikes! A vacuum ...
    Dan MoschukDan Moschuk
    Nov 9, 2000 at 4:19 pm
    Nov 10, 2000 at 8:50 pm
  • On Oct. 30 and 31 I attended OSDN's rather grandiosely named "Open Source Database Summit" (despite what you might infer from the name, it was just a small, open-to-the-public conference). Their info ...
    Tom LaneTom Lane
    Nov 3, 2000 at 4:47 am
    Nov 8, 2000 at 1:50 am
  • Greetings, I was trying to build a full 7.1devel documentation set and noticed that my FreeBSD box didn't have sgmlspl, and I can't find it in the FreeBSD ports collection. What tool is this? -- ...
    Larry RosenmanLarry Rosenman
    Nov 28, 2000 at 10:54 am
    Nov 28, 2000 at 9:03 pm
  • I think you'd be better off coding from scratch. The backend is built on the model that it's in control and it can send off messages or bits of messages whenever it feels like. It's going to be very ...
    Tom LaneTom Lane
    Nov 14, 2000 at 4:12 pm
    Nov 21, 2000 at 3:51 pm
  • I want to find out how confused I am. ;-) I'm testing something on a Postgres 7.0.2 database. I made a small table with two columns, one serial and the other TEXT, and tried to make serveral inserts ...
    Martin A. MarquesMartin A. Marques
    Nov 8, 2000 at 1:36 pm
    Nov 10, 2000 at 4:13 pm
  • Hi, I would like to know if someone have a solution for me ... I have a table with today about 2,8 millions records. The table have good indexes, in our case on idcond, and points ! When I do : ...
    Hervé PiedvacheHervé Piedvache
    Nov 8, 2000 at 8:56 pm
    Nov 9, 2000 at 9:51 am
  • is anyone working on the port of PostgreSQL for Alpha FreeBSD ?? I have been waiting for over a year very very patiently !!! I really love my Alpha FreeBSD box and I want to use PostgreSQL on it... ...
    Nathan BoegerNathan Boeger
    Nov 3, 2000 at 11:34 pm
    Nov 8, 2000 at 1:53 am
  • Hi all, I'm using postgresql-7.0.2 on Linux RedHat 6.2 system. I need help to some question: 1. I have problem insert oid object in a table, not always, sometimes. I have the exception FastPath call ...
    Gabriel López MillánGabriel López Millán
    Nov 30, 2000 at 9:50 am
    Dec 4, 2000 at 8:19 pm
  • I have inadvertently uninstalled PostgreSQL and subsequently reinstalled it, which has rendered my existing databases inaccessible. I'd like to be able to recover them. There is no pgdump output to ...
    Hancock, David (DHANCOCK)Hancock, David (DHANCOCK)
    Nov 30, 2000 at 4:46 pm
    Nov 30, 2000 at 9:18 pm
  • Are there any caveats as to which versions PL/Perl works with? I am running PostgreSQL v7.0.2 and Perl 5.005_03, and I built postgres using the --with-perl option. I built the plperl code and copied ...
    Wade D. OberprillerWade D. Oberpriller
    Nov 13, 2000 at 3:59 pm
    Nov 24, 2000 at 8:00 pm
  • At compile time, do I have to add some flag to configure to make it compile pgaccess, because I didn't find any option for pgaccess compilation with the --help? Saludos... ;-) -- "And I'm happy, ...
    Martin A. MarquesMartin A. Marques
    Nov 20, 2000 at 9:10 pm
    Nov 24, 2000 at 3:59 pm
  • Is anybody familiar with this? http://news.excite.com:80/news/bw/001107/pa-sanchez
    Ned LillyNed Lilly
    Nov 14, 2000 at 3:26 am
    Nov 14, 2000 at 3:01 pm
  • Hello, I need help in case below. My table tipo_categoria has a primary key, called cod_categoria When I use this key as parameter for my sql script, the result of execution is a sequencial scan, but ...
    Vilson fariasVilson farias
    Nov 10, 2000 at 12:17 pm
    Nov 10, 2000 at 6:42 pm
  • Hi - I recently tried to start postmaster (7.0.2) with -B 128 -N 64 and got the "semget failed" error. Looking in the faq[1] it says I need to increase the amount allowed in the kernel. It tells me ...
    Philip HallstromPhilip Hallstrom
    Nov 10, 2000 at 2:58 am
    Nov 10, 2000 at 4:04 pm
  • NVL in postgreSQL???
    Giovanni Serrato CastilloGiovanni Serrato Castillo
    Nov 9, 2000 at 4:45 pm
    Nov 9, 2000 at 10:41 pm
  • The db schema we have need to do a cycle references. I.e., an attribute in table_1 references the key in table_2 and an attribute in table_2 references the key in table_1. However, PostgreSQL does ...
    LiminLimin
    Nov 1, 2000 at 8:40 pm
    Nov 8, 2000 at 7:47 am
  • Hello to all, I am new to the PostgreSQL world, as well as the Linux world... kind of a double whammy... Anyway, I crashed my system the other day when I did a "select *" from one of my large tables ...
    Michael Miyabara-McCaskeyMichael Miyabara-McCaskey
    Nov 6, 2000 at 5:16 am
    Nov 6, 2000 at 2:39 pm
  • I apologize if this discussion area is not intended for such a question. The title suggests that it applies, although noone else has done it. Where would I look to find contracting requirements in ...
    J. BurkeJ. Burke
    Nov 4, 2000 at 4:55 am
    Nov 5, 2000 at 7:41 pm
  • Greetings: I have so far been unsuccessful in my searches. Does someone have a very small sample of a C/C++ program to read some data out of a Postgresql database and insert a new record? Any help ...
    Mulcahy, ChrisMulcahy, Chris
    Nov 1, 2000 at 7:28 pm
    Nov 4, 2000 at 6:18 pm
  • Hi I'm Alvaro Herrera, from Chile, South America, where I study CS (mostly). I'm new to PostgreSQL and to SQL in general. That's for my introduction. Now, I'm building a database to hold customer ...
    Alvaro HerreraAlvaro Herrera
    Nov 2, 2000 at 8:41 pm
    Nov 2, 2000 at 9:41 pm
  • Hi! Just a question concerning large objects. I want to make a image catalogue. I will use postgresql, perl and php. What are the advantages of having the images in the database instead of having ...
    Evelio MartínezEvelio Martínez
    Nov 2, 2000 at 9:23 am
    Nov 2, 2000 at 11:46 am
  • PG seems to be choosing a sub-optimal query plan. It's doing a sequential scan of a 120000-tuple table, instead of an index scan for the 16 matching rows. Running PG 7.0.2: fastfacts= vacuum analyze ...
    Chris JonesChris Jones
    Nov 30, 2000 at 11:20 pm
    Dec 4, 2000 at 11:23 pm
  • I want to write some triggers in Perl. I have searched www.postgresql.org and Bruce's book but cant find out what I need to do to install perl. I've run 'createlang' but it complains about not being ...
    Steve HeavenSteve Heaven
    Nov 29, 2000 at 4:53 pm
    Dec 4, 2000 at 7:47 pm
  • Hi, I'm new to PostgreSQL and have been tasked with determining the cause of hung processes on FreeBSD after the frontend app dies. Eventually we run out of connections when hung processes = ...
    Schmidt, PeterSchmidt, Peter
    Nov 23, 2000 at 5:12 pm
    Nov 27, 2000 at 11:52 pm
  • Hi there. I'm trying to use triggers for the first time, but I'm having some problems. Here's my SQL: create function set_counter() returns opaque as 'BEGIN new.count := 0; RETURN new; END;' language ...
    Nelio Alves Pereira FilhoNelio Alves Pereira Filho
    Nov 27, 2000 at 4:22 pm
    Nov 27, 2000 at 5:59 pm
  • Hello, Is anyone using the PL/Perl language in PostgreSQL on a Solaris machine? If so, how did you get it to work? I am having difficulty getting it to run, I believe I am having problems with the ...
    Wade D. OberprillerWade D. Oberpriller
    Nov 20, 2000 at 3:57 pm
    Nov 27, 2000 at 4:14 pm
  • Guys, hello. Here is a problem. -- -- Creating 2 new functions and new type -- BEGIN; CREATE FUNCTION enum_week_in (opaque) RETURNS int2 AS ' DECLARE invalue ALIAS for $1; BEGIN IF invalue='''' OR ...
    Max FoninMax Fonin
    Nov 23, 2000 at 3:51 pm
    Nov 24, 2000 at 4:37 pm
  • This's great. I have tested Postgres and MySQL with the benchmark shipped with mysql and (of course) MySQL out perform Postgres. I wonder does anyone know where can we download the ANSI SQL benchmark ...
    Limin LiuLimin Liu
    Nov 21, 2000 at 3:05 am
    Nov 24, 2000 at 1:19 pm
Group Navigation
period‹ prev | Nov 2000 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions327
posts1,067
users311
websitepostgresql.org
irc#postgresql

311 users for November 2000

Tom Lane: 154 posts Peter Eisentraut: 33 posts Stephan Szabo: 23 posts Lamar Owen: 22 posts Igor' Robul': 18 posts Adam Lang: 16 posts GH: 15 posts Martin A. Marques: 15 posts The Hermit Hacker: 13 posts Nelio Alves Pereira Filho: 12 posts Poul L. Christiansen: 11 posts Rich Shepard: 11 posts Wade D. Oberpriller: 11 posts Bruce Momjian: 10 posts Alfred Perlstein: 9 posts Gordan Bobic: 9 posts Philip Hallstrom: 9 posts Robert D. Nelson: 9 posts Sandeep Joshi: 9 posts Steve Wolfe: 9 posts
show more
Archives