FAQ

Search Discussions

174 discussions - 1,323 posts

  • The debate on the configuration file sparked a memory of an old patch I submitted in 7.1 days. One of the things I do not like about PostgreSQL is, IMHO, is a backwards configuration process. Rather ...
    Mark L. WoodwardMark L. Woodward
    Feb 11, 2003 at 6:38 pm
    Feb 19, 2003 at 4:40 pm
  • OK, Here's a stab at some extra conf files. Feel free to shoot them down. If we can come up with at least _some_ alternative files that we can put somewhere for them to see when postgres is ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 14, 2003 at 6:14 am
    Feb 19, 2003 at 11:32 pm
  • That's just hiding the most visible symptom. The real problem here is that the SELECT is already committed, when it shouldn't be. regards, tom lane
    Tom LaneTom Lane
    Feb 20, 2003 at 5:40 pm
    Mar 27, 2003 at 4:51 am
  • Simple script: CREATE TABLE test(a int); \copy test from '/tmp/wow' select * from test; now produce error: \copy: COPY state must be terminated first I missed something? -- Teodor Sigaev ...
    Teodor SigaevTeodor Sigaev
    Feb 19, 2003 at 11:00 am
    May 10, 2005 at 12:54 pm
  • Postgres has a bad habit of becoming very confused if the page header of a page on disk has become corrupted. In particular, bogus values in the pd_lower field tend to make it look like there are ...
    Tom LaneTom Lane
    Feb 17, 2003 at 7:41 pm
    Apr 6, 2003 at 10:30 pm
  • Folks, I think we should PGP sign all the "official" packages that are provided for download from the various mirror sites. IMHO, this is important because: - ensuring that end users can trust ...
    Neil ConwayNeil Conway
    Feb 3, 2003 at 12:39 am
    Feb 12, 2003 at 2:15 pm
  • I've been thinking hard for the last few days about how to do space reclamation in b-tree indexes, i.e., recycle pages that are in no-longer-useful portions of the tree structure. We know we need ...
    Tom LaneTom Lane
    Feb 12, 2003 at 10:42 pm
    Mar 7, 2003 at 5:48 am
  • Hello, We recently upgraded a project from 7.2 to 7.3.1 to make use of some of the cool new features in 7.3. The installed version is CVS stable from yesterday. However, we noticed a major ...
    WadeWade
    Feb 1, 2003 at 12:50 am
    Feb 17, 2003 at 10:09 pm
  • 24

    ILIKE

    AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when lower(expr) LIKE 'foo' provides a solution that can use an index and is more standard, too? -- Peter Eisentraut peter_e@gmx.net
    Peter EisentrautPeter Eisentraut
    Feb 22, 2003 at 12:33 am
    Mar 6, 2003 at 4:07 pm
  • How's this issue going on the 7.4 development tree? I saw it on the TODO list, but didn't find much on the archives of this mailing list. -- Porqué usar una base de datos relacional cualquiera, si ...
    Martin MarquesMartin Marques
    Feb 7, 2003 at 1:49 pm
    Feb 15, 2003 at 10:30 pm
  • I need two answers I did not find in documentation : How can I get exact number of rows in DECLARED CURSOR ? OK, I can FETCH until NULL, but this does not fits my needs ! How can I get information is ...
    Darko PrenosilDarko Prenosil
    Feb 24, 2003 at 7:10 pm
    Mar 7, 2003 at 8:03 pm
  • OK, this is the problem: I want to write a bit of SQL that if a row exists in a table, then update it, otherwise it will update it. Problem is, there is a very high chance of simultaneous execute of ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 17, 2003 at 1:51 am
    Feb 25, 2003 at 4:05 am
  • It's interesting that people focus on shared_buffers. From my experience the most dominating parameter for performance is wal_sync_method. It sometimes makes ~20% performance difference. On the ...
    Tatsuo IshiiTatsuo Ishii
    Feb 12, 2003 at 1:09 am
    Feb 14, 2003 at 4:20 pm
  • Hi Everyone, I have just completed a basic set of benchmarking on our new database server. I wanted to figure out a good value for shared_buffers before we go live. We are a busy ecommerce-style ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 12, 2003 at 4:53 am
    Feb 14, 2003 at 2:18 pm
  • I have just committed the latest version of Henry Spencer's regex package (lifted from Tcl 8.4.1) into CVS HEAD. This code is natively able to handle wide characters efficiently, and so it avoids the ...
    Tom LaneTom Lane
    Feb 5, 2003 at 6:10 pm
    Feb 11, 2003 at 5:32 pm
  • My concern here is that what (for example) Bruce decides is not a useful addition to the docs themselves, maybe something that would have helped me with some bizarre problem. If we dump *all* the ...
    Dave PageDave Page
    Feb 2, 2003 at 9:27 pm
    Feb 4, 2003 at 12:10 pm
  • One of the functions of the DBA is to monitor what people are doing to the database. My experience is that "ps" is often sorely lacking in this regard: its output is somewhat limited, from what I've ...
    Kevin BrownKevin Brown
    Feb 14, 2003 at 7:17 pm
    Mar 20, 2003 at 6:51 pm
  • I just dumped and restored a rather large database, I upgraded from 7.2.x to 7.3.x. When I went to test my application against the new database, it was dog slow. It had all the indexes, and looked ...
    Mark L. WoodwardMark L. Woodward
    Feb 27, 2003 at 5:43 pm
    Mar 18, 2003 at 5:05 pm
  • Hi guys, Looking at the log_duration postgresql.conf option. How about adding an option log_duration_min which is a value in milliseconds that is the minimum time a query must run for before being ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 11, 2003 at 3:05 am
    Mar 14, 2003 at 7:27 pm
  • I am trying to emulate a pessimistic locking system you would find in an old school database file system, for example cobol. Generally, when a cobol program tries to read a record that is locked by ...
    Merlin MoncureMerlin Moncure
    Feb 26, 2003 at 5:34 pm
    Feb 28, 2003 at 6:02 pm
  • While looking at this recent bug report (which still fails in CVS tip) http://archives.postgresql.org/pgsql-bugs/2003-02/msg00094.php I realized that the code paths that putatively exist for machines ...
    Tom LaneTom Lane
    Feb 20, 2003 at 3:36 am
    May 19, 2003 at 10:06 pm
  • I've been thinking about improving the algorithm that the free space map (FSM) uses to decide what to store when it's not got enough shared memory to keep track of everything. The present design uses ...
    Tom LaneTom Lane
    Feb 26, 2003 at 8:57 pm
    Feb 28, 2003 at 12:44 am
  • Hi Everyone, I've just spent the last day and a half trying to benchmark our new database installation to find a good value for wal_buffers. The quick answer - there isn't, just leave it on the ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 13, 2003 at 5:16 am
    Feb 15, 2003 at 8:36 am
  • For Win32, in order to emulate fsync() we will need to call FlushFileBuffers(): http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/ base/flushfilebuffers.asp
    Dann CorbitDann Corbit
    Feb 3, 2003 at 8:15 pm
    Feb 4, 2003 at 1:18 pm
  • I'm seeing a regression failure on the horology test on two different machines. I'd venture a guess that it is related to this change: ...
    Joe ConwayJoe Conway
    Feb 22, 2003 at 6:56 am
    Mar 20, 2003 at 4:45 am
  • OK, I have discovered a problem with my auto-naming patch. It's do to with dumping serial columns with pg_dump, eg: -- -- TOC entry 2 (OID 1004551) -- Name: users_users; Type: TABLE; Schema: public; ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 21, 2003 at 7:23 am
    Mar 6, 2003 at 2:30 am
  • Hello postgres hackers, Been a while since I have participated on this list ... but I have a new itch to scratch.... Although the table schema is immaterial, I will provide it so we have a common ...
    Ryan BradetichRyan Bradetich
    Feb 17, 2003 at 6:12 am
    Feb 18, 2003 at 5:38 pm
  • I've spent some time in the past thinking about this, and here's the best idea that I can come up with: Part one: setup an ALTER TABLE directive that allows for the addition/removal of cached ...
    Sean ChittendenSean Chittenden
    Feb 1, 2003 at 4:10 am
    Feb 3, 2003 at 12:28 am
  • Speculation time: do you have the IPv6 code compiled in? I don't. regards, tom lane
    Tom LaneTom Lane
    Feb 13, 2003 at 11:56 pm
    Feb 14, 2003 at 5:21 pm
  • This patch adds a note to the documentation describing why the performance of min() and max() is slow when applied to the entire table, and suggesting the simple workaround most experienced Pg users ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Feb 2, 2003 at 9:48 am
    Feb 17, 2003 at 10:52 pm
  • Well the results are finally in. Hopefully we can concentrate on putting them right, rather than having a round of "told you so's" :-) I modified the test program slightly to improve the consistency ...
    Dave PageDave Page
    Feb 3, 2003 at 4:53 pm
    Feb 3, 2003 at 10:40 pm
  • Hi, I just noticed a bug in adddepend: The below commands will upgrade the foreign key style. Shall I execute them? DROP TRIGGER "RI_ConstraintTrigger_1105102" ON news_authors; DROP TRIGGER ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 21, 2003 at 3:09 am
    Mar 7, 2003 at 2:02 am
  • Require DROP COLUMN CASCADE for a column that is part of a multi-column index Do we want the same behaviour for PRIMARY KEY(col1, col2)? CHECK(col1 col2)? etc. as well? I'm thinking probably... -- ...
    Rod TaylorRod Taylor
    Feb 23, 2003 at 4:30 am
    Mar 6, 2003 at 6:40 pm
  • Dear Friends, As a minor contributor to pgAdmin, I would like to express ideas as regards the Windows port. As a personal point of view, it may or may not reflect the community ideas, who knows. ...
    Jean-Michel PoureJean-Michel Poure
    Feb 12, 2003 at 12:33 pm
    Feb 12, 2003 at 4:41 pm
  • So one of the items on the TODO list is "Add hash for evaluating GROUP BY aggregates (Tom)" I'm finding this would benefit a lot of my queries. Most of the time seems to be going into sorts for group ...
    Greg StarkGreg Stark
    Feb 11, 2003 at 2:48 pm
    Feb 12, 2003 at 5:11 am
  • I've written PL/R to make use of the contrib build system, and modelled its Makefile after other contrib modules. One user who tried installing PL/R under OS X sent me this: The makefile does gcc ...
    Joe ConwayJoe Conway
    Feb 20, 2003 at 6:30 pm
    Mar 6, 2003 at 5:05 am
  • Hi, The new cluster is cool in that : 1. It works 2. It saves the indisclustered status However, after a dump and restore, this indisclustered status will be lost. Would it be an idea to issue a ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 21, 2003 at 8:10 am
    Feb 24, 2003 at 3:29 am
  • I've got a 6-way SGI Challenge L with R4400/200 cpu's in it, and a gig of interleaved ram. I am running postgres 7.3.1, which I compiled 64-bit with MIPSPro. The database is living on an ultrawide ...
    Alex avrietteAlex avriette
    Feb 3, 2003 at 5:05 am
    Feb 11, 2003 at 2:45 am
  • While using PL/R in a web based application, I noticed that the library load and initialization time is significant enough to be annoying. So I wrote a quick hack to load and initialize the library ...
    Joe ConwayJoe Conway
    Feb 13, 2003 at 4:17 am
    May 28, 2003 at 5:12 pm
  • This example in User's Guide section 7.2 doesn't work anymore at all: tgl= select @ text '-4.5' as "abs"; abs ----- 4.5 (1 row) What really happens is this: = select @ text '-4.5' as "abs"; ERROR: ...
    Peter EisentrautPeter Eisentraut
    Feb 24, 2003 at 7:35 pm
    Mar 20, 2003 at 4:17 pm
  • bash-2.05b$ ./psql newempty < file.txt SET You are now connected as new user rbt. SET REVOKE GRANT ERROR: dependent privileges exist (use CASCADE to revoke them too) The above is from the result of ...
    Rod TaylorRod Taylor
    Feb 23, 2003 at 5:16 am
    Mar 17, 2003 at 5:32 pm
  • PostgreSQL Extended Configuration Patch Mohawk Software, 2003 This patch enables PostgreSQL to be far more flexible in its configuration methodology. Specifically, It adds two more command line ...
    Mark L. WoodwardMark L. Woodward
    Feb 19, 2003 at 2:36 am
    Feb 20, 2003 at 12:18 am
  • I noticed a pretty obscure deadlock condition with REINDEX in CVS HEAD: client1: nconway=# create table a (b int unique, c int unique); CREATE TABLE nconway=# begin; BEGIN nconway=# lock table a in ...
    Neil ConwayNeil Conway
    Feb 17, 2003 at 10:27 pm
    Feb 18, 2003 at 2:07 pm
  • This is a patch that allows PostgreSQL to use a configuration file that is outside the main database directory. It adds one more command line parameter, "-C" which specifies the location of the ...
    Mark L. WoodwardMark L. Woodward
    Feb 17, 2003 at 5:47 pm
    Feb 17, 2003 at 8:07 pm
  • Hi! Is there any way to adjust dumps from postgresql 7.3 for use by version 7.2 and vice versa ? Or is there a way to transport a full database via csv or in any other kind to 7.2 and vice versa ? We ...
    Ulf RehmannUlf Rehmann
    Feb 12, 2003 at 9:12 pm
    Feb 13, 2003 at 4:31 pm
  • I was trying from the postgresql.org download web page and following the mirror links there...and none of them that I was able to get to (some of them didn't work) showed 7.3.2. The second link you ...
    Laurette CisnerosLaurette Cisneros
    Feb 5, 2003 at 8:41 pm
    Feb 6, 2003 at 6:30 pm
  • The plan for 7.3.2 release is for Marc to wrap the tarball tomorrow and announce on Tuesday. I have already stamped the version number and updated the release history in CVS, but is there anyone out ...
    Tom LaneTom Lane
    Feb 2, 2003 at 7:59 pm
    Feb 3, 2003 at 2:53 am
  • As you may have noticed we have recently revamped the Interactive Documentation on the website (http://www.postgresql.org/docs). This has raised a couple of questions about how the idocs should work, ...
    Dave PageDave Page
    Feb 2, 2003 at 8:22 pm
    Feb 3, 2003 at 1:01 am
  • Hi guys, I notice that we're still dumping CHECK constraints as part of the CREATE TABLE statement, and not as an ALTER TABLE statement after the data has been loaded. Should we move it to after the ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 26, 2003 at 6:47 am
    Feb 28, 2003 at 11:48 pm
  • Good evening, tonight while running my routine vacuum, the following came up on my screen: ---8<--------------- NOTICE: Rel xamefiles: Uninitialized page 708135 - fixing NOTICE: Rel xamefiles: ...
    Paul L DanielsPaul L Daniels
    Feb 13, 2003 at 5:32 am
    Feb 19, 2003 at 12:32 am
Group Navigation
period‹ prev | Feb 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions174
posts1,323
users165
websitepostgresql.org...
irc#postgresql

165 users for February 2003

Tom Lane: 238 posts Bruce Momjian: 116 posts Christopher Kings-Lynne: 69 posts Kevin Brown: 47 posts Mark L. Woodward: 45 posts Curt Sampson: 39 posts Peter Eisentraut: 37 posts Greg Copeland: 30 posts Hannu Krosing: 25 posts Rod Taylor: 23 posts Lamar Owen: 22 posts Neil Conway: 22 posts Scott.marlowe: 21 posts Dave Page: 20 posts Justin Clift: 19 posts Oliver Elphick: 19 posts Merlin Moncure: 18 posts Bruno Wolff III: 16 posts Christoph Haller: 16 posts Greg Stark: 16 posts
show more
Archives