Search Discussions

355 discussions - 1,270 posts

  • What do you think of having java as a procedural language available in PG? It seems like java has many advantages. I'm just wondering if people have thoughts or ideas on this, and if someone is ...
    Dr. EvilDr. Evil
    Aug 25, 2001 at 11:43 pm
    Sep 6, 2001 at 1:14 am
  • I always enjoy Tom's comments - he is the master of understatement and always helpful. In this case, however, I think he may be understating too much. I read the original question as "PostgreSQL is ...
    Allan EngelhardtAllan Engelhardt
    Aug 14, 2001 at 9:02 pm
    Aug 20, 2001 at 7:23 pm
  • I am running on OpenBSD and Linux, both of which have cryptographic-quality RNGs built in. When I call RANDOM() in PG, do I get the old C library random numbers, which are not very random, or do I ...
    Dr. EvilDr. Evil
    Aug 7, 2001 at 9:06 am
    Aug 8, 2001 at 7:14 pm
  • Well, first of all the scientists are still unsure if this universe will exist forever or not. So even if you find a way to let your system survive the sun becoming a red giant and so on, there's ...
    Jan WieckJan Wieck
    Aug 23, 2001 at 12:51 am
    Nov 19, 2003 at 10:08 am
  • I am creating a DB which is going to have to store a lot of small images. Nothing will be over 10k. This is with PG7.2. I have a few questions: Should I use blob or bytea (neither seem to be well ...
    Dr. EvilDr. Evil
    Aug 16, 2001 at 6:07 am
    Aug 16, 2001 at 8:46 pm
  • Hi guys, I'm willing to put this on techdocs.postgresql.org, as long as I feel it's been written for the right reasons. i.e. I'm all for a document(s) which helps people needing a good, solid, Open ...
    Justin CliftJustin Clift
    Aug 29, 2001 at 10:43 am
    Aug 30, 2001 at 8:56 pm
  • If I design a table with SERIAL type and then try to insert few rows, but some of the rows are rolled back the roll back process does not roll back the counter status. Is there a way to do a roll ...
    Ben-Nes MichaelBen-Nes Michael
    Aug 16, 2001 at 10:15 am
    Aug 17, 2001 at 12:52 pm
  • Not to whine or anything, but I really do think that pgsql development seriously could be helped by usage of an official irc channel. Whether it be hosted on pgsql's official servers or on a 3rd ...
    Gowey, GeoffreyGowey, Geoffrey
    Aug 26, 2001 at 3:35 am
    Sep 3, 2001 at 9:21 pm
  • I am developing a db application in postgresql and i need to write a delete trigger on one of the tables. the environment is table1 field1 varchar(64) other fields. table 2. field1 varchar(64) other ...
    Aug 14, 2001 at 2:04 pm
    Aug 24, 2001 at 6:01 pm
  • I've managed to compile and install it successfully on a P90 with 96MB of RAM. Michael <mwaples%waples.net@interlock.lexmark.com on 08/07/2001 06:25:49 AM To: ...
    Aug 7, 2001 at 12:49 pm
    Aug 22, 2001 at 3:10 pm
  • We have a table here with a serial value in it. We have sets of test data that we run through a processor that changes a fairly large set of tables in deterministic ways. Sometimes (about 20%, it ...
    Stephen Robert NorrisStephen Robert Norris
    Aug 18, 2001 at 5:55 am
    Aug 20, 2001 at 2:05 am
  • select * from env_info,summary,plat_info; Is my statement broken? Is this not legal? Postgres just sits there.... My goal is to select everything from multiple tables with one sql statement. Thank ...
    Jeremy HansenJeremy Hansen
    Aug 10, 2001 at 5:48 pm
    Aug 10, 2001 at 6:49 pm
  • Hello, I'm a newbie in the postgreSQL world, so if I'm asking what's rather straightforward, I appologize. This is what I'm trying to do: my collegue and I have set up three postgreSQL databases; he ...
    Miroslav KoncarMiroslav Koncar
    Aug 22, 2001 at 1:19 pm
    Aug 24, 2001 at 11:08 pm
  • I have table with date type column: chdate date; SELECT chdate from mytable; chdate 1999-01-02 But in Russia we have the next date format: DD-MM-YYYY. When I do coversion to char in SELECT: ...
    Andrey Y. MosienkoAndrey Y. Mosienko
    Aug 21, 2001 at 4:49 am
    Aug 22, 2001 at 3:30 pm
  • Hi everyone, I'm working on a (sorry) closed source application which consists of Java servlets, beans, and client applications talking to a postgresql database. Now, lets say I'm interested in ...
    Mike AraceMike Arace
    Aug 31, 2001 at 1:00 pm
    Sep 1, 2001 at 3:37 am
  • set digest
    Matthew wongMatthew wong
    Aug 1, 2001 at 5:27 am
    Aug 29, 2001 at 1:51 pm
  • If a data analyst needed to perform analysis (select statements only, no updates, creates, etc) while traveling, would it be feasible to put a database on a DVD? Could PostgreSQL use it? Does the use ...
    Andrew GouldAndrew Gould
    Aug 6, 2001 at 4:42 pm
    Aug 7, 2001 at 12:48 am
  • Hi all, I'm currently in the progress of setting up a databasing system for a sales company, using a pure Linux / Postgresql solution. I've traditionally used MS Access 97 for the setup of similar ...
    Aug 20, 2001 at 2:34 pm
    Sep 13, 2001 at 3:49 pm
  • Hi! I've installed 7.1.2 on sparc solaris 7. configure, make, install and initdb worked perfectly. When I try to start postmaster: postgres$ postmaster IpcMemoryCreate: shmget(key=5432001, ...
    Peter LaukoPeter Lauko
    Aug 25, 2001 at 8:59 pm
    Aug 27, 2001 at 12:10 am
  • Hi Im using php to upload Binary data into bytea field. The problem is that when I query what I uploaded I discover that it hold only 13 characters and not the whole binary file I tried manual insert ...
    Ben-Nes MichaelBen-Nes Michael
    Aug 23, 2001 at 11:46 am
    Aug 26, 2001 at 2:56 pm
  • G'day all. I have a cron job which vacuums etc all of my databases but it does not work with 7.1.2 because of the change in structure of .../data/base. It currently says: for q in ...
    Stephen DaviesStephen Davies
    Aug 20, 2001 at 9:32 am
    Aug 23, 2001 at 7:53 pm
  • It looks as though the init.d script "postgres" supplied with 7.1.2 no longer propagates environment variables to pg_ctl. Was that an intentional change? Or is this something no one else sees? I put ...
    Steve WamplerSteve Wampler
    Aug 23, 2001 at 3:43 pm
    Aug 23, 2001 at 7:23 pm
  • I posted this message to the admin list, but just realized maybe it belongs in the general list. Sorry for double posting! I need to find a way to determine how many concurrent connections are being ...
    Tauren MillsTauren Mills
    Aug 1, 2001 at 2:33 am
    Aug 2, 2001 at 2:13 am
  • Hi, I'm having a strange problem with syslog and Solaris 7, and I've run out of ideas about what might be wrong. I configure postgres with --enable-syslog, and everything works fine. Configure finds ...
    Andrew SullivanAndrew Sullivan
    Aug 30, 2001 at 1:35 pm
    Sep 6, 2001 at 2:44 pm
  • hi, When doing vacuumdb, it stops with the following words: ERROR: mdopen: couldn't open test1: No such file or directory vacuumdb: database vacuum failed on testdb1. Where test1 is a view name, ...
    Aug 23, 2001 at 11:24 am
    Aug 31, 2001 at 9:49 pm
  • A simplified version of my situation... I've got three tables that I'm working with... the first is a table of staff members... firstname, lastname, staffid... nothing tough... the second is a table ...
    Joshua Adam GinsbergJoshua Adam Ginsberg
    Aug 11, 2001 at 11:04 am
    Aug 31, 2001 at 12:42 pm
  • This question just came up from a user use to our Informix application. They tried to do a wildcard search, thus "where field_name LIKE 'AB%VN'". The trailing values (after the %) are not recognized ...
    Scott HolmesScott Holmes
    Aug 15, 2001 at 11:07 pm
    Aug 20, 2001 at 2:42 pm
  • Hi, I have a table with no relations to other tables. It has a sequence number field (integer) and a status field being a char. There is a unique index on the seqno field. Now this table has about ...
    Feite BrekeveldFeite Brekeveld
    Aug 17, 2001 at 9:49 am
    Aug 18, 2001 at 3:35 am
  • Does PostgresQL have some way to make update, insert and delete queries not return the number of affected rows? I know that in MS SQL one would use NOCOUNT for that. TIA, Jochem
    Jochem van DietenJochem van Dieten
    Aug 14, 2001 at 1:38 pm
    Aug 15, 2001 at 12:16 am
  • Whats the minimum hardware anyone has installed Postgresql on ? Someone is thowing out some old pc's and thought I might make use of one.
    Aug 7, 2001 at 9:59 am
    Aug 14, 2001 at 8:24 pm
  • In looking over the documentation, I haven't seen any evidence of PostgreSQL working on the Mac. Is this the case, or am I missing something. Has anyone heard of it ever being used on a mac? Thanks, ...
    Israel EvansIsrael Evans
    Aug 29, 2001 at 4:28 pm
    Aug 31, 2001 at 9:19 pm
  • Hi. My database is giving me trouble. I assume that it is due to a bad record, but I am unable to select/delete that record. Have checked logs with no helpful info. Version 7.0.2 on Cobalt RAQ4. Can ...
    Tsukaeru.net WebmasterTsukaeru.net Webmaster
    Aug 24, 2001 at 1:45 am
    Aug 25, 2001 at 12:12 pm
  • hello, i'm having trouble getting ultradev to make a connection with a postgresql database on my server. does anyone have any experience with this? i have a test .jsp script which can pull data out ...
    Tomasz konefalTomasz konefal
    Aug 23, 2001 at 5:33 pm
    Aug 24, 2001 at 2:52 pm
  • here's my problem i have tables A, B, C, D A <- B A <- C <- D i want to maintain integrity so that if A is deleted from then so is anything referencing from B and C - no problem ON DELETE CASCADE but ...
    Murray HobbsMurray Hobbs
    Aug 22, 2001 at 9:52 pm
    Aug 23, 2001 at 8:37 pm
  • I am having trouble with setting up a scheduled VACUUM. Since VACUUM needs an exclusive lock, I can never get it to run. I am using persistant connections from a web server and use a single module to ...
    Mark CoffmanMark Coffman
    Aug 21, 2001 at 8:34 pm
    Aug 22, 2001 at 1:39 am
  • Hello I have statements (highly simplified just to get the point across) like select a,b,c from a where d=2 order by e limit 10; Now I think that because of "order by" the above query already "knows" ...
    Aug 19, 2001 at 5:49 pm
    Aug 21, 2001 at 12:50 pm
  • Hi, Ok i know this is something stupid, somebody mind explaining it to me? Also sorry if this gets posted twice, i got a error back the first time.. I have a Visual Basic Project that access a ...
    Ryan C. BonhamRyan C. Bonham
    Aug 15, 2001 at 3:49 pm
    Aug 21, 2001 at 12:03 am
  • Hi, i'm having again problems installing postrgesql. I couldn't find the reason so i'm asking you and waiting for help. i ran the following patches: pgrl.patch and pgmodule.patch but i still got ...
    Tamara D. BlumTamara D. Blum
    Aug 17, 2001 at 9:14 pm
    Aug 18, 2001 at 2:47 pm
  • Hi I have a very large database of seismic data. It is about 27 Gb now, and growing at about the rate of 1 Gb every 3-4 days. I am running postgres 7.1.2. I might possibly try to upgrade to 7.2 when ...
    Philip CrotwellPhilip Crotwell
    Aug 14, 2001 at 4:03 pm
    Aug 17, 2001 at 9:52 am
  • Hey guys, Is there any reason why there are no stored procedures for postgresql or does this have to do with the ability to add your own procedural language? Roy.
    Aug 14, 2001 at 10:17 pm
    Aug 15, 2001 at 4:42 pm
  • hello, This weekend I read the User guide front to back. I hadn't done that since 6.2 or thereabouts... I have one request for improvement: In the CREATE DATABASE chapter it may be usefull to include ...
    Tony GrantTony Grant
    Aug 6, 2001 at 11:43 am
    Aug 7, 2001 at 4:16 pm
  • Hi, can I nest SQL statements with SPI within trigger functions? How can I distinguish the results in SPI_tuptable? Thanks, Markus
    Markus WagnerMarkus Wagner
    Aug 30, 2001 at 4:19 am
    Sep 4, 2001 at 5:21 pm
  • Hi All Is it possible to fetch data from another database than the current? E.g. like in Oracle I can select data from 2 different DB's like this: select * from db1.table1 as tbl1, db2.table2 as tbl2 ...
    Jacob Vennervald MadsenJacob Vennervald Madsen
    Aug 28, 2001 at 3:32 pm
    Sep 4, 2001 at 5:14 am
  • Hi List I'm using PostgreSQL version PostgreSQL 7.1.2 When I create a new database it's made with SQL_ASCII by default. What do I have to do to make LATIN1 the default encoding? This is how I ...
    Jacob Vennervald MadsenJacob Vennervald Madsen
    Aug 29, 2001 at 1:18 pm
    Aug 30, 2001 at 9:52 am
  • Hi all, I've been trying for days to figure this out, but just not have been able to figure this out. I'm creating a test function for me to start out using the v1 functions, but it fails. I'm doing ...
    Gowey, GeoffreyGowey, Geoffrey
    Aug 25, 2001 at 8:05 pm
    Aug 26, 2001 at 10:06 pm
  • Hello All! Maybe this is one of those typical questions, but I have heard people complaining that Postgres is just for quite small bases, less than 2Gb. Now, we have to choose a free database engine ...
    Ivan BabikovIvan Babikov
    Aug 20, 2001 at 2:37 pm
    Aug 22, 2001 at 7:33 pm
  • I posted a question on JDBC yesterday because I was having data typing problmes. But it is not a JDBC problem... I am trying to populate an array CREATE TABLE festival ( festivalID INTEGER PRIMARY ...
    Tony GrantTony Grant
    Aug 8, 2001 at 1:18 pm
    Aug 22, 2001 at 10:52 am
  • Hi, I am looking for some confirmation and perhaps some explanation of and for the following observation. If I use "000000-000000" as input to a macaddr data type element in my database no value ...
    Gayland GumpGayland Gump
    Aug 21, 2001 at 3:43 pm
    Aug 21, 2001 at 9:29 pm
  • thinking in the long-term for my project... i'm looking at trying to set up two database servers with some sort of clustering and/or failover that are talking to a SAN. is this even feasible using ...
    Robert J. Sanford, Jr.Robert J. Sanford, Jr.
    Aug 20, 2001 at 11:02 pm
    Aug 21, 2001 at 2:01 pm
  • Just started fiddling with PostgreSQL, and know nothing of databases. I have the documentation that came with the Mandrake-8.0 installation written by Thomas Lockhard, and I've perused Bruce ...
    William D. TallmanWilliam D. Tallman
    Aug 20, 2001 at 2:40 pm
    Aug 20, 2001 at 4:49 pm
Group Navigation
period‹ prev | Aug 2001 | next ›
Group Overview
grouppgsql-general @

357 users for August 2001

Tom Lane: 111 posts Stephan Szabo: 36 posts Peter Eisentraut: 35 posts Bruce Momjian: 32 posts Newsreader: 25 posts Lee Harr: 20 posts Doug McNaught: 19 posts Justin Clift: 19 posts Martijn van Oosterhout: 19 posts Andrew Gould: 17 posts Dr. Evil: 16 posts Joe Conway: 16 posts Mitch Vincent: 16 posts Wsheldah: 15 posts Allan Engelhardt: 14 posts Jan Wieck: 14 posts Bruno Wolff III: 13 posts Andrew SNow: 12 posts Jeff Eckermann: 12 posts Lamar Owen: 12 posts
show more