FAQ

Search Discussions

264 discussions - 1,242 posts

  • I'm reading, and enjoying immensely, Fabial Pascal's book "Practical Issues in Database Management." Though I've just gotten started with the book, he seems to be saying that modern RDBMSs aren't as ...
    DananrgDananrg
    Jun 8, 2006 at 12:21 pm
    Jun 17, 2006 at 12:24 am
  • I'm not sure that many people necessarily realise it, but you can also drive Slony directly from pgAdmin 1.4+ if slonik scripts give you a headache. Regards, Dave.
    Dave PageDave Page
    Jun 30, 2006 at 3:22 pm
    Jul 11, 2006 at 5:08 pm
  • Is there a way to add a foreign key constraint without having to wait for it to check the consistency of all existing records? If a database is being reloaded (pg_dumpall then load), it really ...
    WesWes
    Jun 19, 2006 at 3:41 am
    Jul 25, 2006 at 4:01 pm
  • Hi, I am new to pgsql....I really appreciate the licensing terms of pgsql...mysql licensing is a little bit risky to use... But, I have one question... Q. when using pgsql as a very heavy and mission ...
    HowachenHowachen
    Jun 30, 2006 at 3:58 pm
    Jul 12, 2006 at 3:44 pm
  • I've just started receiving an out of memory error with my most complex query. It has been running fine for the past 9 months. It's a snapshot materialized view that I update every night using the ...
    Relyea, MikeRelyea, Mike
    Jun 14, 2006 at 6:08 pm
    Jun 23, 2006 at 5:31 am
  • Hello, we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6. When we do a big SELECT-query the whole maschine becomes very very very slowly or stands. The maschine has 3 GB RAM, so we ...
    MGMG
    Jun 26, 2006 at 12:17 pm
    Jul 6, 2006 at 8:24 pm
  • Hi! First I want to say thanks for writing PostgreSQL. It's nice to have a free alternative. I have a beginner question. I have a table with a bunch of filenames and each of them have a date. ...
    Kevin JenkinsKevin Jenkins
    Jun 18, 2006 at 12:09 am
    Jun 27, 2006 at 12:46 am
  • Hi I need to connect to the postgres database using my unix shell. How should i go about it? Is libpq going to be helpful here? Thanks and regards, ~Jas
    Jasbinder BaliJasbinder Bali
    Jun 29, 2006 at 3:24 pm
    Jul 5, 2006 at 5:44 pm
  • Date and Pascal hate nulls. One even goes so far as to say that if you permit NULLs in a database, then the results from *every* query is suspect. So they turn perform backflips suggesting ways to ...
    DananrgDananrg
    Jun 28, 2006 at 9:31 am
    Jul 5, 2006 at 9:08 pm
  • Err, not quite correct. The app directory is *always* the first choice in either safe or unsafe mode, except if using LoadLibraryEx's alternate search order. See ...
    Dave PageDave Page
    Jun 19, 2006 at 7:24 am
    Jun 22, 2006 at 5:34 pm
  • Hi all, We're using some 3rd party product that uses inheritence, and the following query is rather slow on PostgreSQL 7.4.7 (debian stable). Any suggestions how to speed it up? explain analyze ...
    Alban HertroysAlban Hertroys
    Jun 13, 2006 at 1:14 pm
    Aug 30, 2006 at 1:38 pm
  • I have two postgres servers, one on linux (fedora core 5), one on windows, both are version 8.1.4. Both databases are initialized with locale Croatian and win1250 encoding. running pg_controldata on ...
    Dragan MaticDragan Matic
    Jun 30, 2006 at 9:56 am
    Jul 3, 2006 at 12:16 pm
  • I'm using DBMail running against PostgreSQL as my mailstore for our company network. I recently converted our company database from SQL_ASCII to UTF8 as I thought this would be a *good thing*. The ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Jun 8, 2006 at 5:23 am
    Aug 22, 2006 at 3:37 am
  • Anyone have any tips for minimizing downtime when upgrading? So far we have done upgrades during scheduled downtimes. Now we are getting to the point where the time required for a standard ...
    SnacktimeSnacktime
    Jun 16, 2006 at 5:09 am
    Jun 23, 2006 at 11:30 am
  • I am having brain freeze right now and was hoping someone could help me with a (fairly) simple query. I need to join on the next row in a similar table with specific criteria. I have a table with ...
    Sim ZacksSim Zacks
    Jun 20, 2006 at 5:26 am
    Jun 30, 2006 at 8:48 pm
  • Greetings all, I have been spending some time looking into how auto-vacuum is performing on one of our servers. After putting the PostgreSQL logs in debug I noticed that the threshold for ANALYZE was ...
    Dylan HansenDylan Hansen
    Jun 22, 2006 at 5:49 pm
    Jun 27, 2006 at 5:05 pm
  • Back in April 2006 I emailed about high OIDs in a 7.4.6 database. I've just added new tables to the database (and the slony-relication set) and I'm seeing much higher OID values for the new tables. ...
    John Sidney-WoollettJohn Sidney-Woollett
    Jun 11, 2006 at 5:38 pm
    Jun 12, 2006 at 8:38 pm
  • What is the point of the create or replace view command if you can't change the column and data types ? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au
    Chris VelevitchChris Velevitch
    Jun 5, 2006 at 1:50 am
    Jun 5, 2006 at 3:15 pm
  • I'm seeing something fairly unintuitive about serializable transactions. Taking the following test case: CREATE TABLE foo (id integer); t1 t2 -- BEGIN; -- SET TRANSACTION ISOLATION LEVEL ...
    Brad NicholsonBrad Nicholson
    Jun 28, 2006 at 6:48 pm
    Jun 30, 2006 at 4:49 am
  • I've written a function in C, compiled it and trying to use the same function in one of my postgres functions like this: CREATE FUNCTION add_one(integer) RETURNS integer AS ...
    Jasbinder BaliJasbinder Bali
    Jun 20, 2006 at 7:54 pm
    Jun 22, 2006 at 7:22 am
  • Moving to -general. From the bottom of that page: SELECT * FROM sources INTO src WHERE source_id = $1; SELECT * is generally something to avoid. You end up shoving around more data than needed. ...
    Jim C. NasbyJim C. Nasby
    Jun 6, 2006 at 10:11 pm
    Jun 14, 2006 at 10:39 am
  • Hi, I have recently switched to PostgreSQL and had no problem bringing our existing (my)SQL databases and data into the environment. I am now extending the functionality of our databases and want to ...
    John TregeaJohn Tregea
    Jun 12, 2006 at 6:25 am
    Jun 13, 2006 at 3:27 am
  • I wrote about this, but I lost the thread. Today I did clean install in a new virtual machine of FreeBSD 5.4, Apache 1.3.36, php 5.1.4 and PostgreSQL 8.1.4 from ports - and apache did core dump ...
    PoboxPobox
    Jun 8, 2006 at 8:47 pm
    Jun 10, 2006 at 1:12 pm
  • Hi, Im trying to upgrade from 7.4 - 8.1 but it is failing with Unicode errors. The offending character is the greek character mu (often used for micro). Here is an offending string "BµG@S" (in case ...
    Adam WitneyAdam Witney
    Jun 9, 2006 at 2:59 pm
    Jun 10, 2006 at 12:09 pm
  • I don't want to revisit or be redundant... but is there a quick and dirty and cross-platform system for developing user input forms for Postgres? Ideally, I am interested in something such that you ...
    Webb SpragueWebb Sprague
    Jun 22, 2006 at 1:07 am
    Jul 6, 2006 at 6:40 pm
  • Hi listers, I am trying to learn PG partioning (constaraint exclustion). I have created pretty simple table (all the code is below), but when I try to populate The table with data, the RULE system is ...
    Milen KulevMilen Kulev
    Jun 12, 2006 at 10:03 pm
    Jun 14, 2006 at 7:44 pm
  • Hi, I wonder if anyone can help. I have a VERY wide table and rows. There are over 800 columns of type: numeric(11,2) I can create the table no problem, but when I go to fill out a full row with ...
    List_manList_man
    Jun 10, 2006 at 5:26 am
    Jun 12, 2006 at 10:07 am
  • Hi all, I hope this is the right forum for this, but please correct me if somewhere else is more appropriate. I need to locate all the entries in a table that match , but only after a number of ...
    BadlydrawnbhoyBadlydrawnbhoy
    Jun 2, 2006 at 9:47 am
    Jun 3, 2006 at 1:22 pm
  • On a tangent to the never-ending NULL debate, I've got a table: CREATE TABLE events ( event_id INTEGER PRIMARY KEY, tag_fk INTEGER REFERENCES tags (tag_id), place_fk INTEGER REFERENCES places ...
    Leif B. KristensenLeif B. Kristensen
    Jun 28, 2006 at 3:14 pm
    Jul 11, 2006 at 9:13 am
  • I'm building an app where I have several entities that are identified using a UUID (i.e. a 128 bit quantity). My current implementation uses a composite primary key consisting of two int8 values. ...
    Thomas HallgrenThomas Hallgren
    Jun 28, 2006 at 7:02 am
    Jun 28, 2006 at 2:42 pm
  • Hello list, I am happy to report that I am seeing a 150% average increase in select performance since I upgraded to 8.1.4. Version -------- PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC ...
    Richard Broersma JrRichard Broersma Jr
    Jun 27, 2006 at 4:47 am
    Jun 28, 2006 at 1:10 pm
  • We have an unusual problem with some perl code that is processing data via DBD facility. Basically, the code consists of various subroutines that are identified in a hash. The primary script then ...
    GeoffreyGeoffrey
    Jun 20, 2006 at 1:52 pm
    Jun 20, 2006 at 8:38 pm
  • hi, I am using postgresql 8.0.0. i have four tables in my database TAB1, has one primary key T1 TAB2 , has 2 fields, one is the primary ley T2 and the other one is the foreign key T1(from TAB1) TAB3 ...
    Surabhi.ahujaSurabhi.ahuja
    Jun 12, 2006 at 7:18 am
    Jun 17, 2006 at 5:48 pm
  • Hi all, let's assume that we keep Unicode text data in the column. sometimes we want to sort it according to specific collation order. how can we force collation when running a query? ideal solution ...
    Filip RembiałkowskiFilip Rembiałkowski
    Jun 5, 2006 at 3:04 pm
    Jun 14, 2006 at 1:12 pm
  • Hi, Most web database applications I've seen use a system separate from the rdbms's user database for managing user privileges. For example, there may be a "users" table, or there may be external ...
    Antonis ChristofidesAntonis Christofides
    Jun 29, 2006 at 7:37 am
    Jul 5, 2006 at 7:47 pm
  • Hi, I raised this problem yesterday aswell. I'm badly stuck at this point. The problem is as follows: I have a C function that i want to use in my postgres function. I adopt the following steps to do ...
    Jasbinder BaliJasbinder Bali
    Jun 21, 2006 at 4:42 pm
    Jun 21, 2006 at 7:29 pm
  • hi all i'm using postgres 7.3 my problem is i want to build a helper table: UPDATE studienmodul_summary SET kategorie = (SELECT kategorie_bezeichnung if the SELECT gives back just one result row, ...
    SimonSimon
    Jun 20, 2006 at 10:32 am
    Jun 21, 2006 at 1:13 pm
  • I read recently about the efforts underway to COPY from a view, however I was wondering what the current best-practices are for being able to copy out of a view and import that data into an actual ...
    Worky WorkersonWorky Workerson
    Jun 20, 2006 at 4:47 pm
    Jun 20, 2006 at 9:00 pm
  • Hi I have started to use ldap for user authentication on my systems. 1 is it possible to get postgres to authenticate against ldap 2 is it advisable to do this ? Alex
    Samad, AlexSamad, Alex
    Jun 14, 2006 at 2:31 am
    Jun 16, 2006 at 3:16 pm
  • Hi, It is possible to copy data from text file (CSV) ignoring some columns of this text file? Thanks, Ricardo Vaz Tribunal de Contas do Estado de São Paulo Diretoria de Tecnologia Rua Venceslau Brás, ...
    Ricardo VazRicardo Vaz
    Jun 23, 2006 at 1:26 am
    Jun 23, 2006 at 3:17 am
  • I am doing some preliminary work on the next major release of a piece of software that uses PostgreSQL. As odd as this sounds, it seems that a huge percentage of the new features that have been ...
    Chris SmithChris Smith
    Jun 19, 2006 at 7:42 pm
    Jun 21, 2006 at 8:31 am
  • When using MySQL I have one select that uses MySQL functions so I am wondering about the best way to go to end up with the same result in PostgreSQL. uid is an email address stored in the passwd ...
    Mark ConstableMark Constable
    Jun 17, 2006 at 4:11 pm
    Jun 19, 2006 at 8:56 pm
  • I'd like to suggest that a feature be added to pg_dumpall to remove tablespace definitions/creation from the output. While the inclusion is important for backups - it's equally painful when ...
    Chander GanesanChander Ganesan
    Jun 16, 2006 at 3:13 am
    Jun 16, 2006 at 9:42 pm
  • Hello,
    Jasbinder BaliJasbinder Bali
    Jun 15, 2006 at 6:24 pm
    Jun 16, 2006 at 10:14 am
  • We recently had a partially failed disk in a RAID-1 configuration which did not perform a write operation as requested. Consequently, the mirrored disks had different contents, and the file which ...
    Florian WeimerFlorian Weimer
    Jun 11, 2006 at 5:43 pm
    Jun 12, 2006 at 8:45 pm
  • I hope I'm reading this query wrong: trend=# select relname, relpages*8192/reltuples from pg_class where reltuples 0 order by relpages desc limit 10; relname | ?column? ...
    Alex TurnerAlex Turner
    Jun 8, 2006 at 10:03 pm
    Jun 11, 2006 at 4:27 am
  • Hi all, this is my first time posting here because I've been running pgsql without problem on a couple of Linux boxes for a while now. I'm migrating to a new MacBook, and while I finally got it to ...
    Jonathon McKitrickJonathon McKitrick
    Jun 7, 2006 at 11:15 am
    Jun 9, 2006 at 7:49 pm
  • Hi, how can one set the global OID counter in 8.1.X? We think it would work in 8.0.X using the COPY WITH OIDS command but this does not work in 8.1.X anymore. We have the problem that we made a dump ...
    Dirk LutzebäckDirk Lutzebäck
    Jun 9, 2006 at 1:46 pm
    Jun 9, 2006 at 5:42 pm
  • I did a clean install of 8.0.8 from ports on FreeBSD 5.4 and tried - ./010.pgsql.sh start ./010.pgsql.sh initdb but there was no reaction. This worked normal - /usr/local/bin/initdb -D ...
    PoboxPobox
    Jun 9, 2006 at 12:42 pm
    Jun 9, 2006 at 1:58 pm
  • Are there any configurations/flags that we should re-set for the database (v 7.4.x) in order to enable a backwards scan on an index? We are trying to query a table in descending order. We added an ...
    Carlos OlivaCarlos Oliva
    Jun 6, 2006 at 2:59 pm
    Jun 7, 2006 at 6:58 am
Group Navigation
period‹ prev | Jun 2006 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions264
posts1,242
users313
websitepostgresql.org
irc#postgresql

313 users for June 2006

Tom Lane: 99 posts Martijn van Oosterhout: 50 posts Jim Nasby: 37 posts Scott Marlowe: 21 posts Alban Hertroys: 20 posts David Fetter: 20 posts Florian G. Pflug: 18 posts Jasbinder Bali: 17 posts Michael Fuhr: 17 posts Qingqing Zhou: 17 posts Dananrg: 15 posts Bruno Wolff III: 15 posts Chris smith: 15 posts Pobox: 15 posts Chris Browne: 14 posts John Sidney-Woollett: 14 posts Magnus Hagander: 14 posts Kenneth Downs: 13 posts Merlin Moncure: 13 posts A.M.: 12 posts
show more
Archives