FAQ

PostgreSQL > pgsql-general > October 1999

Search Discussions

183 discussions - 622 posts

  • You make a good point about available admin and other facilities etc. I am interested in some of the forum functionalities that seem to be "off the shelf" with Mysql but I have not done my homework ...
    Scott PerkinsScott Perkins
    Oct 2, 1999 at 9:57 am
    Oct 7, 1999 at 2:41 pm
  • Hello, after installation of postgresql 6.4.2 on my Freebsd machine I can not create a database bash-2.03$ createdb mydb ld.so failed: Can't find shared library "libpq.so.2.0" createdb: database ...
    Carsten HuettlCarsten Huettl
    Oct 14, 1999 at 9:58 pm
    Oct 26, 1999 at 2:00 am
  • Hi, I've gone through the mailing list archives and the documentation to search on this topic, and amazingly there is almost no signs of stored procedure discussions anywhere. Once a while a person ...
    Yin-So ChenYin-So Chen
    Oct 10, 1999 at 7:42 am
    Jan 18, 2000 at 2:42 pm
  • I need to write a function to return the first of december of the year previous to the current year. Part of my problem is I'm not sure how to escape quotes in function definitions. I am looking at ...
    Moray McConnachieMoray McConnachie
    Oct 15, 1999 at 1:55 pm
    Oct 22, 1999 at 4:57 pm
  • ---------- From: Scott Perkins[SMTP:2scott@bellsouth.net] Sent: Sunday, October 03, 1999 8:26 PM To: mysql@lists.mysql.com; pgsql-general@postgresql.org; php3@lists.php.net Subject: Mysql vs ...
    Joe DevlinJoe Devlin
    Oct 4, 1999 at 4:18 pm
    Oct 4, 1999 at 4:58 pm
  • Hi ! I found some errors in pgsql. 1. ---- # ./configure --with-template=solaris_sparc_gcc --enable-hba --with-perl loading cache ./config.cache checking host system type... sparc-sun-solaris2.5.1 ...
    System AdministratorSystem Administrator
    Oct 24, 1999 at 11:21 am
    Oct 25, 1999 at 4:07 pm
  • I have just downloaded the Solid Embedded Engine database from www.solidtech.com. Installing Solid was a breeze - a single file to untar, two commands to run (create initial database, start database ...
    Guan YangGuan Yang
    Oct 18, 1999 at 10:41 am
    Oct 21, 1999 at 10:27 pm
  • Right now any user on the local machine can log on as postgres to the template1 database. I don't like that, so I wish to turn on password checking. OK so I edit pg_hba.conf and put: local all ...
    Lincoln YeohLincoln Yeoh
    Oct 13, 1999 at 6:53 am
    Oct 14, 1999 at 6:50 pm
  • Hello everyone, I would just like to know if the Foreign key constraint feature should be a one of a near release... Any idea? Thanks
    Frederic BoucherFrederic Boucher
    Oct 5, 1999 at 10:25 pm
    Oct 27, 1999 at 7:40 pm
  • Hi I am running a process that does a fair number of selects and updates but nothing too complex. I have the postmaster starting like such: /usr/bin/postmaster -o "-F -S 10240" -d 1 -N 128 -B 256 ...
    Michael SimmsMichael Simms
    Oct 5, 1999 at 12:04 am
    Oct 25, 1999 at 1:16 pm
  • Hi, I am in need of a great SQL reference that is readable by a beginner but is also comprehensive, any recommendations? Do you think O'Reilly is best? I have seen others recommended? I have pretty ...
    John HendersonJohn Henderson
    Oct 29, 1999 at 1:19 am
    Oct 30, 1999 at 5:58 pm
  • What are the plans/timescales for a MS Windows postgreSQL server? Mike Brickman RADical Solutions e-mail: mfb@radical-solutions.co.uk
    Mike BrickmanMike Brickman
    Oct 26, 1999 at 8:00 am
    Oct 27, 1999 at 6:15 pm
  • Hi, I'm trying to backup a database using pg_dump, but whenever I try I get an error telling me I am really hosed. The template1 database works, psql works fine, the database is live and working just ...
    Nikos MouatNikos Mouat
    Oct 6, 1999 at 5:38 am
    Oct 12, 1999 at 12:32 am
  • I posted this question before and got no good responses. I'm posting it again out of pure desperation. I've got a Postgres 6.5.1 server running on a RedHat (i386) 5.2 box. PostgreSQL was compiled ...
    Doran L. BartonDoran L. Barton
    Oct 8, 1999 at 2:58 pm
    Oct 9, 1999 at 2:50 am
  • Hi All, I have a table of questions to be displayed to the user. Table: questions question_id SERIAL page int order int question varchar(100) answers text The field order is how the questions are ...
    Shawn T. WalkerShawn T. Walker
    Oct 27, 1999 at 5:31 pm
    Nov 2, 1999 at 9:53 am
  • Hi, I sent out the forwarded message below last Sunday, and have received no responses. Now I realize that this list operates on a volunteer basis and that everyone is busy, so I am in no way ...
    Frank MandarinoFrank Mandarino
    Oct 6, 1999 at 1:30 pm
    Oct 9, 1999 at 4:19 am
  • Hi All. I need to convert MS access database into PostgreSQL. Does anybody has an experience of this? Can you share with this experience? Thank you in advance. Sincerely yours, Yury. ...
    Yury DonYury Don
    Oct 15, 1999 at 6:37 am
    Feb 12, 2000 at 2:40 am
  • Hello, I've heard that the last version of PostgreSQL which i think is 6.5.2 allow to make a search in a attribute as a plain text search. How can i make that ? -- Edouard DESSIOUX Proverbe chien : ...
    Edouard DESSIOUXEdouard DESSIOUX
    Oct 25, 1999 at 2:38 pm
    Oct 26, 1999 at 9:33 am
  • This has got to be easy but I am having a hard time finding the right docs. What I want to do is analogous to: UPDATE website SET content='contents of a big ass file that I dont want to type on the ...
    Jason C. WellsJason C. Wells
    Oct 23, 1999 at 11:59 pm
    Oct 25, 1999 at 1:40 am
  • Hello, Similar to other questions I've seen posed in the last day or so, apologies if this exact question has been asked, I don't think it has. I want to restrict access to a set of databases to ...
    Mark JewissMark Jewiss
    Oct 14, 1999 at 2:50 pm
    Oct 15, 1999 at 9:00 am
  • hi, i seem to be experienceing a problem where after updating an existing pl/pgsql function the backend crashes. the function code is ok, if i restart the backend and then vcaccum it usually will ...
    Paul KellyPaul Kelly
    Oct 12, 1999 at 9:11 am
    Oct 13, 1999 at 1:46 pm
  • hi, this is kind of emergent! we are in the process of decision making. Is there an true64 on alpha port? thanks in advance!!!!!! amy Get Your Private, Free Email at http://www.hotmail.com
    Amy chengAmy cheng
    Oct 1, 1999 at 7:58 pm
    Oct 5, 1999 at 8:46 am
  • Manuel KronManuel Kron
    Oct 3, 1999 at 4:35 pm
    Oct 31, 1999 at 10:46 am
  • I'm relatively new to Postgres. I'd like some help setting up a BLOB (binary large object) field to hold images, and more importantly, inserting data (images) into it. We're using version 6.5.1. I ...
    David LanierDavid Lanier
    Oct 14, 1999 at 3:14 pm
    Oct 14, 1999 at 4:31 pm
  • I've got a fairly good size database that has in one table around 50,000 records in it. I'm using a perl script that is located on **another** machine in the same network to access the DB with. Once ...
    Andy LewisAndy Lewis
    Oct 15, 1999 at 2:52 pm
    Oct 18, 1999 at 1:42 pm
  • What is the best way to import into a PostgreSQL database data from a Microsoft Access database? Should I export the data to a pipe or comma delimited file and then import? *But how can I do that* ? ...
    PostgreSQLPostgreSQL
    Oct 1, 1999 at 9:41 pm
    Oct 15, 1999 at 5:03 pm
  • Dear all, mydb= create table rtext (rtext varchar(10)); CREATE mydb= insert into rtext values ('hello'); INSERT 17681 1 What do "17681" and "1" mean? Could someone help me to understand this please? ...
    Chairudin Sentosa HarjoChairudin Sentosa Harjo
    Oct 14, 1999 at 2:14 am
    Oct 14, 1999 at 9:52 am
  • install unix Bruce, I changed URL to http://www.freebsd.org/~kevlo/postgres/portNT.html Please update FAQ, thanks. I also update my page, porting 6.5.2 to NT. BTW, I will update my Chinese page soon. ...
    Kevin LoKevin Lo
    Oct 1, 1999 at 9:54 am
    Oct 2, 1999 at 2:04 pm
  • Hello, I have set up a postgres installation on a freeBSD box and am now ready to take the next steps. Where can I find some Webpages with postgres applications or sample. How do I create a "user ...
    Carsten HuettlCarsten Huettl
    Oct 29, 1999 at 1:59 am
    Nov 25, 1999 at 8:22 am
  • Hallo, You can have a look at http://www.simtax.ca/acc where you can download a working accounting program written by a friend of mine (aus Bayern). The docs are lacking (my fault, actually) but we ...
    Thomas GoodThomas Good
    Oct 29, 1999 at 1:15 pm
    Oct 31, 1999 at 1:18 pm
  • hi, I've been playing with pgsql for a few days now and am getting the hang of it. I just did a loop that inserts a few thousand records into a table. I did a statement, prepare, execute; it worked ...
    Jason C. LeachJason C. Leach
    Oct 29, 1999 at 7:51 am
    Oct 30, 1999 at 9:59 am
  • Hello, How could i know the name of all the table in my database and, if possible, their prototype. I would like a SQL command if possible -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ...
    Edouard DESSIOUXEdouard DESSIOUX
    Oct 28, 1999 at 8:09 am
    Oct 28, 1999 at 11:30 am
  • Hi all, I need help in inserting a value from sequence. My code goes like this (from Java). I do face a syntax level problem. statement.execute("insert into T_name (id) values (" + nextval('s_name') ...
    Soundar rajanSoundar rajan
    Oct 27, 1999 at 2:32 pm
    Oct 27, 1999 at 3:15 pm
  • Greetings ! I got the above error [see subject] when I attempted to "initdb". What's wrong and how do I fix it ? Appreciatively, Courtney 
    Courtney ThomasCourtney Thomas
    Oct 26, 1999 at 2:27 pm
    Oct 26, 1999 at 6:07 pm
  • hi, there, I'm using: create table test ( proposetime datetime not null default now(), ) then, I find that I need to make the time uniform through the transaction. Is there a way to use ...
    Amy chengAmy cheng
    Oct 25, 1999 at 8:06 pm
    Oct 26, 1999 at 3:49 pm
  • Hi all, I created two tables with CIDR and inet data values separately. I was not able to insert values into it. When I tries to do insert into ip values (10.20.30.40); the error I get time and again ...
    Soundar rajanSoundar rajan
    Oct 21, 1999 at 7:13 pm
    Oct 21, 1999 at 7:41 pm
  • Hi, I am using postgresql under linux. Now that I need to build up the jdbc driver for postgresql, when I make under the directory /src/interfaces/jdbc.. I get an error stating '(u' unexpected ...
    Soundar rajanSoundar rajan
    Oct 15, 1999 at 7:36 pm
    Oct 19, 1999 at 7:50 pm
  • ----- Original Message ----- From: Nikolay Mijaylov To: pgsql-general@postgreSQL.org Sent: 12 Октомври 1999 г. 19:27 Subject: Indexes?!?!? Hi all I making a project (Free EMail:) with a table that ...
    Nikolay MijaylovNikolay Mijaylov
    Oct 13, 1999 at 6:39 am
    Oct 13, 1999 at 7:35 am
  • I have been told on the Novice list that in order to start Postgres for an Internet connection, it needs to have the -i flag set. However, following the documentation, for RedHat automatic startups, ...
    Duncan KinderDuncan Kinder
    Oct 12, 1999 at 4:07 pm
    Oct 13, 1999 at 4:08 am
  • Hi all! I found strange files in my database directory. ls /usr/local/pgsql/base/isrts/pg_psort.1922.* -l -rw------- 1 postgres postgres 564108288 Oct 1 17:37 ...
    Natalya S. MakushinaNatalya S. Makushina
    Oct 7, 1999 at 8:15 am
    Oct 8, 1999 at 6:01 am
  • I have two identical tables -- section and temp_section. I use the section table for keeping original values and temp_section for editing. How do I copy the values from temp_section to section? =====
    Omega WeaponOmega Weapon
    Oct 6, 1999 at 2:33 am
    Oct 6, 1999 at 6:27 am
  • If from the psql command line I use select current_timestamp it shows like this: 1999-10-01 14:30:53-05 However if I insert into a datetime field, when I do a select it formats it like so: Sun Oct 03 ...
    Kevin HeflinKevin Heflin
    Oct 1, 1999 at 7:38 pm
    Oct 4, 1999 at 4:19 pm
  • Hi. I have downloaded and gunziped the 6.5.2 patch. It will not tar xvf. What do I do with it? Thanks in advance. Regards, Duncan C. Kinder dckinder@mountain.net
    Duncan KinderDuncan Kinder
    Oct 3, 1999 at 7:30 pm
    Oct 4, 1999 at 12:21 am
  • Hello, I've installed postgresql 6.5.1 Everthing went fine, till I tried to run initdb It says that it can't parse template1 Can anyone help me with this problem? Thanks, Bas van der Tol Delft, The ...
    S. van der TolS. van der Tol
    Oct 28, 1999 at 6:01 pm
    Nov 4, 1999 at 7:14 pm
  • I am in the process of writing a book about PostgreSQL for Addison, Wesley to be published in 2000. The book is tentatively titled, "PostgreSQL: Introduction and Concepts." The book is on our web ...
    Bruce MomjianBruce Momjian
    Oct 26, 1999 at 5:52 pm
    Oct 28, 1999 at 2:07 pm
  • Since I have not got any reply I try GENERAL list. Regards, Andrzej Mazurkiewicz
    Andrzej MazurkiewiczAndrzej Mazurkiewicz
    Oct 27, 1999 at 12:50 pm
    Oct 27, 1999 at 4:09 pm
  • Hi all, How do I select max(oid) from table; I'm able to to select max(fieldname) from tablename; but not max(oid). Any help be appreciated.
    Soundar rajanSoundar rajan
    Oct 22, 1999 at 7:38 pm
    Oct 26, 1999 at 4:12 am
  • Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a ...
    Soundar rajanSoundar rajan
    Oct 20, 1999 at 9:09 pm
    Oct 20, 1999 at 9:43 pm
  • I have seen similar problems in the archive, however nothing that can answer my problem. I have completely removed all previous installs of Postgresql. I have kill the postmaster process. I have ...
    Bruce, Chris A (Chris)** CTR **Bruce, Chris A (Chris)** CTR **
    Oct 19, 1999 at 4:28 pm
    Oct 19, 1999 at 5:06 pm
  • Hi, I know it's not a PHP3 mailinglist but the question is somewhat related to pgsql. I would like to know what's the problem with following line: $dbConn = pg_Connect( " host=$host user=$user ...
    Sebestyen ZoltanSebestyen Zoltan
    Oct 15, 1999 at 2:52 pm
    Oct 18, 1999 at 8:16 am
Oct 1999
1234
Group Navigation
period‹ prev | Oct 1999 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions183
posts622
users217
websitepostgresql.org
irc#postgresql

217 users for October 1999

Bruce Momjian: 41 posts Aaron J. Seigo: 17 posts Amy cheng: 16 posts Soundar rajan: 16 posts The Hermit Hacker: 16 posts Joe Devlin: 14 posts Lincoln Yeoh: 14 posts Carsten Huettl: 12 posts Doran L. Barton: 12 posts Michael Widenius: 12 posts Charles Tassell: 10 posts Gene Selkov, Jr.: 10 posts Scott Perkins: 10 posts Yin-So Chen: 10 posts Greg: 9 posts Duncan Kinder: 9 posts Mike Mascari: 9 posts Nicolas Huillard: 8 posts Bob Kline: 7 posts Herouth Maoz: 7 posts
show more
Archives