FAQ

PostgreSQL > pgsql-hackers > January 2004

Search Discussions

138 discussions - 861 posts

  • We ran out of disk space on our main server, and now I've freed up space, we cannot start postgres! Jan 23 12:18:50 canaveral postgres[563]: [2-1] LOG: checkpoint record is at 2/96500B94 Jan 23 ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jan 23, 2004 at 8:29 pm
    Jan 31, 2004 at 4:54 am
  • Hello, Is is possible to change the transaction behaviour not to abort when a syntax error occurs. I've done some searches on the list, and have not found anything. -ESR-
    Edwin S. RamirezEdwin S. Ramirez
    Jan 30, 2004 at 3:50 pm
    Feb 23, 2004 at 5:40 pm
  • Hello, I think it's safe to say there is a working implementation of a signal handler. The one tricky part left is to identify some smart places for the backend to check the awaiting signal queue. ...
    Merlin MoncureMerlin Moncure
    Jan 22, 2004 at 3:00 pm
    Mar 14, 2004 at 5:37 am
  • As some know, win32 doesn't have sync, and some are concerned that sync isn't reliable enough during checkpoint anyway. The trick is to somehow record all files modified since the last checkpoint, ...
    Bruce MomjianBruce Momjian
    Jan 30, 2004 at 5:01 pm
    May 14, 2004 at 11:34 am
  • We frequently recommend to people that they increase sort_mem while creating btree indexes. It is reasonable to have a larger setting for that purpose, since (1) a single backend isn't going to be ...
    Tom LaneTom Lane
    Jan 31, 2004 at 10:00 pm
    Feb 12, 2004 at 5:06 pm
  • [ Moved to hackers.] I am starting to agree that our \d* handling is just too overloaded. Look at the option list from \?: Informational \d [NAME] describe table, index, sequence, or view ...
    Bruce MomjianBruce Momjian
    Jan 4, 2004 at 1:26 am
    Mar 31, 2004 at 1:06 am
  • How feasible would it be to have a btree index on ctid? I'm thinking it ought to work simply enough for the normal case of insert/delet/update, but I'm not completely certain how vacuum, vacuum full, ...
    Greg StarkGreg Stark
    Jan 27, 2004 at 8:41 pm
    Jan 31, 2004 at 12:50 am
  • Hi, Is this all that's planned for 7.5? (based on current TODO list) -Change factorial to return a numeric (Gavin) -COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ] ...
    OwOw
    Jan 12, 2004 at 7:14 pm
    Jan 26, 2004 at 6:33 pm
  • hello, this note is intended to describe my work on beginning to further integrate xml into postgresql. first, i'd like to thank the contributers of contrib/xml as their work was instrumental in ...
    Brian MooreBrian Moore
    Jan 25, 2004 at 9:07 am
    Jan 31, 2004 at 3:35 am
  • In CreateSharedMemoryAndSemaphores, there is the following comment, just before CreateLWLocks(): /* * Now initialize LWLocks, which do shared memory allocation and are * needed for InitShmemIndex. */ ...
    Claudio NatoliClaudio Natoli
    Jan 12, 2004 at 9:12 am
    Jan 27, 2004 at 2:46 pm
  • So one of the client machines for one of my databases at work resides on 10.128.0.45. I had to enter something in pg_hba.conf for it today, as we're bringing this database up. We have a lot of 10/8 ...
    Alex J. AvrietteAlex J. Avriette
    Jan 7, 2004 at 2:33 am
    Jan 7, 2004 at 9:56 pm
  • Because I've lost a lot of data using postgresql (and I know for sure this should'nt happen) I've gone a bit further reading documentations on my disks and... I have FUJITSU MAP3367NC 36G 10000 rpm ...
    OhpOhp
    Jan 27, 2004 at 9:44 pm
    Jan 31, 2004 at 9:19 pm
  • I've been looking (and coded) a little bit on named function calls. Calls on the form: foo (x = 13, y = 42) Implementing this means that the symbol = no longer can be defined by the user as an ...
    Dennis BjorklundDennis Bjorklund
    Jan 25, 2004 at 9:13 am
    Jan 26, 2004 at 7:48 pm
  • Just had a client point this out to me, and am wondering if its supposed to happen: 420_test= select dropgeometrycolumn('420_test','lroadline61','roads61_geom'); ERROR: permission denied for relation ...
    Marc G. FournierMarc G. Fournier
    Jan 19, 2004 at 7:50 pm
    Feb 4, 2004 at 5:36 pm
  • (I hope this is -hackers appropriate - feel free to point me elsewhere) I'm using 7.4.1 as the backend to several applications. Until recently, I've been developing solely single-threaded ...
    Steve AtkinsSteve Atkins
    Jan 14, 2004 at 6:46 am
    Jan 31, 2004 at 8:17 pm
  • This is not directly related to current development, but it is something that might need a low-level solution. I've been thinking for some time about how to enchance the current "XML support" (e.g., ...
    Peter EisentrautPeter Eisentraut
    Jan 9, 2004 at 6:46 pm
    Jan 21, 2004 at 5:06 am
  • libpq needs additional changes for complete thread safety: - openssl needs different initialization. - kerberos is not thread safe. - functions such as gethostbyname are not thread safe, and could be ...
    Manfred SpraulManfred Spraul
    Jan 11, 2004 at 2:11 pm
    Feb 11, 2004 at 9:58 pm
  • I've created a stub AM that literally does nothing. It indexes nothing. It scans for nothing. Nadda. It does just enough work to specify return values that prevent PG from dumping core. What I've ...
    Eric RidgeEric Ridge
    Jan 18, 2004 at 2:26 am
    Jan 19, 2004 at 3:59 am
  • http://www.postgresql.org/docs/7.3/static/transaction-iso.html#XACT-READ-COMMITTED Reading this: " BEGIN; UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345; UPDATE accounts SET ...
    Marc G. FournierMarc G. Fournier
    Jan 29, 2004 at 5:38 pm
    Jan 30, 2004 at 11:47 am
  • Just overheard one of my colleagues on the phone to one of our users taking them through the process of moving their PGDATA to a partition with space... With the various paths, service names, config ...
    Lee KindnessLee Kindness
    Jan 16, 2004 at 11:09 am
    Jan 16, 2004 at 5:42 pm
  • I've been looking in the sql200x draft and there are no function calls with named arguments. Thinking more about it, I'm not sure if it really is an important addition at all. I've got a number of ...
    Dennis BjorklundDennis Bjorklund
    Jan 27, 2004 at 4:34 pm
    Jan 28, 2004 at 5:16 pm
  • hello, i would like to begin work on the TODO item Allow backend to output result sets in XML i would like to know if anyone has already begun work on this item. if someone has already started work, ...
    Brian MooreBrian Moore
    Jan 20, 2004 at 6:34 am
    Jan 23, 2004 at 3:04 am
  • I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the ...
    Lamar OwenLamar Owen
    Jan 19, 2004 at 7:36 pm
    Jan 21, 2004 at 1:42 am
  • Hi all, After unsuccessfully trying to join the current OLE DB project on gborg, I'm writing my own. So far I don't have anything too fancy (just trying to get over the initial shock of what OLE DB ...
    Shachar ShemeshShachar Shemesh
    Jan 8, 2004 at 8:06 pm
    Jan 12, 2004 at 1:18 pm
  • The default installation in fedora does not work very well for non english people. For example. if I run psql and type COMMIT i get: dennis=# commit; WARNING: COMMIT: ingen transaktion p g while it ...
    Dennis BjörklundDennis Björklund
    Jan 9, 2004 at 7:10 am
    Jan 9, 2004 at 10:41 pm
  • how can i change default time format because now i have for example 2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out millisec. a tryed with Data-Style but there arent custom ...
    IvanIvan
    Jan 1, 2004 at 3:54 pm
    Jan 5, 2004 at 8:41 pm
  • Hi all, From the OLE DB manual: The problem - it appears there is no requirement to execute the command before asking about the rowset returned. Only setting the actual command and preparing it. This ...
    Shachar ShemeshShachar Shemesh
    Jan 19, 2004 at 2:14 pm
    Jan 30, 2004 at 10:50 am
  • Would it be okay if I add some .cvsignore files to cvs? So we don't need to get rows like ? po/tr.mo ? po/zh_CN.mo ? po/zh_TW.mo ? utils/mb/conversion_procs/euc_jp_and_sjis/libeuc_jp_and_sjis.so.0.0 ...
    Dennis BjorklundDennis Bjorklund
    Jan 24, 2004 at 7:43 am
    Jan 24, 2004 at 8:13 pm
  • Dear friends, In the past, there were several discussions in order to find suitable answers for MS Windows users willing to install and run PostgreSQL. Some of you suggested that users should ...
    Jean-Michel POUREJean-Michel POURE
    Jan 22, 2004 at 3:16 pm
    Jan 24, 2004 at 4:01 pm
  • I have hacked analyze.c to automatically create a unique index on the oid when a table is created and I am getting the failed to re-find parent key in pg_attribute_relid_attnam_index every 8 attempts ...
    Dave CramerDave Cramer
    Jan 13, 2004 at 9:31 pm
    Jan 14, 2004 at 2:41 pm
  • What is needed to provide spinlock support for linux on hppa? make[5]: Entering directory `/build/buildd/postgresql-7.4.1/build-tree/postgresql-7.4.1/src/backend/access/transam' ... hppa-linux-gcc ...
    Oliver ElphickOliver Elphick
    Jan 1, 2004 at 3:23 am
    Jan 4, 2004 at 6:52 pm
  • Hi Is it just me, or is there any way a sort could be relevant in a subquery? (except on queries containing volatile functions) select a.* from test1 a, (select id from test1 order by num) as b where ...
    Dennis HaneyDennis Haney
    Jan 27, 2004 at 4:27 pm
    Jan 27, 2004 at 10:31 pm
  • The GEQO planner module contains six different recombination algorithms, only one of which is actually used --- the others are ifdef'd out, and have been ever since we got the code. Does anyone see a ...
    Tom LaneTom Lane
    Jan 22, 2004 at 4:16 am
    Jan 23, 2004 at 5:51 am
  • This is what we did: 0. BEGIN; 1. ALTER TABLE ... SET WITHOUT OIDS 2. A bunch of things are selected out of this table and inserted into another (using INSERT ... SELECT) 3. An index is created on a ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jan 21, 2004 at 8:04 am
    Feb 12, 2004 at 5:40 am
  • I would like to register a "transaction callback" in the backend. Don't think it's possible today and my question is, how hard would it be to implement something that would enable this registration? ...
    Thomas HallgrenThomas Hallgren
    Jan 31, 2004 at 4:50 pm
    Jan 31, 2004 at 11:20 pm
  • [ CC to hackers added.] Uh, a password? What purpose would that serve? Isn't that something you control when attaching to the database? Is this for prompting for a username password? The problem is ...
    Bruce MomjianBruce Momjian
    Jan 27, 2004 at 2:42 am
    Jan 28, 2004 at 10:25 pm
  • Yes, my patch only handles pl/pgsql so far. The patch was big enough as it was. I've not looked at it since I sent it in, I wanted to see what happend with it before spending more time on it. Things ...
    Dennis BjörklundDennis Björklund
    Jan 7, 2004 at 5:59 am
    Jan 8, 2004 at 1:43 am
  • be merged (hope it hasn't bitrotted in the meantime): and user statements configurable using your setup. I thought we had thrashed this out back in August. Certainly the only thing I recall seeing ...
    Andrew DunstanAndrew Dunstan
    Jan 6, 2004 at 10:57 am
    Jan 6, 2004 at 10:36 pm
  • Gavin SherryGavin Sherry
    Jan 27, 2004 at 7:22 am
    Feb 12, 2004 at 7:21 pm
  • With improvement I can see that it can be materialized and thus used as a normal table in the planner. Is there any additional reasons that I can't see? But this limited optimization makes me wonder, ...
    Dennis HaneyDennis Haney
    Jan 23, 2004 at 6:37 pm
    Jan 27, 2004 at 5:28 pm
  • Floating point math itself is not precise, but rather an approximation, usually of 8 or 14 digits. You can't approximate money. This isn't a PostgreSQL issue but rather a general programming issue. ...
    Bruce MomjianBruce Momjian
    Jan 5, 2004 at 12:53 am
    Jan 12, 2004 at 6:14 pm
  • Hi there, I'm pleased to present pilot version of http://www.pgsql.ru - search system on postgresql related resources. Currently, we have crawled 27 sites, new resources are welcome. It has ...
    Oleg BartunovOleg Bartunov
    Jan 5, 2004 at 2:49 pm
    Jan 9, 2004 at 8:13 am
  • Hi, Was wondering if there was anything akin to an evaluate statement in Postgresql for dynamic strings? Alex
    A EA E
    Jan 4, 2004 at 9:09 pm
    Jan 6, 2004 at 4:25 pm
  • Is it possible to make a composite GiST index? I want to create an index on a txtidx and a timestamp column - is that at all possible? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jan 5, 2004 at 6:40 am
    Jan 5, 2004 at 3:41 pm
  • 2 things. I submitted a patch for this 5 months ago, which is still waiting to be merged (hope it hasn't bitrotted in the meantime): . Allow log lines to include session-level information, like ...
    Andrew DunstanAndrew Dunstan
    Jan 5, 2004 at 6:54 pm
    Mar 31, 2004 at 3:55 pm
  • I needed these, so I went and implemented them myself. I have to admit I'm not so wise on PostgreSQL backend stuff, and so I abstained from editing the fmgrtab.c and postgres.bki. Sorry for that, but ...
    David HelgasonDavid Helgason
    Jan 23, 2004 at 12:59 am
    Feb 12, 2004 at 4:06 pm
  • Dear Hackers, First: I think I have sent out a msg with no body. I'm sorry, I have to communicate thru a weird Win98 machine, it gets things screwed up sometimes. I would like to take up the ...
    BARTKO, ZoltanBARTKO, Zoltan
    Jan 29, 2004 at 6:24 am
    Feb 2, 2004 at 7:57 am
  • Hi folks, I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the schemas which existed in the original databases were not created in the new database. The CREATE SCHEMA commands are ...
    Dan LangilleDan Langille
    Jan 31, 2004 at 2:10 am
    Jan 31, 2004 at 5:11 pm
  • Hi, I've upgraded my production system to 741 yesterday, and just discovered this log message: statistic buffer is full. What does it mean? filing up too fast, no more stats, need to grow? What ...
    OhpOhp
    Jan 26, 2004 at 1:26 pm
    Jan 26, 2004 at 5:53 pm
  • Hi all, We are building security system for a project where the security is modeled based on the sql-92 GRANT/REVOKE statements. I was going through the documentation of postgresql related to ...
    Potuganti RamuPotuganti Ramu
    Jan 9, 2004 at 2:10 pm
    Jan 9, 2004 at 5:56 pm
Jan 2004
123
Group Navigation
period‹ prev | Jan 2004 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions138
posts861
users134
websitepostgresql.org...
irc#postgresql

134 users for January 2004

Tom Lane: 167 posts Bruce Momjian: 62 posts Andrew Dunstan: 35 posts Peter Eisentraut: 35 posts Christopher Kings-Lynne: 29 posts Dennis Björklund: 24 posts Jan Wieck: 22 posts Greg Stark: 20 posts Dave Cramer: 19 posts Ohp: 18 posts Marc G. Fournier: 18 posts Neil Conway: 17 posts Thomas Hallgren: 16 posts Claudio Natoli: 15 posts Simon Riggs: 14 posts Alvaro Herrera: 12 posts Eric Ridge: 11 posts Hannu Krosing: 11 posts Manfred Spraul: 11 posts Merlin Moncure: 9 posts
show more
Archives