Search Discussions

190 discussions - 1,396 posts

  • Is is possible to add GNU/GPL licence to the next release of the pgsql in addition to the UCB licence. The UCB licence applies to old code several years ago, but by law it is required to include it ...
    Jan 20, 2002 at 9:03 pm
    Jan 23, 2002 at 12:29 am
  • Continuing to think about implementing SQL schemas for 7.3 ... Today's topic for discussion: which types of Postgres objects should belong to schemas, and which ones should have other name scopes? ...
    Tom LaneTom Lane
    Jan 21, 2002 at 9:29 pm
    Feb 1, 2002 at 1:08 am
  • Hello, I have an table with ca 1.7 million records, with the following structure: Table "iplog_gate200112" Attribute | Type | Modifier -----------+-----------+---------- ipaddr | inet | input | ...
    Daniel KalchevDaniel Kalchev
    Jan 7, 2002 at 6:41 pm
    Jan 16, 2002 at 7:56 pm
  • Hi guys, Michael Devogelaere, the guy who writes the QMail-SQL package has recently started moving away from using PostgreSQL to MySQL. In his experience, MySQL works better. Now, he's just tested ...
    Justin CliftJustin Clift
    Jan 23, 2002 at 11:52 pm
    Feb 1, 2002 at 9:05 pm
  • [2002-01-19 19:40] Murray Prior Hobbs said: Indeed. I just got finished installing a chroot image of redhat-7.2 to test this. I am seeing the same Tcl_CreateInterp problem you mentioned earlier. The ...
    Brent VernerBrent Verner
    Jan 20, 2002 at 11:59 am
    Jan 27, 2002 at 4:00 pm
  • The tuple toaster currently fetches toast-table rows using SnapshotAny. This is quite uncool, because it will in fact find *any* row. Including dead rows resulting from an aborted (or, in 7.2, ...
    Tom LaneTom Lane
    Jan 15, 2002 at 11:46 pm
    Jan 18, 2002 at 7:48 am
  • I am testing pg_upgrade. I successfully did a pg_upgrade of a 7.2 regression database into a fresh 7.2 install. I compared the output of pg_dump from both copies and found that c_star dump caused a ...
    Bruce MomjianBruce Momjian
    Jan 13, 2002 at 4:18 am
    Jan 25, 2002 at 1:15 am
  • Looking at my mailbox, I see _no_ open items for 7.2. Is this a good time for RC1? Tom, can you apply that lwlock patch you are holding? -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Jan 4, 2002 at 5:53 am
    Jan 10, 2002 at 2:49 pm
  • Hi, I have made a new version of pgbench which allows not to update branches and tellers tables, which should significantly reduce the contentions. (See attached patches against current. Note that ...
    Tatsuo IshiiTatsuo Ishii
    Jan 9, 2002 at 1:38 am
    Feb 5, 2002 at 5:03 am
  • I am seeing a bug in CVS in pg_dump/pg_restore with -o: $ dropdb test $ createdb test $ pg_dump -Fc -b -o test /bjm/out $ dropdb test $ createdb test $ pg_restore -v -d test /bjm/out pg_restore: ...
    Bruce MomjianBruce Momjian
    Jan 17, 2002 at 5:49 pm
    Jan 18, 2002 at 7:15 pm
  • I have been experimenting with altering the SPINS_PER_DELAY number in src/backend/storage/lmgr/s_lock.c. My results suggest that the current setting of 100 may be too small. The attached graph shows ...
    Tom LaneTom Lane
    Jan 5, 2002 at 3:53 am
    Jan 6, 2002 at 3:05 am
  • As hinted somewhere within the schema-objects thread, I'm implementing GUC settings that are stored in the pg_shadow and pg_database system catalogs and are activated in sessions for that user or ...
    Peter EisentrautPeter Eisentraut
    Jan 28, 2002 at 9:15 pm
    Feb 21, 2002 at 4:47 am
  • Hi, I just read one of those MySQL-PGSQL comparison on a German Linux magazine that's not exactly known to be well informed. :-) This article really cries for a reply. Here are some extracts: The ...
    Michael MeskesMichael Meskes
    Jan 13, 2002 at 8:53 am
    Jan 14, 2002 at 3:50 pm
  • I just spent some time trying to understand the mechanism behind the "XLogFlush: request is not satisfied" startup errors we've seen reported occasionally with 7.1. The only apparent way for this to ...
    Tom LaneTom Lane
    Jan 12, 2002 at 8:46 pm
    Jan 27, 2002 at 3:54 am
  • I spent the weekend fooling around trying to reduce the time needed to start a fresh backend. Profiling seemed to indicate that much of the time was going into loading entries into the relcache: ...
    Tom LaneTom Lane
    Jan 28, 2002 at 8:27 pm
    Jan 31, 2002 at 3:12 am
  • TODO: I have added a syntax suggested by someone on IRC: * Make it easier to create a database owned by someone who can't createdb, perhaps CREATE DATABASE dbname WITH USER = "user" ...
    Bruce MomjianBruce Momjian
    Jan 3, 2002 at 8:00 am
    Feb 23, 2002 at 2:00 am
  • Is it safe to drop and recreate an index used by a sequence? Over three databases I have these key indexes taking up about a gig of disk space and I need to free it up (since the partition is getting ...
    Vince VielhaberVince Vielhaber
    Jan 25, 2002 at 8:24 pm
    Jan 29, 2002 at 4:28 pm
  • I have talked in the past about a possible implementation of savepoints/nested transactions. I would like to more formally outline my ideas below. We have talked about using WAL for such a purpose, ...
    Bruce MomjianBruce Momjian
    Jan 23, 2002 at 6:19 pm
    Jan 25, 2002 at 11:58 pm
  • RTLD_LAZY allows you to load shared library modules that contain circular references. I don't know if that's useful or just stupid, but on some systems the shared library models are pretty, um, ...
    Peter EisentrautPeter Eisentraut
    Jan 20, 2002 at 9:09 pm
    Feb 15, 2002 at 2:08 am
  • The other day, I did a test build of "everything", which involved specifying 17 command-line arguments to configure. This is probably the reason why some fringe features are not tested very often: ...
    Peter EisentrautPeter Eisentraut
    Jan 30, 2002 at 12:31 am
    Jan 31, 2002 at 8:31 am
  • I got followings with current on AIX 5L using xlc (native AIX compiler): : : : "data.c", line 357.81: 1506-068 (S) Operation between types "void*" and "long" is not allowed. "data.c", line 362.90: ...
    Tatsuo IshiiTatsuo Ishii
    Jan 7, 2002 at 5:28 am
    Jan 8, 2002 at 2:24 pm
  • Morning all ... So far as we can tell, we're *finally* ready for release ... Tom made a few benign commits since rc2 that he feels doesn't warrant an rc3, so we are planning on doing the final ...
    Marc G. FournierMarc G. Fournier
    Jan 30, 2002 at 7:29 pm
    Feb 2, 2002 at 4:00 am
  • Hi, anybody has an experience how is stable postgresql under Windows system ? I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed by very bad performance. Are there something I could ...
    Oleg BartunovOleg Bartunov
    Jan 30, 2002 at 5:38 pm
    Jan 31, 2002 at 9:30 pm
  • Dear all, I would like to know if "Add OR REPLACE" to-do item is on PostgreSQL 7.3 radar list. There is a strong need for : - CREATE OR REPLACE VIEW, - CREATE OR REPLACE TRIGGER. Please let me know ...
    Jean-Michel PoureJean-Michel Poure
    Jan 23, 2002 at 1:44 pm
    Jan 24, 2002 at 6:01 pm
  • PostgreSQL often uses terminology in programs and documentation that is vague and meaningless to anyone who is new to the system or not familiar with the implementation. Users are often heard to ...
    Peter EisentrautPeter Eisentraut
    Jan 18, 2002 at 7:15 pm
    Jan 20, 2002 at 10:23 pm
  • Look at this: $ dropdb lijasdf oiuwqe test DROP DATABASE The create/drop scripts only process the last arguments, ignoring earlier ones. I assume no one wants me to fix it now so I will add this to ...
    Bruce MomjianBruce Momjian
    Jan 3, 2002 at 6:12 pm
    Jan 18, 2002 at 9:00 pm
  • While fooling around some more with profiling of simple queries, I noticed that in some scenarios there are lots of failing lookups in the syscaches. This happens, for example, when trying to resolve ...
    Tom LaneTom Lane
    Jan 30, 2002 at 12:32 am
    Feb 1, 2002 at 11:13 pm
  • Should the permissions of a deleted user get assigned to a new user as in the example below? Martin $ createdb test CREATE DATABASE $ psql test Welcome to psql, the PostgreSQL interactive terminal. ...
    Martin RentersMartin Renters
    Jan 11, 2002 at 7:09 pm
    Jan 26, 2002 at 8:09 am
  • Just started using the pgcrypt 0.4.2 (very cool stuff) and am having some strange errors (not so cool). Can someone make sense of the SQL below? I'm not 100% sure what's going on or not going on... ...
    Sean ChittendenSean Chittenden
    Jan 5, 2002 at 8:50 am
    Jan 7, 2002 at 6:57 pm
  • We are running the 7.2b4 beta server. This join worked last week and today it gets and error: select * from b, d where b.address = d.address; It now fails with the following error: ERROR: ...
    Laurette CisnerosLaurette Cisneros
    Jan 2, 2002 at 9:40 pm
    Jan 7, 2002 at 6:13 pm
  • Over the last two days I have been struggling with running vacuum on a 7.2b4 database that is running in a production environment. This was essentially the first time I ran vacuum on this database ...
    Barry LindBarry Lind
    Jan 2, 2002 at 12:34 am
    Jan 3, 2002 at 12:04 am
  • I notice that in some places we compare the result of getopt(3) to "EOF", and in some other places we compare it to "-1". I think we should standardize on one or the other; anyone have an opinion ...
    Tom LaneTom Lane
    Jan 9, 2002 at 5:58 pm
    Jan 10, 2002 at 12:33 pm
  • I have added this item to TODO: * Consider use of open/fctl(O_DIRECT) to minimize OS caching Web shows it minimized file system caching, perhaps for sequential scans: ...
    Bruce MomjianBruce Momjian
    Jan 4, 2002 at 9:08 pm
    Jan 5, 2002 at 12:28 am
  • Don, does your approach handle directed graphs ( DAG ) ? Actually our module is just a result of our research for new data type which could handle DAGs ( yahoo, dmoz -like hierarchies) effectively in ...
    Oleg BartunovOleg Bartunov
    Jan 25, 2002 at 7:17 pm
    Jan 27, 2002 at 3:18 pm
  • OK, the fix for Trond's autoconf issue is in. I think we could roll RC2 now. Are we in docs freeze yet? I'm working on an overhaul of the plperl chapter of the programmer's guide, and plan to commit ...
    Tom LaneTom Lane
    Jan 24, 2002 at 8:18 pm
    Jan 25, 2002 at 3:11 am
  • Tom asked about pg_upgrade as part of our initdb for timezone. I have made some improvements to pg_upgrade in CVS and have successfully migrated a regression database from a 7.2 to another 7.2 ...
    Bruce MomjianBruce Momjian
    Jan 9, 2002 at 4:03 pm
    Jan 13, 2002 at 6:21 am
  • For an application I have to code I currently implement ON ERROR TRIGGERS which shall be called after UNIQUE, CHECK, NOT NULL and REFERENCES violations. The implementation plan is as follows: 1) Make ...
    Holger KrugHolger Krug
    Jan 4, 2002 at 4:37 pm
    Jan 8, 2002 at 9:21 am
  • Hi! I am preparing the update of the FreeBSD port of PostgreSQL with the upcoming 7.2, and I'm just wondering: is there any performance penalty intoduced by including --with-ssl in the default ...
    Palle GirgensohnPalle Girgensohn
    Jan 4, 2002 at 3:43 am
    Jan 4, 2002 at 1:20 pm
  • I've noticed that in postgresql 7.2b4 and in some contrib(I've seen dbf2pgsql) there are inline variables, I think this is not ANSI code. MIPS PRO compilers did not work with inline unless u use API ...
    Luis AmigoLuis Amigo
    Jan 29, 2002 at 10:57 am
    Jan 31, 2002 at 9:40 am
  • Hi guys, Sorry to say this, but I'm feeling we're getting near to needing a 7.1.4. A lot of places won't upgrade to 7.2 final until a few bug-fix point releases are out the door anyway, and we all ...
    Justin CliftJustin Clift
    Jan 24, 2002 at 10:02 am
    Jan 24, 2002 at 6:57 pm
  • Hi all, I've been thinking implementing auditing for Postgres 7.3 and wanted to see if anyone had any thoughts about it. Auditing would allow a user to log queries executed upon different 'schema' ...
    Gavin SherryGavin Sherry
    Jan 23, 2002 at 10:19 am
    Jan 23, 2002 at 3:51 pm
  • I certainly don't like that. I want to be able to get at the configuration setting without any notice going off. I wouldn't use a printf format string at all. It's not user-friendly -- not everyone ...
    Peter EisentrautPeter Eisentraut
    Jan 17, 2002 at 10:33 pm
    Jan 18, 2002 at 5:20 pm
  • Hi, I hope, that this is not too off topic for this list, but anyway, it should be easy for any PG-expert. I need to run a shell script that logs in to Postgresql, executes a query and logs off ...
    Alexander PucherAlexander Pucher
    Jan 11, 2002 at 3:59 am
    Jan 13, 2002 at 11:50 am
  • Did time become a keyword in 7.2? 7.1.3 allowed it as a column name... 7.2 rejects it. Tks
    Dwayne MillerDwayne Miller
    Jan 4, 2002 at 3:19 am
    Jan 9, 2002 at 5:07 pm
  • Could we remove lines 552-560 of pgbench.c? The behavior that guarded against is long gone, and forcing a checkpoint every few thousand tuples seems to be putting a huge crimp in the speed of pgbench ...
    Tom LaneTom Lane
    Jan 6, 2002 at 5:22 am
    Jan 6, 2002 at 7:47 pm
  • Hi, Is't late to submit new contrib module for 7.2 ? It's almost ready and tested, we have to write README.tree. New module creates new data types 'tree', 'treequery' for tree-like data and provides ...
    Oleg BartunovOleg Bartunov
    Jan 25, 2002 at 2:08 pm
    Mar 8, 2002 at 1:16 am
  • The current version of the interfaces/libpgtcl/Makefile fails to build a shared lib on platforms where the shlib needs to resolve symbols from the loading executable (tclsh) at link time. (only ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jan 9, 2002 at 11:58 am
    Feb 25, 2002 at 11:47 am
  • Hi all, Since I was at first Oracle DBA, I've been told many times at professional trainings that when there is a table wich primary key is generated by a sequence, it is worth create a RTREE index ...
    Jean-Paul ARGUDOJean-Paul ARGUDO
    Jan 25, 2002 at 9:02 am
    Jan 25, 2002 at 5:27 pm
  • AFAIK we are go for 7.2RC1. regards, tom lane
    Tom LaneTom Lane
    Jan 19, 2002 at 5:24 am
    Jan 21, 2002 at 8:10 pm
  • Regarding the licensing thread: Any chance we can limit this topic (and perhaps future ones) to a single list? I think everyone involved reads both HACKERS and GENERAL. Thanks, Greg Sabino Mullane ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jan 22, 2002 at 2:10 am
    Jan 23, 2002 at 12:46 am
Group Navigation
period‹ prev | Jan 2002 | next ›
Group Overview
grouppgsql-hackers @

137 users for January 2002

Tom Lane: 317 posts Bruce Momjian: 185 posts Peter Eisentraut: 66 posts Brent Verner: 40 posts Marc G. Fournier: 39 posts Andreas Zeugswetter: 37 posts Hiroshi Inoue: 34 posts Mark L. Woodward: 32 posts Vince Vielhaber: 29 posts Bill Studenmund: 27 posts Don Baccus: 27 posts Thomas Lockhart: 25 posts Holger Krug: 24 posts Justin Clift: 23 posts Gavin Sherry: 22 posts Christopher Kings-Lynne: 21 posts Jan Wieck: 21 posts Daniel Kalchev: 19 posts Hannu Krosing: 19 posts Oleg Bartunov: 16 posts
show more