FAQ

PostgreSQL > pgsql-hackers > July 2002

Search Discussions

181 discussions - 1,290 posts

  • Here are the open items for 7.3. We have one more month to address them before beta. --------------------------------------------------------------------------- P O S T G R E S Q L 7 . 3 O P E N I T ...
    Bruce MomjianBruce Momjian
    Jul 31, 2002 at 3:50 am
    Aug 29, 2002 at 2:00 am
  • Just a long standing curiosity? For most web sites MySQL seems to work fine, but overall PostgreSQL offers more capabilites so why build upon a limited base such as MySQL? Does anyone here have any ...
    Matthew TedderMatthew Tedder
    Jul 29, 2002 at 11:36 am
    Aug 12, 2002 at 12:00 am
  • Hi All, I have given up working on the BETWEEN node. It got to the stage where I realised I was really out of my depth! Rod Taylor has indicated an interest in the problem and I have sent him my ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 3, 2002 at 9:19 am
    Jul 6, 2002 at 3:42 pm
  • As per earlier discussion, I'm working on the hot backup issues as part of the PITR support. While I was looking at the buffer manager and the relcache/MyDb issues to figure out the best way to work ...
    J. R. NieldJ. R. Nield
    Jul 24, 2002 at 6:45 am
    Aug 10, 2002 at 1:27 am
  • I am willing to supply a complete, friendly, powerful and pretty installer program, based on NSIS. http://www.winamp.com/nsdn/nsis/index.jhtml I suggest that pgAdmin is included in the install ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 1, 2002 at 5:35 am
    Jul 10, 2002 at 10:10 pm
  • I've developed patches to be able to specify the location of the WAL directory, with the default location being where it is now. The patches define a new environment variable PGXLOG (a la PGDATA) and ...
    Thomas LockhartThomas Lockhart
    Jul 30, 2002 at 1:54 am
    Aug 3, 2002 at 11:42 am
  • Here is my proposal for new CREATE CONVERSION which makes it possible to define new encoding conversion mapping between two encodings on the fly. The background: We are getting having more and more ...
    Tatsuo IshiiTatsuo Ishii
    Jul 5, 2002 at 6:36 am
    Jul 11, 2002 at 2:47 pm
  • I have implemented this TODO item: * Add getpid() function to backend There were a large number of pg_stat functions that access pids and backends slots so I added it there: test= select ...
    Bruce MomjianBruce Momjian
    Jul 31, 2002 at 12:40 am
    Aug 5, 2002 at 9:48 pm
  • Something to maybe add to the TODO list, if someone has the time/inclination to work on it ... The problem with the current auth system, as I see it, is that you can't easily have seperate user lists ...
    Marc G. FournierMarc G. Fournier
    Jul 26, 2002 at 1:48 pm
    Aug 1, 2002 at 1:40 am
  • OK, more DROP COLUMN funny business: Assuming that selects, updates and deletes all ignore the dropped column, what happens with things like alter table statements? You can still quite happily set ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 15, 2002 at 3:30 pm
    Jul 18, 2002 at 2:10 am
  • Hello: I've got the logging system to the point where I can take a shutdown consistent copy of a system, and play forward through multiple checkpoints. It seems to handle CREATE TABLE/DROP ...
    J. R. NieldJ. R. Nield
    Jul 4, 2002 at 3:58 pm
    Jul 18, 2002 at 8:26 pm
  • A while ago, I started a small discussion about passing arguments to a NOTIFY so that the listening backend could get more information about the event. There wasn't exactly a consensus from what I ...
    Jeff DavisJeff Davis
    Jul 2, 2002 at 9:45 am
    Jul 4, 2002 at 5:23 am
  • I'm having a weird problem on my " PostgreSQL 7.2.1 on i386--netbsdelf, compiled by GCC 2.95.3" system. Executing these commands: CREATE TABLE test_one (id int PRIMARY KEY, value_one text); CREATE ...
    Curt SampsonCurt Sampson
    Jul 31, 2002 at 2:34 am
    Aug 2, 2002 at 9:57 am
  • Consider CREATE TABLE foo (f1 int primary key); CREATE TABLE bar (f1 int references foo); DROP TABLE foo RESTRICT; Should this succeed? Or should it be necessary to say DROP CASCADE to get rid of the ...
    Tom LaneTom Lane
    Jul 10, 2002 at 10:33 pm
    Jul 14, 2002 at 12:22 am
  • Hi guys, I seem to be getting virus emails that pretend to be one of your guys. eg. I get them from T.Ishii and N.Conway, etc. Anyone out there on the list who should perhaps scan their computer? :) ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 27, 2002 at 2:26 am
    Jul 31, 2002 at 10:06 am
  • The following system table columns are currently unused and don't appear to be in the line of resurrection. pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.probyte_pct ...
    Peter EisentrautPeter Eisentraut
    Jul 15, 2002 at 10:51 pm
    Jul 16, 2002 at 7:04 am
  • We've discussed at least a couple of times before that it would be nice to be able to create stand-alone composite types. Tom mentioned that ideally this would be done as part of a refactoring of ...
    Joe ConwayJoe Conway
    Jul 30, 2002 at 5:51 am
    Aug 10, 2002 at 9:58 am
  • I am working on a rather extensive Oracle compatibility layer that I use with PostgreSQL. I am considering contributing the code back to the project but the problem is that the layer is currently ...
    Marc LavergneMarc Lavergne
    Jul 21, 2002 at 7:22 pm
    Sep 29, 2002 at 2:10 am
  • Hi, Would it be possible to add a new attribute to pg_views that stores the original view definition, as entered via SQL? This would make the lives of those of us who make admin interfaces a lot ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 16, 2002 at 5:42 am
    Jul 17, 2002 at 8:35 am
  • Hi Florian, Actually, I replied to you 5 minutes after you posted, but I think my emails were being stalled somewhere... To generate the diff, do this: cd contrib/fulltextindex cvs diff -c ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 1, 2002 at 7:50 am
    Jul 12, 2002 at 2:26 pm
  • OK, This is the problem I'm having with the DROP COLUMN implementation. Since I've already incorporated all of Hiroshi's changes, I think this may have been an issue in his trial implementation as ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 5, 2002 at 7:57 am
    Jul 9, 2002 at 9:12 am
  • Is this the kind of thing you mean? #include "postgres.h" #include "fmgr.h" extern Datum pg_reset_stats(PG_FUNCTION_ARGS); PG_FUNCTION_INFO_V1(pg_reset_stats); Datum pg_reset_stats(PG_FUNCTION_ARGS) ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 29, 2002 at 3:51 am
    Jul 31, 2002 at 7:24 am
  • Actually not. SQL92 defines this command as <prepare statement ::= PREPARE <SQL statement name FROM <SQL statement variable <SQL statement variable ::= <simple value specification where <simple value ...
    Tom LaneTom Lane
    Jul 21, 2002 at 1:59 am
    Jul 28, 2002 at 3:18 pm
  • I have faced a problem with encoding conversion while the database is starting up. If postmaster accepts a connection request while in the state, it issues a fatal message "The database system is ...
    Tatsuo IshiiTatsuo Ishii
    Jul 18, 2002 at 4:55 am
    Jul 23, 2002 at 10:16 pm
  • OK, I have added comments to \dT and SGML docs to mention that 'line' is not implemented. This should help future folks. It would be nice to get the line type working 100%. Thomas says the problem is ...
    Bruce MomjianBruce Momjian
    Jul 16, 2002 at 3:33 am
    Jul 16, 2002 at 8:50 pm
  • <delurk - reading from the archives, so please cc me on responses Note that before bugzilla really supports postgresql, we (ie the bugzilla team) are going to need DROP COLUMN support, as well as ...
    Bradley BaetzBradley Baetz
    Jul 10, 2002 at 11:44 pm
    Jul 11, 2002 at 8:32 am
  • OK, this is what I'm seeing on FreeBSD/Alpha for libpq++. I haven't figured out how to build libpqxx yet.: gmake[3]: Entering directory `/home/chriskl/pgsql-head/src/interfaces/libpq++' g++ -O2 -g ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 3, 2002 at 8:01 am
    Jul 7, 2002 at 8:28 pm
  • Actually, from reading that thread, I started to think along those lines too ... it is a major change, is there a reason why going to 8.0 on this one is a bad idea? I realize that its *only* been 2 ...
    Marc G. FournierMarc G. Fournier
    Jul 5, 2002 at 3:17 am
    Jul 6, 2002 at 10:16 am
  • This behavior doesn't look right: nconway=# create table foo (a int default 50, b int default 100); CREATE TABLE nconway=# copy foo from stdin; Enter data to be copied followed by a newline. End with ...
    Neil ConwayNeil Conway
    Jul 24, 2002 at 5:59 pm
    Aug 27, 2002 at 8:33 pm
  • SQL92 requires named constraints to have names that are unique within their schema. Our past implementation did not require constraint names to be unique at all; as a compromise I suggested requiring ...
    Tom LaneTom Lane
    Jul 2, 2002 at 6:38 pm
    Jul 8, 2002 at 11:44 pm
  • Hi all As I understand every time there is a request to postgres a new backend is made, and when the request is finished, even if the connection is already active the backend dies. I wonder if is ...
    Luis Alberto Amigo NavarroLuis Alberto Amigo Navarro
    Jul 29, 2002 at 9:27 am
    Jul 30, 2002 at 7:19 pm
  • OK, DROP COLUMN now seems to work perfectly. All the old test cases that failed now work fine. However, I'm not happy with the way dropped columns are renamed. I want to give them a name that no-one ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 15, 2002 at 3:45 am
    Jul 15, 2002 at 5:52 pm
  • Now that the pg_depend mechanism is mostly in there, it is no longer a good idea to delete things directly (for example, by calling heap_drop_with_catalog or even just heap_delete'ing a catalog ...
    Tom LaneTom Lane
    Jul 12, 2002 at 7:17 pm
    Jul 14, 2002 at 12:02 am
  • Hello, As of today, a Bugzilla has been made available at - bugzilla.pgaccess.org This is a pretty straight forward installation of Bugzilla 2.14.2 It is currently empty. There are even no components ...
    Iavor RaytchevIavor Raytchev
    Jul 9, 2002 at 6:42 pm
    Jul 12, 2002 at 2:50 am
  • We are about to submit brand bew contrib/ltree module (first draft of documetation is available from http://www.sai.msu.su/~megera/postgres/gist/ltree/) and I have a question what version to submit - ...
    Oleg BartunovOleg Bartunov
    Jul 21, 2002 at 3:38 pm
    Aug 6, 2002 at 1:40 pm
  • I've been working on the TODO list item "Add SHOW command to display locks". The code is basically finished, but I'd like to make sure the user interface is okay with everyone before I send it in to ...
    Neil ConwayNeil Conway
    Jul 18, 2002 at 6:35 pm
    Jul 19, 2002 at 2:11 pm
  • We have src/utils for stuff supposedly that is used by the backend and other binaries, and src/backend/port for stuff used only by the backend. However, over time, this distinction has broken down ...
    Bruce MomjianBruce Momjian
    Jul 15, 2002 at 10:54 pm
    Jul 18, 2002 at 12:30 am
  • When trying to perform a full vacuum I am getting the following error: ERROR: No one parent tuple was found Plain vacuum works fine. Thinking it might be a problem with the indexes I have rebuilt ...
    Barry LindBarry Lind
    Jul 10, 2002 at 3:40 am
    Jul 10, 2002 at 6:27 am
  • Hi, I see different results in Oracle and postgres for same outer join queries. Here are the details. I have the following tables in our pg db table: yuva_test1 yt1_id yt1_name yt1_descr 1 1-name1 ...
    Yuva ChandoluYuva Chandolu
    Jul 31, 2002 at 3:53 am
    Jul 31, 2002 at 5:39 pm
  • One of my machines has two CPUs, and in some cases I build a pair of indexes in parallel to take advantage of this. (I can't seem to do an ALTER TABLE ADD PRIMARY KEY in parallel with an index build, ...
    Curt SampsonCurt Sampson
    Jul 18, 2002 at 12:12 am
    Jul 28, 2002 at 4:39 pm
  • Hello, I would like to implement a function similar to the Decode function in Oracle. I was wondering if it is possible to accept a variable number of parameters (array??). Thanks, Edwin S. Ramirez
    Edwin S. RamirezEdwin S. Ramirez
    Jul 23, 2002 at 9:47 pm
    Jul 26, 2002 at 3:43 pm
  • Mac OS X: postgres% psql --version psql (PostgreSQL) 7.2.1 contains support for: multibyte LEDEV=# create table test1 (foo varchar(5)); CREATE LEDEV=# create table test2 (foo char(5)); CREATE LEDEV=# ...
    Scott RoystonScott Royston
    Jul 11, 2002 at 9:47 pm
    Jul 12, 2002 at 3:28 pm
  • There seems to have been an accumulation lately of stuff that was simply dumped into the source tree without any sort of integration. I am particularly talking about interfaces/ssl and ...
    Peter EisentrautPeter Eisentraut
    Jul 9, 2002 at 10:15 pm
    Jul 10, 2002 at 4:17 am
  • I'd like to implement error codes. I think they would be pretty useful, although there are a few difficulties in the implementation I'd like to get some input on. Should every elog() have an error ...
    Neil ConwayNeil Conway
    Jul 17, 2002 at 6:27 pm
    Nov 26, 2002 at 11:57 pm
  • (crossposted to -hackers, should follow up on that list) Right. So you can do your example pretty easily: thomas=# select overlay(f1 placing '' from position('/local' in f1) thomas-# for ...
    Thomas LockhartThomas Lockhart
    Jul 12, 2002 at 3:07 pm
    Aug 12, 2002 at 9:56 pm
  • What's with this manual page? http://candle.pha.pa.us/main/writings/pgsql/sgml/gist.html Seems like it's almost accidental - like a copied and pasted email. It doesn't look like it should be there? ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 30, 2002 at 6:06 am
    Jul 30, 2002 at 3:40 pm
  • I have a need for relation synonyms in PostgreSQL. I don't see it in 7.2.1 but the catalog seems to be able to support it more or less. Here's what I intend to do: 1) Create a duplicate record in ...
    Marc LavergneMarc Lavergne
    Jul 24, 2002 at 6:24 am
    Jul 26, 2002 at 3:22 am
  • Shouldn't the effect of ALTER TABLE ALTER COLUMN SET STATISTICS be recorded by pg_dump? For example: CREATE TABLE foo (col1 int, col2 int); ALTER TABLE foo ALTER COLUMN col1 SET STATISTICS 100; $ ...
    Neil ConwayNeil Conway
    Jul 19, 2002 at 4:27 pm
    Jul 20, 2002 at 1:02 am
  • I was getting CVS errors because regress/GNUmakefile does an 'rm -rf results', removing the CVS directory from results. This was causing my 'cvs update's to fail. My fix was to change 'rm -rf ...
    Bruce MomjianBruce Momjian
    Jul 2, 2002 at 5:03 am
    Jul 4, 2002 at 5:23 am
  • Hi, i want to announce you the release of a new PostgreSQL Interface... its name is XPg, and it was made on Java under the GPL license. Please, check the site... it could be a useful tool for much ...
    Gustavo Gonzalez GironGustavo Gonzalez Giron
    Jul 21, 2002 at 6:12 pm
    Jul 30, 2002 at 2:59 am
Jul 2002
1234
Group Navigation
period‹ prev | Jul 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions181
posts1,290
users117
websitepostgresql.org...
irc#postgresql

117 users for July 2002

Tom Lane: 220 posts Bruce Momjian: 214 posts Christopher Kings-Lynne: 122 posts Hannu Krosing: 65 posts Peter Eisentraut: 45 posts Rod Taylor: 45 posts Thomas Lockhart: 45 posts Tatsuo Ishii: 41 posts Marc G. Fournier: 38 posts Curt Sampson: 36 posts Neil Conway: 35 posts Lamar Owen: 25 posts Joe Conway: 21 posts Jan Wieck: 17 posts Hiroshi Inoue: 16 posts Andreas Zeugswetter: 13 posts Andrew Sullivan: 13 posts Marc Lavergne: 13 posts Iavor Raytchev: 11 posts Luis Alberto Amigo Navarro: 11 posts
show more
Archives