FAQ

Search Discussions

334 discussions - 1,117 posts

  • Hi, I have a column of times that I would need to sum up for accounting purposes. Since sum(time) does not seem to be defined anybody got an easy clue how to do this? Regards, Konstantin -- Dipl-Inf. ...
    Konstantinos AgourosKonstantinos Agouros
    Nov 3, 2001 at 4:28 pm
    Nov 7, 2001 at 6:43 am
  • I just read that the new commercial version of Sourceforge will _only_ run on Linux/Oracle: http://www.idg.net/ic_724290_1773_1-3921.html Formerly, there was only a non-commerical version and it ran ...
    Bruce MomjianBruce Momjian
    Nov 7, 2001 at 4:13 am
    Nov 15, 2001 at 7:37 pm
  • Just undertaking a port of a small Data Warehouse-type batch load application from Oracle to PostgreSQL. It's common practice in such a system to load data into a staging table whose fields are ...
    Andy MardenAndy Marden
    Nov 27, 2001 at 10:08 am
    Feb 23, 2002 at 1:58 am
  • Hi I am currently evaluating PostgreSQL for a project I'm working on and need to find out how long it takes to execute several types of queries Can someone tell me if there is a way of getting the ...
    Elizabeth O'NeillElizabeth O'Neill
    Nov 27, 2001 at 10:18 am
    Dec 10, 2001 at 11:00 am
  • Hi all. Can anyone tell me how to get a sequential row count field in the output of a query? Say I want to query for all users in a table sorted by lastname and firstname. I would like to include a ...
    Al KirkusAl Kirkus
    Nov 1, 2001 at 8:13 pm
    Nov 9, 2001 at 1:01 am
  • Hello Balaji, There are no real limitations when using PostgreSQL smart programming features: views, triggers, rules, types and plpgsql server-side language. For example: 1) FAST READINGS: triggers ...
    Jean-Michel PoureJean-Michel Poure
    Nov 5, 2001 at 10:33 am
    Apr 20, 2002 at 7:11 am
  • Here is a wierd one... Initdb is failing most of the time on RH 7.1. Postgresql ver 7.1.3 and 7.1.2. After building the PG from the source tarball, both 'make check' and the actual install fail with ...
    Paul StavridesPaul Stavrides
    Nov 30, 2001 at 1:02 pm
    Dec 1, 2001 at 2:25 am
  • Hi All, I recently noticed that the DBD::Pg Perl module appears to be doing a lot of work escaping characters for BYTEA data types. It's importing Perl's POSIX support to check every character in ...
    David WheelerDavid Wheeler
    Nov 18, 2001 at 4:58 am
    Nov 27, 2001 at 4:14 pm
  • Hello, I have found a problem today to which I am unable to find the solution. I write to this list looking for help. I have been using PostgreSQL for about a year or so, and I manage a quite large ...
    Antonio Fiol BonnínAntonio Fiol Bonnín
    Nov 8, 2001 at 12:31 pm
    Nov 12, 2001 at 3:29 pm
  • [ redirected from patches to general ] Peter Eisentraut <peter_e@gmx.net writes: I'm of two minds about it. It'd annoy *me*, but I know we have seen trouble reports from people who were using ...
    Tom LaneTom Lane
    Nov 21, 2001 at 3:12 pm
    Nov 26, 2001 at 6:58 pm
  • This is my first time posting here and I've not lurked that much so feel free to lamblast me if I'm out of line - but from what I've seen of PostGres one of the biggest barriers to more widespread ...
    Simon WillisonSimon Willison
    Nov 19, 2001 at 11:08 am
    Nov 21, 2001 at 10:24 am
  • Hi all, I'm running Postgresql 7.1.1 on Solaris and mostly uses JDBC Driver to connect to the Database. Recently I'm seeing very weird behaviour, Database Server automatically shuts down and when I ...
    Sunit BhatiaSunit Bhatia
    Nov 15, 2001 at 3:04 am
    Nov 16, 2001 at 11:35 am
  • I am in need of some assistance in coding a c module using libpq on a windows platform. Specifically, I need some help with providing the input buffer for lo_write. The code sample provided in the ...
    Scott HolmesScott Holmes
    Nov 4, 2001 at 7:39 pm
    Nov 5, 2001 at 3:41 pm
  • Hi! A few months ago I asked if anyone started working on PL/JAVA, the ansver was no. Now I started to write a java stored procedure language and environment for PostgreSQL. Some code is already ...
    Laszlo HornyakLaszlo Hornyak
    Nov 30, 2001 at 9:05 am
    Dec 6, 2001 at 12:33 pm
  • I have the following table : Attribute | Type | Modifier -----------+--------------------------+---------- motid | integer | not null objid | integer | not null date | timestamp with time zone | not ...
    Eric CholetEric Cholet
    Nov 21, 2001 at 11:23 am
    Nov 22, 2001 at 2:13 pm
  • I have in my code a SQL statement that does the following: select period_start + interval('1 hour') from periods; This worked in 7.1, but in 7.2 I am getting the following error: ERROR: parser: parse ...
    Barry LindBarry Lind
    Nov 16, 2001 at 2:22 am
    Nov 20, 2001 at 4:40 pm
  • I've got a large database, currently about 40 million rows in the biggest table. I'm trying to set it up with PostgreSQL 7.1.3, but I've got some questions... I initially created the table and with a ...
    Gurupartap DavisGurupartap Davis
    Nov 13, 2001 at 8:46 pm
    Nov 16, 2001 at 5:31 pm
  • Hi. I have a question: Does anybody know where can I find some information about how to get to a Postgres database from Delphi. I need to write a client/server application in Delphi which uses ...
    JahroJahro
    Nov 15, 2001 at 12:37 am
    Nov 16, 2001 at 12:37 pm
  • I have several really big tables that have columns uniquely identified by single or multiple rows. [ I have about 25 tables, 10k to 500k rows per table ] Each day I get a flat file of updates. I have ...
    OrionOrion
    Nov 8, 2001 at 8:07 pm
    Nov 13, 2001 at 10:37 am
  • Good evening ... Back on October 25th, 2001, the PostgreSQL Global Development Group quietly released Beta1 of PostgreSQL v7.2, in order to get the first round of packaging and testing of our ...
    Marc G. FournierMarc G. Fournier
    Nov 7, 2001 at 11:43 pm
    Nov 12, 2001 at 5:26 pm
  • Running into an interesting problem when trying to do a psql from the commandline. My infrastructure: Intel Architecture Redhat 7.1 PostgreSQL 7.0.3 (from stock RPM's of the 7.1 distribution) 320MB ...
    Mark NickelMark Nickel
    Nov 6, 2001 at 2:30 am
    Nov 6, 2001 at 6:47 pm
  • Hi, I want to install and work with DBD::Pg module thorugh Perl in one machine, but the database server is installed in another machine. Can I install and work with the module in this case? Is there ...
    Samik RaychaudhuriSamik Raychaudhuri
    Nov 30, 2001 at 11:38 pm
    Feb 15, 2002 at 2:05 pm
  • Hi, I'm sure this question was asked before but I can't find the answer. I've just started looking at options of runnnig Linux-based (actually, I need something free :) database engines with MS ...
    Andrey ShcherbinaAndrey Shcherbina
    Nov 21, 2001 at 6:38 pm
    Nov 21, 2001 at 10:46 pm
  • Hi all: Let's suppose I create a table with a CHECK constraint, like: CREATE TABLE blabla (id int, tipo varchar(8), CHECK tipo IN ('tipo1', 'tipo2', 'tipo3')) Can I change the CHECK constraint ...
    Paulo JanPaulo Jan
    Nov 13, 2001 at 3:23 pm
    Nov 15, 2001 at 7:13 pm
  • I have a function and a table: create table foo ( f1 integer default foo_func(); ); create function foo_func returns integer as 'select max(f1)+1 from foo' language 'sql'; when I use pg_dump, and ...
    Eric RidgeEric Ridge
    Nov 6, 2001 at 8:56 pm
    Nov 8, 2001 at 9:47 pm
  • I am new to postgres and am in the process of creating a new database of several 100 tables. Most of the tables have a serial datatype. When the table is created psql says it is creating an implicit ...
    Tom InnesTom Innes
    Nov 2, 2001 at 1:22 pm
    Nov 6, 2001 at 9:10 pm
  • From my postgres log: DEBUG: query: SELECT mytext,myint INTO TEMP tqt FROM ...; . . . DEBUG: query: DROP TABLE tqt; DEBUG: ProcessUtility: DROP TABLE tqt; NOTICE: FlushRelationBuffers(tqt, 0): block ...
    Joseph ShraibmanJoseph Shraibman
    Nov 28, 2001 at 11:19 pm
    Nov 30, 2001 at 4:16 pm
  • Hi, everybody. This is my first post on this list and I hope It's the good place for my question. I'm developping an Opensource projetc which aims to be a GTK frontend for Postgresql first ( and ...
    William WAISSEWilliam WAISSE
    Nov 23, 2001 at 4:38 pm
    Nov 27, 2001 at 9:33 am
  • I am running a capacity test just for fun, and notice that if I run one update the system uses 100% of the CPU, but if I use 2 updates at the same time the system is only about 3% loaded and the ...
    Mike HardingMike Harding
    Nov 26, 2001 at 4:54 am
    Nov 26, 2001 at 8:08 pm
  • Hi: Why won't pl/perl build under the install for postgresql 7.1.3? My perl installation only has libperl in the archive format (libperl.a) and the perl makefile calls for libperl.so...building perl ...
    -wiseguy-wiseguy
    Nov 25, 2001 at 8:38 pm
    Nov 26, 2001 at 7:27 pm
  • Hi there! I just started using postgres and I'm loving it. I really want to go all open source at the office... I have a database in MSSQL which I was able to export succesfully using the ...
    Alexander WallaceAlexander Wallace
    Nov 20, 2001 at 9:25 pm
    Nov 23, 2001 at 4:47 pm
  • I hope someone can help me out with this. Postgres 7.1.3 Solaris 2.8 I have a table called system_data setup like this. ----------------------------------------------------- This table is indexed on ...
    Brian AvisBrian Avis
    Nov 19, 2001 at 9:08 pm
    Nov 19, 2001 at 10:48 pm
  • I am using postgresql-7.0.3 and is now having a strange problem!!! I got a table with a "serial" attribute. For example CREATE TABLE test ( id SERIAL NOT NULL, val INT ); The the following insertions ...
    Rasmus Resen AmossenRasmus Resen Amossen
    Nov 15, 2001 at 2:07 am
    Nov 15, 2001 at 11:17 pm
  • Hi, I hope someone can help me. I want to create a new table using the "automatic" sequence function of Postgres by creating the first column as type "serial". But I want to start at say "5000". Can ...
    Tielman J de VilliersTielman J de Villiers
    Nov 15, 2001 at 1:57 pm
    Nov 15, 2001 at 7:32 pm
  • The following works in 7.1. Is this behavior guaranteed or is it the subject of possible change in the future? Or am I just "getting lucky" that nextval() is evaluated before currval(): CREATE ...
    Mike MascariMike Mascari
    Nov 13, 2001 at 12:34 pm
    Nov 13, 2001 at 9:33 pm
  • How do I set up my pg_hba.conf file to allow user "a" to only have access to databases x, y, and z; and user "b" to only have access to databases m, n, and o? The pgident authentication mechanism ...
    Travis BauerTravis Bauer
    Nov 12, 2001 at 5:12 am
    Nov 13, 2001 at 7:07 am
  • Is an Object Identifier (OID) is a good choice for a primary key within a database table? ----------------------------------------------------------------------------------------------------------- ...
    Richard TeviotdaleRichard Teviotdale
    Nov 7, 2001 at 9:01 pm
    Nov 8, 2001 at 11:38 pm
  • Hi, after some work with intervals I got a little further. Now I have two questions: a) Is there a datestyle where 24 hours is not represented as a 1 but as 24 hours (or 48 or whatever)? b) Can ...
    Konstantinos AgourosKonstantinos Agouros
    Nov 4, 2001 at 4:28 pm
    Nov 4, 2001 at 8:21 pm
  • Hi, I've searched the docs., faqs and mailing lists for this but didn't find anything. Everytime I startup our postgres db, I get DEBUG messages as follows DEBUG: database system was shut down at ...
    Sanjay BhatiaSanjay Bhatia
    Nov 29, 2001 at 1:07 am
    Dec 29, 2001 at 6:15 pm
  • AFAIR (Postgres 6.5 - 7.1.3): cd /usr/src/postgresql-X.X.X/src/interfaces/libpq++/examples [postgres@xxx examples]$ /usr/local/pgsql/bin/psql Password: Welcome to psql, the PostgreSQL interactive ...
    Albert BartoszkoAlbert Bartoszko
    Nov 28, 2001 at 2:08 pm
    Dec 5, 2001 at 11:35 pm
  • This is a little off topic but this is the best source of SQL knowledge I know about so hopefully this will be interesting enough for someone to answer. :-) I've got the following tables: Table ...
    Fran FabrizioFran Fabrizio
    Nov 20, 2001 at 3:26 pm
    Nov 21, 2001 at 7:08 pm
  • when I do: /usr/local/pgsql/bin/dropdb -h myhost -U myuser dbname it complains that there isnt an entry in pg_hba.conf for 'template1', when i rather explicitly told it to drop 'dbname'. am i missing ...
    Alex AvrietteAlex Avriette
    Nov 13, 2001 at 9:38 pm
    Nov 20, 2001 at 6:23 pm
  • When I upgraded from 7.0.2 to 7.1, one of my batch scripts went from 10 to 20 minutes? Some time ago I wrote a script that imports a 1.5M text file into 3 tables (about 7K, 9K, 9.5K rows). I had set ...
    Frank BaxFrank Bax
    Nov 12, 2001 at 5:56 pm
    Nov 15, 2001 at 3:23 am
  • Using CREATE INDEX on a large table ( 70 million rows) results in the following error: ERROR: Memory exhausted in AllocSetReAlloc(134217728) (134217728 is exactly 128 megabytes). The box has 2Gigs of ...
    Eric CholetEric Cholet
    Nov 14, 2001 at 2:02 pm
    Nov 14, 2001 at 5:05 pm
  • Hi!! Im Darwin a student from DATA COllege San Fernando Pampanga, Philppines. I am a new memeber in your mailing list. Hope you could accomodate me. I just want to consult anyone out there who could ...
    DarwinDarwin
    Nov 9, 2001 at 9:22 am
    Nov 9, 2001 at 7:00 pm
  • Hi everyone, Has anyone else noticed that Sourceforge.net is moving from PostgreSQL to Oracle? Just noticed in their jobs page they're looking for a DBA to assist them in the transition from ...
    Justin CliftJustin Clift
    Nov 4, 2001 at 9:43 am
    Nov 7, 2001 at 10:40 am
  • Hi I'm using postgresql to manage a web site. Problem: How are people dealing with data integrity issues such as stale data when writing web-based apps? For instance: The value of X is 7. Step (1) ...
    Jelle OuwerkerkJelle Ouwerkerk
    Nov 5, 2001 at 9:50 pm
    Nov 6, 2001 at 6:55 pm
  • Hi, I´m new in PostgreSQL, but i have worked with many databases systems. I know good standard SQL language. I know that stored procedures I can create by CREATE PROCEDURE. But I didn ´t find this ...
    Tomáš KubišTomáš Kubiš
    Nov 5, 2001 at 9:37 am
    Nov 6, 2001 at 12:16 am
  • trying for days now to get documentation about this tool that would allow me to authenticate users for different services via a postgres-database on my linuxsystem. I obtained two versions: 0.03 ...
    Peter PilslPeter Pilsl
    Nov 20, 2001 at 12:22 pm
    Dec 21, 2001 at 11:21 pm
  • I am looking into some performance issues with an application I have. I want to do some testing to see how much overhead TOAST adds to my application. I have a table that performs a similar function ...
    Barry LindBarry Lind
    Nov 27, 2001 at 8:26 pm
    Dec 5, 2001 at 10:40 pm
Group Navigation
period‹ prev | Nov 2001 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions334
posts1,117
users363
websitepostgresql.org
irc#postgresql

363 users for November 2001

Tom Lane: 130 posts Stephan Szabo: 40 posts Bruce Momjian: 38 posts Command Prompt, Inc.: 26 posts Jean-Michel Poure: 19 posts Doug McNaught: 16 posts Wsheldah: 15 posts Francisco Reyes: 15 posts Martijn van Oosterhout: 14 posts Jason Earl: 12 posts Aasmund Midttun Godal: 10 posts Antonio Fiol Bonnín: 10 posts Eric Ridge: 10 posts Justin Clift: 10 posts Andrew Gould: 9 posts Martín Marqués: 9 posts Tielman J de Villiers: 9 posts Tony: 9 posts Andrew G. Hammond: 8 posts Brent R. Matzelle: 8 posts
show more
Archives