FAQ

PostgreSQL > pgsql-hackers > May 2002

Search Discussions

178 discussions - 1,157 posts

  • Morning all ... Just a heads up that over the next little while, I'm planning on making a bunch of commits in order to work on making the code able to work natively in the above environments ... my ...
    Marc G. FournierMarc G. Fournier
    May 3, 2002 at 1:18 pm
    Jun 3, 2002 at 9:53 pm
  • Hi, Something is pretty broken in redhat 7.3 but I'm not sure what and I don't have time to dig further masm@test=# select cast('1967-04-18' as timestamptz); timestamptz ------------------------ ...
    Manuel SugawaraManuel Sugawara
    May 18, 2002 at 4:34 am
    Jun 7, 2002 at 5:11 am
  • Hi all, I followed the various threads regarding this for some time now. My current situation is: I'm working at a company which does industrial automation, and does it's own custom products. We try ...
    Joerg HessdoerferJoerg Hessdoerfer
    May 16, 2002 at 11:48 am
    Jun 19, 2002 at 12:48 pm
  • I mentioned in another thread, Windows does not support "fork()." PostgreSQL seems irrevocably tied to using fork(). Without a drastic rewrite of how postmaster works, I don't see a way to make a ...
    Mark L. WoodwardMark L. Woodward
    May 7, 2002 at 6:41 pm
    May 10, 2002 at 1:50 am
  • Just out of curiosity, does PostgreSQL have a mission statement? If so, where could I find it? If not, does anyone see a need? (No, I am not some rabid MBA, but it may be useful to have for those ...
    Mark L. WoodwardMark L. Woodward
    May 1, 2002 at 6:50 pm
    May 12, 2002 at 5:46 pm
  • Do we want a Win32 native version of PostgreSQL? The only reasons *not* to use Cygwin is licensing, installation hassles, and maybe stability or performance. Therefore, there is no strong technical ...
    Mark L. WoodwardMark L. Woodward
    May 8, 2002 at 2:32 pm
    May 10, 2002 at 5:04 pm
  • Hi, having been chased away from pgsql-novice by Rasmus Mohr, I come here to try my luck :-) I'm still new to this; so please be patient, if I ask silly questions. There has been a discussion ...
    Manfred KoizarManfred Koizar
    May 2, 2002 at 6:32 pm
    Jun 11, 2002 at 1:11 pm
  • As I set out to do the Windows semaphore thing, I notice it can get quite ugly. In the current CVS directory, there is pgsql/src/backend/port directory. I propose that this become a separate ...
    Mark L. WoodwardMark L. Woodward
    May 7, 2002 at 2:00 pm
    May 9, 2002 at 10:13 am
  • I find that this group is frustrating to work with. They seem very intolerant of the plurality. I did a configuration patch several months ago. I liked it, as did some others. It did not affect any ...
    Mark L. WoodwardMark L. Woodward
    May 13, 2002 at 3:34 pm
    May 15, 2002 at 3:45 am
  • From the client: COPY "unique_names" WITH OIDS FROM stdin; LOG: query: select getdatabaseencoding() pg_restore: LOG: query: Create Temporary Table pg_dump_blob_xref(oldOid pg_catalog.oid, newOid ...
    Ron SnyderRon Snyder
    May 31, 2002 at 11:36 pm
    Sep 29, 2002 at 2:56 am
  • I'm using 7.2.1 on a Debian system. If I do an insert or update or delete on a table, postgres tells me how many rows were affected. Using the following input to psql, I got the results: INSERT 0 0 ...
    Michael Alan DormanMichael Alan Dorman
    May 8, 2002 at 11:38 pm
    Aug 26, 2002 at 6:20 pm
  • With the current SRF patch, in certain circumstances selecting from a VIEW produces "Buffer Leak" warnings, while selecting from the function itself does not. Also the VIEW returns only one of the ...
    Joe ConwayJoe Conway
    May 9, 2002 at 5:56 pm
    May 28, 2002 at 12:50 pm
  • Hi, I have some schema queries/thoughts that I would appreciate some help/insights/fixes with/for please! (Apologies if these have been asked before or have been addressed in a recent snapshot - my ...
    Dave PageDave Page
    May 17, 2002 at 4:58 pm
    May 21, 2002 at 10:29 pm
  • Hi, we've got rather strange problem with updating and GiST indices. Below is a test run: drop table tst; create table tst ( a int[], i int ); copy tst from stdin; ........ \. create index tsti on ...
    Oleg BartunovOleg Bartunov
    May 25, 2002 at 9:31 am
    May 28, 2002 at 7:01 pm
  • Upon doing some inspection of apache 2.x, it seems that me making a SysV Windows .DLL for PostgreSQL, while a cool project, would be unnecessary. The APR (Apache Portable Runtime) seems to have all ...
    Mark L. WoodwardMark L. Woodward
    May 4, 2002 at 1:50 pm
    May 6, 2002 at 11:20 pm
  • If a VACUUM running concurrently with someone else's indexscan were to delete the index tuple that the indexscan is currently stopped on, then we'd get a failure when the indexscan resumes and tries ...
    Tom LaneTom Lane
    May 25, 2002 at 6:21 pm
    Sep 2, 2002 at 5:49 am
  • Currently there's an int16 t_natts in HeapTupleHeaderData. This number is stored on disk for every single tuple. Assuming that the number of attributes is constant for all tuples of one relation we ...
    Manfred KoizarManfred Koizar
    May 5, 2002 at 9:48 pm
    Jun 12, 2002 at 6:28 pm
  • I've run into an interesting issue. A very long running transaction doing data loads is getting quite slow. I really don't want to break up the transactions (and for now it's ok), but it makes me ...
    Rod TaylorRod Taylor
    May 1, 2002 at 2:27 pm
    Jun 12, 2002 at 4:02 am
  • Since we now have an official entry in /etc/services, shouldn't we be able to make use of it, by using getservbyname() if a nonnumeric port number is specified? -- Peter Eisentraut peter_e@gmx.net
    Peter EisentrautPeter Eisentraut
    May 20, 2002 at 8:34 pm
    Jun 8, 2002 at 5:25 pm
  • There has been a discussion on the general list about this area. One of the members produced a test case for demonstrating rapid size increase. I decided to see if I could induce similar behaviour ...
    Mark kirkwoodMark kirkwood
    May 7, 2002 at 6:25 am
    May 21, 2002 at 10:31 pm
  • There is a report from a debian user about a vulnerability in PostgreSQL pre 7.2. Here is a possible attack scenario which allows to execute ANY SQL in PostgreSQL. A web application accepts an input ...
    Tatsuo IshiiTatsuo Ishii
    May 2, 2002 at 8:19 am
    Jun 13, 2002 at 1:10 am
  • Hi, could anyone please enlighten me about the status of replication? I do expect lots of questions about this, and I'm not really sure if I can promise it for 7.3. :-) Yes, I know it#s marked urgent ...
    Michael MeskesMichael Meskes
    May 27, 2002 at 3:40 pm
    May 30, 2002 at 12:23 pm
  • Hi, I just noticed plpgsql evaluates all AND'ed conditions even if the first one fails. Example: elsif TG_OP = ''UPDATE'' and old.type_reponse = ''abandon'' This will break stuff if the trigger is ...
    Louis-David MitterrandLouis-David Mitterrand
    May 28, 2002 at 7:20 am
    Jun 1, 2002 at 8:58 pm
  • Here is a revised patch for a sample C function returning setof composite. (Same comments as last time -- It is a clone of SHOW ALL as an SRF. For the moment, the function is implemented as ...
    Joe ConwayJoe Conway
    May 27, 2002 at 1:30 am
    Jun 10, 2002 at 6:22 am
  • I'm working on cleaning up loose ends in pg_dump, and in particular trying to ensure that objects in user schemas can be named the same as system objects without conflicts. Most of this works now, ...
    Tom LaneTom Lane
    May 13, 2002 at 9:35 pm
    May 14, 2002 at 10:30 am
  • For my own protection I'm adding checks to truncate so that if there is an ON DELETE trigger it will not execute the truncate command. Anyway, should it really only be 'Disallow TRUNCATE on tables ...
    Rod TaylorRod Taylor
    May 12, 2002 at 3:55 pm
    May 14, 2002 at 1:25 am
  • It is sunday morning and I have been musing about some PostgreSQL issues. As some of you are aware, my dot com, dot died, and I am working on a business plan for a consulting company which, amongst ...
    Mark L. WoodwardMark L. Woodward
    May 5, 2002 at 2:06 pm
    Aug 29, 2002 at 6:22 pm
  • Hi there. I'm yet another developer working full-time on a native windows port. I'm also working closely with Jan Wieck (next office). I know there is a reluctance to modify the code base to support ...
    Katherine WardKatherine Ward
    May 30, 2002 at 9:33 pm
    Jun 1, 2002 at 3:55 pm
  • With 7.1.3, large indexes with null values allowed in one or more of the columns would cause crashes. (I have definitely seen this happen). Here is a project that mentions repairs: ...
    Dann CorbitDann Corbit
    May 28, 2002 at 7:09 pm
    May 30, 2002 at 1:58 pm
  • I'm working on a revised patch for PREPARE/EXECUTE. The basic code has been written (although I've been delayed due to the workload at school). I'm now trying to add support for preparing queries ...
    Neil ConwayNeil Conway
    May 1, 2002 at 12:11 am
    May 28, 2002 at 1:17 am
  • As per earlier vague hint, I'm bringing the CREATE FUNCTION syntax in line with SQL99. Everything is fully backward compatible. Here is the new synopsis: CREATE [OR REPLACE] FUNCTION name (args) ...
    Peter EisentrautPeter Eisentraut
    May 16, 2002 at 5:24 pm
    May 18, 2002 at 7:26 pm
  • I've been looking at the authentication and networking code and would like to float a trial balloon. 1) add SASL. This is a new standards-track protocol that is often described as "PAM" for network ...
    Bear GilesBear Giles
    May 18, 2002 at 5:39 pm
    Jun 7, 2002 at 5:29 am
  • There seems to be a pg_dump issue with inherited tables when columns are added to the parent table after creating the child table. Here is how to repeat the problem. Create a test database and run ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    May 22, 2002 at 2:06 pm
    May 25, 2002 at 10:05 pm
  • I'm planning to tackle the problem of killing index tuples for dead rows during normal processing (ie, before VACUUM). We've noticed repeatedly that visits to dead heap rows consume a lot of time ...
    Tom LaneTom Lane
    May 21, 2002 at 5:43 pm
    May 22, 2002 at 9:56 pm
  • [Cc:ed to hackers] (trying select convert(lower(convert('X', 'LATIN1')),'LATIN1','UNICODE');) SQL standard? The SQL standard says nothing about locale. So making lower() (and others) "locale aware" ...
    Tatsuo IshiiTatsuo Ishii
    May 11, 2002 at 1:38 am
    May 20, 2002 at 8:26 am
  • Are you using 7.2 ? Your settings probably worked well under 7.1 but doesn't in 7.2 due to the following change in tcop/postgres.c. /* * It is possible that the original query was removed due to * a ...
    Hiroshi InoueHiroshi Inoue
    May 2, 2002 at 5:46 am
    May 5, 2002 at 11:14 pm
  • Attached is the first cut at some SSL documetation for the PostgreSQL manual. It's in plain text, not DocBook, to make editing easy for the first few revisions. The documentation leads the code by a ...
    Bear GilesBear Giles
    May 20, 2002 at 8:49 pm
    Jun 19, 2002 at 6:59 am
  • Hi, I've got performance problem and while I'dont ready to describe it I'd like to ask about strange explain: tour=# explain analyze select * from tours where ( operator_id in (2,3,4,5,7) and type_id ...
    Oleg BartunovOleg Bartunov
    May 13, 2002 at 2:17 pm
    May 14, 2002 at 1:40 pm
  • During some testing of pgAdmin's internals whilst adding schema support I noticed that altering or setting a comment on an operator actually sets the comment on the operator function. In other words, ...
    Dave PageDave Page
    May 12, 2002 at 9:03 pm
    Jun 5, 2002 at 8:45 pm
  • Hello, We are a small group around pgaccess and Teo (teo@flex.ro) who use pgaccess in our daily work and now we try to join our efforts and bring our patches together. During the last two weeks we ...
    Iavor RaytchevIavor Raytchev
    May 9, 2002 at 1:31 pm
    Jun 4, 2002 at 6:19 pm
  • I'm writing a function that accepts a table name and digs some information out about it. I'm developing on 7.3cvs w/schemas, and wanted my function to use schemas. If the user gives a full schema ...
    Joel BurtonJoel Burton
    May 19, 2002 at 9:03 pm
    May 24, 2002 at 9:28 pm
  • I've been buried in the backend parser/planner/executor now for the last 2 weeks or so, and I now have a patch for a working implementation of SRFs as RTEs (i.e. "SELECT tbl.* FROM myfunc() AS tbl"). ...
    Joe ConwayJoe Conway
    May 6, 2002 at 5:40 pm
    May 12, 2002 at 3:55 pm
  • Dear Team, I have been monitoring this list for quite some time now and have been studying PostGreSQL for a while. I also did some internet research on the subject of "multi valued" database theory. ...
    ArthurArthur
    May 1, 2002 at 6:52 pm
    May 2, 2002 at 12:11 pm
  • At the end of this message is some code I used to find medians. It's kind of a hack, but approximately works, and is intended as a somewhat awkward stopgap for people who need to use medians. It ...
    Josh BurdickJosh Burdick
    May 30, 2002 at 8:28 pm
    May 30, 2002 at 10:35 pm
  • There are certain oddities in current interval behaviour: template1=# select version(); version ------------------------------------------------------------------ PostgreSQL 7.3devel on ...
    Oliver ElphickOliver Elphick
    May 22, 2002 at 8:23 am
    May 28, 2002 at 10:12 pm
  • The following steps should fix the configure and compile problems that was occuring with installing Postgres 7.2 on HPUX 11.11. using the gcc compiler (See below for reference posts) for compiling ...
    Umang PatelUmang Patel
    May 1, 2002 at 8:22 pm
    May 22, 2002 at 2:38 pm
  • Just noticed this a few minutes ago on build from cvs tip: make -C preproc all make[4]: Entering directory `/opt/src/pgsql/src/interfaces/ecpg/preproc' bison -y -d preproc.y conflicts: 2 ...
    Joe ConwayJoe Conway
    May 16, 2002 at 11:51 pm
    May 22, 2002 at 9:51 am
  • For those who want to play on the bleeding edge of CVS, can someone provide the syntax for the recently-checked-in set-returning functions? I've got it figured out when I'm returning a many rows of ...
    Joel BurtonJoel Burton
    May 18, 2002 at 7:09 pm
    May 19, 2002 at 2:35 am
  • Since locale support is now enabled by default, it is desirable that the regression tests can pass if the clusters locale is not C. As a first step I have included the following statements in ...
    Peter EisentrautPeter Eisentraut
    May 10, 2002 at 9:25 pm
    May 12, 2002 at 3:47 pm
  • Hello postgresql-hackers, Been a while sine I've particiapated on this list so I wanted to say thank you for the great product postgresql 7.2.1 is! I have been doing some testing in preperation of a ...
    Ryan BradetichRyan Bradetich
    May 6, 2002 at 6:34 pm
    May 8, 2002 at 3:55 am
May 2002
1234
Group Navigation
period‹ prev | May 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions178
posts1,157
users136
websitepostgresql.org...
irc#postgresql

136 users for May 2002

Tom Lane: 264 posts Mark L. Woodward: 62 posts Marc G. Fournier: 42 posts Hannu Krosing: 40 posts Joe Conway: 35 posts Thomas Lockhart: 33 posts Joel Burton: 31 posts Dann Corbit: 30 posts Christopher Kings-Lynne: 28 posts Rod Taylor: 26 posts Jean-Michel Poure: 24 posts Jan Wieck: 23 posts Manfred Koizar: 21 posts Neil Conway: 21 posts Peter Eisentraut: 21 posts Dave Page: 20 posts Michael Meskes: 20 posts Lamar Owen: 19 posts Bear Giles: 17 posts Nigel J. Andrews: 16 posts
show more
Archives