Search Discussions

176 discussions - 951 posts

  • Hi all, Following is a proposal to implement what SQL2003 calls 'SQL-Invoked Procedures' and what most people refer to as stored procedures. Fujitsu will be funding Neil Conway and I to work on this ...
    Gavin SherryGavin Sherry
    Sep 23, 2004 at 3:00 am
    Oct 21, 2004 at 5:16 pm
  • Anyone working on the libpq interface to prepared statements? We could really use that for DBD::Pg. Alternatively, if someone knows a trick to prepare an INSERT statement without knowing the data ...
    Greg Sabino MullaneGreg Sabino Mullane
    Sep 14, 2004 at 1:14 am
    Oct 18, 2004 at 11:18 pm
  • Hi all, now that Apache Portable Runtime was release why don't use it on Postgres? Regards Gaetano Mendola
    Gaetano MendolaGaetano Mendola
    Sep 4, 2004 at 8:33 pm
    Oct 9, 2004 at 12:42 am
  • very good. just think of future MSVC versions. Just one more glitch: #undef rename #undef unlink has to be defined before #include <unistd.h on CYGWIN, because unistd.h has the declarations for ...
    Reini UrbanReini Urban
    Sep 10, 2004 at 9:17 am
    Oct 13, 2004 at 9:07 pm
  • On an x86_64 machine I'm finding that I cannot configure --with-python without the attached patch. Undoubtedly there is a better way to fix this -- any suggestions? Another configure issue: I find ...
    Joe ConwayJoe Conway
    Sep 9, 2004 at 6:17 pm
    Sep 15, 2004 at 11:07 pm
  • Here's another thing that I think it would be good to fix in 8.0. We've had numerous complaints before about RI constraints not firing inside PL functions; a recent one is ...
    Tom LaneTom Lane
    Sep 7, 2004 at 7:04 pm
    Sep 10, 2004 at 6:55 pm
  • I have already this mail to PATCHES mailing list and nobody replied me !!!., Hope the hackers and the developers send their ideas. Qustion: is this approach is suitable for solving the need for ...
    Mahmoud TaghizadehMahmoud Taghizadeh
    Sep 19, 2004 at 6:53 am
    Sep 26, 2004 at 6:51 am
  • Are there any plans to support indexed views, or cross-table indexes, or any form of "materialized views" in postgresql? How complex would the implementation be? Indexed views are sometimes the best ...
    Tiago WrightTiago Wright
    Sep 5, 2004 at 8:37 pm
    Sep 12, 2004 at 10:06 pm
  • Hi everybody, I have started testing PostgreSQL on windows. Now that I have managed to import a dump of one of our production databases to postgres on my notebook, there is one issue that came up ...
    Michael PaesoldMichael Paesold
    Sep 17, 2004 at 1:36 pm
    Sep 21, 2004 at 11:42 pm
  • Hi list, is it is known that postgres 8.0 (beta1 and beta2 both same behavoir) will eat tons of memory on Windows under heavy load? Scenario: I have a big delete with about 56000 rows. (DELETE FROM ...
    Daniel SchuchardtDaniel Schuchardt
    Sep 11, 2004 at 9:36 pm
    Sep 15, 2004 at 3:49 am
  • Hi all, I was implement the "transaction idle timeout" function in PostgreSQL (version 7.4.5 and 8.0.0beta2) test=# SET trans_idle_timeout=10; SET test=# BEGIN; BEGIN (ps) ... postgres: sygma test ...
    Szima GáborSzima Gábor
    Sep 17, 2004 at 6:45 am
    Sep 20, 2004 at 12:42 pm
  • I have a complaint from an OLE DB user that when he does "select 'a'", he gets an "unhanded type" error. Since OLE DB uses a binary interface, it has to know about all variable types that pass ...
    Shachar ShemeshShachar Shemesh
    Sep 28, 2004 at 6:30 pm
    Mar 17, 2005 at 3:31 pm
  • Problem: PL/Java use a JVM. On some platforms and with some JVM's (Sun's in particular) a libzip.so is bundled that contains a 1.1.3 version of functions also provided in zlib (why they do this is ...
    Thomas HallgrenThomas Hallgren
    Sep 23, 2004 at 11:02 am
    Sep 26, 2004 at 1:44 pm
  • I'm seeing an intermittent assertion failure while running "make check" with current sources. I can usually reproduce the problem at least once out of every 3 or 4 runs of "make check" on each of two ...
    Neil ConwayNeil Conway
    Sep 16, 2004 at 7:32 am
    Sep 22, 2004 at 4:03 am
  • HI, I'm using 7.4.5 on Mac OS X (G5) and was profiling it to see why it is SO SLOW at committing inserts and deletes into a large database. One of the many slowdowns was from MemSet. I found an old ...
    Marc ColosimoMarc Colosimo
    Sep 14, 2004 at 1:47 pm
    Oct 1, 2004 at 8:40 pm
  • Tom, I noticed your recent corrections to lock.c regarding the releasing of locks in an out of shared memory condition. This may or may not be relevant, but when I purposefully use up all the lock ...
    Merlin MoncureMerlin Moncure
    Sep 28, 2004 at 6:53 pm
    Oct 4, 2004 at 9:05 am
  • Yes, I thought that too - but not for me, not now. Look here: http://research.microsoft.com/db/ImmortalDB/ for similar Best Regards, Simon Riggs
    Simon RiggsSimon Riggs
    Sep 28, 2004 at 7:08 am
    Oct 1, 2004 at 12:27 am
  • The attached archive contains a script that I used to reproduce the error multiple times. Setup: * create database crashtest * start 6 instances of testload.tcl as ./testload.tcl tN dbname=crashtest ...
    Jan WieckJan Wieck
    Sep 24, 2004 at 8:10 pm
    Sep 26, 2004 at 12:29 am
  • I'd like to make it possible to perform function calls in PL/PgSQL without needing to use PERFORM. I think this would be useful because (a) it is closer to how PL/SQL works (b) PERFORM is (IMHO) a ...
    Neil ConwayNeil Conway
    Sep 15, 2004 at 4:07 am
    Sep 17, 2004 at 3:38 am
  • In recognition of his role as lead developer on the internationalization front, as well as his invaluble work in both the build and release processes, Peter Eisentraut has been invited, and has ...
    Marc G. FournierMarc G. Fournier
    Sep 15, 2004 at 10:52 pm
    Sep 16, 2004 at 2:16 pm
  • For our research project, I need to implement an encryption support for Postgressql. At this current phase, I need to at least support page level encryption In other words, each page that belongs to ...
    Murat KantarciogluMurat Kantarcioglu
    Sep 9, 2004 at 9:05 pm
    Sep 10, 2004 at 7:36 pm
  • On my german Windows XP Professional, %t in log_line_prefix produces 2004-09-18 14:23:26 Westeuropäische Sommerzeit This is rather long and ugly. It is already on the open item list: * shorten ...
    Michael PaesoldMichael Paesold
    Sep 18, 2004 at 1:04 pm
    Oct 8, 2004 at 6:33 pm
  • I tried that, the error is the same but with user "postgres" [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres psql: FATAL: Password authentication failed for user "postgres" It is not taking my ...
    Sudhakar KurumellaSudhakar Kurumella
    Sep 21, 2004 at 12:58 pm
    Sep 21, 2004 at 4:27 pm
  • I've been knocking around a bit with user level locks and I have a few suggestions/questions: First, the pg_locks view lists user level locks but doesn't really say much about them. For example, for ...
    Merlin MoncureMerlin Moncure
    Sep 13, 2004 at 5:35 pm
    Sep 14, 2004 at 5:21 pm
  • Folks, I've noticed that when coming into an organization, I need to do some counting on what's in all the tables in a db. This shortens that process considerably, with the usual caveat that count(*) ...
    David FetterDavid Fetter
    Sep 29, 2004 at 12:01 am
    Oct 13, 2004 at 7:45 am
  • Josh asked me to post this, since it was just "odd" ... I have pg_autovacuum running on the table, with output looking for it looking like: [2004-09-30 02:29:47 PM] Performing: VACUUM ANALYZE ...
    Marc G. FournierMarc G. Fournier
    Sep 30, 2004 at 6:04 pm
    Oct 1, 2004 at 1:09 pm
  • I get this failure on current CVS running configure --with-python: checking for python... /usr/local/bin/python checking for Python distutils module... no configure: error: distutils module not found ...
    Bruce MomjianBruce Momjian
    Sep 21, 2004 at 6:17 am
    Sep 23, 2004 at 12:31 am
  • Tried to install this on AIX 5.1, no luck (compiles fine without --enable-thread-safety though) . AIX 5.1 gcc 3.3.2 ./configure --prefix=/opt/dbs/pgsql800b3-AIX51-2004-09-30 ...
    Brad NicholsonBrad Nicholson
    Sep 30, 2004 at 9:17 pm
    Oct 4, 2004 at 7:21 am
  • Risking to report a dup (by being on digest), I report that I can't compile postgres from just CVS-checked out sources: gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations ...
    Serguei A. MokhovSerguei A. Mokhov
    Sep 27, 2004 at 9:01 pm
    Sep 28, 2004 at 5:51 am
  • I've just spent a while this afternoon attempting to get SSL support working. It appears to be lacking in a few areas, foremost documentation. I've got a patch filling in the missing pieces for the ...
    Dominic MitchellDominic Mitchell
    Sep 21, 2004 at 7:24 am
    Sep 26, 2004 at 11:09 pm
  • Following result seems strange since it is not what the standard expects: test=# select (1,1) (0,10); ?column? ---------- f (1 row) On the other hand I see following in the doc: ...
    Tatsuo IshiiTatsuo Ishii
    Sep 9, 2004 at 2:07 pm
    Sep 10, 2004 at 4:36 pm
  • Kind people, Lately (past 3 days or so, but I don't know exactly how far back this goes), I've been getting some regression test failures for geometry with CVS HEAD on OS/X. Here is regression.diffs. ...
    David FetterDavid Fetter
    Sep 8, 2004 at 7:47 pm
    Sep 9, 2004 at 12:35 am
  • Hi all, I'm having some problem with permissions on views, I spoke with Josh on IRC about it and I'm reposting it: I found a not simmetrical behavior about permission on views and functions. Let me ...
    Gaetano MendolaGaetano Mendola
    Sep 16, 2004 at 10:17 pm
    Sep 17, 2004 at 10:37 pm
  • Hi, I am using a version of PostgreSQL compiled from a CVS update of yesterday, and compiled with make clean all make install One client connection to the database doing routine and low volume ...
    Grant FinnemoreGrant Finnemore
    Sep 10, 2004 at 8:17 am
    Dec 12, 2004 at 5:29 am
  • I was hoping this would be in for beta 3, but alas - can someone *please* commit the win32 version patch at: http://candle.pha.pa.us/mhonarc/patches/msg00000.html With the correction at ...
    Dave PageDave Page
    Sep 27, 2004 at 10:04 am
    Oct 9, 2004 at 4:04 am
  • I noticed that pgindent is doing weird things with function pointer declarations; see for example what it did with AnalyzeAttrFetchFunc and compute_stats in src/include/commands/vacuum.h. I don't ...
    Tom LaneTom Lane
    Sep 30, 2004 at 5:22 pm
    Oct 6, 2004 at 8:28 am
  • OK, I have a situation that might be a performance problem, a bug, or an unavoidable consequence of using prepared statements. The short version is that I am getting function executions for rows not ...
    Merlin MoncureMerlin Moncure
    Sep 30, 2004 at 1:45 pm
    Sep 30, 2004 at 3:02 pm
  • We were bitten by the following bug a few times, when our server tried to reestablish connections under bad network conditions: if connection is closed while trying to get response to SSL setup ...
    Hannu KrosingHannu Krosing
    Sep 23, 2004 at 12:11 am
    Sep 25, 2004 at 11:50 am
  • Sep 24 10:22:37 snafu postgres[18306]: [2-1] LOG: database system was interrupted while in recovery at 2004-09-24 10:21:41 MST Sep 24 10:22:37 snafu postgres[18306]: [2-2] HINT: This probably means ...
    Cott LangCott Lang
    Sep 24, 2004 at 5:21 pm
    Sep 24, 2004 at 8:59 pm
  • Hi! I have a error callback function registered to run each time an SQL error occurs. The problem is that the errfinish() calls it both if the executed SQL statement was wrong, and if the statem,ent ...
    Laszlo HornyakLaszlo Hornyak
    Sep 20, 2004 at 8:26 pm
    Sep 23, 2004 at 11:10 am
  • Hi, AFAIR there was a thread about "SELECT FOR UPDATE NOWAIT" availability in {7.5,8.0}, 7-8 months ago. Now we have LOCK TABLE ... NOWAIT; but I wonder whether we'll have the SELECT ... NOWAIT one. ...
    Devrim GündüzDevrim Gündüz
    Sep 8, 2004 at 10:56 pm
    Sep 15, 2004 at 1:25 pm
  • I'm fairly displeased with what pgindent has done to single-line PG_TRY constructs, as in this example from pl_exec.c: *************** exec_stmt_block(PLpgSQL_execstate * esta *** 911,922 **** ...
    Tom LaneTom Lane
    Sep 12, 2004 at 5:40 pm
    Sep 13, 2004 at 12:41 am
  • I've accepted an offer from Fujitsu Australia Software Technologies to work on PostgreSQL full-time for them for the next twelve months in Sydney, Australia. I'll be working with Gavin Sherry and two ...
    Neil ConwayNeil Conway
    Sep 8, 2004 at 5:58 am
    Sep 8, 2004 at 11:26 pm
  • Part of my final year thesis involves creating a database using PostgreSQL. As a way of documentation, is it correct to say that PosgreSQL belongs to the fifth generation of database management ...
    Eyinagho NewtonEyinagho Newton
    Sep 2, 2004 at 10:58 am
    Sep 4, 2004 at 10:25 pm
  • Daniel AhlinDaniel Ahlin
    Sep 25, 2004 at 1:40 pm
    May 20, 2005 at 6:02 pm
  • Hi list, When I try to create a user using the "create user" SQL command, where the command is being executed using the PQexecParams function from libpq, and the username and password are passed as ...
    Shachar ShemeshShachar Shemesh
    Sep 20, 2004 at 12:04 pm
    Sep 21, 2004 at 6:55 am
  • hi! I apologize for mailing on the hackers list but I posted on the general list and did not get a good answer. I have two independent issues, but am addressing them together. 1. Oracle has package ...
    Paramveer SinghParamveer Singh
    Sep 20, 2004 at 11:26 am
    Sep 20, 2004 at 6:12 pm
  • Hello folks, I have an idea, to break pg_dump into functions within PostgreSQL. We currently have some functions like pg_get_viewdef, but it would be great to have a function or functions to dump the ...
    Mark GibsonMark Gibson
    Sep 14, 2004 at 8:40 am
    Sep 16, 2004 at 1:54 pm
  • Hi, I've been playing with OSDL DBT-3 for a while and found very strange phenomemon. The query in question is Q4: select o_orderpriority, count(*) as order_count from orders where o_orderdate = date ...
    Tatsuo IshiiTatsuo Ishii
    Sep 4, 2004 at 5:48 pm
    Sep 6, 2004 at 8:05 pm
  • Hi Gaetano, I want to clarify this. The point of the core is they won't do it because they have things more important to do, or, the feature will never be part of the postgresql even if someone else ...
    Jaime CasanovaJaime Casanova
    Sep 4, 2004 at 10:25 pm
    Sep 6, 2004 at 7:57 am
Group Navigation
period‹ prev | Sep 2004 | next ›
Group Overview
grouppgsql-hackers @

142 users for September 2004

Tom Lane: 188 posts Bruce Momjian: 62 posts Gaetano Mendola: 48 posts Andrew Dunstan: 41 posts Greg Stark: 30 posts Alvaro Herrera: 25 posts Neil Conway: 24 posts Peter Eisentraut: 20 posts Dann Corbit: 18 posts Joe Conway: 18 posts Marc G. Fournier: 18 posts Merlin Moncure: 16 posts Stephan Szabo: 14 posts Jan Wieck: 13 posts Reini Urban: 13 posts Dennis Bjorklund: 12 posts Gavin Sherry: 11 posts Oliver Jowett: 11 posts Simon Riggs: 11 posts Michael Paesold: 10 posts
show more