Search Discussions

123 discussions - 1,004 posts

  • You might remember that when we released 8.0, the plan was to have a 12-month development cycle for 8.1, unless there were Win32 problems that required complex fixes, in which case we would have a ...
    Bruce MomjianBruce Momjian
    Apr 28, 2005 at 1:02 pm
    May 26, 2005 at 1:52 am
  • Hello, We at Command Prompt are in the process of completing a new rev of plPHP. The new rev will not require the PHP source. It will only require that PHP is installed. In other words it can be ...
    Joshua D. DrakeJoshua D. Drake
    Apr 2, 2005 at 3:11 am
    Apr 5, 2005 at 3:33 pm
  • Greetings, There appears to be some deficiencies in both the documentation of the 'md5' authentication methology (in pg_hba.conf) and in the md5 hash generation which is stored in pg_shadow. The md5 ...
    Stephen FrostStephen Frost
    Apr 20, 2005 at 8:14 pm
    Apr 23, 2005 at 2:00 pm
  • I had a problem using PITR recovery just now. If I do: SELECT pg_start_backup('label'); do my tar SELECT pg_stop_backup(); and stop the server, delete /data, then recover from the tar, delete files ...
    Bruce MomjianBruce Momjian
    Apr 16, 2005 at 6:00 am
    Apr 21, 2005 at 8:33 pm
  • Greg, Well, unusual distributions are certainly tough. But I think the problem exists even for relatively well-distributed populations. Part of it is, I believe, the formula we are using: n*d / (n - ...
    Josh BerkusJosh Berkus
    Apr 23, 2005 at 11:34 pm
    May 4, 2005 at 2:52 am
  • I am very excited to see companies involved in PostgreSQL development. It gives us funding for developers and features that is new for us. We had Fujitsu funding some features for 8.0 and that really ...
    Bruce MomjianBruce Momjian
    Apr 28, 2005 at 5:10 am
    Apr 30, 2005 at 9:40 pm
  • OK, so we need to make a decision. Right now I have Greg's patch that is enabled by "\set ON_ERROR_ROLLBACK on": test= \set ON_ERROR_ROLLBACK on test= BEGIN; BEGIN test= lkjasdf; ERROR: syntax error ...
    Bruce MomjianBruce Momjian
    Apr 25, 2005 at 5:30 pm
    Apr 27, 2005 at 5:37 pm
  • I find the following behavior confusing: neilc=# create table t1 (a int, b int); CREATE TABLE neilc=# create table t2 (a int, b int); CREATE TABLE neilc=# create table t3 (a int, b int); CREATE TABLE ...
    Neil ConwayNeil Conway
    Apr 26, 2005 at 5:31 am
    Apr 28, 2005 at 5:46 am
  • Fetching data from just indexes has been discussed on this list several times before, and it has been told that this can't be done with postgres thanks to MVCC. But this is true only when data is ...
    Hannu KrosingHannu Krosing
    Apr 22, 2005 at 3:17 pm
    Apr 27, 2005 at 1:17 pm
  • We have toyed around with PostgreSQL's WAL structure and we are wondering whether it is (theoretically) possible to replay WAL records coming from a remote host while a system is working in read only ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Apr 24, 2005 at 6:13 am
    Jul 22, 2005 at 4:23 pm
  • Hi! When setting log_statement = all, and using JDBC PreparedStatements, I get $n in the log where the real arguments used to be in previous versions of postgresql: postgres[30059]: [97-1] LOG: ...
    Palle GirgensohnPalle Girgensohn
    Apr 6, 2005 at 1:02 pm
    Apr 11, 2005 at 9:51 pm
  • In parse_func.c there are routines argtype_inherit() and gen_cross_product() that date from Berkeley days. The comments explain their reason for existence thus: * This function is used to handle ...
    Tom LaneTom Lane
    Apr 16, 2005 at 12:04 am
    Apr 20, 2005 at 2:34 pm
  • I think that's great news! If the code is written in a conforming way, I don't see why a new release would be a cause for headaches. And if new compiler releases *are* a cause for headaches, it ...
    Dave HeldDave Held
    Apr 22, 2005 at 2:10 pm
    Apr 24, 2005 at 1:36 pm
  • Hi PSQL Hackers, I have done the following Post to PSQL Performance, but Richard Huxton say it might be a better Idea to post it again on you List so i forward the message. apoc9009@yahoo.de wrote: I ...
    Apr 26, 2005 at 8:34 am
    Apr 28, 2005 at 1:43 am
  • Hi guys, After working on PHP for a few weeks, I see that what they do with their interactive docs is have any comments posted get emailed to the docs list. Do we do this? That was, good comments are ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 14, 2005 at 1:41 am
    Apr 15, 2005 at 3:52 pm
  • Hi, While trying to determine if SPI_cursor_move can rewind (and receiving a great help from the guys at the irc), we found out that since the count parameter is int and FETCH_ALL is LONG_MAX then ...
    Tzahi FadidaTzahi Fadida
    Apr 30, 2005 at 12:26 am
    May 3, 2005 at 7:35 am
  • We've been talking about this long enough ... let's try to actually do it ... In the last go-round, the thread starting here, http://archives.postgresql.org/pgsql-hackers/2004-11/msg00371.php we ...
    Tom LaneTom Lane
    Apr 9, 2005 at 12:50 am
    Apr 9, 2005 at 5:25 am
  • In working on the newsysviews project we've discovered that there's no definitive way to determine if a cast is a system cast (system as in part of postgresql/created by createdb) or not. What ...
    Jim C. NasbyJim C. Nasby
    Apr 10, 2005 at 11:10 pm
    Apr 13, 2005 at 7:43 pm
  • I'm currently finding that the stats regression test fails with bitmapped index scans enabled: *** 62,68 **** WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ...
    Tom LaneTom Lane
    Apr 22, 2005 at 5:59 pm
    Oct 6, 2005 at 2:50 am
  • Folks, At OSDL we're seeing a wierd performance crash on 8.1cvs. What's wierd about it is that it doesn't happen all the time -- about 1 out of 4 test runs. What it looks like happens sometimes is ...
    Josh BerkusJosh Berkus
    Apr 20, 2005 at 6:04 pm
    Apr 24, 2005 at 7:06 pm
  • Greetings, I suggest function for "inet" increment w/ int8 (signed). FUNCTION inet_inc(int, int8) RETURNS inet Function, useful for making address pools (using also existing "inet" compare functions ...
    Ilya A. KovalenkoIlya A. Kovalenko
    Apr 17, 2005 at 8:22 pm
    Apr 20, 2005 at 2:58 pm
  • I've read about changes in CVS head needed to accomodate OUT parameters. I tried to compile PL/Java and it fails (of course). Is there any brief text somewhere that highligts the changes that where ...
    Thomas HallgrenThomas Hallgren
    Apr 12, 2005 at 9:24 am
    Apr 15, 2005 at 6:38 am
  • ================== Date: Fri, 22 Apr 2005 00:15:31 -0700 From: Mark Mitchell <mark@codesourcery.com To: gcc-announce@gcc.gnu.org, gcc@gcc.gnu.org Subject: GCC 4.0.0 has been released GCC 4.0.0 has ...
    Marc G. FournierMarc G. Fournier
    Apr 22, 2005 at 1:56 pm
    Apr 22, 2005 at 10:16 pm
  • I talked to a few people on IRC about this and they didn't think I was nuts, so maybe this is something practical... In a nutshell, my idea is to use the normal transactional/XID code to relocate ...
    Jim C. NasbyJim C. Nasby
    Apr 20, 2005 at 10:06 pm
    Apr 22, 2005 at 6:09 pm
  • Hey guys, The 'Unicode characters above 0x10000' issue keeps rearing its ugly head in the IRC channel. I propose that it be fixed, even backported... This is John Hansen's most recent patch to fix ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 4, 2005 at 3:20 pm
    Apr 11, 2005 at 3:42 am
  • Hi Tom, I've got the impression that you have worked most actively on VACUUM and so I ask you this directly instead of adressing pgsql-hackers list in general. Feel free to correct me :) I have a ...
    Hannu KrosingHannu Krosing
    Apr 25, 2005 at 10:46 am
    May 9, 2005 at 11:57 am
  • Hackers, I'd like to introduce the concept of (dynamically loaded) stream filters that would be used to wrap calls to send/recv by the FE/BE protocol. The initial "StreamFilter" will be a zlib ...
    Brent VernerBrent Verner
    Apr 25, 2005 at 5:32 pm
    Apr 30, 2005 at 11:26 am
  • Hi Tom, I hate to slow you down when you're coding, but it'd be cool if you could explain to me (and other interested parties) what's going on here :) Is this totally rad bitmap index support going ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 21, 2005 at 2:33 am
    Apr 21, 2005 at 3:20 pm
  • A range of WAL/PITR items still need work. I'm fairly sure I won't be doing any of these in time for 8.1, so feel free to have a go. 1. PITR archive recovery could do more to overlap recovery of ...
    Simon RiggsSimon Riggs
    Apr 20, 2005 at 8:31 pm
    Apr 21, 2005 at 1:07 pm
  • While thinking about the use of hand-assigned OIDs for pg_proc and pg_operator, it occurred to me to wonder why we don't have hand-assigned OIDs for all system catalogs and indexes. Currently, most ...
    Tom LaneTom Lane
    Apr 12, 2005 at 9:19 pm
    Apr 18, 2005 at 5:49 pm
  • Hi, My postgresql was running successfully in my Redhat LInux 9. After 1 day when i try to login to the folder /usr/local/pgsql/data to update the ip address i am getting as [root@reset data]# ls ...
    ElayaRaja SElayaRaja S
    Apr 18, 2005 at 4:48 am
    Apr 18, 2005 at 1:36 pm
  • Recent discussions on PERFORM have made me look into some aspects of B-tree index code, especially with regard to bulk loading high volumes of data. I now have cause for concern about the way that ...
    Simon RiggsSimon Riggs
    Apr 14, 2005 at 12:54 pm
    Apr 15, 2005 at 4:31 pm
  • BTW, it would get the right answer if it had recognized the WHERE clause as a range restriction --- it still doesn't know exactly what fraction of rows will match, but its default estimate is a great ...
    Tom LaneTom Lane
    Apr 6, 2005 at 10:09 pm
    Apr 7, 2005 at 9:40 pm
  • As of CVS tip, plpgsql handles output parameters, in the style CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS $$ BEGIN sum := x + y; prod := x * y; RETURN; END; $$ LANGUAGE ...
    Tom LaneTom Lane
    Apr 5, 2005 at 6:28 am
    Apr 5, 2005 at 3:51 pm
  • I took a pg_dump -Fc from a Pg 8.0.1 installation on (Solaris / Sun) with Slony installed and attempted to restore to 8.0.2 on Linux / x86 without Slony installed. pg_restore skipped all of the Slony ...
    Rod TaylorRod Taylor
    Apr 26, 2005 at 6:56 pm
    Sep 11, 2005 at 2:04 am
  • Does anyone know why so many LEFT JOINs are used in psql/describe.c to join to the pg_namespace table, like here: printfPQExpBuffer(&buf, "SELECT c.oid,\n" " n.nspname,\n" " c.relname\n" "FROM ...
    Bruce MomjianBruce Momjian
    Apr 2, 2005 at 3:15 am
    May 11, 2005 at 1:48 am
  • Hello, We are considering submitting a patch for REINDEX ALL. What syntax would we like? REINDEX ALL? REINDEX DATABASE ALL? Sincerely, Joshua D. Drake -- Command Prompt, Inc., Your PostgreSQL ...
    Joshua D. DrakeJoshua D. Drake
    Apr 5, 2005 at 6:51 pm
    Apr 5, 2005 at 11:34 pm
  • I'd like to propose that we abandon the name "PostgreSQL" and rename the project "Postgre", to be pronounced either "post-greh" or "post-gree". This change would have a twofold purpose: it would meet ...
    Michael FuhrMichael Fuhr
    Apr 1, 2005 at 7:40 am
    Apr 1, 2005 at 3:01 pm
  • Greetings, I don't really know if this is the correct place to ask this question, if not please direct me to the correct mailing list. I'm trying to develop a new operator for PostGreSQL (actually ...
    Kim BilleKim Bille
    Apr 18, 2005 at 12:34 pm
    Apr 19, 2005 at 4:12 am
  • Is PostgreSQL supposed to enforce a LATIN1/ISO-8859-1 encoding if that's the database encoding? Because people using this database can happily insert any old non-LATIN1 junk into the database, then ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 12, 2005 at 2:39 am
    Apr 13, 2005 at 3:19 am
  • I get the following error message when I try to do an initdb with CVS HEAD on a Win32 platform: creating configuration files ... ok creating template1 database in data-head/base/1 ... FATAL: access ...
    Thomas HallgrenThomas Hallgren
    Apr 12, 2005 at 1:52 pm
    Apr 12, 2005 at 2:54 pm
  • [ CC'ing hackers to see if anyone else wants to weigh in ] Tom Lane wrote: This would be fine with me. Are there any other opinions out there on what syntax would be best for this feature? (For those ...
    Neil ConwayNeil Conway
    Apr 5, 2005 at 1:18 am
    Apr 11, 2005 at 9:35 pm
  • Hello, pgsql-hackers. I have an idea ( :-) ) about SELECT field1,agregate(field2) FROM view GROUP BY field1; (and its variant SELECT agragate(field2) FROM view) where view is SELECT ... UNION ALL ... ...
    Sokolov YuraSokolov Yura
    Apr 29, 2005 at 11:54 am
    May 25, 2005 at 3:21 pm
  • An example that Elein put up yesterday: http://archives.postgresql.org/pgsql-general/2005-04/msg01384.php caused me to realize that type output functions that depend on additional arguments to ...
    Tom LaneTom Lane
    Apr 30, 2005 at 8:18 pm
    Apr 30, 2005 at 11:36 pm
  • The basic idea is to change register_dirty_segment() to register_opened_segment(). That is, we don't care if a segment is dirty or not, if someone opened it, then we will fsync it at checkpoint time. ...
    Qingqing ZhouQingqing Zhou
    Apr 25, 2005 at 8:16 am
    Apr 26, 2005 at 6:05 am
  • I am about to rip out the code that supports multiple indexscans for OR conditions inside a single IndexScan plan node. As best I can tell, the new-style bitmap-OR code is as fast or faster than the ...
    Tom LaneTom Lane
    Apr 24, 2005 at 6:42 pm
    Apr 25, 2005 at 2:47 am
  • Should that sequence really stick around as an integer, numeric and text field??? test=# create table test (a serial); NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for serial ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 19, 2005 at 5:12 am
    Apr 21, 2005 at 1:54 am
  • Hi, I am unable to restart the PostgreSQL. I am using redhat Linux 9 with postgresql 7.4.5. Unexpectedly due to ups problem my server was shutdown once. After that i am unable to restart the server. ...
    ElayaRaja SElayaRaja S
    Apr 15, 2005 at 6:45 am
    Apr 15, 2005 at 9:01 pm
  • Hi! I'd like to vote in favor of this patch: http://candle.pha.pa.us/mhonarc/patches2/msg00025.html. I know Tom said he didn't really like it, but I'd ask you to reconsider that. My use would be ...
    Magnus HaganderMagnus Hagander
    Apr 15, 2005 at 3:30 pm
    Apr 15, 2005 at 6:38 pm
  • Hi, My buildfarm member, osprey, has been crashing on the union regression test on CVS tip since after march 11th with a segmentation fault. See the backtrace further down. The crash occurs in ...
    Rémi ZaraRémi Zara
    Apr 11, 2005 at 7:33 pm
    Apr 14, 2005 at 8:54 pm
Group Navigation
period‹ prev | Apr 2005 | next ›
Group Overview
grouppgsql-hackers @

144 users for April 2005

Tom Lane: 190 posts Bruce Momjian: 93 posts Alvaro Herrera: 44 posts Christopher Kings-Lynne: 44 posts Joshua D. Drake: 36 posts Simon Riggs: 35 posts Josh Berkus: 29 posts Jim C. Nasby: 28 posts Andrew Dunstan: 24 posts Stephen Frost: 22 posts Greg Stark: 21 posts Marc G. Fournier: 20 posts Neil Conway: 20 posts Dave Held: 18 posts Oleg Bartunov: 16 posts Thomas Hallgren: 16 posts Bruno Wolff III: 13 posts Qingqing Zhou: 12 posts Robert Treat: 12 posts Rod Taylor: 11 posts
show more