[PATCHES] Czech NLS

: ftp://ftp2.zf.jcu.cz/users/zakkr/pg/nls-cs-07222003.patch.gz Thanks, Karel PS. Is pgsql-patches list limit 40Kb? -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr/ ---(end of broadcast)--- TIP 5: Have you checked our

Re: [PATCHES] Czech NLS

On Wed, Jul 23, 2003 at 11:48:19AM +0200, Peter Eisentraut wrote: Karel Zak writes: the patch contains complete messages transaltion of: Installed. Nice work. Thanks. What time will freeze backend messages? I think after beta release. Karel -- Karel Zak [EMAIL PROTECTED

Re: [PATCHES] [BUGS] to_timestamp not stable if date string shorter than

On Wed, Sep 03, 2003 at 12:15:47AM -0400, Tom Lane wrote: that as a full fix. Karel, the ball's in your court ... Fixed. All tests passed. My court is without ball now. The patch is attached. Thanks, it was good find! Karel -- Karel Zak [EMAIL PROTECTED] http

[PATCHES] 7.3: [BUGS] to_timestamp not stable if date string shorter than

On Wed, Sep 03, 2003 at 11:53:35AM -0400, Tom Lane wrote: Karel Zak [EMAIL PROTECTED] writes: Hmm.. but the patch fix another small bug which I found today. Okay. Please send a patch against 7.3 tip and I'll throw it in. The patch for REL7_3_4 is attached. Karel -- Karel

[PATCHES] 7.4: pg_dumplo fix

Hi, someone report me small bug in contrib/pg_dumplo today. It's problem with a little dirty snprintf() usage which I used some years ago: snprintf(path, BUFSIZ, %s/lo_dump.index, path); Thanks, Karel -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr

Re: [PATCHES] psql-current italian translation updates

-- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PATCHES] ISO year.

DCH_I must be behind DCH_IW. If you will add others IY the order must be: DCH_IW DCH_I DCH_IYYY DCH_IYY DCH_IY .. and same for lower case version: @@ -582,6 +583,7 @@ DCH_ww, DCH_w, DCH_y_yyy, + DCH_i, ^ Thanks! Karel -- Karel Zak

Re: [PATCHES] ISO year.

in docs and marked as PostgreSQL extension. Karel -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] ISO year.

On Thu, Dec 18, 2003 at 08:18:08PM +0100, Kurt Roeckx wrote: DCH_IW, + DCH_IYYY, + DCH_IYY, + DCH_IY, + DCH_I, It's better :-) This patch is OK for me. Karel -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr/ ---(end

[PATCHES] pstrndup()

be NULL) to new allocated string. Is something like this interesting for PostgreSQL? Karel -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr/ pstrndup-7.5-03172004.patch.gz Description: GNU Zip compressed data ---(end of broadcast

Re: [PATCHES] pstrndup()

. You're right it's horrible function. The result of strndup() is always zero terminated. It's more safe and strndup() is binary safe because it doesn't check something in input string. The pstrndup() is based on PostgreSQL memory managment. Karel -- Karel Zak [EMAIL PROTECTED

Re: [PATCHES] [HACKERS] Dates BC.

On Mon, Mar 29, 2004 at 03:37:07PM -0500, Bruce Momjian wrote: Karel Zak wrote: On Fri, Dec 19, 2003 at 01:12:08AM -0800, Dann Corbit wrote: There is no zero calendar year. The first year of Anno Domini is 1. It's ordinal, not cardinal. I agree. But the follow quoted code

Re: [PATCHES] Updated COPY CSV patch

on locale. Now we ignore LC_NUMERIC, but maybe at some time in future we will support it. I think the best solution is quote all values including numerics too. 123,456 (in Czech this is one number with decimal point ;-) Karel -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz

[PATCHES] NLS: czech

/pg_ctl/nls.mk patching file src/bin/pg_ctl/po/cs.po patching file src/bin/pg_resetxlog/po/cs.po patching file src/interfaces/libpq/po/cs.po .. so nothing dangerous. Karel PS. thanks to Michal Taborsky [EMAIL PROTECTED] who translated all in this patch. -- Karel Zak [EMAIL PROTECTED] http

Re: [PATCHES] Again!! locale per column for postgreSQL

On Wed, 2004-09-15 at 07:01 -0700, Mahmoud Taghizadeh wrote: Qustion: is this approach is suitable for solving the need for locale per column in PostgreSQL ? There is a function I attached to this mail. this function is similar to nls_sort. this function is written by Karel Zak, I dont know

[PATCHES] 8.0-NLS: czech

Hi, on URL: http://people.redhat.com/kzak/pg-nls-cs-21102004.patch.gz is new Czech translation of PostgreSQL messages. It's too big for e-mail attachment and mailing list limit. Thanks, Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr ---(end of broadcast

[PATCHES] sign parsing (was: Re: [HACKERS] to_char/to_number loses sign)

On Tue, 2004-10-26 at 13:27 -0400, Tom Lane wrote: Karel Zak [EMAIL PROTECTED] writes: Yes, you're right. It strange, but NUM_S missing there. The conversion from string to number is less stable part of formatting.c... The patch is in the attachment. This patch causes the regression

Re: [PATCHES] 8.0-NLS: czech

Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[PATCHES] pg_dumplo schema support

with this patch and it works for me. If you think that 8.1 will better, please apply it to 8.1. Thanks, Karel -- Karel Zak [EMAIL PROTECTED] pg_dumplo-schema-11232004.patch.gz Description: GNU Zip compressed data ---(end of broadcast

Re: [PATCHES] Implementing RESET CONNECTION ...

() implementation) and if PG returns string CONNECTION- RESETED it can deallocate internal stuff. This solution doesn't require touch the protocol. Karel -- Karel Zak [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [PATCHES] Implementing RESET CONNECTION ...

On Wed, 2005-01-05 at 01:33 +1300, Oliver Jowett wrote: Karel Zak wrote: I think each PG command returns some status. For example in libpq it's possible check by PQcmdStatus(). I think JDBC can checks this status (by own PQcmdStatus() implementation) and if PG returns string CONNECTION

Re: [PATCHES] [BUGS] CC Date format code defaults to current centry

1909-12-01 For YYY/ it ignore CC option. The patch (with docs changes) is in the attachment. Karel -- Karel Zak [EMAIL PROTECTED] formatting-17032005.patch.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 2: you

Re: [PATCHES] AllocSetReset improvement

--- if there are no blocks allocated to the context, it surely hasn't got any chunks either, so the MemSet is unnecessary. Good point. There's same MemSet in AllocSetDelete() too. Karel -- Karel Zak [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1

Re: [PATCHES] Implementing SELECT FOR UPDATE [NOWAIT]

to choose an index scan if your joining column's datatypes do not match -- Karel Zak [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] limiting connections per user/database

Oracle has better solution for per-user setting: CREATE PROFILE name SESSIONS_PER_USER int CONNECT_TIME int IDLE_TIME int; ALTER USER name PROFILE name; karel -- Karel Zak [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you

Re: [PATCHES] Implementing SELECT FOR UPDATE [NOWAIT]

. --- Hans-Juergen Schoenig wrote: Folks, We have implemented SELECT FOR UPDATE NOWAIT for PostgreSQL. -- Karel Zak [EMAIL PROTECTED] pgsql-nowait-07012005.patch.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 8: explain

[PATCHES] COPY view

BBB 3 ccc CCC 4 ddd DDD -- Karel Zak [EMAIL PROTECTED] pgsql-copyview-29092005.patch.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PATCHES] [HACKERS] to_char and i18n

-versa conversion from string with TMMonth/TMDay to timestamp. to_timestamp('Domingo, 25 Dezembro 2005', 'TMDay, DD TMMonth ') Or.. at least describe in the docs that this way is unsupported for 'TM' prefix. Karel -- Karel Zak [EMAIL PROTECTED] ---(end

Re: [HACKERS] [PATCHES] COPY view

On Tue, Aug 22, 2006 at 01:11:22PM -0400, Andrew Dunstan wrote: There's nothing hidden (unless it's also hidden from me ;-) ) I take it that when you talk about we did this you are referring to the patch from Karel Zak. Hans has been original author of COPY VIEW idea and I've wrote

Leaving... (was: Re: [HACKERS] [PATCHES] COPY view)

: The patch submitter has neither provided an updated patch nor defended his original submission as being the right thing. If he doesn't take it seriously enough to have done any followup, why should the rest of us? -- Karel Zak [EMAIL PROTECTED] ---(end of broadcast