Search Discussions

205 discussions - 1,220 posts

  • Hi guys, Just out of interest, if someone was going to pay you to hack on Postgres for 6 months, what would you like to code for 7.4? My ones are: * Compliant ADD COLUMN * Integrated full text ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 29, 2002 at 6:57 pm
    Dec 11, 2002 at 7:18 am
  • Wow, this sounds great. Where can I get a copy? Why would anyone use anything else? ;-) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard ...
    Bruce MomjianBruce Momjian
    Nov 28, 2002 at 8:16 pm
    Dec 16, 2002 at 7:15 am
  • Hm. So the "while read line" loop is iterating only once. I was thinking to myself that something within the while loop must be eating up stdin, so that there's nothing left for the "while read" to ...
    Tom LaneTom Lane
    Nov 13, 2002 at 12:04 am
    Nov 25, 2002 at 9:49 pm
  • I am including a set of 4 small patches that enable PostgreSQL 7.3b3 to build successfully on OpenUnix 8.0. These same patches should also work for UnixWare 7.x. I will confirm that tomorrow (Nov 7, ...
    Billy G. AllieBilly G. Allie
    Nov 7, 2002 at 3:57 am
    Nov 9, 2002 at 4:22 pm
  • I am going to work on nested transactions for 7.4. My goal is to first implement nested transactions: BEGIN; SELECT ... BEGIN; UPDATE; COMMIT; DELETE; COMMIT; and later savepoints (Oracle): BEGIN; ...
    Bruce MomjianBruce Momjian
    Nov 22, 2002 at 5:32 am
    Dec 10, 2002 at 3:24 am
  • I have copies of Peer Direct's (Jan's company) port of PostgreSQL to Win32, and SRA's port to Win32, and permission to generate a merged patch that can be applied to 7.4. Now that 7.3 is almost ...
    Bruce MomjianBruce Momjian
    Nov 6, 2002 at 6:19 am
    Nov 9, 2002 at 4:25 pm
  • There has been some previous discussion of changing the FE/BE protocol in 7.4, in order to fix several problems. I think this is worth doing: if we can resolve all these issues in a single release, ...
    Neil ConwayNeil Conway
    Nov 5, 2002 at 12:22 am
    Dec 10, 2002 at 10:28 pm
  • There isn't one! Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 29, 2002 at 8:30 pm
    Dec 2, 2002 at 3:53 pm
  • Hi All, This relates to the recent discussion about floating point output format. The discussion was at a point where one parameter would be added to specify the number of extra digits used in fp ...
    Pedro M. FerreiraPedro M. Ferreira
    Nov 4, 2002 at 1:50 pm
    Nov 15, 2002 at 6:03 pm
  • Hello, i've read that there are 2 different native ports for Windows somewhere. I've searched for them but didn't found them. Is there anyone who can point me to a link or send me a copy of the ...
    Ulrich NeumannUlrich Neumann
    Nov 25, 2002 at 5:37 pm
    Nov 28, 2002 at 7:23 am
  • Hi, Has anyone given much thought to improving pg_dump's object order algorithm for 7.4? It seems that now we have dependencies, it should just be a matter of doing a breadth-first or depth-first ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 13, 2002 at 5:33 am
    Nov 16, 2002 at 9:08 pm
  • Are we still on schedule for RC1 on Friday? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your ...
    Bruce MomjianBruce Momjian
    Nov 6, 2002 at 5:57 am
    Nov 9, 2002 at 4:33 am
  • Hello, When I change view and change number of column PostgreSQL return error : 'cannot change number of column in view' Is it too hard set this command if view exits drop view and then change view ...
    Nov 14, 2002 at 1:39 pm
    Nov 15, 2002 at 4:29 pm
  • It seems to me that about the only major issue right now is testing the various platforms ... would anyone disagree with putting out an RC1 on Friday whose primary purpose is platform testing? I ...
    Marc G. FournierMarc G. Fournier
    Nov 13, 2002 at 3:39 pm
    Nov 15, 2002 at 3:02 am
  • Several months ago tried to implement a special postgres backend as an Auto Vacuum Daemon (AVD), somewhat like the stats collector. I failed due to my lack of experience with the postgres source. On ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Nov 27, 2002 at 2:59 am
    Dec 10, 2002 at 10:19 pm
  • I have been serving my email/web/ftp using a 56k modem for the past two months at candle.pha.pa.us (which is also momjian.postgresql.org). Are people finding it slow? I am going to be getting a ...
    Bruce MomjianBruce Momjian
    Nov 3, 2002 at 6:31 pm
    Nov 5, 2002 at 6:50 pm
  • I just tried it. I created a sequence using SERIAL when I created a table. I used the same sequence for another table by setting a column default to nextval(sequence). I deleted the first table. The ...
    Oliver ElphickOliver Elphick
    Nov 20, 2002 at 10:12 pm
    Nov 26, 2002 at 3:31 pm
  • Are those two syntaxes eqivalent ? select * from users where monitored; select * from users where monitored=true; If the answer is yes, the optimimer probably doesn't agree with you :) Tested on RC1: ...
    Daniele OrlandiDaniele Orlandi
    Nov 21, 2002 at 6:38 pm
    Nov 24, 2002 at 3:29 am
  • Oops. I removed that test on 21-Oct as part of this fix: 2002-10-21 18:06 tgl * src/: backend/access/transam/xact.c, backend/catalog/heap.c, backend/catalog/index.c, backend/commands/dbcommands.c, ...
    Tom LaneTom Lane
    Nov 17, 2002 at 7:33 pm
    Nov 18, 2002 at 7:23 pm
  • To me, this is a bug in PostgreSQL. A comment in InternalIpcMemoryCreate() says * Fail quietly if error indicates a collision with existing * segment. One would expect EEXIST, given that we said ...
    Peter EisentrautPeter Eisentraut
    Nov 4, 2002 at 7:18 pm
    Nov 18, 2002 at 6:10 pm
  • Just a quick note to mention that I've resigned from the PostgreSQL steering committee. It has been a lot of fun and very rewarding to participate in PostgreSQL development over the last six years, ...
    Thomas LockhartThomas Lockhart
    Nov 15, 2002 at 6:38 am
    Nov 16, 2002 at 2:10 pm
  • Morning all ... As I was unable to figure out a way of merging HEAD into a BRANCH (BRANCH into HEAD is easy), I moved the REL7_3_STABLE tag up to today, so that the BRANCH is in a more appropriate ...
    Marc G. FournierMarc G. Fournier
    Nov 4, 2002 at 6:01 pm
    Nov 6, 2002 at 5:03 pm
  • Hello hackers, In the pg_stat_activity view, the usesysid is shown as having type Oid. However pg_shadow says it's an integer. Is there a reason? Looks like a bug. This patch seems to corrects this ...
    Alvaro HerreraAlvaro Herrera
    Nov 17, 2002 at 2:07 pm
    Nov 18, 2002 at 5:17 pm
  • Hello, I work with JDeveloper and PostgreSQL JDBC and I have one problem. I get error : sub-SELECT in FORM must have an alias I can't change SQL command, but it is internal JDeveloper command Is it ...
    Nov 9, 2002 at 4:58 pm
    Nov 15, 2002 at 3:13 am
  • Ok, someone else posted their data warehousing wishlist, I want to post my single item OLP wishlist: Plan stability. This is the natural conclusion of having prepared queries. This is one area where ...
    Greg StarkGreg Stark
    Nov 30, 2002 at 10:33 pm
    Dec 6, 2002 at 1:48 am
  • I will be applying outstanding 7.4 patches on Friday: http:/momjian.postgresql.org/cgi-bin/pgpatches2 If anyone wants those rejected/modified, please let me know. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Nov 7, 2002 at 3:11 am
    Nov 10, 2002 at 12:31 am
  • I saw this when compiling 7.3b4 as well and also with 7.3b5 cd contrib make ... make[1]: Leaving directory `/nfs/visor/u/software/postgres/postgresql-7.3b5/contrib/rtree_gist' make[1]: Entering ...
    Laurette CisnerosLaurette Cisneros
    Nov 6, 2002 at 11:36 pm
    Nov 7, 2002 at 8:24 pm
  • Is the following supposed to work? $ psql -U neteng -h tide netmaster ERROR: parser: parse error at or near "." Welcome to psql 7.3b3, the PostgreSQL interactive terminal. Type: \copyright for ...
    Larry RosenmanLarry Rosenman
    Nov 1, 2002 at 4:30 pm
    Nov 2, 2002 at 5:37 am
  • I have been experimenting with empirical tests of file system and device level writes to determine the actual constraints in order to speed up the WAL logging code. Using a raw file partition and a ...
    Curtis FaithCurtis Faith
    Nov 11, 2002 at 8:33 pm
    May 26, 2003 at 6:22 pm
  • Tatsuo, are you or anyone else working on adding PREPARE, EXECUTE support to pgbench? If not, I can do it myself and if you are interested, I'll send you the patch. - Curtis
    Curtis FaithCurtis Faith
    Nov 12, 2002 at 7:41 pm
    Jan 20, 2003 at 3:59 am
  • A quick question: in 7.3 the following no longer works: template1= select 0::bool; ERROR: Cannot cast type integer to boolean The statement must be rewritten as this: template1= select '0'::bool; ...
    Ian BarwickIan Barwick
    Nov 27, 2002 at 12:19 am
    Nov 30, 2002 at 9:06 pm
  • Hi Guys, I emailed a few people to try to get some platform reports. What was the solution to this problem? It was AWK or something wasn't it? Will Martin have to try RC1? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 15, 2002 at 1:47 am
    Nov 27, 2002 at 10:22 pm
  • Hi, I just discovered, that there is missing a const when passing a buffer to PQescapeBytea and PQunescapeBytea. I fixed it and tried to create a usable diff (I'm not so familar to diff). Tommi ...
    Tommi MäkitaloTommi Mäkitalo
    Nov 2, 2002 at 9:44 pm
    Nov 11, 2002 at 9:21 am
  • Thinking with my marketing hat on, MVCC would be a much bigger win if VACUUM was not required (or was done automagically). The need for periodic VACUUM just gives ammunition to the PostgreSQL ...
    Curtis FaithCurtis Faith
    Nov 26, 2002 at 3:32 pm
    Nov 27, 2002 at 5:20 pm
  • The optimizer seems to know about dead rows in tables (ie. it will use an index it would not ordinarily use if vacuum-full had been run, apparently because it knows the table has many dead rows, and ...
    Philip WarnerPhilip Warner
    Nov 2, 2002 at 8:40 am
    Nov 3, 2002 at 11:05 am
  • I have been looking at contrib/ltree in the PostgreSQL repository. I've modified the code to allow / as a node delimiter instead of . which is the default. Below are the patches to make this change. ...
    Dan LangilleDan Langille
    Nov 27, 2002 at 1:33 am
    Dec 5, 2002 at 1:05 pm
  • Hi Guys, I'm starting work on ADD COLUMN. I'm going to allow: * SERIAL, SERIAL8 * DEFAULT * NOT NULL etc... The one big programming difficulty I see is the process of running through all the existing ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 23, 2002 at 11:53 pm
    Nov 24, 2002 at 9:16 pm
  • Hi guys, We received a query through the Advocacy site about whether we support AIX 5.1 or not, so am trying to find out. Just took a look at the Supported Platforms list, and the FAQ_AIX document ...
    Justin CliftJustin Clift
    Nov 14, 2002 at 6:51 am
    Nov 14, 2002 at 4:34 pm
  • what is the command to launch a sql script not in psql thanks
    Florian LitotFlorian Litot
    Nov 5, 2002 at 2:22 pm
    Nov 8, 2002 at 3:14 pm
  • I've been thinking about how to improve the performance of queries using "WHERE x IN (subselect)" and "WHERE x NOT IN (subselect)". In the existing implementation, the subquery result is rescanned to ...
    Tom LaneTom Lane
    Nov 27, 2002 at 11:56 pm
    Nov 30, 2002 at 11:38 am
  • I am all for it. That would much more closely match what I would expect. One alternate possible approach would maybe be to change the on-disk representation to really be binary compatible and change ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 18, 2002 at 10:42 am
    Nov 19, 2002 at 1:43 pm
  • Hey Hackers - I was testing beta5 and found a performance regression involving application of constraints into a VIEW - I've got a view that is fairly expensive, involving a subselet and an ...
    Ross J. ReedstromRoss J. Reedstrom
    Nov 13, 2002 at 6:22 am
    Nov 13, 2002 at 3:20 pm
  • ... and the same for SELECT/INTO Also, the hasoids (or equivalent) attribute is not picked up from the source table which would be another way to push this property into the target table. One or both ...
    Thomas LockhartThomas Lockhart
    Nov 7, 2002 at 4:48 pm
    Nov 13, 2002 at 2:10 am
  • This is wrong assumption. If 1st client executes UPDATE t SET a = 1 WHERE b = 2; 2nd client executes UPDATE t SET a = 2 WHERE b = 2; at "the same time" you don't know in what order these queries will ...
    Mikheev, VadimMikheev, Vadim
    Nov 4, 2002 at 8:24 pm
    Nov 8, 2002 at 2:28 am
  • Hi i think a hit a major problem on 7.2.1. I run 3 systems with postgresql 7.2.1. Its a redhat 7.1 for development, a redhat 7.3 for production and a FreeBSD 4.6.1RC2 for testing. After long runs ...
    Achilleus MantziosAchilleus Mantzios
    Nov 6, 2002 at 12:36 pm
    Nov 7, 2002 at 3:10 pm
  • Hi Joe ! Now when the 7.3 release is out,can we get back to plpq ? I did send You sources before vacation, and You said that You will take a look. I hope I am not disturbing You. If You think that ...
    Darko PrenosilDarko Prenosil
    Nov 30, 2002 at 11:18 am
    Dec 3, 2002 at 9:13 am
  • By accident I stumbled across the following paragraph in the August 2002 draft of SQL 2003: If there are multiple instances of <next value expression s specifying the same sequence generator within a ...
    Manfred KoizarManfred Koizar
    Nov 27, 2002 at 3:35 pm
    Nov 28, 2002 at 3:39 pm
  • Folks, We need a quote from a major code contributor to PostgreSQL about the upcoming 7.3 release -- something about how great the new release is, or some of the features in the release. We need this ...
    Josh BerkusJosh Berkus
    Nov 19, 2002 at 4:49 pm
    Nov 27, 2002 at 3:29 pm
  • Hi, Is there any reason why the grolist field in the table pg_group is implemented as an array and not as a separate table? According to the documentation: <quote source="Postgresql 7.2 User Manual, ...
    Reinoud van LeeuwenReinoud van Leeuwen
    Nov 20, 2002 at 12:03 pm
    Nov 27, 2002 at 1:35 am
  • I was playing with the Japanese win32 7.2.1 port and I noticed that "select 0 / 0" caused the server to crash and restart. I understand that it is a totally unsupported version, but it should be easy ...
    Merlin MoncureMerlin Moncure
    Nov 26, 2002 at 3:00 am
    Nov 26, 2002 at 10:18 pm
Group Navigation
period‹ prev | Nov 2002 | next ›
Group Overview
grouppgsql-hackers @

169 users for November 2002

Tom Lane: 209 posts Bruce Momjian: 190 posts Christopher Kings-Lynne: 62 posts Neil Conway: 40 posts Peter Eisentraut: 36 posts Marc G. Fournier: 34 posts Larry Rosenman: 27 posts Rod Taylor: 27 posts Scott.marlowe: 27 posts Snpe: 26 posts Justin Clift: 23 posts Hannu Krosing: 21 posts Stephan Szabo: 18 posts Philip Warner: 16 posts Joe Conway: 13 posts Andreas Zeugswetter: 12 posts Patrick Welche: 12 posts Al Sutton: 11 posts Alvaro Herrera: 10 posts Bruno Wolff III: 10 posts
show more