FAQ

PostgreSQL > pgsql-hackers > December 2002

Search Discussions

161 discussions - 1,176 posts

  • Thanks to Rod Taylor's kind help in donating a system account, I've been able to test libpqxx against postgres 7.3. Unfortunately, I'm running into several problems. One thing that broke libpqxx was ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Dec 4, 2002 at 9:33 am
    Dec 17, 2002 at 12:23 pm
  • I wanted to outline some of the big items we are looking at for 7.4: Win32 Port: Katie Ward and Jan are working on contributing their Win32 port for 7.4. They plan to have a patch available by the ...
    Bruce MomjianBruce Momjian
    Dec 13, 2002 at 6:22 am
    Dec 17, 2002 at 5:22 pm
  • Going to announce later this evening to give the mirrors a chance to catch up ... let me know if there are any problems ..
    Marc G. FournierMarc G. Fournier
    Dec 18, 2002 at 2:18 pm
    Dec 20, 2002 at 12:03 am
  • I have been working on a patch to implement IPv6 connections. A working patch was supplied by Nigel Kukard about two weeks ago, and I have been improving it. The original patch assumed the system has ...
    Bruce MomjianBruce Momjian
    Dec 29, 2002 at 4:36 am
    Jan 28, 2003 at 3:12 am
  • Update on replication: We have several things happening with Postgres-R replication: o Someone is porting the 7.2-based Postgres-R code to 7.3 o Darren and I are in discussion with the Spread folks, ...
    Bruce MomjianBruce Momjian
    Dec 17, 2002 at 5:57 pm
    Dec 18, 2002 at 1:36 pm
  • I'm evaluating tsearch contrib module, and i get a backend crash when i'm about to use a tsearch function. When i issue update things set nidx=txt2txtidx(productname), ...
    Magnus Naeslund(f)Magnus Naeslund(f)
    Dec 3, 2002 at 2:53 pm
    Dec 6, 2002 at 5:16 am
  • Hi, Some guys from Turkey claim that they have a code to crack PostgreSQL passwords, defined in pg_hba.conf . http://www.core.gen.tr/pgcrack/ Maybe some of you want to get the code... Best regards, ...
    Devrim GündüzDevrim Gündüz
    Dec 31, 2002 at 5:17 pm
    Jan 4, 2003 at 1:38 am
  • I have prepared the 7.3 CVS branch in preparation of a 7.3.1 release soon. Please check it. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard ...
    Bruce MomjianBruce Momjian
    Dec 18, 2002 at 2:17 am
    Dec 28, 2002 at 9:15 pm
  • We support "alter table add foreign key". How about supporting "alter table drop foreign key"? - he said as he went to drop a foreign key -- Dan Langille : http://www.langille.org/
    Dan LangilleDan Langille
    Dec 5, 2002 at 4:01 pm
    Dec 5, 2002 at 9:25 pm
  • [ moved to hackers from pgsql-patches ] "Christopher Kings-Lynne" <chriskl@familyhealth.com.au writes: ... and that was already proposed for "show schemas" (namespaces). I'm inclined to think it's ...
    Tom LaneTom Lane
    Dec 9, 2002 at 9:12 pm
    Dec 12, 2002 at 4:14 am
  • The notes below are the results of various tuning issues experienced recently on a large database (several GB) that has many tables and a high transient data flow (ie. thousands of records added, ...
    Philip WarnerPhilip Warner
    Dec 8, 2002 at 2:43 pm
    Dec 11, 2002 at 5:19 am
  • Hi, I've been trying to ask on general, and tried to search the archives without much result, so I'll try here. I'm using PostgreSQL 7.2.1 on Solaris 8/sparc. In a table, I have a text field, which ...
    Tomas BerndtssonTomas Berndtsson
    Dec 4, 2002 at 3:39 pm
    Dec 6, 2002 at 1:03 pm
  • Hi! subject says it all, I guess. There is hardly no difference between 7.3 libpq and 7.3.1 libpq. Why the version shift? Isn't the only thing rectifying a version shift that there is a change in the ...
    Palle GirgensohnPalle Girgensohn
    Dec 30, 2002 at 3:41 am
    Jan 4, 2003 at 4:59 am
  • Someone asked earlier about how to change a bunch of existing tables int the PUBLIC schema to some other schema. For grins I tried: regression=# select oid,* from pg_namespace ; oid | nspname | ...
    Joe ConwayJoe Conway
    Dec 1, 2002 at 5:29 am
    Dec 3, 2002 at 5:03 pm
  • Here's something that's been bothering me for a while... Perhaps this is correct behaviour, but I can't quite see how. This does not happen if I replace the FETCHes by MOVEs. Here's the reference ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Dec 26, 2002 at 1:44 am
    Dec 30, 2002 at 6:50 pm
  • I was bemused to notice that pg_dump is currently unable to dump the regression database. The domain regression test leaves an empty table (one with zero columns), which causes pg_dump to produce -- ...
    Tom LaneTom Lane
    Dec 12, 2002 at 9:09 pm
    Dec 16, 2002 at 11:37 pm
  • Hi folks, Let's create a release team. This strategy is one well established in other projects and in industry. For lack of a better starting reference, let me suggest ...
    Dan LangilleDan Langille
    Dec 8, 2002 at 3:03 am
    Dec 10, 2002 at 7:12 pm
  • Just wondering where I should put my modified tuning notes. I was planning on making them section 3.7 in the Admin guide. Does that sound reasonable? The current version can be seen at: ...
    Philip WarnerPhilip Warner
    Dec 11, 2002 at 2:42 pm
    Dec 14, 2002 at 12:31 am
  • I've been looking at the recently-committed ALTER DOMAIN patch, and I think it's got some serious if not fatal problems. Specifically, the approach to adding/dropping constraints associated with ...
    Tom LaneTom Lane
    Dec 10, 2002 at 5:39 pm
    Dec 12, 2002 at 2:45 pm
  • Steve KingSteve King
    Dec 13, 2002 at 9:29 am
    Dec 18, 2002 at 8:47 pm
  • I just sync'd up with cvs and tried to make clean then configure, and I'm getting this: config.status: linking ./src/backend/libpq/v6util.c to src/interfaces/libpq/v6util.c config.status: error: ...
    Joe ConwayJoe Conway
    Dec 6, 2002 at 4:09 am
    Dec 9, 2002 at 6:13 pm
  • I am not going to apply this patch because I think it will mess up the handling of other locales. --------------------------------------------------------------------------- Nicolai Tufar wrote: -- ...
    Bruce MomjianBruce Momjian
    Dec 5, 2002 at 6:19 am
    Dec 9, 2002 at 5:47 pm
  • Unfortunately there doesn't seem to be any easy way to do this. There is no ALTER SEQUENCE command and you can't use UPDATE on a sequence. Hackers: Could this be a TODO item for 7.4? The easiest way ...
    Oliver ElphickOliver Elphick
    Dec 4, 2002 at 2:17 pm
    Dec 5, 2002 at 7:25 pm
  • Tom, Folks: Joe and I were discussing your recent discussion about the costs of VACUUM and tuple maintainence, and I had an interesting idea. How hard would it be to add a "WITH (VACUUM)" option to ...
    Josh BerkusJosh Berkus
    Dec 16, 2002 at 10:04 pm
    Dec 17, 2002 at 6:38 pm
  • I've found a situation that doesn't look correct to me in 7.3.1 (and presumably 7.3 as well). If I alter a column so that it no longer uses a sequence for default values and then try to drop the ...
    Tara PiorkowskiTara Piorkowski
    Dec 30, 2002 at 4:09 pm
    Dec 31, 2002 at 6:05 pm
  • I wonder if EXECUTE could/should be made to return the appropriate command status string for the executed statement, instead of "EXECUTE". regards, tom lane
    Tom LaneTom Lane
    Dec 20, 2002 at 2:36 pm
    Dec 23, 2002 at 1:35 am
  • I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it is even anticipated in guc.c as a possible future ...
    Joe ConwayJoe Conway
    Dec 19, 2002 at 1:01 am
    Dec 19, 2002 at 11:36 pm
  • Joe, have you heard of a standard called SQL/MED? I came across a description of it the other day. You might think it's got some medical connotation, but actually the acronym is Management of ...
    Tom LaneTom Lane
    Dec 6, 2002 at 4:09 pm
    Dec 6, 2002 at 8:57 pm
  • Cool :) I'm now working on postmaster windows shell. It's not finished yet but main things work. Funcionality implemented now is : Console redirection for capture output from postmaster ...
    Igor GeorgievIgor Georgiev
    Dec 5, 2002 at 12:47 pm
    Dec 6, 2002 at 11:08 am
  • I think the python interface in /interfaces/python should be moved to gborg. It already has its own web site: http://www.druid.net/pygresql/ and there is also another one, pyPgSQL, at: ...
    Bruce MomjianBruce Momjian
    Dec 17, 2002 at 7:10 pm
    Jan 8, 2003 at 3:17 pm
  • Hi every one and happy Xmas. Hope you can still answer that one. Waiting for my brand you server, I've installed an old bi-PII 300 unser unixware 713 and trying postgresql 7.3.1 with it. Compile ...
    Olivier PRENANTOlivier PRENANT
    Dec 26, 2002 at 5:25 pm
    Dec 27, 2002 at 7:07 pm
  • Hi all, I've been thinking about resource management and postgres. I want to develop a user profile system (a-la oracle) which allows a DBA to restrict/configure access to system resources. This ...
    Gavin SherryGavin Sherry
    Dec 21, 2002 at 2:29 am
    Dec 22, 2002 at 6:01 am
  • Hi guys, Just a thought - do we explicitly wipe password strings from RAM after using them? I just read an article (by MS in fact) that illustrates a cute problem. Imagine you memset the password to ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 17, 2002 at 2:07 am
    Dec 17, 2002 at 6:28 pm
  • Can anyone tell me how to get a tuple's TupleDesc if all that is known is the tid? Or is there an easy way to step through a tuple, retrieving the data and data type from each field? Thanks, Nate ...
    Nate SommerNate Sommer
    Dec 10, 2002 at 4:08 am
    Dec 10, 2002 at 7:14 am
  • I am working on getting a shrink-wrapped version of PostgreSQL for Windows Currently it installs a customized version of Cygwin, PostgreSQL 7.2.3, cygipc, psqlodbc, and pgadminII I currently have the ...
    Mark L. WoodwardMark L. Woodward
    Dec 3, 2002 at 6:14 am
    Dec 3, 2002 at 7:24 pm
  • The following statements do not utilize an index when executed inside a plpgsql procedure, but does when executed interactively in psql! Does not use index: FOR somemorerows IN SELECT zipcode_list ...
    Ryan MahoneyRyan Mahoney
    Dec 20, 2002 at 10:19 pm
    Dec 21, 2002 at 8:56 pm
  • Hi, I am doing some experiments on dead tuples, I am looking of reusing the dead tuples apace in a particular page during the "Update".This patch is meant for the tables which are heavily updated to ...
    JanardhanJanardhan
    Dec 11, 2002 at 2:40 am
    Dec 18, 2002 at 8:21 am
  • (crossposting to hackers) Something along the lines of char *PQversion(const PGconn *conn) ? Sounds good to me. Is it on the todo-list? (Couldn't see it there). Ian Barwick barwick@gmx.net
    Ian BarwickIan Barwick
    Dec 10, 2002 at 3:38 pm
    Dec 12, 2002 at 12:19 am
  • Looking at my problem with changed cursor behaviour in 7.3 again, I noticed something interesting: a cursor in 7.3 apparently does not let you scroll back to its first row at all! Neither a "move ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Dec 8, 2002 at 6:28 pm
    Dec 8, 2002 at 10:58 pm
  • Was it necessary? No idea, you're welcome to search through the pgsql-hackers archives to determine the reasoning behind the change. I believe the change was made by Bruce Momjian (going by the ...
    Lee KindnessLee Kindness
    Dec 3, 2002 at 11:08 am
    Dec 3, 2002 at 5:22 pm
  • Is there a known problem with TOAST tables growing indefinitely in 7.2? We have a database that has large text chunks inserted & deleted regularly, and despite regular vacuums, the toast table ...
    Philip WarnerPhilip Warner
    Dec 2, 2002 at 3:25 am
    Dec 3, 2002 at 6:34 am
  • Hello In PostgreSQL 7.2/7.1: template1=# select text(2.000::numeric); text ------ 2 (1 row) In 7.3: template1=# select text(2.000::numeric); text ------- 2.000 (1 row) The text(numeric) function ...
    Szima GáborSzima Gábor
    Dec 1, 2002 at 4:48 pm
    Dec 2, 2002 at 8:18 pm
  • I have not been aggressive about backpatching documentation improvements into 7.3.1. Is that something I should check? As I remember, we didn't update the official docs for minor releases. Is that ...
    Bruce MomjianBruce Momjian
    Dec 18, 2002 at 2:25 am
    Dec 19, 2002 at 11:38 pm
  • I'm working on the TODO item "Allow easy display of usernames in a group" in the context of a slightly larger effort to improve usability of arrays. I'm far enough down the road to have a better idea ...
    Joe ConwayJoe Conway
    Dec 8, 2002 at 4:52 pm
    Dec 11, 2002 at 10:33 pm
  • Rod, can you comment on these warnings Joe Conway's compiler is showing? I don't see the warnings with gcc, but clearly they look like problems. I can just assign a NULL on definition, but I thought ...
    Bruce MomjianBruce Momjian
    Dec 7, 2002 at 3:58 am
    Dec 9, 2002 at 6:44 pm
  • Han Holl's recent complaint about memory leaks in SQL-language functions has started me thinking again about making plan trees read-only to the executor. This would make it a lot easier to manage ...
    Tom LaneTom Lane
    Dec 2, 2002 at 12:21 am
    Dec 2, 2002 at 5:03 pm
  • Last night, we packaged up v7.3.1 of PostgreSQL, our latest stable release. Purely meant to be a bug fix release, this one does have one major change, in that the major number of the libpq library ...
    Marc G. FournierMarc G. Fournier
    Dec 22, 2002 at 7:12 pm
    Dec 30, 2002 at 3:51 am
  • Hi all, I'm planning an upgrade from 7.2.3 to 7.3.1 on some HP-UX systems. With the major number bump in 7.3.1 I was expecting to be able to do this upgrade without a flag day to re-compile clients, ...
    Giles LeanGiles Lean
    Dec 23, 2002 at 2:24 am
    Dec 23, 2002 at 10:24 pm
  • I'm working on a new interface to PostgreSQL and having a difficult time. Perhaps someone here can shed some light on the subject. 1. Am I correct in thinking that the OID that I receive with the ...
    Reggie BurnettReggie Burnett
    Dec 6, 2002 at 2:57 pm
    Dec 6, 2002 at 3:40 pm
  • Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it now has subselects. Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 4, 2002 at 2:55 am
    Dec 4, 2002 at 2:55 pm
Dec 2002
1234
Group Navigation
period‹ prev | Dec 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions161
posts1,176
users131
websitepostgresql.org...
irc#postgresql

131 users for December 2002

Bruce Momjian: 178 posts Tom Lane: 158 posts Marc G. Fournier: 52 posts Christopher Kings-Lynne: 44 posts Rod Taylor: 37 posts Peter Eisentraut: 35 posts Philip Warner: 33 posts Joe Conway: 32 posts Justin Clift: 27 posts Dan Langille: 26 posts Vince Vielhaber: 25 posts Magnus Naeslund(f): 24 posts Greg Copeland: 22 posts Kevin Brown: 20 posts Dave Page: 19 posts Jeroen T. Vermeulen: 19 posts Robert Treat: 17 posts Hannu Krosing: 16 posts Lee Kindness: 16 posts Mark L. Woodward: 13 posts
show more
Archives