Search Discussions

164 discussions - 1,531 posts

  • Hello, While trying to optimise a query I found that running VACUUM ANALYSE changed all the Index Scans to Seq Scans and that the only way to revert to Index Scans was the add "enable_seqscan = 0" in ...
    Louis-David MitterrandLouis-David Mitterrand
    Apr 16, 2002 at 2:03 pm
    Jun 27, 2002 at 3:38 am
  • OK, would people please vote on how to handle SET in an aborted transaction? This vote will allow us to resolve the issue and move forward if needed. In the case of: SET x=1; BEGIN; SET x=2; ...
    Bruce MomjianBruce Momjian
    Apr 23, 2002 at 4:27 pm
    Apr 30, 2002 at 3:06 am
  • Current CVS tip has most of the needed infrastructure for SQL-spec schema support: you can create schemas, and you can create objects within schemas, and search-path-based lookup for named objects ...
    Tom LaneTom Lane
    Apr 30, 2002 at 5:31 pm
    Jun 12, 2002 at 3:44 am
  • Is anyone feeling we have the 7.3 release nearing? I certainly am not. I can imagine us going for several more months like this, perhaps through August. -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 11, 2002 at 4:51 am
    Apr 18, 2002 at 4:13 am
  • I was originally planning to revise pg_aggregate along the same lines as pg_proc and so forth: add an aggnamespace column and fix the search code to be namespace-aware. But it seemed a tad annoying ...
    Tom LaneTom Lane
    Apr 6, 2002 at 7:27 am
    Apr 18, 2002 at 4:00 am
  • Hi, I'm playing with the new schema functionality. I login to a database as a user yamada. There I created 2 schemas yamada and inoue. By accident I made 2 tables with the same name vs1 in both ...
    Hiroshi InoueHiroshi Inoue
    Apr 4, 2002 at 3:40 am
    Apr 19, 2002 at 9:03 am
  • From here: http://osdb.sourceforge.net/ We find this quote: "For you long-suffering OSDB PostgreSQL users, we offer --postgresql=no_hash_index to work around the hash index problems of OSDB with ...
    Dann CorbitDann Corbit
    Apr 22, 2002 at 9:16 pm
    Jun 22, 2002 at 4:02 am
  • I've been thinking about exactly what to do with access privileges for namespaces (a/k/a schemas). The SQL99 spec isn't much guidance, since as far as I can tell it doesn't have explicit privileges ...
    Tom LaneTom Lane
    Apr 18, 2002 at 11:14 pm
    Apr 22, 2002 at 3:25 am
  • Since I'm about to have to edit pg_proc.h to add a namespace column, I thought this would be a good time to revise the current proiscachable column into the three-way cachability distinction we've ...
    Tom LaneTom Lane
    Apr 2, 2002 at 9:40 pm
    Apr 13, 2002 at 3:34 pm
  • It would be nice if total table cardinality could be maintained live. So (after the initial vacuum) we update the cardinality for each table in the system table (or perhaps add an entry to the table ...
    Dann CorbitDann Corbit
    Apr 5, 2002 at 6:58 pm
    Apr 8, 2002 at 3:23 am
  • Hi Tom, How about we include this and have configure somehow ensure the Solaris users get it automatically? There are a *bunch* of Solaris users out there. :-) Regards and best wishes, Justin Clift ...
    Justin CliftJustin Clift
    Apr 3, 2002 at 8:02 am
    Jun 6, 2002 at 5:49 pm
  • I've applied patches to implement an int64-based data/time storage scheme. I've also accumulated some other minor fixes, which result in an initdb being required (sorry!). Note that the *default* ...
    Thomas LockhartThomas Lockhart
    Apr 21, 2002 at 8:02 pm
    Apr 22, 2002 at 2:57 am
  • The emitted code might or might not be the same --- but duplicate or near-duplicate chunks of source code are always best avoided, if only from a maintenance perspective. Try chasing the references ...
    Tom LaneTom Lane
    Apr 11, 2002 at 3:09 am
    Apr 18, 2002 at 3:26 am
  • Can someone comment on this? I can't decide. --------------------------------------------------------------------------- Andreas Scherbaum wrote: -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 18, 2002 at 3:46 am
    Apr 25, 2002 at 2:34 pm
  • Hi all, I'm working on a fairly large patch (cleaning up Karel Zak's PREPARE/EXECUTE work), and I'm having some problems with bison (I'm a yacc newbie). In fact, my grammar currently has an obscene ...
    Neil ConwayNeil Conway
    Apr 11, 2002 at 1:29 am
    Apr 12, 2002 at 4:20 pm
  • I've detected that the restoring of large objects may consume huge amounts of diskspace when using unusual blocksizes (e.g. 32KB). My setup is Postgresql-7.2.1 + 32KB blocks + LOBLKSIZE 16KB, a ...
    Mario WeilguniMario Weilguni
    Apr 11, 2002 at 8:55 am
    May 3, 2002 at 12:29 pm
  • I posted this some time ago to pgsql-bugs[1], to no response. So I'll venture to try here. Postgres breaks the standard for string literals by supporting C-like escape sequences. This causes pain for ...
    Andrew PimlottAndrew Pimlott
    Apr 24, 2002 at 6:05 pm
    Jun 6, 2002 at 7:27 pm
  • Appended is a message that I sent to the pgsql-general list, and for which I received no useful reply. (Well, anyway, no reply that has helped me to speed up my imports.) If you've read it already, ...
    Curt SampsonCurt Sampson
    Apr 15, 2002 at 6:48 am
    Apr 16, 2002 at 5:15 am
  • After some fooling around with gram.y, I have come to the conclusion that there's just no way to use a schema-qualified name for an operator in an expression. I was hoping we might be able to write ...
    Tom LaneTom Lane
    Apr 15, 2002 at 4:43 pm
    Apr 16, 2002 at 11:03 pm
  • I submitted a patch which would make Postgresql ANSI compliant in regards to INSERT with a provided column list. As Tom states below, this is not full compliance. CREATE TABLE tab(col1 text, col2 ...
    Rod TaylorRod Taylor
    Apr 15, 2002 at 4:01 am
    Apr 16, 2002 at 2:45 am
  • PQescapebytea() is not multibyte aware and will produce bad multibyte character sequences. Example: INSERT INTO t1(bytea_col) VALUES('characters produced by PQescapebytea'); ERROR: Invalid EUC_JP ...
    Tatsuo IshiiTatsuo Ishii
    Apr 5, 2002 at 6:26 am
    Apr 8, 2002 at 3:52 am
  • Can we enable syslog support by default for 7.3? -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Apr 19, 2002 at 2:35 am
    Apr 26, 2002 at 1:57 pm
  • The determination of locale is now done as follows: collate/ctype: initdb --lc-collate, initdb --locale, LC_ALL, LC_COLLATE, LANG messages/monetary/numeric/time: Have GUC variables lc_messages, etc. ...
    Peter EisentrautPeter Eisentraut
    Apr 3, 2002 at 5:47 am
    Apr 4, 2002 at 4:46 am
  • Hi, Would it be an idea to have pg_dump append an ANALYZE; command to the end of its dumps to assist newbies / inexperienced admins? Reason being is that I noticed that when I just restored a 50MB ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 3, 2002 at 1:40 am
    Apr 4, 2002 at 6:14 pm
  • [Please CC any replies, I'm subscribed nomail] Hi, Chapter 7 of the Developers guide in about the Page Format on disk and it's a little out of date not to mention somewhat incomplete. 1. Is there ...
    Martijn van OosterhoutMartijn van Oosterhout
    Apr 20, 2002 at 2:22 pm
    Jun 20, 2002 at 10:27 pm
  • Hi All, With regards to the proposed command.c refactoring... I've done it by removing command.c and replacing it with portal.c alter.c lock.c namespace.c Is that a good idea? Will it break too many ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 3, 2002 at 8:39 am
    Apr 14, 2002 at 11:12 pm
  • I was just fooling around with replacing the existing plain index on pg_trigger.tgrelid with a unique index on (tgrelid, tgname). In theory this should not affect anything --- the code already ...
    Tom LaneTom Lane
    Apr 19, 2002 at 2:02 am
    Apr 23, 2002 at 4:56 pm
  • [I've moved this discussion about changing the line pointer from four bytes to two from -general to -hackers, since it's fairly technical. The entire message Tom is responding to is appended to this ...
    Curt SampsonCurt Sampson
    Apr 20, 2002 at 8:07 am
    Apr 21, 2002 at 7:51 pm
  • Hi all, I've attached an updated version of Karel Zak's pg_qcache patch, which adds PREPARE/EXECUTE support to PostgreSQL (allowing prepared SQL statements). It should apply cleanly against CVS HEAD, ...
    Neil ConwayNeil Conway
    Apr 13, 2002 at 10:47 pm
    Apr 16, 2002 at 3:51 pm
  • Here is the resignation letter from Jordan Hubbard, long time FreeBSD core member. The interesting part is where he explains that being in the core/hackers group isn't fun anymore: ...
    Bruce MomjianBruce Momjian
    Apr 30, 2002 at 1:50 am
    Apr 30, 2002 at 5:10 am
  • I agree that we don't want to reinstate that hack on the gram.y side. However, it seems to me way past time that we did what needs to be done with variable.c --- ie, get rid of it. All these ...
    Tom LaneTom Lane
    Apr 21, 2002 at 9:52 pm
    Apr 22, 2002 at 12:06 am
  • pg_dumping a table having a primary key yields commands like -- -- TOC Entry ID 2 (OID 139812) -- -- Name: table1 Type: TABLE Owner: postgres -- CREATE TABLE "table1" ( "column10" character ...
    Tom LaneTom Lane
    Apr 12, 2002 at 5:28 pm
    Apr 13, 2002 at 7:57 pm
  • Take this update statement: update mytable set foo=foo+1 where bar='xxx'; If that gets executed more than once at the same time by multiple instances of postgresql. Will foo ever lose a count? I am ...
    Apr 3, 2002 at 2:28 pm
    Apr 4, 2002 at 1:38 am
  • Hi all, Why does the password_encryption GUC variable default to false? AFAICT there shouldn't be any issues with client compatibility -- in fact, I'd be inclined to rip out all support for storing ...
    Neil ConwayNeil Conway
    Apr 25, 2002 at 5:21 am
    Apr 25, 2002 at 8:26 pm
  • I'd like to implement *something* to help us collect information on what platforms actually have what features. This would be useful, for example, for figuring out whether any platforms are lacking 8 ...
    Thomas LockhartThomas Lockhart
    Apr 23, 2002 at 5:20 am
    Apr 24, 2002 at 6:28 pm
  • Hi all, Here's an updated version of the experimental qCache patch I posted a couple days ago (which is a port of Karel Zak's 7.0 work to CVS HEAD). Changes: - fix segfault in EXECUTE under some ...
    Neil ConwayNeil Conway
    Apr 17, 2002 at 9:17 pm
    Apr 18, 2002 at 9:04 am
  • On the note of NAMEDATALEN, a view in the INFORMATION_SCHEMA definition is exactly 2 characters over the current limit. ADMINISTRABLE_ROLE_AUTHORIZATIONS Not that it's a great reason, but it isn't a ...
    Rod TaylorRod Taylor
    Apr 16, 2002 at 3:19 am
    Apr 16, 2002 at 6:12 pm
  • I'm running into a minor issue with security in regards to users being able to see constructs that they have no access too. The solution? Information_Schema coupled with no direct access to ...
    Rod TaylorRod Taylor
    Apr 15, 2002 at 1:26 am
    Apr 15, 2002 at 5:01 am
  • Hi everyone, This is Prof. Bayer's response to the question "is it alright to use UB-Tree's in Open Source projects?". It's a "No, but we can discuss a licensing model" type answer. Regards and best ...
    Justin CliftJustin Clift
    Apr 10, 2002 at 2:35 pm
    Apr 12, 2002 at 4:41 pm
  • Hi all, Some questions: 1. What is the difference between abstime and timestamp - they seem to display equally... 2. Since int4 and abstime are binary compatible (ie int4::abstime works), is there ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 4, 2002 at 4:48 am
    Apr 5, 2002 at 3:13 pm
  • Over this past weekend, the PostgreSQL Global Development Group packaged up and put onto our ftp server PostgreSQL v7.2.1 ... a bug fix release, it fixes a critical bug in v7.2: sequence counters ...
    Marc G. FournierMarc G. Fournier
    Apr 2, 2002 at 2:08 pm
    Apr 2, 2002 at 5:30 pm
  • For tracking of Foreign Keys, Check constraints, and maybe NULL / NOT NULL (specific type of check constraint) I intend to create (as per suggestion) pg_constraint. conrelid conname contype ('c'heck, ...
    Rod TaylorRod Taylor
    Apr 26, 2002 at 2:31 am
    Apr 26, 2002 at 5:29 pm
  • The Firebird guys have gotten around to releasing 1.0. If you read this front page spiel, you'll notice that they use MVCC, but with an overwriting storage manager. ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 16, 2002 at 4:35 am
    Apr 16, 2002 at 11:14 pm
  • Has anyone seen this: ERROR: dtoi4: integer out of range on 7.1.3 What worries me, is that at startup time, the log shows: DEBUG: database system was shut down at 2002-04-02 23:16:52 EEST DEBUG: ...
    Daniel KalchevDaniel Kalchev
    Apr 2, 2002 at 8:25 pm
    Apr 3, 2002 at 3:28 pm
  • Appears psql needs to know how to differentiate between it's own temp tables and those of another connection. On the plus side, this takes care of a TODO item to add temp table listings to psql. ...
    Rod TaylorRod Taylor
    Apr 30, 2002 at 1:23 am
    May 25, 2002 at 10:45 pm
  • Assuming the following fetch statement in embedded SQL/C: EXEC SQL FETCH ALL IN selectFromTable_cur INTO :array1, :array2; is memory automatically allocated (by experimentation I guess so)? Should ...
    Lee KindnessLee Kindness
    Apr 25, 2002 at 11:42 am
    May 6, 2002 at 1:59 pm
  • Caveat: I'm not a pg hacker, I apologize in advance if this is a dumb question, but it has been nagging at me, and I don't know who else to ask. If the WAL is a record of all transactions, and if the ...
    Mike BiamonteMike Biamonte
    Apr 24, 2002 at 2:07 pm
    Apr 27, 2002 at 1:18 pm
  • I've been poking at the scanner a bit using the large literal test case from the other day http://archives.postgresql.org/pgsql-hackers/2002-04/msg00811.php I've been able to reduce the wall-clock ...
    Peter EisentrautPeter Eisentraut
    Apr 19, 2002 at 4:57 pm
    Apr 21, 2002 at 2:05 am
  • In my understanding, our consensus was enabling multibyte support by default for 7.3. Any objection? -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Apr 16, 2002 at 1:21 am
    Apr 17, 2002 at 2:10 am
  • RPMs for 7.2.1 are immediately available for download from ftp://ftp.postgresql.org/pub/binary/v7.2.1/RPMS Binary RPMs available are for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC, and the source ...
    Lamar OwenLamar Owen
    Apr 14, 2002 at 3:59 am
    Apr 14, 2002 at 7:59 pm
Group Navigation
period‹ prev | Apr 2002 | next ›
Group Overview
grouppgsql-hackers @

136 users for April 2002

Tom Lane: 314 posts Bruce Momjian: 244 posts Hiroshi Inoue: 73 posts Christopher Kings-Lynne: 72 posts Peter Eisentraut: 70 posts Mark L. Woodward: 46 posts Rod Taylor: 44 posts Curt Sampson: 39 posts Neil Conway: 32 posts Thomas Lockhart: 31 posts Michael Loftis: 29 posts Hannu Krosing: 28 posts Jan Wieck: 28 posts Thomas Lockhart: 28 posts Joe Conway: 27 posts Tatsuo Ishii: 24 posts Gavin Sherry: 19 posts Marc G. Fournier: 18 posts Barry Lind: 17 posts Dann Corbit: 15 posts
show more