FAQ

Search Discussions

152 discussions - 1,553 posts

  • A couple of questions on this. I'm not objecting to the tech stuff itself, but on procedure: 1) Why was this added without any discussion, or even notification, on -hackers before it was done? Last I ...
    Magnus HaganderMagnus Hagander
    Oct 8, 2007 at 2:26 pm
    Oct 19, 2007 at 11:09 am
  • For planning purposes, I think its always a good idea to lay down some dates for the next lot of development milestones. These can be provisional, until declared solid later. So: When is the next ...
    Simon RiggsSimon Riggs
    Oct 22, 2007 at 6:45 pm
    Oct 27, 2007 at 12:22 am
  • Hi, Currently The index implementation in Postgresql does not store the Snapshot information in the Index. If we add the snapshot information into the indexing structure, we will have the following ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Oct 8, 2007 at 6:42 am
    Oct 28, 2007 at 10:28 am
  • I had a thought a week ago. If we update the time zone database for future dates, and you have a future date/time stored, doesn't the time change when the time zone database changes. For example if I ...
    Bruce MomjianBruce Momjian
    Oct 9, 2007 at 3:48 am
    Oct 12, 2007 at 10:07 am
  • Oh, that's interesting. That's actually a sideeffect of us increasing the stack size for the postgres.exe executable in order to work on other things. By default, it burns 1MB/thread, but ours will ...
    Magnus HaganderMagnus Hagander
    Oct 21, 2007 at 9:01 am
    Nov 12, 2007 at 5:21 pm
  • If I run the database under non-archiving mode, and execute the following command: alter table t set tablespace tblspc1; Isn't it possible that the "new t" cann't be recovered?
    Jacky LengJacky Leng
    Oct 16, 2007 at 10:34 am
    Oct 18, 2007 at 4:04 pm
  • Hello, I found lot of discus about this topic. http://www.postgresql.org/docs/faqs.TODO.html http://archives.postgresql.org/pgsql-hackers/2003-08/msg00501.php ...
    Pavel StehulePavel Stehule
    Oct 27, 2007 at 11:40 am
    Apr 11, 2008 at 7:39 pm
  • So where do we stand on the Windows locale/encoding business --- are we happy with the behavior now, or does it still need work? regards, tom lane
    Tom LaneTom Lane
    Oct 16, 2007 at 5:23 pm
    Oct 17, 2007 at 3:25 pm
  • I noticed that if you create a dump on a database containing a money column and a certain locale, this dump is not restorable on a database with a different locale. Most notably, I tried dumping the ...
    Alvaro HerreraAlvaro Herrera
    Oct 4, 2007 at 7:15 pm
    Nov 5, 2007 at 6:28 am
  • Hi All, You knew it was coming.... I have an 8.2 database that has full text searching. I tried to backup/restore it to 8.3 but got lots of errors: <snip ERROR: could not access file ...
    Andy ColsonAndy Colson
    Oct 10, 2007 at 5:29 pm
    Oct 19, 2007 at 11:09 am
  • I've requested this before without response, but I'm asking again because it just caused me pain again: could we get a TODO added to have the planner recognize equivalent IN and EXISTS constructs and ...
    Kevin GrittnerKevin Grittner
    Oct 22, 2007 at 2:31 pm
    Sep 3, 2008 at 9:27 pm
  • We have had very few beta1 issues. I am thinking we should release beta2 next week and perhaps accelerate beta and consider a final release in November rather than December. Because of the length of ...
    Bruce MomjianBruce Momjian
    Oct 20, 2007 at 10:56 pm
    Oct 22, 2007 at 3:48 pm
  • I've been learning much more than I wanted to know about $SUBJECT since putting in the src/port/chklocale.c code to try to enforce that our database encoding matches the system locale settings. ...
    Tom LaneTom Lane
    Oct 6, 2007 at 5:55 pm
    Oct 17, 2007 at 9:33 pm
  • I'm working on some code for pgInstaller that will check the locale and encoding selected by the user are a valid combination. The changes recently added to initdb (which highlighted the UTF-8 issue ...
    Dave PageDave Page
    Oct 9, 2007 at 8:33 pm
    Oct 12, 2007 at 2:45 pm
  • If I am reading the state machine in wparser_def.c correctly, the three classifications of words that the default parser knows are lword Composed entirely of ASCII letters nlword Composed entirely of ...
    Tom LaneTom Lane
    Oct 21, 2007 at 8:48 pm
    Oct 23, 2007 at 10:53 pm
  • There's a gripe over here http://archives.postgresql.org/pgsql-general/2007-10/msg00640.php to the effect that PG should not give a message like "password authentication failure" when the user is ...
    Tom LaneTom Lane
    Oct 14, 2007 at 7:34 pm
    Oct 23, 2007 at 6:28 pm
  • Hi, If i do update and delete operations on a row pointed by cursor's current then only first operation succeeds, second operation fails. Ex. DROP TABLE IF EXISTS tab; create table tab (num int,num2 ...
    Dharmendra GoyalDharmendra Goyal
    Oct 24, 2007 at 9:39 am
    Oct 25, 2007 at 9:27 am
  • I have a few questions from recent attempts to perform a join between two tables, where one table has an integer array in it. Join is of the form: select ... from t1 where col1 = any (select col2 ...
    Simon RiggsSimon Riggs
    Oct 5, 2007 at 12:25 pm
    Oct 6, 2007 at 6:19 pm
  • [ BCC to docs and hackers. Sorry this seems like the only logical way to do this.] I have added the following introductory paragraph to the release notes: This release represents a major leap forward ...
    Bruce MomjianBruce Momjian
    Oct 11, 2007 at 8:05 pm
    Oct 18, 2007 at 8:00 pm
  • Folks, I'm writing up the new GUCs, and noticed that max_prepared_transactions defaults to 5. This is too many for most applications (which don't use them at all) and far too few for applications ...
    Josh BerkusJosh Berkus
    Oct 18, 2007 at 4:23 am
    Oct 19, 2007 at 1:07 pm
  • Update on my testing 8.3beta1 on Solaris. * CLOG reads * Asynchronous Commit benefit * Hot CPU Utilization Regards, Jignesh __Background_:_ We were using PostgreSQL 8.3beta1 testing on our latest Sun ...
    Jignesh K. ShahJignesh K. Shah
    Oct 25, 2007 at 8:25 pm
    Nov 15, 2007 at 8:49 pm
  • I'm trying to solve one TODO item mentioned in src/backend/utils/mmgr/mcxt.c. ---- /* * MemoryContextSwitchTo * Returns the current context; installs the given context. * * This is inlined when using ...
    Zdenek KotalaZdenek Kotala
    Oct 25, 2007 at 1:51 pm
    Oct 30, 2007 at 5:34 pm
  • Reading the commit message about the TZ encoding issue I'm curious why this isn't a more widespread problem. How does gettext now what encoding we want messages in? How do we prevent things like ...
    Gregory StarkGregory Stark
    Oct 5, 2007 at 10:18 pm
    Oct 8, 2007 at 10:41 am
  • I know I haven't been very active for a while here, but I just got to testing the October 3 version a bit prior to getting back to the Java GSS client stuff I promised. There seem to be some funny ...
    Henry B. HotzHenry B. Hotz
    Oct 20, 2007 at 12:12 am
    Oct 28, 2007 at 4:46 am
  • Buildfarm member brown_bat (cygwin/gcc) still isn't happy: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -g ...
    Tom LaneTom Lane
    Oct 4, 2007 at 4:47 am
    Oct 5, 2007 at 5:41 pm
  • Hello this function can help with array's iteration. create function generate_iterator(anyarray) returns setof integer as $$ select i from generate_series(array_lower($1,1), array_upper($1,1)) g(i) ...
    Pavel StehulePavel Stehule
    Oct 18, 2007 at 5:20 am
    Mar 25, 2008 at 12:08 am
  • Following test case is crashing the postgresql-8.3-beta create schema st; CREATE TABLE ST.STUDENT( STUDENT_ID VARCHAR2(10), NAME VARCHAR(50) NOT NULL, NIC CHAR(11), DOB DATE NOT NULL, GENDER CHAR(1) ...
    Sheikh AmjadSheikh Amjad
    Oct 31, 2007 at 2:29 pm
    Nov 8, 2007 at 4:30 pm
  • I think you're confusing checkpoint_timeout and archive_timeout... I seem to recall this behavior having been discussed before, but I can't find it in the archives right now. What is happening is ...
    Tom LaneTom Lane
    Oct 26, 2007 at 10:47 pm
    Oct 29, 2007 at 6:26 pm
  • I encountered PANICs on CentOS 5.0 when I ran write-mostly workload. It occurs only if wal_sync_method is set to open_sync; there were no problem in fdatasync. It occurred on both Postgres 8.2.5 and ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Oct 26, 2007 at 4:21 am
    Mar 25, 2008 at 12:15 am
  • I know its way too late in the game, sorry, but it's a very small patch... I was wondering if this could be added to 8.3: it adds the dbsize to \l in psql. It looks like this: List of databases Name ...
    Andy ColsonAndy Colson
    Oct 31, 2007 at 8:27 pm
    Mar 7, 2008 at 3:56 pm
  • I am doing just that. I'll post it soon. FWIW I disagree with cancelling just any autovac work automatically; in my patch I'm only cancelling if it's analyze, on the grounds that if you have really ...
    Alvaro HerreraAlvaro Herrera
    Oct 25, 2007 at 4:42 pm
    Oct 25, 2007 at 9:05 pm
  • Hello, I've installed on a windows xp machine beta 1 of postgresql 8.3 and pgadmin III 1.8. I've loaded a backup of a database from a 8.2.5 machine, for testing purpose, and tried the new ...
    Roberto IcardiRoberto Icardi
    Oct 22, 2007 at 1:27 pm
    Oct 25, 2007 at 8:46 am
  • Those who have been with the community from long ago might remember discussion about implementing a undo log. The big advantage of this is that it allows UPDATE to _replace_ rows and limits the ...
    Bruce MomjianBruce Momjian
    Oct 20, 2007 at 10:49 pm
    Oct 23, 2007 at 4:26 pm
  • 4.1) To SELECT a random row, use: SELECT col FROM tab ORDER BY random() LIMIT 1; + On bigger tables this solution is slow. Please, find smarter solution on network. 4.6) ILIKE is slow, specially on ...
    Pavel StehulePavel Stehule
    Oct 9, 2007 at 12:28 pm
    Oct 10, 2007 at 2:44 pm
  • Following on from Hiroshi's earlier post: http://archives.postgresql.org/pgsql-hackers/2007-10/msg00324.php Per http://archives.postgresql.org/pgsql-hackers/2007-08/msg01018.php, superusers should be ...
    Dave PageDave Page
    Oct 12, 2007 at 11:20 am
    Oct 12, 2007 at 5:15 pm
  • When I run initdb -E EUC_JP --no-locale, I found following in my postgresql.conf: default_text_search_config = 'pg_catalog.english' The manual says: default_text_search_config (string) Selects the ...
    Tatsuo IshiiTatsuo Ishii
    Oct 5, 2007 at 1:18 am
    Oct 5, 2007 at 3:31 pm
  • Hi, I went through the mailing list and couldn't get answer to the question. a) Is there a proposal in place for going back in time within a transaction? -- Thanks, Gokul. CertoSQL Project, Allied ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Oct 31, 2007 at 10:31 am
    Nov 1, 2007 at 10:21 am
  • Interesting ... may I inquire what is this for? And why was it applied so late in the cycle, without any previous proposal or discussion? -- Alvaro Herrera http://www.flickr.com/photos/alvherre/ "The ...
    Alvaro HerreraAlvaro Herrera
    Oct 30, 2007 at 2:44 pm
    Oct 30, 2007 at 11:44 pm
  • It's my company, if course I am ;)... but not in this thread. If you are interested feel free to email me directly or start a new thread. Good :) Here come my questions : seems that you don't do ...
    Hannu KrosingHannu Krosing
    Oct 11, 2007 at 10:57 am
    Oct 12, 2007 at 11:43 am
  • While poking at the complaint reported here: http://archives.postgresql.org/pgsql-general/2007-10/msg01484.php I realized that there is a related issue for null defaults. Consider create table p (f1 ...
    Tom LaneTom Lane
    Oct 28, 2007 at 4:44 pm
    Oct 28, 2007 at 11:56 pm
  • Hi hackers, Just looked at the new features of 8.3 and realized that positioned updates/deletes is now possible with this new release... We would use that if we could define the cursor name with a ...
    Sebastien FLAESCHSebastien FLAESCH
    Oct 26, 2007 at 10:08 am
    Oct 28, 2007 at 7:46 am
  • Getting much further now - now they all build :-) But I'm getting a couple of failures in autoprep and oldexec. Diffs attached. Pointers? //Magnus
    Magnus HaganderMagnus Hagander
    Oct 3, 2007 at 11:54 am
    Oct 12, 2007 at 10:41 am
  • Is it intentional that dblink's unnamed connections don't get re-used? stats=# select datname, usename from pg_stat_activity; datname | usename ---------+--------- stats | decibel (1 row) stats=# ...
    Decibel!Decibel!
    Oct 18, 2007 at 2:09 pm
    Mar 25, 2008 at 12:07 am
  • Hi all, it seems that the stats collector on my box is using more CPU than it did in the past. This is what I'm observing: CPU usage for the stat process: 25% flat $ psql -c "select version()" ...
    Gaetano MendolaGaetano Mendola
    Oct 29, 2007 at 9:01 am
    Oct 29, 2007 at 10:07 am
  • Hi, Is initdb supposed to pick up reasonable TS configurations in general? If so, it's failing for me: initdb: could not find suitable text search configuration for locale fr_CA.UTF-8 The default ...
    Alvaro HerreraAlvaro Herrera
    Oct 24, 2007 at 7:51 pm
    Oct 25, 2007 at 10:52 pm
  • Hellow, I continue to have problems using the debugger, can not achieve any breakpoint that is outside the postmaster.c? Can anyone give me any hint? Where do I mark a breakpoint so that I can follow ...
    Pedro BelminoPedro Belmino
    Oct 19, 2007 at 11:23 am
    Oct 20, 2007 at 8:43 am
  • Hi hackers, I note that if you pass NULL to quote_literal(), you get NULL. This isn't surprising, but I was thinking that the stated purpose of quote_literal is preparing the argument for entry into ...
    Brendan JurdBrendan Jurd
    Oct 10, 2007 at 4:57 am
    Oct 11, 2007 at 8:10 am
  • Hi, I have been doing my master degree research and I am using Postgresql 8.2.5. I would appreciate if anyone could help me, ASAP, concerning the following question: How can I obtain the time spent ...
    Camilo PortoCamilo Porto
    Oct 27, 2007 at 2:46 am
    Nov 1, 2007 at 3:52 pm
  • Hi In looking at current developments in computers, it seems we're nearing a point where a fundamental change may be possible in databases... Namely in-memory databases which could lead to huge ...
    DanDan
    Oct 25, 2007 at 3:10 pm
    Oct 31, 2007 at 7:01 am
  • Hello. I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL 8.1.10. I'm on WindowsXP and I'm compiling with Visual C++ 6.0. I have a very simple routine that works fine with the 8.0.3 version: ...
    Boergesson, CherylBoergesson, Cheryl
    Oct 18, 2007 at 1:24 pm
    Oct 27, 2007 at 2:29 pm
Group Navigation
period‹ prev | Oct 2007 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions152
posts1,553
users141
websitepostgresql.org...
irc#postgresql

141 users for October 2007

Tom Lane: 275 posts Magnus Hagander: 99 posts Simon Riggs: 84 posts Gregory Stark: 71 posts Alvaro Herrera: 66 posts Bruce Momjian: 62 posts Heikki Linnakangas: 60 posts Andrew Dunstan: 50 posts Pavel Stehule: 45 posts Joshua D. Drake: 42 posts Dave Page: 41 posts Gokulakannan Somasundaram: 37 posts Peter Eisentraut: 30 posts Hannu Krosing: 24 posts Josh Berkus: 21 posts Kevin Grittner: 20 posts Marko Kreen: 20 posts Tatsuo Ishii: 18 posts Brendan Jurd: 17 posts Florian G. Pflug: 16 posts
show more
Archives