Search Discussions

202 discussions - 1,301 posts

  • I noticed OCTET_LENGTH will return the size of the data after TOAST may have compressed it. While this could be useful information, this behaviour has no basis in the SQL standard and it's not what ...
    Peter EisentrautPeter Eisentraut
    Nov 17, 2001 at 5:25 pm
    Nov 26, 2001 at 8:45 am
  • OK, the list is getting smaller fast (thanks for all of the responses!). Here is what I have left currently (note the addition of NetBSD/sparc, which I had inadvertently omitted from the first list): ...
    Thomas LockhartThomas Lockhart
    Nov 29, 2001 at 3:51 am
    Dec 11, 2001 at 6:47 am
  • We have seen very few bug reports since going beta. That means either no one is testing the beta, which I don't believe, or that the beta is quite stable. Maybe we should start thinking about a date ...
    Bruce MomjianBruce Momjian
    Nov 3, 2001 at 9:48 pm
    Nov 14, 2001 at 5:20 pm
  • 48


    Are we doing beta3 soon? I thought we were going to do it yesterday, though it seems like we have a few packaging problems to iron out first. -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Nov 17, 2001 at 6:19 pm
    Nov 26, 2001 at 5:29 pm
  • But this way the password ends up in the environment, which on many systems is visible to other processes/users (via /proc or the 'ps' command). Might as well use "trust"... -Doug -- Let us cross ...
    Doug McNaughtDoug McNaught
    Nov 28, 2001 at 4:18 pm
    Dec 5, 2001 at 9:23 pm
  • OK, 7.2 is looking _very_ good. We have very few open items. They are: Source Code Changes ------------------- Compile in syslog feature by default? (Peter, Tom) AIX compile (Tatsuo) Libpq++ compile ...
    Bruce MomjianBruce Momjian
    Nov 7, 2001 at 3:45 am
    Nov 23, 2001 at 12:55 pm
  • I have not recorded successful tests for the following platforms (I've included the names of folks who reported for the last release, in case they are still able to test or want to hand it off to ...
    Thomas LockhartThomas Lockhart
    Nov 28, 2001 at 4:58 am
    Dec 3, 2001 at 4:09 pm
  • You can see that we have very few open items and beta2 has generated no serious problems since its release on Wednesday. Should we consider a date for RC1? Items postponed for 7.3 are at: ...
    Bruce MomjianBruce Momjian
    Nov 12, 2001 at 6:22 am
    Nov 20, 2001 at 3:53 pm
  • We had a discussion in late September about deprecating the postmaster's -o switch in the 7.2 documentation, with an eye to removing it in 7.3: see thread starting at ...
    Tom LaneTom Lane
    Nov 24, 2001 at 9:24 pm
    Nov 26, 2001 at 7:41 pm
  • Okay ... with everything that has been going on, hardware/server wise, this whole release cycle has turned into one big nightmare ... Unless someone has something they are sitting on, I'd like to ...
    Marc G. FournierMarc G. Fournier
    Nov 5, 2001 at 1:00 pm
    Mar 20, 2002 at 7:44 pm
  • Hi everyone, I have noticed a possibly major issues in Plpython that may need to be addressed before 7.2 is released: 1) If Plpython is installed as a trusted language, and from what little I can ...
    Kevin JacobsKevin Jacobs
    Nov 8, 2001 at 1:40 pm
    Nov 17, 2001 at 7:53 pm
  • Could we add code to detect a partial write when we recover from one using WAL so we can know if these partial writes are ever happening? I am with you on this. There has to be a better way. -- Bruce ...
    Bruce MomjianBruce Momjian
    Nov 17, 2001 at 2:11 am
    Dec 21, 2001 at 3:54 am
  • Currently, if PG has a single-argument function named after its result type, the function is assumed to represent a valid implicit type coercion. For example, I can do regression=# select now() || ...
    Tom LaneTom Lane
    Nov 21, 2001 at 8:24 pm
    Apr 17, 2002 at 7:07 pm
  • Hi all, The following is a description of a patch I am proposing for 7.3. Please read and comment. Thanks Jim This proposal covers the ability to allow a DBA (and general users) to specify where a ...
    Jim ButtafuocoJim Buttafuoco
    Nov 5, 2001 at 2:53 pm
    Mar 5, 2002 at 2:02 pm
  • I have been thinking about postgresql.conf and I have made a few posts already about it. My concern is that Postgres, as default, is not very well tuned. One can even say the default is pretty much a ...
    Mark L. WoodwardMark L. Woodward
    Nov 19, 2001 at 1:47 pm
    Nov 23, 2001 at 4:28 pm
  • This would be an incremental patch to Peter's, but as I said I have not been able to check configure itself. (The rest works, needless to say) I am actually very suspicious whether the configure ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 14, 2001 at 6:00 pm
    Nov 16, 2001 at 6:32 pm
  • It is sort of discouraging that Postgres' default configuration is so conservative. A tweek here and there can make a big difference. It seems to me that the default postgresql.conf should not be ...
    Mark L. WoodwardMark L. Woodward
    Nov 16, 2001 at 1:46 pm
    Nov 18, 2001 at 9:36 am
  • This is a patch that was posted some time ago to pgsql-patches and no one has commented on it. It adds something that JDBC has that is not present in libpq (see below). Is it OK for inclusion? ...
    Fernando NasserFernando Nasser
    Nov 26, 2001 at 7:14 pm
    Aug 25, 2002 at 8:29 pm
  • Okay, PeterE got the appropriate scripts setup, and I just ran the packaging script, which appears to have all gone great ... As usual, I want to give it ~24hrs to perculate through the mirrors ...
    Marc G. FournierMarc G. Fournier
    Nov 22, 2001 at 5:57 pm
    Nov 25, 2001 at 10:12 pm
  • Can someone look at this compiler warning I am seeing in ODBC: --------------------------------------------------------------------------- gcc -O2 -pipe -m486 -Wall -Wmissing-prototypes ...
    Bruce MomjianBruce Momjian
    Nov 1, 2001 at 8:11 pm
    Nov 6, 2001 at 2:45 am
  • While surfing through our web page I found some references about Postgres (the original Berkley project) starting as Ingres. Now I wonder whether we or let's say the original Postgres project still ...
    Michael MeskesMichael Meskes
    Nov 30, 2001 at 9:50 am
    Dec 27, 2001 at 5:00 am
  • Just donwloaded and built 7.2beta3 on Compaq Tru64 (Digital Unix) 4.0 on Alpha architecture and now all regression tests are passed. test=# SELECT version(); version ...
    Alessio BragadiniAlessio Bragadini
    Nov 26, 2001 at 2:36 pm
    Nov 30, 2001 at 11:27 pm
  • Any chance the sequence docs could be updated to indicate sequence bounds (int4)? http://www.postgresql.org/idocs/index.php?sql-createsequence.html Perhaps note that int8 is coming? How do user notes ...
    August ZajoncAugust Zajonc
    Nov 28, 2001 at 2:08 am
    Nov 29, 2001 at 11:13 am
  • 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
  • Is the best method of reloading pg_hba.conf to SIGHUP the master process? David
    David FordDavid Ford
    Nov 9, 2001 at 10:05 pm
    Nov 10, 2001 at 4:11 pm
  • Tom, does a client do a kill() to its parent on password change? If this is true, people can't depend on editing pg_hba.conf and having the change take affect _only_ when they sighup the postmaster. ...
    Bruce MomjianBruce Momjian
    Nov 2, 2001 at 10:14 pm
    Nov 6, 2001 at 4:22 am
  • I've had two overnight crashes with postgresql-7.2b1. Neither logged any useful info in the logfile created by pg_ctl, syslog or messages. The server has one user database with 1148 records. It is ...
    Mr. Shannon AldingerMr. Shannon Aldinger
    Nov 1, 2001 at 3:11 pm
    Nov 2, 2001 at 3:09 pm
  • Is pg_dump supposed to work against prior version databases? I was moving data from an old server (running 7.2devel from several months ago) to a new server (running 7.2b3), using pg_dump on the ...
    Joe ConwayJoe Conway
    Nov 29, 2001 at 4:48 am
    Dec 2, 2001 at 6:29 am
  • I wanted to know if there was a decision to remove the triggered data change violation checks from trigger.c or to change them to a per statement check? I'm building a fix for some foreign key ...
    Stephan SzaboStephan Szabo
    Nov 11, 2001 at 6:54 pm
    Nov 12, 2001 at 10:18 am
  • Hi, I've almost got the ALTER TABLE RENAME fixed so it doesn't break triggers referring to the renamed column. The final problem is that after the pg_trigger.tgargs is updated, that change is not ...
    Brent VernerBrent Verner
    Nov 6, 2001 at 9:38 am
    Nov 10, 2001 at 4:11 pm
  • What's really going on here is that 1. The CREATE TABLE AS command creates a column with type bpchar and typmod -1 (ie, no specific length enforced). 2. pg_dump dumps this column with the type ...
    Tom LaneTom Lane
    Nov 10, 2001 at 6:39 pm
    Dec 5, 2001 at 9:04 pm
  • I was thinking of re-designing my database schema to use a SERIAL value as an indentification across tables (i.e. as a foreign key). I've been playing with some example tables and have found the ...
    Tony ReinaTony Reina
    Nov 28, 2001 at 9:38 pm
    Dec 1, 2001 at 6:45 pm
  • I'm going to look into this, but thought I'd share the misery: CREATE FUNCTION crash() RETURNS varchar AS ' plpy.execute("syntax error") ' language 'plpython'; SELECT crash(); -Brad
    Bradley McLeanBradley McLean
    Nov 9, 2001 at 7:06 pm
    Nov 22, 2001 at 3:49 am
  • Could someone please give me a quick tip as to where in the source code the bit that auto-generates sequence names is? I plan to patch it to stop it generating conflicting names... Cheers, Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 13, 2001 at 10:36 am
    Nov 22, 2001 at 1:34 am
  • Hi! We are using postgres as RDBMS in an web application that is translated to about a dozen different languages. Some users get puzzled about the sorting order in lists, since we have to choose only ...
    Palle GirgensohnPalle Girgensohn
    Nov 17, 2001 at 4:50 pm
    Nov 18, 2001 at 2:18 pm
  • Does anyone have anything outstanding that holds off an RC1? Seen alot of changes over the past week, but mostly in the docs ... haven't seen anything that I think is 'major' that would require a ...
    Marc G. FournierMarc G. Fournier
    Nov 30, 2001 at 7:58 pm
    Dec 4, 2001 at 10:21 pm
  • As most of you probably know, my former employer Great Bridge folded a couple months ago. I am happy to announce that I've accepted a position with Red Hat Inc, working in their database group. I ...
    Tom LaneTom Lane
    Nov 27, 2001 at 8:21 pm
    Nov 28, 2001 at 2:07 am
  • Hi I examined multibyte psql.exe and libpq.dll Yesterday according to the bug report from Hiroshi Saito. At first the compilation didn't work at all and I found the following in src/win32.mak though ...
    Hiroshi InoueHiroshi Inoue
    Nov 23, 2001 at 1:36 am
    Nov 26, 2001 at 12:22 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 11, 2001 at 3:36 am
  • I think the wording is good. I would keep supporting the envar. What exactly speaks against a commandline switch, that gets hidden with the postmaster argv trick, and a similar notice as for ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 30, 2001 at 11:06 am
    Dec 28, 2001 at 3:31 am
  • According to incidents.org, a new worm that infects MS SQL servers is currently spreading fast, and it's being used to lauch distributed denial-of-service attacks against various sites: see ...
    Tom LaneTom Lane
    Nov 25, 2001 at 5:20 am
    Dec 5, 2001 at 8:50 pm
  • Is this behavior intended in the backend? The problem is that when you create a rule on an object that calls a stored function and invoke that rule on an insert/update/delete statement your ...
    Barry LindBarry Lind
    Nov 26, 2001 at 9:02 pm
    Nov 27, 2001 at 9:15 am
  • Okay, now that Vince and I have the DNS re-sorted out, and I'm pulling from the right source, I've rebuilt the packages ... Tom, can you check them over now and let me know if they look okay? Header ...
    Marc G. FournierMarc G. Fournier
    Nov 23, 2001 at 1:35 pm
    Nov 25, 2001 at 2:41 am
  • Dear all, I need to store text documents in PosgreSQL with revision management. Chora PHP cvs library can be used for this purpose. Did anyone think of integrating diff/patch within PostgreSQL? If it ...
    Jean-Michel PoureJean-Michel Poure
    Nov 10, 2001 at 5:30 pm
    Nov 22, 2001 at 5:18 pm
  • I am writing an analysis package that needs to create a table and index on a live system. The problem: I have a program which does data analysis which, when completed, copys the results back to ...
    Mark L. WoodwardMark L. Woodward
    Nov 12, 2001 at 6:04 pm
    Nov 22, 2001 at 3:12 am
  • Hi all, at the moment import/export of large objects on server-side only can be activated for all users by editing config.h due to security reasons. My idea is, to enable in for everyone, when using ...
    Klaus RegerKlaus Reger
    Nov 1, 2001 at 7:07 am
    Nov 20, 2001 at 8:45 am
  • ecpg's tests currently fail because the Makefile refers to a nonexistent test file "testdynalloc". Did you forget to commit this file? regards, tom lane
    Tom LaneTom Lane
    Nov 16, 2001 at 4:28 am
    Nov 16, 2001 at 7:03 pm
  • Hi!! We are developing a project at the Universidad Nacional del Centro, in Argentina. Sergio Pili, who has communicated with you previously, is working with us. We are interested in the feature he ...
    Sergio PiliSergio Pili
    Nov 15, 2001 at 7:32 pm
    Dec 1, 2001 at 11:39 pm
  • Now that we've gone through nearly one development cycle with national language support, I'd like to bring up a number of issues concerning the style of the backend error messages that make life ...
    Peter EisentrautPeter Eisentraut
    Nov 30, 2001 at 6:05 pm
    Nov 30, 2001 at 8:09 pm
  • [ redirected from pgsql-admin ] Luis Amigo <lamigo@atc.unican.es writes: Indeed, a quick look in the C spec says that offsetof is required to have a constant value, so this coding is unportable. I've ...
    Tom LaneTom Lane
    Nov 26, 2001 at 10:39 pm
    Nov 28, 2001 at 3:49 pm
Group Navigation
period‹ prev | Nov 2001 | next ›
Group Overview
grouppgsql-hackers @

151 users for November 2001

Tom Lane: 270 posts Bruce Momjian: 232 posts Peter Eisentraut: 73 posts Marc G. Fournier: 45 posts Thomas Lockhart: 39 posts Christopher Kings-Lynne: 32 posts Tatsuo Ishii: 32 posts Hannu Krosing: 31 posts Andreas Zeugswetter: 30 posts Mark L. Woodward: 24 posts Stephan Szabo: 24 posts Vince Vielhaber: 19 posts Lamar Owen: 18 posts Barry Lind: 15 posts Brent Verner: 15 posts Hiroshi Inoue: 13 posts Bradley McLean: 12 posts Doug McNaught: 12 posts Joe Conway: 12 posts Kevin Jacobs: 12 posts
show more