FAQ

Search Discussions

452 discussions - 1,565 posts

  • I need a guaranteed ordering of transaction IDs as they are queued for asyncronous replication. I'd use the 32-bit internal transaction ID from GetTransactionId(), but 32-bits will not suffice for ...
    Ed L.Ed L.
    Mar 20, 2003 at 9:52 pm
    Apr 14, 2003 at 7:45 pm
  • I'm getting beaten up by the mysql users around me because they claim that MySQL 4.x with InnoDB solves all of the ACID problems, so Pg no longer pulls clearly ahead. Has anyone examined this closely ...
    Randal L. SchwartzRandal L. Schwartz
    Mar 24, 2003 at 2:52 pm
    Mar 26, 2003 at 2:22 am
  • I am trying to integrate MapInfo with a postgresql backend. Problem: MapInfo query uses both quoted and unquoted statements i.e. "MAPINFO"."MAPINFO_MAPCATALOG" and mapinfo.mapinfo_mapcatalog I can ...
    David DelormeDavid Delorme
    Mar 12, 2003 at 2:44 pm
    Mar 18, 2003 at 6:22 pm
  • I posted about this earlier and got no response, but now it's happening again. Can someone please help? We're getting the following error message from PostgreSQL 7.3.2: ERROR: unexpected chunk number ...
    Chris SmithChris Smith
    Mar 26, 2003 at 3:16 pm
    Mar 31, 2003 at 3:38 pm
  • Hi all, We have a problem with our PostgreSQL application. We are trying to decide if this is a major problem with Postgres, or is due to our application design. Our application generates thousands ...
    Andrew BartleyAndrew Bartley
    Mar 24, 2003 at 2:27 am
    Mar 25, 2003 at 3:29 pm
  • I'm trying to find a work-around for blocked inserts in transactions in postgres 7.3. It appears that inserts into tables which reference other tables block inserts until a transaction is committed. ...
    Chris HutchinsonChris Hutchinson
    Mar 26, 2003 at 5:32 am
    Mar 27, 2003 at 11:18 pm
  • I have postgres set to a max connection limit of 512. I have nearly 30,000 users that will be taking a training course over the next 6 weeks. I have 3 web servers load balanced serving php content ...
    Delao, Darryl WDelao, Darryl W
    Mar 10, 2003 at 3:26 pm
    Mar 11, 2003 at 8:46 pm
  • Hi, group, (1) I found system tables are all created without OIDs. But the default behavior of creating user tables are with OIDs. Is there any benefit to create user tables with OIDs? (2) I heard ...
    Flower SunFlower Sun
    Mar 27, 2003 at 8:42 pm
    Apr 1, 2003 at 5:07 pm
  • To get rid of this message, do I increase shared_buffers? ERROR: out of free buffers: time to abort! This is taking place in an UPDATE.
    Joseph ShraibmanJoseph Shraibman
    Mar 10, 2003 at 11:17 pm
    Mar 23, 2003 at 9:58 pm
  • I'm doing some testing of dbmirror, and thinking about async replication of DDL statements such as "CREATE TABLE", etc. Dbmirror uses triggers to queue any modified rows for retrieval by a ...
    Ed L.Ed L.
    Mar 6, 2003 at 5:46 pm
    Mar 8, 2003 at 2:10 am
  • PG-People, Under what circumstances should pg_ctl -m fast fail to shut down the database? I've been having some problems on one server with it not shutting down on command. -- Josh Berkus ...
    Josh BerkusJosh Berkus
    Mar 4, 2003 at 6:39 pm
    Mar 7, 2003 at 10:10 pm
  • I searched the list archives and Google - came up with some extensive discussions about PL/Java in August 2001, but it doesn't look like it ever got going. I would be very interested in contributing ...
    Roman FailRoman Fail
    Mar 13, 2003 at 6:26 pm
    Mar 25, 2003 at 2:46 pm
  • Oh wise ones, Novice trying to install postgresql-7.3.2 on linux. I am not root, but do have sudo priv. I unpacked the tarball in /usr.local/pkg/postgresql-7.3.2. I got as far as adduser which ...
    Charles HauserCharles Hauser
    Mar 10, 2003 at 8:55 pm
    Mar 11, 2003 at 8:33 pm
  • 11

    ssl

    I'm using redhat 8.0 and postgresql 7.2.4 (rpm from postgresql.org). I want to enable ssl. I have edited postgresql.conf to ssl = true. I also follow the 7.3 manual (from postgresql.org) to create ...
    PgPg
    Mar 19, 2003 at 6:33 am
    Mar 24, 2003 at 4:11 am
  • I admit, I suck at math, but I really thought postgres would ERROR on this: foo=# select 1/0; ?column? ---------- (1 row) More surprising is that this does ERROR: foo=# select 1/0.0; ERROR: division ...
    Eric B.RidgeEric B.Ridge
    Mar 7, 2003 at 6:48 pm
    Mar 8, 2003 at 7:28 pm
  • I get a "missing FROM-clause" with the following query. I don't see why as prod_id is a FK in the supposedly missing table ... I also get an error on my ORDER by, even though I am ordering on ...
    Jean-Christian ImbeaultJean-Christian Imbeault
    Mar 28, 2003 at 2:37 am
    Mar 28, 2003 at 6:51 pm
  • Hi, I want to make really advanced query and I'm not sure it's possible... it would be "like that": select A, B, C, D, E, F from TABLE_X ORDER BY D, C, E if A==0 AND B!=0 {A=B*Z.TABLE_Y} if A!=0 AND ...
    Dousak "May (Phoebus Apollonus)"Dousak "May (Phoebus Apollonus)"
    Mar 13, 2003 at 6:56 pm
    Mar 13, 2003 at 11:32 pm
  • i want to disable WAL. 1. an it be done? 2. What lines do i have to modify in postgresql.conf and how? Thank you in advance
    Munteanu GabrielMunteanu Gabriel
    Mar 3, 2003 at 11:43 am
    Mar 5, 2003 at 3:04 pm
  • Two systems both Red Hat running Postgres 7.3.2 Postgres (installed from tar) data is 1.8G total space (half of which is static data touched once a night when I vacuum), there are web pages (Apache ...
    DeJuan JacksonDeJuan Jackson
    Mar 28, 2003 at 4:25 pm
    Apr 1, 2003 at 10:13 am
  • Hello everybody, Can someone tell me the various aspects of Hardware for performance tuning in PostgreSQL 7.3 on a RHL 8 server. How can I determine the required hardware ...
    Abhishek SharmaAbhishek Sharma
    Mar 26, 2003 at 5:52 am
    Mar 27, 2003 at 5:20 pm
  • Hi all, I have a kinda weird postgres sql question for everyone. When running the following SQL commands: delete from xrefmembergroup where membergroupid = 2 ; select 1 as true; insert into ...
    Kurt OverbergKurt Overberg
    Mar 18, 2003 at 6:18 pm
    Mar 20, 2003 at 3:43 pm
  • FYI, my contract with SRA has been renewed for another year, meaning I will continue the next year working on PostgreSQL full time. I want to thank SRA for their support of the PostgreSQL effort by ...
    Bruce MomjianBruce Momjian
    Mar 6, 2003 at 2:47 am
    Mar 18, 2003 at 3:52 am
  • I get this error when vacuuming a table: PANIC: open of /usr/local/pgsql/data/pg_clog/0005 failed: No such file or directory using 7.3.2. Any pointers? -- Eric Cholet
    Eric CholetEric Cholet
    Mar 12, 2003 at 11:48 am
    Mar 12, 2003 at 11:20 pm
  • Hi All I think i found the problem to my previous thread. Since upgrading to 7.3.2 from 7.3.1 im having the following problem. The following line works: SELECT * INTO lft_rgt FROM forum_tree WHERE ...
    Ben-Nes MichaelBen-Nes Michael
    Mar 3, 2003 at 12:05 pm
    Mar 5, 2003 at 10:14 am
  • I've written code to connect to and/or create databases in C. To check my work, I'll open up psql in another console. But if I'm connected to the default database (template1), and attempt to connect ...
    Paul M FosterPaul M Foster
    Mar 19, 2003 at 11:14 pm
    Mar 21, 2003 at 5:08 am
  • I have an indexed column called home_phone, which is of type bigint. How can I search this column efficiently, using LIKE queries? For example: test= SELECT id FROM user WHERE home_phone LIKE ...
    ValerianValerian
    Mar 14, 2003 at 6:26 am
    Mar 17, 2003 at 4:21 am
  • Got 2 corrupted sequences, that I have discovered so far, and fixed them with 'setval'. Is there a way to check all sequences in a database? Something simmilar to reindex but for sequences? Running ...
    Francisco ReyesFrancisco Reyes
    Mar 14, 2003 at 8:00 pm
    Mar 14, 2003 at 9:16 pm
  • There are several databases I'm trying to dump, but I keep running into problems. Could someone please tell me what these error messages mean? (I'm using PostgreSQL 7.0.1). I'm trying to dump a ...
    Ben RamseyBen Ramsey
    Mar 7, 2003 at 8:53 pm
    Mar 12, 2003 at 4:55 pm
  • I'm running Redhat Linux 8. I have registration to the Redhat Network so I'm probably running the latest version of postgre sql available. I also have Redhat Databse v2.1 installed, but whenever I ...
    Ferindo Middleton JrFerindo Middleton Jr
    Mar 31, 2003 at 1:23 am
    Apr 6, 2003 at 1:11 pm
  • We are looking for a DB design program which can reverse engineer a PG database. We want to use this to create revised documentation for the database after changes are made. PG outputs a creation SQL ...
    Paul RosenbergPaul Rosenberg
    Mar 25, 2003 at 11:31 pm
    Mar 31, 2003 at 4:12 pm
  • Some days ago I sent this to pgsql-general-owner@postgresql.org, but received no reply. Let's see if it's noticed here. Thanks. -------- I can't seem to post to the list from my primary address. At ...
    Fernando SchapachnikFernando Schapachnik
    Mar 21, 2003 at 3:30 pm
    Mar 25, 2003 at 2:46 pm
  • PostgreSQL users working with XML may be interested in my post at: http://www.throwingbeans.org/tech/postgresql_and_xml.html It explains the work I did with John Gray to enable XPath in SQL queries ...
    Tom dysonTom dyson
    Mar 14, 2003 at 5:14 pm
    Mar 16, 2003 at 10:57 am
  • I cannot upgrade the existing 7.2.1 installation with the 7.3.2 rpms that Lamar put together. He's looking at the error message to see if it gives him any idea of what went wrong. While I'm running ...
    Rich ShepardRich Shepard
    Mar 8, 2003 at 1:01 am
    Mar 9, 2003 at 8:48 pm
  • I have the following, simplified three tables: CREATE TABLE Usrs( usr_id serial NOT NULL PRIMARY KEY, login varchar(32) UNIQUE, name text NOT NULL); CREATE TABLE EmailAddrs( email_addr_id serial NOT ...
    Dennis GearonDennis Gearon
    Mar 3, 2003 at 5:05 pm
    Mar 4, 2003 at 1:43 am
  • Hi, Who can give us some help with DBMirror ?? We make some test with DBMirror ... for us it's running perfectly ;o) Only one big trouble ... inserting data in transaction ... We try to make one ...
    Hervé PiedvacheHervé Piedvache
    Mar 31, 2003 at 3:41 pm
    Apr 3, 2003 at 6:02 pm
  • The best thing would be to store the lat and lon as point in the table instead of in separate float columns. You can extra the lat and lon using subscripts if you need them broken out. You really ...
    Bruno Wolff IIIBruno Wolff III
    Mar 27, 2003 at 1:05 pm
    Apr 2, 2003 at 4:56 pm
  • I'm seeing some strange behaviour using the int_array_enum function in contrib/intagg. It seems when i set the array to an empty array by hand doing update set level_2_ids = '{}' then int_array_enum ...
    Greg StarkGreg Stark
    Mar 27, 2003 at 3:50 pm
    Mar 27, 2003 at 11:29 pm
  • I agree that bz2 might very well speed up download over a dialup line. I was, however, pointing out that one of the arguments as to why downloads should be available in bz2 format -- to minimize ...
    Daniel R. AndersonDaniel R. Anderson
    Mar 20, 2003 at 4:53 pm
    Mar 24, 2003 at 6:50 am
  • Hi, I know this is rather stupid but still, I have a table which has a timestamp field in it and I need to get only time part of it. i.e. HH:MI format. So far I tried, phd=# select to_timestamp( ...
    "Shridhar Daithankar"Shridhar Daithankar
    Mar 20, 2003 at 4:05 pm
    Mar 23, 2003 at 4:01 pm
  • I understand there is an escaping function for queries in postgres. 1/ Is it in pl/pgsql, and callable from standard queries? 2/ does it handle: A/ 'chr(' B/ ''' C/ '"' D/ '--' E/ ';'
    Dennis GearonDennis Gearon
    Mar 18, 2003 at 12:16 am
    Mar 19, 2003 at 2:40 pm
  • Hello, Running version 7.1, have the following entry in PG_HBA.CONF: --- Local all trust Host all 123.0.0.0 255.255.255.0 password --- With that setting, anyone can login to the database [via our web ...
    James HallJames Hall
    Mar 14, 2003 at 4:22 pm
    Mar 16, 2003 at 10:55 pm
  • Hi all, I am wondering if anyone has any good solutions for having postgres leave an audit trail. Specifically I would like it to copy rows to a ghost table without constraints every time a row is ...
    James GregoryJames Gregory
    Mar 13, 2003 at 3:32 am
    Mar 13, 2003 at 5:31 pm
  • I am sure that I am doing something subtly wrong with my sql syntax here. I thought that it was a timestamp null column issue, but it doesn't work with int either. Is there a special way to denote ...
    Matthew PhillipsMatthew Phillips
    Mar 13, 2003 at 12:47 am
    Mar 13, 2003 at 2:35 am
  • Is there any way to add a foreign key constraint after a table is created? I got this error ----------------- PostgreSQL said: ERROR: parser: parse error at or near "FOREIGN" Your query: ALTER TABLE ...
    Dennis GearonDennis Gearon
    Mar 4, 2003 at 4:02 pm
    Mar 5, 2003 at 2:33 pm
  • Is it possible to do this? INSERT INTO Usrs( first_name, middle_name, sur_name, sur_name_extra, gen_id, login ) VALUES ( 'Dennis'::text, 'Keith'::text, 'Gearon'::text, 'none'::text, (SELECT gen_id ...
    Dennis GearonDennis Gearon
    Mar 3, 2003 at 3:05 am
    Mar 3, 2003 at 5:10 am
  • I am trying to setup the postgres.conf to send all postgres messages to a syslog server. However, in the conf file there is no place to define the host. I will be sending to an external host. How do ...
    Delao, Darryl WDelao, Darryl W
    Mar 28, 2003 at 4:31 pm
    Apr 3, 2003 at 10:17 pm
  • anyone have any recommendations on upgrading postgresql on a redhat 7.1 system? there are no redhat 7.1 rpms for postgresql 7.2 or 7.3. the 7.3 rpms require a newer version of openssl, and that wants ...
    Richard WeltyRichard Welty
    Mar 30, 2003 at 11:31 pm
    Mar 31, 2003 at 10:39 pm
  • This query: connxdatasync=# select "a".OID connxdatasync-# from "CNX_DS2_1_BCHFIL_FILE" "a" connxdatasync-# left outer join "CNX_DS_1_BCHFIL_FILE" "b" on connxdatasync-# ( "a"."FILE_KEY" = ...
    Dann CorbitDann Corbit
    Mar 27, 2003 at 11:29 pm
    Mar 29, 2003 at 6:54 am
  • Hi Guys, I just thought I'd share with you guys a very clever solution to the old 'update row. if no rows affected, then insert the row' race condition problem. A guy at my work came up with it. We ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 27, 2003 at 1:55 am
    Mar 28, 2003 at 5:34 am
  • Hi, I juts tried to load the python module instead of using c as a way to program an interface with the client. I went into python and typed: and I got: /usr/libexec/ld.so: python: libpq-so.3.0: No ...
    Daniel R. AndersonDaniel R. Anderson
    Mar 27, 2003 at 8:55 pm
    Mar 28, 2003 at 2:12 am
Group Navigation
period‹ prev | Mar 2003 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions452
posts1,565
users389
websitepostgresql.org
irc#postgresql

389 users for March 2003

Tom Lane: 170 posts Dennis Gearon: 77 posts Bruce Momjian: 61 posts Scott.marlowe: 53 posts Stephan Szabo: 39 posts Ed L.: 28 posts Doug McNaught: 25 posts Andrew Sullivan: 24 posts Daniel R. Anderson: 21 posts Joe Conway: 20 posts Richard Huxton: 20 posts Martijn van Oosterhout: 19 posts Joshua Moore-Oliva: 18 posts Neil Conway: 17 posts Flower Sun: 15 posts Tom: 15 posts Bruno Wolff III: 14 posts James Gregory: 14 posts Jean-Christian Imbeault: 14 posts Greg Sabino Mullane: 13 posts
show more
Archives