[PATCHES] Translation updates for 8.0: initdb-ru, psql-ru
Hello Peter, Please install the next cut on Russian translations for 8.0. Thanks, -s initdb-ru.po.gz;psql-ru.po.gz initdb-ru.po.gz Description: GNU Zip compressed data psql-ru.po.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PATCHES] [HACKERS] [Fwd: Re: [pgsql-hackers-win32] Import from Linux to
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: No, I think 7.4 should do. 7.3 users will still have the dos2unix workaround available. Are you going to do the 7.4 patch, or do you need me to? I normally only keep a HEAD tree checked out. A quick look at the cvsweb diffs suggests the patch should apply cleanly but with different line offsets. If you're sure the code in that routine hasn't changed since 7.4, then I can just apply the patch to that branch. It has - the prompt changes in version 1.37. But I don't think that conflict with this patch. I'll have a look this morning. cheers andrew ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[PATCHES] pg_restore recognizing $-quotes
Not sure if this is the desired approach, but since it works, I thought I'd send it. This patch allows pg_restore to recognize $-quotes in SQL queries. It will treat any unquoted string that starts with a $ and has no preceding identifier chars as a potential $-quote tag, it then makes sure that the tag chars are valid. If so, it processes the $-quote. Tested against local DBs and regression DB. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 03 5330 3172 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp.mit.edu:11371 |/ pg_dump_040812.patch.gz Description: Binary data ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch
On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally but used a different syntax --- I think the guy had started by looking at extract(epoch from timestamp) rather than to_timestamp. Other than Chris' suggestion of extract(timestamp from epoch)? I did find this documentation patch from December 2003 giving an example of how to convert from Unix epoch to timestamp, but not a function per se. http://archives.postgresql.org/pgsql-patches/2003-12/msg00112.php However, I suspect you may thinking of something else. Michael Glaesemann grzm myrealbox com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch
Michael Glaesemann [EMAIL PROTECTED] writes: On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally but used a different syntax --- I think Other than Chris' suggestion of extract(timestamp from epoch)? [ looks in archives... ] Oh, actually that was *you* --- I was vaguely remembering your proposed patch of 2-Aug. You were calling the function epoch_to_timestamp at the time. I like to_timestamp(double) better than these other names ... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PATCHES] Translation updates for 8.0: initdb-ru, psql-ru
Serguei Mokhov wrote: Please install the next cut on Russian translations for 8.0. Done. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PATCHES] Translation updates for 7.4.4(!!) / 8.0: postgres-ru
Serguei Mokhov wrote: Another chunk of translated backend messages. It'd be cool if it makes into 7.4.4 before it is rolled out. Please also apply to 8.0. Done. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 8: explain analyze is your friend
[PATCHES] Minor psql reference fix
Hi, I just stumbled across a strange looking sentence in the psql reference. I'm not sure if I fixed it correctly, since English isn't my native language. Patch attached. Thanks Andreas Index: psql-ref.sgml === RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/ref/psql-ref.sgml,v retrieving revision 1.119 diff -c -r1.119 psql-ref.sgml *** psql-ref.sgml 15 Jul 2004 03:56:04 - 1.119 --- psql-ref.sgml 13 Aug 2004 23:47:57 - *** *** 2551,2557 first argument of a single-letter backslash command to start directly after the command, without intervening whitespace. For compatibility this is still supported to some extent, ! but were are not going to explain the details here as this use is discouraged. If you get strange messages, keep this in mind. For example programlisting --- 2551,2557 first argument of a single-letter backslash command to start directly after the command, without intervening whitespace. For compatibility this is still supported to some extent, ! but we are not going to explain the details here as this use is discouraged. If you get strange messages, keep this in mind. For example programlisting ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch
TODO here? --- Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally but used a different syntax --- I think Other than Chris' suggestion of extract(timestamp from epoch)? [ looks in archives... ] Oh, actually that was *you* --- I was vaguely remembering your proposed patch of 2-Aug. You were calling the function epoch_to_timestamp at the time. I like to_timestamp(double) better than these other names ... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch
Sorry, I now see I should add the patch to the 8.1 queue. --- Bruce Momjian wrote: TODO here? --- Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally but used a different syntax --- I think Other than Chris' suggestion of extract(timestamp from epoch)? [ looks in archives... ] Oh, actually that was *you* --- I was vaguely remembering your proposed patch of 2-Aug. You were calling the function epoch_to_timestamp at the time. I like to_timestamp(double) better than these other names ... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PATCHES] [HACKERS] [Fwd: Re: [pgsql-hackers-win32] Import from Linux to
Andrew Dunstan wrote: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: No, I think 7.4 should do. 7.3 users will still have the dos2unix workaround available. Are you going to do the 7.4 patch, or do you need me to? I normally only keep a HEAD tree checked out. A quick look at the cvsweb diffs suggests the patch should apply cleanly but with different line offsets. If you're sure the code in that routine hasn't changed since 7.4, then I can just apply the patch to that branch. It has - the prompt changes in version 1.37. But I don't think that conflict with this patch. I'll have a look this morning. One issue is that pre-8.0, psql files were opened in Win32 text mode, so we wouldn't have seen this bug on Win32, but we would on Linux. Because we open them on Win32 now in binary mode so we see control-Z it will show up on Win32 too. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PATCHES] [HACKERS] [Fwd: Re: [pgsql-hackers-win32] Import from Linux to
Bruce Momjian wrote: One issue is that pre-8.0, psql files were opened in Win32 text mode, so we wouldn't have seen this bug on Win32, but we would on Linux. Because we open them on Win32 now in binary mode so we see control-Z it will show up on Win32 too. true, *BUT* The patch is not platform-specific. It simply makes psql accept the same line endings on COPY FROM that the backend will accept - in effect it makes it line-end agnostic - this is a Good Thing (tm). We are still months away from releasing 8.0, so I think doing this for tomorrow's 7.4 bundle makes sense. cheers andrew ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PATCHES] [HACKERS] [Fwd: Re: [pgsql-hackers-win32] Import from Linux to
Andrew Dunstan wrote: Bruce Momjian wrote: One issue is that pre-8.0, psql files were opened in Win32 text mode, so we wouldn't have seen this bug on Win32, but we would on Linux. Because we open them on Win32 now in binary mode so we see control-Z it will show up on Win32 too. true, *BUT* The patch is not platform-specific. It simply makes psql accept the same line endings on COPY FROM that the backend will accept - in effect it makes it line-end agnostic - this is a Good Thing (tm). We are still months away from releasing 8.0, so I think doing this for tomorrow's 7.4 bundle makes sense. Yes, totally agree. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] [HACKERS] [Fwd: Re: [pgsql-hackers-win32] Import from Linux to
Andrew Dunstan [EMAIL PROTECTED] writes: Here's the diff with 7.4 line numbers - tests fine for me. Patch applied. Thanks for double-checking it. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] [HACKERS] [Fwd: Re: [pgsql-hackers-win32] Import from Linux to
Andrew Dunstan [EMAIL PROTECTED] writes: The patch is not platform-specific. It simply makes psql accept the same line endings on COPY FROM that the backend will accept - in effect it makes it line-end agnostic - this is a Good Thing (tm). Strictly speaking it's not there yet --- psql still doesn't cope with line endings that are \r only (original Mac OS style). However, since we do not and probably never will have a port to original Mac OS, I'm satisfied with the code as-is. We are still months away from releasing 8.0, so I think doing this for tomorrow's 7.4 bundle makes sense. I agree (and did in fact just commit the back-patch a bit ago). regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PATCHES] Minor psql reference fix
Andreas Seltenreich [EMAIL PROTECTED] writes: I just stumbled across a strange looking sentence in the psql reference. I'm not sure if I fixed it correctly, since English isn't my native language. Patch attached. Yup, it's wrong, and your fix is perfect. Patch applied --- thanks! regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[PATCHES] Translation updates for 8.0: psql-ru
Hello, Please install this one. It fixes up 8 strings I missed last time due to working on older version of downloaded .po file. Thanks, -s psql-ru.po.gz psql-ru.po.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] [pgsql-hackers-win32] make fails if path has spaces
OK, patch attached and applied. I am not sure if there are going to be other place that need fixing so I added a comment. --- Andreas Pflug wrote: Bruce Momjian wrote: It could be fixed in both places, but the more general fix would be to qoute in Makefile.global, i.e. fixing configure. What if you change this: PERL= @PERL@ to this: PERL= @PERL@ Does it help? Changed in src/Makefile.global.in, and it works. There are other candidates that could have a non-msys path, which maybe should be quoted as well. Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: src/Makefile.global.in === RCS file: /cvsroot/pgsql-server/src/Makefile.global.in,v retrieving revision 1.191 diff -c -c -r1.191 Makefile.global.in *** src/Makefile.global.in 1 Aug 2004 06:19:19 - 1.191 --- src/Makefile.global.in 14 Aug 2004 23:47:04 - *** *** 207,213 # Perl ! PERL = @PERL@ perl_archlibexp = @perl_archlibexp@ perl_privlibexp = @perl_privlibexp@ perl_useshrplib = @perl_useshrplib@ --- 207,213 # Perl ! PERL = @PERL@ # quoted for pathname with spaces perl_archlibexp = @perl_archlibexp@ perl_privlibexp = @perl_privlibexp@ perl_useshrplib = @perl_useshrplib@ ---(end of broadcast)--- TIP 8: explain analyze is your friend