FAQ

Search Discussions

352 discussions - 1,857 posts

  • My guess is that we could do it in Perl, and call some C programs as required. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 ...
    Bruce MomjianBruce Momjian
    Sep 27, 2003 at 9:59 pm
    Sep 28, 2003 at 4:02 pm
  • Hi !! Everybody I am developing app using Delphi and I have a question: I have to save pictures into my database. Each picture has 20 o 30k aprox. What is the way more optimus? That 's table will ...
    Edwin QuijadaEdwin Quijada
    Sep 9, 2003 at 4:54 pm
    Dec 17, 2003 at 6:18 pm
  • Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - ...
    Joshua D. DrakeJoshua D. Drake
    Sep 18, 2003 at 8:23 pm
    Sep 22, 2003 at 11:49 pm
  • While updating to 7.3.4 I note with some alarm the following passage in README.Debian.migration.gz written by Oliver Elphick: "Some schema designs rely on the use of oids as row identifiers. This is ...
    Malcolm WarrenMalcolm Warren
    Sep 3, 2003 at 8:27 am
    Sep 4, 2003 at 6:17 am
  • Hi, MySQL has a nice feature that allows to call a replace rather insert which will attempt to insert if record not present and replace if it does. Is there any similar feature ? Currently I run a ...
    AlexAlex
    Sep 4, 2003 at 8:01 am
    Sep 11, 2003 at 1:43 pm
  • I need to sort some data based on a Time field and the times can cross both midnight and noon. As far as I can tell, there is no way to solve this without also supplying a date or am I missing ...
    Bjørn T JohansenBjørn T Johansen
    Sep 29, 2003 at 9:12 am
    Sep 30, 2003 at 9:55 am
  • On a 7.3.4 database: explain analyse select count(*) from elog; Aggregate (cost=223764.05..223764.05 rows=1 width=0) (actual time=81372.11..81372.11 rows=1 loops=1) - Seq Scan on elog ...
    Joseph ShraibmanJoseph Shraibman
    Sep 8, 2003 at 1:07 am
    Sep 10, 2003 at 5:15 pm
  • Hello list, The TCL trigger that uses NEW and OLD arrays failed after after I removed a unused column, now I got this error: pltcl: Cache lookup for attribute '........pg.dropped.24........' type 0 ...
    Josué MaldonadoJosué Maldonado
    Sep 3, 2003 at 7:54 pm
    Sep 4, 2003 at 8:19 pm
  • Hi @ all, i'm sure there was a psql-function to transfere my Blob-Data to the server but I can't remember. I have a script like this : UPDATE xy SET z = lo_import('localpath_and_file'); but i want to ...
    Daniel SchuchardtDaniel Schuchardt
    Sep 17, 2003 at 4:32 pm
    Sep 19, 2003 at 12:55 pm
  • Hi, While on the topic of "need for in-place upgrades", I got to think- ing how the pg_restore could be speeded up. Am I wrong in saying that in the current pg_restore, all of the indexes are created ...
    Ron JohnsonRon Johnson
    Sep 15, 2003 at 11:53 pm
    Sep 27, 2003 at 4:59 pm
  • I need to write a SQL that calculates the interval between a start time and a stop time. This is the easy part. The problem is that I only have the time part, i.e. no date, so how can I be sure to ...
    Bjørn T JohansenBjørn T Johansen
    Sep 11, 2003 at 11:24 am
    Sep 11, 2003 at 7:10 pm
  • I have a customer table that has the field CUSTOMER_ID as the primary key (cust_pkkey), the table has 102,834 records in it. The following select statement works fine: select * from customer order by ...
    Bupp PhillipsBupp Phillips
    Sep 2, 2003 at 2:53 am
    Sep 6, 2003 at 7:44 pm
  • Hi all. This is off topic and is a cross-post, so I'll be brief. There is a very nasty virus out there and I urge everybody to get their AV in order. The virus is known as: "W32.Gibe-F" or ...
    Nikola MilutinovicNikola Milutinovic
    Sep 19, 2003 at 8:39 pm
    Sep 23, 2003 at 5:28 pm
  • Hi, everybody! Here is a weird problem, I ran into... I have two huge (80 million rows each) tables (a and b), with id as a PK on both of them and also an FK from b referencing a. When I try to run a ...
    Dmitry TkachDmitry Tkach
    Sep 17, 2003 at 6:06 pm
    Sep 17, 2003 at 9:52 pm
  • have the table "numbercheck" Attribute | Type | Modifier -----------+------------+---------- svcnumber | integer | not null svcqual | varchar(9) | svcequip | char(1) | svctroub | varchar(6) | svcrate ...
    Dave [Hawk-Systems]Dave [Hawk-Systems]
    Sep 25, 2003 at 4:39 pm
    Sep 28, 2003 at 6:21 pm
  • I had no idea that my address was being broadcast to the world via comp.databases.postgresql.general I have no problem with having messages sent to the list go to the group. I do have a problem with ...
    ExpectExpect
    Sep 19, 2003 at 4:00 am
    Sep 24, 2003 at 4:13 pm
  • http://www.computerworld.com.au/index.php?id=1482975508&fp=16&fpid=0 -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA ...
    Ron JohnsonRon Johnson
    Sep 17, 2003 at 9:56 pm
    Sep 18, 2003 at 9:33 pm
  • Hello, As I'm in the middle of the migration process form mysql to pg I found that there is no CONCAT function which is available in mysql. Can anybody tell me how to implement this function using ...
    Marek LewczukMarek Lewczuk
    Sep 16, 2003 at 11:45 am
    Sep 17, 2003 at 3:33 pm
  • This will be a little vague, it was last night and I can't now do the test in that db (see below) so can't give the exact wording. I seem to remember a report a little while ago about tsearch v2 ...
    Nigel J. AndrewsNigel J. Andrews
    Sep 4, 2003 at 11:28 am
    Sep 8, 2003 at 1:34 am
  • Hello, I'm moving out from MySQL to PostgreSQL and there are some function which are not supported in PG so I'm trying to write my own functions. Currently I have big problem with function IF(), ...
    Marek LewczukMarek Lewczuk
    Sep 6, 2003 at 12:55 pm
    Sep 8, 2003 at 1:28 am
  • I am trying to tune my database and I discovered one select that does a seq scan on a table but I can't see why... All the join fields are indexed and I am returning just one record, so no sort is ...
    Bjorn T JohansenBjorn T Johansen
    Sep 5, 2003 at 6:08 am
    Sep 5, 2003 at 9:53 pm
  • Hello, sometimes I get a strange error from postgresql when I try to connect using ssl to the server: LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token "hostssl" FATAL: Missing or ...
    Angel TodorovAngel Todorov
    Sep 30, 2003 at 8:44 am
    Oct 2, 2003 at 8:09 pm
  • Can anyone reccomend a career path or maybe past experience on a good career path to becoming a DBA? I recently took a class on Intro to SQL at the local college and enjoyed it very much. I dont want ...
    Bryant MBryant M
    Sep 22, 2003 at 9:31 pm
    Sep 25, 2003 at 10:04 pm
  • Hi, I am a Postgres newbie who worked until now with Oracle. Now I want to know if it is possible (when yes the how?) in Postgresql To set dynamically the Localization? For example in Oracle you can ...
    Amin SchoeibAmin Schoeib
    Sep 3, 2003 at 9:06 am
    Sep 4, 2003 at 7:32 am
  • Hi Many people are asking how to automatically update columns containing a modification date on updates. I'm wondering if the only solutions in the current pgsql really are... - adding ...
    Sven SchwynSven Schwyn
    Sep 27, 2003 at 10:52 am
    Sep 29, 2003 at 5:30 pm
  • Is there a way to make Postgresql case-INSENSITIVE? Thanks
    RelaxinRelaxin
    Sep 13, 2003 at 11:08 am
    Sep 15, 2003 at 6:56 am
  • good day! is there a way to retrieve a user's decrypted password, just like when i issued a "SELECT * FROM pg_shadow;" in the earlier version of postgresql? thanks in advance!Ü *(¯`·.,¸¸.·´¯`·.¸¸.- ...
    Don V. SoledadDon V. Soledad
    Sep 6, 2003 at 3:03 am
    Sep 10, 2003 at 4:38 pm
  • Since you usually need to know the total number of rows a query would return, do you think it's better to: a) Do one query with a LIMIT and OFFSET to get the results, and another COUNT query to get ...
    CSNCSN
    Sep 5, 2003 at 9:18 am
    Sep 5, 2003 at 9:49 pm
  • I'm in a situation where I need to load an ASCII file into a database. No sweat so far right? The records are indexed by date and I have a unique index on date. The ASCII can overlap, meaning it can ...
    Curtis StanfordCurtis Stanford
    Sep 25, 2003 at 1:23 am
    Sep 26, 2003 at 4:09 pm
  • Hello, I'm trying to retrieve a limited number of random rows, and order them by a column, and am not having any luck with that last part: SELECT * FROM tablename ORDER BY random(), id LIMIT 10 ...
    Jean-francois DoyonJean-francois Doyon
    Sep 23, 2003 at 10:03 pm
    Sep 23, 2003 at 11:24 pm
  • Howdy: Has anyone used the Ora2Pg tool for exporting data to PostgreSQL? I'm trying to move data over, and my perl script to insert records into the PostgreSQL table is going very slowly. ...
    Johnson, ShaunnJohnson, Shaunn
    Sep 19, 2003 at 8:00 pm
    Sep 19, 2003 at 10:49 pm
  • Hi, at NC State University, my students and I are working on a project called "self-organizing databases," please see description below. I would like to use an open-source database system for ...
    Rada ChirkovaRada Chirkova
    Sep 7, 2003 at 8:55 pm
    Sep 12, 2003 at 4:16 pm
  • I have been trying to find out more about the postmaster crashing, but things seem to be getting stranger! I am experiencing problems running postmaster in gdb too (see end of message) I will put all ...
    Psql-mailPsql-mail
    Sep 3, 2003 at 4:06 pm
    Sep 5, 2003 at 4:44 pm
  • Hi All, I've noticed that in the pg_type system table, there is a data type called "name", would that represent the definition of the table name space, including the max length a talbe name space ...
    Chris BowlbyChris Bowlby
    Sep 2, 2003 at 4:59 pm
    Sep 2, 2003 at 8:58 pm
  • Hi, where can be fount Win32 versions of Postgress?
    MailrunMailrun
    Sep 2, 2003 at 10:09 am
    Sep 26, 2003 at 10:58 am
  • We are looking for information regarding any capabilities of PostgreSQL in regards to scalability. Ideally we want to be able to scale in both directions. What sort of solutions are out there for ...
    Duffey, KevinDuffey, Kevin
    Sep 18, 2003 at 7:10 pm
    Sep 23, 2003 at 3:17 pm
  • Look at this: http://www.zend.com/images/survey/14.gif I belive that there is only one reason why most of people are using MySQL - it has native, very easy to install version for windows.
    Marek LewczukMarek Lewczuk
    Sep 19, 2003 at 10:06 am
    Sep 20, 2003 at 10:42 pm
  • I'm finding that column defaults are not being assigned to nulls when I do an insert by way of a an ON INSERT rule on a view. For example, the following script \set ON_ERROR_STOP ON \c template1 ...
    BtoberBtober
    Sep 19, 2003 at 7:54 am
    Sep 19, 2003 at 3:53 pm
  • A (renewed) effort has been launched by Guillaume Lelarge (with the help of Jerome Seyler and myself) to translate PostgreSQL to French. The goal is to translate the various applications, the manuals ...
    Francois SuterFrancois Suter
    Sep 1, 2003 at 4:24 pm
    Sep 4, 2003 at 5:33 pm
  • Hello, I have to migrate a MySQL database to a PostgreSQL database without procedures. The problem is that this MySQL database uses ENUM, do you see what can I do to migrate ENUM into PostgreSQL ? ...
    Bruno BAGUETTEBruno BAGUETTE
    Sep 3, 2003 at 12:29 pm
    Sep 4, 2003 at 2:25 am
  • Is it right for postgres to accept a foreign key constraint when the type of the field is not the same as that of the foreign key? For example: # Create table a (id int primary key); NOTICE: CREATE ...
    Jean-Christian ImbeaultJean-Christian Imbeault
    Sep 22, 2003 at 11:57 pm
    Jan 20, 2004 at 11:37 am
  • Hello all I need to transfer a database installation from one host to another. I need to dump all users, databases, schemas, stored procedures, triggers, etc. but no actual data at all. What I try to ...
    Claudio LapidusClaudio Lapidus
    Sep 26, 2003 at 7:37 pm
    Oct 3, 2003 at 3:49 pm
  • Hello, I am currently adding SSL support to the Npgsql driver (the .NET data provider for PostgreSQL). I have tested with the Mentalis Secure Library (http://www.mentalis.org/soft/projects/ssocket/). ...
    Angel TodorovAngel Todorov
    Sep 29, 2003 at 12:59 am
    Sep 29, 2003 at 3:09 pm
  • Greetings. The official PostgreSQL documentation has been translated to German and has been published as a book by verlag moderne industrie/mitp ("PostgreSQL: Das offizielle Handbuch", ISBN ...
    Peter EisentrautPeter Eisentraut
    Sep 25, 2003 at 11:35 am
    Sep 26, 2003 at 10:52 pm
  • Hi, I'm trying to debug a pltcl procedure (being used as a trigger), and I'm having trouble generating useful debug output. I'm using elog, and I want the output to contain the value of an array. So, ...
    Russ BrownRuss Brown
    Sep 24, 2003 at 2:32 pm
    Sep 24, 2003 at 8:03 pm
  • Hi, I have had a site working for the last 2 years and have had no problems until at the weekend I replace my database server with a newer one. The database migration went like a dream and I had the ...
    Abdul-Wahid PatersonAbdul-Wahid Paterson
    Sep 15, 2003 at 6:19 pm
    Sep 23, 2003 at 1:52 pm
  • postgres 7.3.2 I store unicode-data in postgresql. The data is retrieved via webinterfaces, processed with perl and then stored in postgresql (and viceversa). All is going nice with one problem. If ...
    Peter pilslPeter pilsl
    Sep 19, 2003 at 12:13 pm
    Sep 22, 2003 at 3:14 pm
  • Looks like for the first time in 6 years, I'm experienced some database table corruption. This was due to the space filling up on a server (you don't want to know how that happened). I have 3 tables ...
    Network AdministratorNetwork Administrator
    Sep 16, 2003 at 7:30 pm
    Sep 17, 2003 at 7:17 pm
  • ok, i'm confused. i have two systems. one is redhat 7.1 (a server in colo, reasonably current), the other is 8.0 (my laptop). the server in colo is running postgresql 7.3.2 along with redhat's ...
    Richard WeltyRichard Welty
    Sep 12, 2003 at 12:09 am
    Sep 12, 2003 at 4:35 pm
  • the rather the PG dunno Hi everyone, While we are still on this topic, can I put in another request? What I didn't realise when I joined the postgresql mailing lists is that emails to the mailing ...
    Mark Cave-AylandMark Cave-Ayland
    Sep 10, 2003 at 11:29 am
    Sep 11, 2003 at 5:47 pm
Group Navigation
period‹ prev | Sep 2003 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions352
posts1,857
users355
websitepostgresql.org
irc#postgresql

355 users for September 2003

Tom Lane: 188 posts Ron Johnson: 68 posts Bruce Momjian: 62 posts Richard Huxton: 62 posts Dennis Gearon: 51 posts Scott.marlowe: 49 posts Nigel J. Andrews: 45 posts Shridhar Daithankar: 34 posts Bjørn T Johansen: 30 posts Joshua D. Drake: 30 posts Marc G. Fournier: 29 posts Chris Browne: 28 posts Greg Stark: 28 posts Stephan Szabo: 25 posts Jonathan Bartlett: 24 posts Alvaro Herrera Munoz: 23 posts Vivek Khera: 23 posts Josué Maldonado: 21 posts Doug McNaught: 20 posts Amin Schoeib: 19 posts
show more
Archives