FAQ

PostgreSQL > pgsql-hackers > June 2004

Search Discussions

156 discussions - 1,037 posts

  • We were discussing prepared statement support for libpqxx just now (Bruce, Peter Eisentraut & myself are manning the postgres booth at LinuxTag 2004 in Karlsruhe, Germany), when we ran into a problem ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Jun 23, 2004 at 4:16 pm
    Jul 12, 2004 at 9:59 am
  • (warning: rehashing of issues ahead) Sometimes when I talk to technical people about using PostgreSQL, I get a strong reaction along the lines of "it's ugly, complex, and hard to set up." While we ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jun 9, 2004 at 10:20 am
    Jun 16, 2004 at 6:49 pm
  • I have an idea, let me know what you all think. rather than do: select sum( field) from largetable I want (need) to be able to do something like this: select setval('myseq', select sum(field) from ...
    Mark L. WoodwardMark L. Woodward
    Jun 8, 2004 at 3:15 am
    Oct 21, 2004 at 4:32 pm
  • Hi, This is a preview patch - DON'T COMMIT IT TO HEAD! What I've done in this patch is add the following: ALTER AGGREGATE / OWNER TO ALTER CONVERSION / OWNER TO ALTER FUNCTION / OWNER TO ALTER ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 15, 2004 at 2:57 am
    Jun 19, 2004 at 8:29 am
  • I see the problems with the existing mechanisms, but just to float an idea - what about adding a GUC variable that can be used to specify an amount of shared memory to use as a fifo area in which a ...
    Dave PageDave Page
    Jun 7, 2004 at 1:44 pm
    Jun 19, 2004 at 3:05 am
  • I am wondering why thread_test.c is checking for mktemp()? That function is nowhere used in the libpq. Also, I would suggest that we allow to build the libpq with thread specific compiler options, ...
    Jan WieckJan Wieck
    Jun 9, 2004 at 1:13 pm
    Jul 10, 2004 at 1:23 am
  • They still suck; I'm not aware of any situation where I'd recommend hash over btree indexes in Postgres. I think we have fixed the hash indexes' deadlock problems as of 7.4, but there's still no real ...
    Tom LaneTom Lane
    Jun 5, 2004 at 8:03 pm
    Aug 14, 2004 at 12:35 am
  • I was just about to commit a patch that revises the btree index build procedure as discussed here: http://archives.postgresql.org/pgsql-general/2004-05/msg00480.php specifically, not using shared ...
    Tom LaneTom Lane
    Jun 1, 2004 at 12:28 am
    Jun 1, 2004 at 8:31 pm
  • I've been down several roads about how to handle data that has to change on a very frequent and rapid manner. Think about summary tables, WEB session tables, etc. As great as MVCC is for the vast ...
    Mark L. WoodwardMark L. Woodward
    Jun 8, 2004 at 7:07 pm
    Jun 10, 2004 at 5:42 pm
  • I think a warning is missing if I create a table without OIDS that inherits from a table with oids: kalman=# create table test ( a integer ); CREATE TABLE kalman=# create table test_2 ( b integer ) ...
    Gaetano MendolaGaetano Mendola
    Jun 22, 2004 at 10:38 pm
    Jun 28, 2004 at 11:14 am
  • I have been harping for the last few days (years, actually) about tweaks and changes to PostgreSQL for a number of reasons ranging from session management to static tables. I even had a notion to ...
    Mark L. WoodwardMark L. Woodward
    Jun 12, 2004 at 4:19 am
    Jun 14, 2004 at 11:21 am
  • Why does postgres maintain a loader logic of its own? I can understand that the dynamic_library_path is necessary in order to configure everything in one single place. But why not just merge it with ...
    Thomas HallgrenThomas Hallgren
    Jun 8, 2004 at 8:48 am
    Jun 9, 2004 at 2:36 pm
  • Hello all, I've created a lock timeout patch and it's attached. When a transaction is blocked by another transaction because of waiting a lock, we need a lock timeout in some cases. Using this patch, ...
    Satoshi NagayasuSatoshi Nagayasu
    Jun 28, 2004 at 3:29 am
    Jun 30, 2004 at 3:19 am
  • OK, I think it might save me some time if I get some guidance on how we should modify pg_dump to fix the owner/grants issue. I intend to make new archives created with 7.5 pg_dump have the fix, and ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 24, 2004 at 3:52 am
    Jun 28, 2004 at 3:46 am
  • I have tried your patches and it works great. Thanks. One thing I noticed was if I change tablespace for a table having indexes, they are left in the old tablespace and the table itself was moved to ...
    Tatsuo IshiiTatsuo Ishii
    Jun 20, 2004 at 12:39 pm
    Jun 21, 2004 at 5:14 am
  • I'm getting the following error when trying to initdb with CVS tip. This is on win XP, though I don't know if it's win32 specific. Also of note, although it says it's clearing the contents of the ...
    Dave PageDave Page
    Jun 18, 2004 at 10:21 pm
    Jul 28, 2004 at 2:30 pm
  • Hi all, Can anyone tell me if postgresql has problems with xeon processors? If so, there is any fix or project of fix it? Thanx in advance, Jaime Casanova
    Jaime CasanovaJaime Casanova
    Jun 25, 2004 at 8:13 pm
    Jul 1, 2004 at 5:03 pm
  • I've noticed yet another hole in our handling of object permissions, which is that ALTER OWNER doesn't modify the object ACL list at all. This leads to unpleasant results. For example, in CVS tip: ...
    Tom LaneTom Lane
    Jun 1, 2004 at 10:07 pm
    Jun 3, 2004 at 10:10 am
  • In line with my idea of keeping the hackers up to date with stuff in the IRC channel, here are the topics of the week: * We have a request for granting on all tables every other day (already in TODO) ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 15, 2004 at 6:18 am
    Jun 16, 2004 at 6:37 am
  • Hi, I checked out the windows port to play with. It compiled file but 'make check' produced attached regression diff. I am using the nightly snapshot. Is it too early to look at these failures or did ...
    Shridhar DaithankarShridhar Daithankar
    Jun 7, 2004 at 10:57 am
    Jun 8, 2004 at 4:33 pm
  • Yes, Slonik's, it't true. After nearly a year the Slony-I project is entering the BETA phase for the 1.0 release. Please visit http://gborg.postgresql.org/project/slony1/news/newsfull.php?news_id=174 ...
    Jan WieckJan Wieck
    Jun 4, 2004 at 5:01 am
    Jun 8, 2004 at 12:35 pm
  • Near the end of repair_frag() in vacuum.c -- under the comment /* clean moved tuples from last page in Nvacpagelist list */ -- there is code that marks itemids as unused. Itemids affected are those ...
    Manfred KoizarManfred Koizar
    Jun 10, 2004 at 8:07 pm
    Feb 15, 2005 at 3:50 am
  • hi, i am wondering what you think about including evgen potemkin's patch for recursive SQL in the next postgres version: http://gppl.terminal.ru/ cons: - its not standard SQL (uses oracle style ...
    jacob koehler (RRes-Roth)jacob koehler (RRes-Roth)
    Jun 26, 2004 at 7:21 pm
    Jul 1, 2004 at 5:04 am
  • Next Monday, we're going to put out a 7.4.3 release, incorporating all the little patches that have been back-patched to date ... I just setup a cron job that will build a nightly snapshot of ...
    Marc G. FournierMarc G. Fournier
    Jun 8, 2004 at 4:03 pm
    Jun 14, 2004 at 2:24 pm
  • Stop me if you've heard this before. I'm looking at fast calculation of aggregates (sum(), max(), count()) across large tables, or across fairly simply defined subsets of those tables. Lets say that, ...
    Steve AtkinsSteve Atkins
    Jun 11, 2004 at 7:42 am
    Jun 15, 2004 at 3:47 am
  • (moved to -hackers) Is it conceivable that different SERIAL sequence names could now be generated? ie. If I upgrade from 7.4 with a dump that looks like this: CREATE TABLE blah ( id SERIAL ); COPY ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 11, 2004 at 1:42 am
    Jun 13, 2004 at 5:24 pm
  • There's just one thing left to do to make composite types useful as table columns: we have to support I/O of composite values. (Without this, pg_dump would fail to work on such columns, rendering ...
    Tom LaneTom Lane
    Jun 5, 2004 at 4:57 pm
    Jun 10, 2004 at 2:26 pm
  • Would anyone else think that dumping: SET client_min_messages TO warning; In pg_dumps would be cool? It would mean that while restoring a dump you can actually see the wood for the trees when trying ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 29, 2004 at 2:43 am
    Jul 11, 2004 at 9:50 pm
  • Hi! since we have a lot of databases here that suffer from pg_dump's deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from the upcoming 7.5 release. This version works much better, ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Jun 18, 2004 at 2:38 pm
    Jun 25, 2004 at 6:16 am
  • Although DROP TABLESPACE can detect tables existing in the target tablespace, it doesn't have any way to detect schemas that reference that tablespace as their default tablespace. Thus you can get ...
    Tom LaneTom Lane
    Jun 19, 2004 at 1:10 am
    Jun 19, 2004 at 10:26 pm
  • template1=# BEGIN; BEGIN template1=# CREATE TABLE foobar (foo char(10)); CREATE TABLE template1=# select relname, relfilenode from pg_class where relname='foobar'; relname | relfilenode ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 12, 2004 at 12:49 pm
    Jun 14, 2004 at 1:49 pm
  • Dear hackers, It seems that current cvs head regression tests are broken, at least on my debian laptop. That does not help with developping some new patch... sh uname -a Linux sablons 2.4.20-3-686 #1 ...
    Fabien COELHOFabien COELHO
    Jun 8, 2004 at 1:53 pm
    Jun 9, 2004 at 4:53 am
  • For adminstrator's convenience, I'd like to see a function that returns the serverlog. Are there any security or other issues that should prevent me from implementing this? Regards, Andreas
    Andreas PflugAndreas Pflug
    Jun 7, 2004 at 12:01 am
    Jun 7, 2004 at 3:54 pm
  • Is it me or has the default locale of created databases change at some point? Currently, on Linux, if one does not specify a locale, the locale is taken from the system environment and it is not "C." ...
    Mark L. WoodwardMark L. Woodward
    Jun 2, 2004 at 5:39 pm
    Jun 3, 2004 at 2:10 am
  • Now that PG will have tablespaces I can stick my really high I/O data on a fiberchannel array, and save some money by putting the rest of it (also the majority of it) on less expensive SCSI RAID ...
    Mike RylanderMike Rylander
    Jun 28, 2004 at 7:14 pm
    Aug 6, 2004 at 2:11 pm
  • Chris KL just raised an issue on IRC: test= create table test (a int4) tablespace pg_default; ERROR: permission denied for tablespace pg_default This wasn't encountered in my original patch because ...
    Gavin SherryGavin Sherry
    Jun 28, 2004 at 5:35 am
    Jun 29, 2004 at 1:45 pm
  • Tom doesn't like returning the server's logfile using a pgsql function unless logfile rotation is implemented, so here it is. This proposal doesn't include a daemon that triggers pg_logfile_rotate ...
    Andreas PflugAndreas Pflug
    Jun 13, 2004 at 4:43 pm
    Jun 19, 2004 at 9:10 am
  • Hi All, I've been attempting to recover some data from a data file that was dumped and compressed using pg_dump. I've noticed that the pg_restore application was supposed to have some work put into ...
    Chris BowlbyChris Bowlby
    Jun 15, 2004 at 4:54 pm
    Jun 16, 2004 at 2:09 am
  • (sorry I have to post it again in plain text) I'm currently working on a master student research project ¡°support triggers on columns¡± that is supervised by a professor from my university (Ottawa ...
    MarkMark
    Jun 28, 2004 at 1:44 pm
    Jan 29, 2005 at 4:20 am
  • Hackers, I think there a bug in the GUC mechanism. The custom variables patch added several malloc() and a strdup() call, and they are never checked for an out of memory condition. -- Alvaro Herrera ...
    Alvaro HerreraAlvaro Herrera
    Jun 24, 2004 at 5:27 am
    Jun 24, 2004 at 5:29 pm
  • Dear Gurus, I tried to shuffle through the archives but was lost in the technical details. Please feel free to tell me a search keyword suitable for my case if there's any. QUESTION1: is this error ...
    Szűcs GáborSzűcs Gábor
    Jun 9, 2004 at 8:30 am
    Jun 10, 2004 at 3:03 pm
  • It has been suggested a couple of times that we should use a different syntax for subtransactions than for main transactions. This would for example allow things like BEGIN; do something; SUBBEGIN; ...
    Alvaro HerreraAlvaro Herrera
    Jun 26, 2004 at 4:49 am
    Jul 11, 2004 at 12:21 am
  • ...on the assumption we now have archived xlogs, how do we do recovery? Default is to put all xlogs back into pg_xlog and then let recovery do its work...though clearly we all want finer ...
    Simon RiggsSimon Riggs
    Jun 15, 2004 at 8:52 pm
    Jun 23, 2004 at 8:46 am
  • In phpPgAdmin, I need to know if the backend supports tablespaces or not. What is the most reliable way of detecting that the backend is the win32 native version and hence does not support ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 30, 2004 at 2:45 pm
    Jun 30, 2004 at 10:06 pm
  • I'm having trouble accessing specific schemas and wonder if maybe I haven't installed something properly in 7.4.2. Here is what is happening: SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; ERROR: parser: ...
    Cason, KennyCason, Kenny
    Jun 29, 2004 at 7:07 pm
    Jun 30, 2004 at 12:27 am
  • Where are we on this? --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + ...
    Bruce MomjianBruce Momjian
    Jun 11, 2004 at 6:22 pm
    Jun 24, 2004 at 11:01 am
  • Hi all, I have defined a datatype called "varcharci", shamelessly yanking the input, output, recv and send functions from varchar. This means (as far as I understand things) that this type is binary ...
    Shachar ShemeshShachar Shemesh
    Jun 17, 2004 at 4:58 pm
    Jun 22, 2004 at 1:46 pm
  • (Moved to -hackers) Comment on TABLESPACE is impossible, no? Tablespaces are a global relation and pg_description isn't. I'll do RENAME and OWNER TO for tablespaces with this patch I'm working on atm ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 18, 2004 at 6:37 am
    Jun 19, 2004 at 8:24 am
  • [ Thread moved to hackers and win32.] Andreas Pflug wrote: What is the recommended way to create mutex objects (CreateMutex) from Win32 libraries? There must be a clean way like there is in pthreads. ...
    Bruce MomjianBruce Momjian
    Jun 11, 2004 at 6:03 pm
    Jun 14, 2004 at 5:33 am
  • DBMS like MySQL and hsqldb (the only two I know that can keep and process tables on the heap) have a CREATE DATABASE case in which the 'database' is specified to reside in memory, that is RAM. For ...
    AlbretchAlbretch
    Jun 6, 2004 at 6:17 pm
    Jun 8, 2004 at 12:44 am
Jun 2004
1234
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions156
posts1,037
users138
websitepostgresql.org...
irc#postgresql

138 users for June 2004

Tom Lane: 220 posts Bruce Momjian: 90 posts Christopher Kings-Lynne: 85 posts Alvaro Herrera: 44 posts Mark L. Woodward: 36 posts Andrew Dunstan: 33 posts Thomas Hallgren: 28 posts Andreas Pflug: 27 posts Greg Stark: 23 posts Jan Wieck: 22 posts Gaetano Mendola: 15 posts Gavin Sherry: 15 posts Darko Prenosil: 14 posts Dave Page: 14 posts Marc G. Fournier: 14 posts Merlin Moncure: 14 posts Shridhar Daithankar: 14 posts Simon Riggs: 14 posts Peter Eisentraut: 11 posts Dann Corbit: 9 posts
show more
Archives