FAQ

Search Discussions

55 discussions - 343 posts

  • Attached is a patch with documentation for the CSV mode of COPY patch submitted yesterday. cheers andrew
    Andrew DunstanAndrew Dunstan
    Apr 10, 2004 at 4:24 pm
    Apr 14, 2004 at 10:51 pm
  • Perhaps for the paranoid we could invent a setting which turns the facility off. Personally, I don't usually allow a superuser *any* access except from the local host - maybe that would be an answer. ...
    Andrew DunstanAndrew Dunstan
    Apr 3, 2004 at 4:08 pm
    Jul 27, 2004 at 2:08 am
  • Hackers, Here is a very preliminar patch that allows the user to say "BEGIN" inside a transaction and have the system react accordingly. This is only a modification to xact.c (and slightly to other ...
    Alvaro HerreraAlvaro Herrera
    Apr 14, 2004 at 3:08 am
    Apr 29, 2004 at 8:08 pm
  • This mail apparantly didn't make it through because it was too large. Resending it without the largest file, tzlib.tgz. I've put this file (+ the patches) on http://www.hagander.net/pgsql/. //Magnus ...
    Magnus HaganderMagnus Hagander
    Apr 21, 2004 at 7:16 pm
    May 1, 2004 at 10:08 pm
  • Oh, one more item. CSV needs a way to output date values in Datestyle format, for use by spreadsheets that understand mm/dd/yy dates, but not ISO dates. This will not be on by default. -- Bruce ...
    Bruce MomjianBruce Momjian
    Apr 15, 2004 at 2:27 am
    Apr 16, 2004 at 2:39 pm
  • Greetings, The attached patch adds some error-checking to the timestamp_recv function so that it's not possible to put an invalid timestamp into a timestamp column (hopefully). The check is done in ...
    Stephen FrostStephen Frost
    Apr 5, 2004 at 3:29 pm
    Jun 3, 2004 at 8:33 pm
  • Fabien COELHOFabien COELHO
    Apr 9, 2004 at 6:55 pm
    Apr 20, 2004 at 12:59 pm
  • OK, here is a patch that implements #1. Here is sample output: test= set client_min_messages = 'log'; SET test= set log_statement = 'mod'; SET test= select 1; ?column? ---------- 1 (1 row) test= ...
    Bruce MomjianBruce Momjian
    Apr 6, 2004 at 4:03 am
    Apr 7, 2004 at 5:06 am
  • It would appear the spec was approved of before we got foo.nextval, so here it is again. NEXT VALUE FOR and CURRENT VALUE FOR where CURRENT is an unreserved keyword and VALUE is not reserved in any ...
    Rod TaylorRod Taylor
    Apr 20, 2004 at 11:19 pm
    May 8, 2004 at 3:03 am
  • The attached patch implements the width_bucket() function (as specified by Section 6.27 of the SQL2003 standard, in particular page 250 in my copy). This function accepts an operand, a lower bound, ...
    Neil ConwayNeil Conway
    Apr 25, 2004 at 4:15 am
    May 14, 2004 at 9:56 pm
  • Yes, the problem is that we used the username for the salt, just like FreeBSD does for its MD5 passwords. Of course, you can't rename unix users, while PostgreSQL allows user renaming. The attached ...
    Bruce MomjianBruce Momjian
    Apr 27, 2004 at 2:16 am
    May 6, 2004 at 5:50 pm
  • Kind people, Please find attached a diff to the SGML docs that attempts to go over the new dollar quoting feature. In eager anticipation of comments & feedback, I remain, Your Humble Servant, D -- ...
    David FetterDavid Fetter
    Apr 27, 2004 at 9:12 pm
    Apr 28, 2004 at 5:02 pm
  • Hackers, This patch adds subtransaction support into the storage manager. Files created or dropped inside a subtransaction are correctly dealt with at subtransaction commit or abort. This works: ...
    Alvaro HerreraAlvaro Herrera
    Apr 25, 2004 at 6:06 pm
    Apr 30, 2004 at 3:17 pm
  • This one's simple enough to reproduce (see SQL script below), but, there are some comments in src/backend/catalog/namespace.c that seem questionable and incorrect: ## BEGIN ## /* * First, do ...
    Sean ChittendenSean Chittenden
    Apr 27, 2004 at 11:18 pm
    Apr 29, 2004 at 11:07 pm
  • Fabien COELHOFabien COELHO
    Apr 12, 2004 at 3:37 pm
    Apr 26, 2004 at 5:09 pm
  • I have 3 others somehow minor patches that are being submitted: (1) Date: Mon, 12 Apr 2004 17:36:55 +0200 (CEST) Subject: [PATCHES] aclitem accessor functions (2) Date: Sat, 17 Apr 2004 19:35:57 ...
    Fabien COELHOFabien COELHO
    Apr 22, 2004 at 7:29 am
    Apr 23, 2004 at 1:14 pm
  • For application to HEAD, following community review. Corrects issues recently posted by Dann Corbit, allowing libpq/psql to be built under VC++. Moves a pgstat win32 #def to port.h --- Certain ...
    Claudio NatoliClaudio Natoli
    Apr 1, 2004 at 3:05 am
    Apr 5, 2004 at 9:04 am
  • I have applied the attached patch that complete TODO item: o -Allow dump/load of CSV format This adds new keywords to COPY and \copy: CSV - enable CSV mode QUOTE - specify quote character ESCAPE - ...
    Bruce MomjianBruce Momjian
    Apr 19, 2004 at 5:26 pm
    Apr 20, 2004 at 3:41 pm
  • Here is the first preview of the two-stage tuple sampling as discussed on -hackers last week. It is for review only, please do not apply. As I didn't have a current CVS checkout when I worked on the ...
    Manfred KoizarManfred Koizar
    Apr 5, 2004 at 5:47 pm
    Apr 5, 2004 at 11:58 pm
  • This patch makes the following changes: (1) Add ceiling() as an alias for ceil() (both double precision and numeric variants). This is required by SQL2003, so both spellings of the function name have ...
    Neil ConwayNeil Conway
    Apr 23, 2004 at 7:01 am
    May 4, 2004 at 4:45 am
  • Full set of patches, including both earlier reported bugs fixed. This note was originally posted at Tue, 27 Apr 2004 23:30:39 +0100, but for some reason hasn't yet appeared on the [HACKERS] list, so ...
    Simon RiggsSimon Riggs
    Apr 29, 2004 at 10:22 pm
    Apr 30, 2004 at 6:59 am
  • Hackers, While playing with the init code I noticed traces of Hellerstein's "expensive function optimization". It is completely disabled, uses functions nowhere to be defined, and is out of date. So ...
    Alvaro HerreraAlvaro Herrera
    Apr 24, 2004 at 9:58 pm
    Apr 25, 2004 at 6:41 pm
  • Kris JurkaKris Jurka
    Apr 18, 2004 at 10:03 am
    Apr 22, 2004 at 6:04 am
  • For application to HEAD, following community review. * Most changes are to fix warnings issued when compiling win32 * removed a few redundant defines * get_user_name safe under win32 * rationalized ...
    Claudio NatoliClaudio Natoli
    Apr 13, 2004 at 6:17 am
    Apr 19, 2004 at 5:43 pm
  • Here's an attempt at new socket and signal code for win32. It works on the principle of turning sockets into non-blocking, and then emulate blocking behaviour on top of that, while allowing signals ...
    Magnus HaganderMagnus Hagander
    Apr 4, 2004 at 8:07 pm
    Apr 12, 2004 at 4:19 pm
  • Hello, This update fixes a few small typos in names, pronouns and formatting in the Russian FAQ. To Victor: Why do you use the translit encoding for FAQ instead of KOI8-R as the rest of the ...
    Serguei MokhovSerguei Mokhov
    Apr 12, 2004 at 1:02 am
    Apr 12, 2004 at 3:22 am
  • This patch makes psql's \d+ command indicate whether the table in question contains OIDs or not. I didn't add this information to \d, on the grounds that \d is more commonly used and few people will ...
    Neil ConwayNeil Conway
    Apr 22, 2004 at 6:44 am
    Apr 22, 2004 at 5:39 pm
  • SsingerSsinger
    Apr 18, 2004 at 3:36 pm
    Apr 22, 2004 at 1:02 pm
  • This patch changes PrivateRefCount and LocalRefCount in the bufmgr from being arrays of long to arrays of int32, per earlier discussion. This should save a little memory on 64LP machines, and there's ...
    Neil ConwayNeil Conway
    Apr 21, 2004 at 7:58 pm
    Apr 22, 2004 at 7:24 am
  • This patch improves the backup & restore documentation somewhat: I added a few more cross-refs, documented increasing checkpoint_segments, and made a few other minor improvements. I intend to apply ...
    Neil ConwayNeil Conway
    Apr 21, 2004 at 5:22 pm
    Apr 21, 2004 at 7:29 pm
  • Fabien COELHOFabien COELHO
    Apr 10, 2004 at 12:20 pm
    Apr 20, 2004 at 1:53 am
  • The attached patch for contrib/pg_autovacuum/README.pg_autovacuum fixes one apparent error and makes a minor stylistic change that makes it more consistent and makes clear something that confused me ...
    Andrew DunstanAndrew Dunstan
    Apr 19, 2004 at 3:56 pm
    Apr 19, 2004 at 9:30 pm
  • Fabien COELHOFabien COELHO
    Apr 18, 2004 at 9:43 am
    Apr 18, 2004 at 5:56 pm
  • Attached is an undocumented patch that implements COPY for CSVs according to the scheme recently discussed. I believe it handles all the straightforward and perverse cases that were discussed ...
    Andrew DunstanAndrew Dunstan
    Apr 8, 2004 at 7:04 pm
    Apr 9, 2004 at 11:51 pm
  • Below is my patch addressing the TODO list item "Allow external interfaces to extend the GUC variable set ". It's outlined after the suggestions made by Tom Lane and Joe Conway in this thread: ...
    Thomas HallgrenThomas Hallgren
    Apr 27, 2004 at 6:14 pm
    Apr 29, 2004 at 10:45 pm
  • Hi, The attached patch adds a new command: ALTER TABLE [ONLY] foo SET WITHOUT CLUSTER; I would probably have preferred the DROP CLUSTER syntax, but it doesn't seem easy to get working without ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 28, 2004 at 8:03 am
    Apr 29, 2004 at 4:43 am
  • Hi all, Talking about patches in pipe, I just want to see my patch in PostgreSQL. Nobody comments about it. It's about ALTER DATABASE foo OWNER TO bar. ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Apr 22, 2004 at 9:36 pm
    Apr 22, 2004 at 9:55 pm
  • Per discussion earlier today, here is a fix that lets ereport() on win32 report socket errors. //Magnus <<win32_socketerror.patch
    Magnus HaganderMagnus Hagander
    Apr 19, 2004 at 8:18 pm
    Apr 22, 2004 at 6:04 am
  • Hi! Starting with 2.0 NetBSD has native threads. The attached patch adds support for this to the src/templates/netbsd file. (Since, $host_os doesn't include the OS version number I had to take ...
    Marc RechtMarc Recht
    Apr 20, 2004 at 12:13 am
    Apr 20, 2004 at 2:37 pm
  • Hello, Please install attached translation updates. This is for 7.5. initdb to to about ~50% the rest is complete $ msgfmt -cv initdb-ru.po 37 translated messages, 35 untranslated messages. $ msgfmt ...
    Serguei MokhovSerguei Mokhov
    Apr 6, 2004 at 4:50 pm
    Apr 15, 2004 at 8:04 am
  • Fabien COELHOFabien COELHO
    Apr 5, 2004 at 7:54 am
    Apr 10, 2004 at 6:03 pm
  • This patch does two things: 1) Changes the semantics of assign_search_path()/'SET search_path' so that you can't set your search path to a schema you don't have USAGE privs for. 2) Changes psql's \dn ...
    Sean ChittendenSean Chittenden
    Apr 9, 2004 at 3:00 am
    Apr 9, 2004 at 6:07 am
  • More information on authorization charges. -------- Original Message -------- Subject: Re: Re: Cancelling authorization transactions Date: Thu, 8 Apr 2004 07:13:22 -0700 (PDT) From: VeriSign Payment ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 9, 2004 at 2:05 am
    Apr 9, 2004 at 2:13 am
  • With Peter's help, I have changed the way I do thread testing from configure to be much cleaner. Patch attached and applied. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Apr 27, 2004 at 7:50 pm
    Apr 27, 2004 at 7:50 pm
  • Yes, I see that backend/Makefile already had the $(X) for link lines so it seems it is necessary. I applied the attached patch that adds $(X) to the other links. I don't think we have a lot of folks ...
    Bruce MomjianBruce Momjian
    Apr 26, 2004 at 5:42 pm
    Apr 26, 2004 at 5:42 pm
  • I've applied the attached patch; it makes a few trivial fixes, mostly to comments. -Neil
    Neil ConwayNeil Conway
    Apr 26, 2004 at 12:06 am
    Apr 26, 2004 at 12:06 am
  • I just changed the COPY CSV keywords: FORCE QUOTE to force quotes FORCE NOT NULL to quote null input values Patch attached. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Apr 21, 2004 at 12:35 am
    Apr 21, 2004 at 12:35 am
  • I just changed COPY CSV keywords to be: FORCE QUOTE to force quotes on output FORCE NOT NULL to quote null input values -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Apr 21, 2004 at 12:34 am
    Apr 21, 2004 at 12:34 am
  • Fabien COELHOFabien COELHO
    Apr 17, 2004 at 5:36 pm
    Apr 17, 2004 at 5:36 pm
  • This patch fixes a server crash for an invalid database name. I wasn't dealing with Warn_restart_ready properly in my SIGTERM safety patch. Applied. -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 16, 2004 at 12:58 pm
    Apr 16, 2004 at 12:58 pm
Group Navigation
period‹ prev | Apr 2004 | next ›
Group Overview
grouppgsql-patches @
categoriespostgresql
discussions55
posts343
users31
websitepostgresql.org
irc#postgresql

31 users for April 2004

Bruce Momjian: 118 posts Andrew Dunstan: 48 posts Tom Lane: 37 posts Fabien COELHO: 34 posts Alvaro Herrera: 19 posts Peter Eisentraut: 16 posts Neil Conway: 13 posts Magnus Hagander: 7 posts Claudio Natoli: 6 posts Christopher Kings-Lynne: 5 posts Sean Chittenden: 5 posts Bruno Wolff III: 4 posts Manfred Koizar: 4 posts Simon Riggs: 4 posts David Fetter: 3 posts Serguei Mokhov: 3 posts Ssinger: 2 posts Thomas Hallgren: 2 posts Dan Graham: 1 post Euler Taveira de Oliveira: 1 post
show more
Archives