Commit Graph

  • 505b925276 Fix #elif spacing too. Bruce Momjian 2005-07-13 15:59:32 +00:00
  • 32f9bc6f7d Fix libpq memory leak during PQreset() --- closePGconn() was not freeing all transient state of the PGconn object. Tom Lane 2005-07-13 15:26:25 +00:00
  • 57bdab7d35 Fix libpq memory leak during PQreset() --- closePGconn() was not freeing all transient state of the PGconn object. Tom Lane 2005-07-13 15:26:16 +00:00
  • 35a0fc32f5 Fix libpq memory leak during PQreset() --- closePGconn() was not freeing all transient state of the PGconn object. Tom Lane 2005-07-13 15:26:06 +00:00
  • faea3db958 Fix libpq memory leak during PQreset() --- closePGconn() was not freeing all transient state of the PGconn object. Tom Lane 2005-07-13 15:25:55 +00:00
  • 5d0a43c585 Fix pgindent to not have blank line before #else in variable definition section of a function. Bruce Momjian 2005-07-13 04:44:42 +00:00
  • 7690b41328 Add backslashes to parentheses in awk regex because if not, they are treated as regex groups. Bruce Momjian 2005-07-13 04:00:28 +00:00
  • 5bced8f5cb Move -L flag around for shared builds: Bruce Momjian 2005-07-13 02:11:57 +00:00
  • d6375d6109 Documentation for some new PL/Perl features. Patch from David Fetter, various editorialization from Neil Conway. Neil Conway 2005-07-13 02:10:42 +00:00
  • b4363b7733 Hack around the discrepancy between default library search paths for gcc and for HP's ld on HPUX. There may be better ways to do this, but this seems to work for me... Tom Lane 2005-07-12 23:06:48 +00:00
  • 2d481b31af Fix plperl crash with list value return for an array result type. Reported by Michael Fuhr, fixed by Andrew Dunstan. Tom Lane 2005-07-12 20:35:42 +00:00
  • 807bbe6051 More pgcrypto fixes: handle long messages correctly, suppress compiler warnings. Marko Kreen and Kris Jurka. Tom Lane 2005-07-12 20:27:45 +00:00
  • 7f0b690334 Improve comments for AdjustIntervalForTypmod. Bruce Momjian 2005-07-12 16:05:12 +00:00
  • 62abb039df Change 5e0 to 5.0, for consistency. Bruce Momjian 2005-07-12 15:17:44 +00:00
  • 220e6bfc53 Fix plperl to do recursion safely, and fix a problem with array results. Add suitable regression tests. Andrew Dunstan Tom Lane 2005-07-12 01:16:22 +00:00
  • a1a64bb7c3 Further tweaking of Win32-specific random code. Marko Kreen Tom Lane 2005-07-11 19:06:46 +00:00
  • e82f7e9e7e I forgot to update win32 code when doing a renaming in random.c. Marko Kreen Tom Lane 2005-07-11 17:00:03 +00:00
  • 067a5cdb35 Avoid bzero/bxopy in favor of more standard library routines. Marko Kreen Tom Lane 2005-07-11 15:40:38 +00:00
  • e997758cb6 More pgcrypto fixes: avoid bogus alignment assumptions in sha2, be more wary about having a value for BYTE_ORDER, clean up randomly- chosen ways of including Postgres core headers. Marko Kreen and Tom Lane Tom Lane 2005-07-11 15:07:59 +00:00
  • 3c52d17fa6 Add support for AES cipher with older OpenSSL libraries. Marko Kreen Tom Lane 2005-07-11 14:38:05 +00:00
  • 8826fe859f Missed adding extra argument to array_recv in a couple of places (harmless, actually, but let's be tidy). Tom Lane 2005-07-10 21:36:21 +00:00
  • d78397d301 Change typreceive function API so that receive functions get the same optional arguments as text input functions, ie, typioparam OID and atttypmod. Make all the datatypes that use typmod enforce it the same way in typreceive as they do in typinput. This fixes a problem with failure to enforce length restrictions during COPY FROM BINARY. Tom Lane 2005-07-10 21:14:00 +00:00
  • 2e330699fa > One more failure: > > I think this is because we don't have -lz in SHLIB_LINK. > Following patch fixes it. Bruce Momjian 2005-07-10 18:32:55 +00:00
  • 21634e513f Add extra argument for new pg_regexec API. Bruce Momjian 2005-07-10 18:31:59 +00:00
  • aacfeba61b Suppress compile warning. Tom Lane 2005-07-10 17:22:54 +00:00
  • e8a3e6b8a0 Rename xmalloc to pg_malloc for consistency with psql usage. Bruce Momjian 2005-07-10 16:13:13 +00:00
  • f86c63ab6a Reverse pg_malloc patch because psql/print.c is used in scripts files that don't have pg_malloc. Bruce Momjian 2005-07-10 15:53:42 +00:00
  • 8c9393c640 Use failure-safe pg_malloc consistently in psql/print.c. Bruce Momjian 2005-07-10 15:48:14 +00:00
  • 6e1004f0fd Remove #include <openssl/bn.h> as compile fix. Bruce Momjian 2005-07-10 15:37:03 +00:00
  • b135508c98 Following up a previous thought I had, yesterday I realised how to return arays nicely without having to make the plperl programmer aware of anything. The attached patch allows plperl to return an arrayref where the function returns an array type. It silently calls a perl function to stringify the array before passing it to the pg array parser. Non-array returns are handled as before (i.e. passed through this process) so it is backwards compatible. I will presently submit regression tests and docs. Bruce Momjian 2005-07-10 15:32:47 +00:00
  • 6d92f2106f The attached patch implements spi_query() and spi_fetchrow() functions for PL/Perl, to avoid loading the entire result set into memory as the existing spi_exec_query() function does. Bruce Momjian 2005-07-10 15:19:43 +00:00
  • d1cffe2f77 Add --encoding to pg_dump. Bruce Momjian 2005-07-10 15:08:52 +00:00
  • 0793108036 This patch implements putting language handlers for the optional PLs into pg_catalog rather than public, and supports dumping languages whose handlers are found there. This will make it easier to drop the public schema if desired. Bruce Momjian 2005-07-10 14:26:30 +00:00
  • d51df91897 As Kris Jurka found out, pgcrypto does not work with OpenSSL 0.9.6x. The DES functions use the older 'des_' API, but the newer 3DES functions use the 0.9.7x-only 'DES_' API. Bruce Momjian 2005-07-10 13:54:34 +00:00
  • e94dd6ab91 Add missing pgcrypto files from previous commit. Bruce Momjian 2005-07-10 13:46:29 +00:00
  • 42e7b0f02f Update. Bruce Momjian 2005-07-10 05:06:42 +00:00
  • 37f11c3081 This patch addresses the problem mentioned in the "process crash when a plpython function returns unicode" thread: Bruce Momjian 2005-07-10 04:56:55 +00:00
  • 75a64eeb4b I made the patch that implements regexp_replace again. The specification of this function is as follows. Bruce Momjian 2005-07-10 04:54:33 +00:00
  • 73e2431817 Major pgcrypto changes: Bruce Momjian 2005-07-10 03:57:55 +00:00
  • 4fcf8b11ff - Add Fortuna PRNG to pgcrypto. - Move openssl random provider to openssl.c and builtin provider to internal.c - Make px_random_bytes use Fortuna, instead of giving error. - Retarget random.c to aquiring system randomness, for initial seeding of Fortuna. There is ATM 2 functions for Windows, reader from /dev/urandom and the regular time()/getpid() silliness. Bruce Momjian 2005-07-10 03:55:28 +00:00
  • 248eeb82f0 This patch adds implementation of SHA2 to pgcrypto. New hashes: SHA256, SHA384, SHA512. Bruce Momjian 2005-07-10 03:52:56 +00:00
  • 73a7c322c3 Add psql \pset numericsep to allow output numbers like 100,000.0 or 100.000,0. Bruce Momjian 2005-07-10 03:46:13 +00:00
  • be3aa30da3 Fix inadequate error checking: you can't assume that fcinfo->resultinfo is a ReturnSetInfo unless you've tested it with IsA. Tom Lane 2005-07-09 01:53:22 +00:00
  • 18e64f6c81 Fix config file lexer to not barf if postgresql.conf ends with a comment that has no terminating newline. Per report from maps.on at gmx.net. Tom Lane 2005-07-08 18:41:55 +00:00
  • 40d091b818 Fix config file lexer to not barf if postgresql.conf ends with a comment that has no terminating newline. Per report from maps.on at gmx.net. Tom Lane 2005-07-08 18:41:40 +00:00
  • 0ed5f90d73 Try connecting to both postgres and template1 databases to do the initial inspection of shared catalogs. This allows pg_dumpall to continue to work with pre-8.1 servers that likely won't have a database named postgres. Also, suppress output of SYSID options for users and groups, since server no longer does anything with these except emit a rude message. There is much more to be done to update pg_dumpall for the roles feature, but this at least makes it usable again. Per gripe from Chris K-L. Tom Lane 2005-07-08 16:51:30 +00:00
  • 91d381e3c0 Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. Tom Lane 2005-07-08 15:25:46 +00:00
  • d53f22de86 Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. Tom Lane 2005-07-08 15:25:36 +00:00
  • a5d10d66d1 Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. Tom Lane 2005-07-08 15:25:19 +00:00
  • a646e4874a Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. Tom Lane 2005-07-08 15:24:53 +00:00
  • 70f7da3e6e Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. Tom Lane 2005-07-08 15:24:41 +00:00
  • 85f97937d2 testing activitymail PostgreSQL Daemon 2005-07-08 15:13:09 +00:00
  • 86897f54a8 This patch updates the DDL for contrib/pgcrypto to create all functions as STRICT, and all functions except gen_salt() as IMMUTABLE. gen_salt() is VOLATILE. Neil Conway 2005-07-08 04:27:49 +00:00
  • 40ffa1a14c Remove some dead code for handling XLOG_DBASE_CREATE_OLD and XLOG_DBASE_DROP_OLD WAL records -- these records are no longer created in current sources. Adjust numbering of XLOG_DBASE_CREATE and XLOG_DBASE_DROP and bump the catversion. Patch from Gavin Sherry, adjusted by Neil Conway. Neil Conway 2005-07-08 04:12:27 +00:00
  • d7207cfc6b Even though I'd like to see full_page_writes go away before 8.1, a minimum requirement is that it not completely break the system meanwhile. Put the test in the right place. Tom Lane 2005-07-08 04:07:26 +00:00
  • a4ffa38234 Done: Bruce Momjian 2005-07-08 02:44:37 +00:00
  • 59d1b3d99e Track dependencies on shared objects (which is to say, roles; we already have adequate mechanisms for tracking the contents of databases and tablespaces). This solves the longstanding problem that you can drop a user who still owns objects and/or has access permissions. Alvaro Herrera, with some kibitzing from Tom Lane. Tom Lane 2005-07-07 20:40:02 +00:00
  • 442b59dd8b Update: Bruce Momjian 2005-07-07 16:02:06 +00:00
  • f0a2a91918 Update: Bruce Momjian 2005-07-07 15:18:26 +00:00
  • 1c883366ef Fix plperl expected output. Bruce Momjian 2005-07-07 04:41:01 +00:00
  • 294de2dc01 pg_column_size() cleanup for messages and code cleanup. Bruce Momjian 2005-07-07 04:36:08 +00:00
  • eefdbba062 Currently, nonfatal warnings are not trapped (as they should be) by plperl - the attached small patch remedies that omission, and adds a small regression test for error and warning output - the new regression input and expected output are in separate attached files. Bruce Momjian 2005-07-06 22:44:49 +00:00
  • 77838f7380 Currently, nonfatal warnings are not trapped (as they should be) by plperl - the attached small patch remedies that omission. Bruce Momjian 2005-07-06 22:33:39 +00:00
  • 970bb03c3c Complete zic patch backout by removing NO_PGPORT workaround. Bruce Momjian 2005-07-06 21:40:09 +00:00
  • 261ffd03f7 Reverse out because the lack of using pgport in timezone/ is causing problems: Bruce Momjian 2005-07-06 21:04:14 +00:00
  • a923602855 Add pg_column_size() to return storage size of a column, including possible compression. Bruce Momjian 2005-07-06 19:02:54 +00:00
  • b9cb132648 Sync dlopen error handling for the *BSDs ... seems to me I've done this before, but they were out of sync again. Per Kris Jurka. Tom Lane 2005-07-06 16:55:58 +00:00
  • 6e2ff6e89a Add a check for trigger function with declared arguments. This path could not be reached before, but now that there is a plpgsql validator function, it can be. Check is needed to prevent core dump reported by Satoshi Nagayasu. Besides, this gives a more specific and useful error message for a fairly common novice error. Tom Lane 2005-07-06 16:42:10 +00:00
  • 99382f4581 Save and restore errno across bindtextdomain call, per discussion. Tom Lane 2005-07-06 16:25:59 +00:00
  • 3d6b0d8631 Fix incorrect PG_CPPFLAGS initialization, per Marko. Tom Lane 2005-07-06 16:14:42 +00:00
  • 0bf8b27348 Update description of GUC full_page_writes. Bruce Momjian 2005-07-06 14:45:12 +00:00
  • 7d2e1cb730 Done: Bruce Momjian 2005-07-06 03:40:15 +00:00
  • c3a69c3b3b Attached is a patch that enhances the "\h" capability in psql. I often find myself typing a command and then wanting to get the syntax for it. So I do a ctrl-a and add a \h: but psql does not recognize the command, because I have stuff attached to it (e.g. "alter table foobar"), so I have to scroll over and delete everything except the name of the command itself. This patch gives \h three chances to match: if nothing matches the complete string (current behavior), it tries to match the first two words (e.g. "ALTER TABLE"). If that fails, it tries to match the first word (e.g. "DELETE"). Bruce Momjian 2005-07-06 03:14:48 +00:00
  • 84d630eb24 Dept of second thoughts: don't expose rijndael.tbl: rijndael.c dependency to make. We ship the table file in the tarball and so this dependency just opens file timestamp skew problems without doing anything useful. (Not that it should hurt, either ... except for cross-compile builds.) Tom Lane 2005-07-05 23:18:44 +00:00
  • 326a7a0788 Add GUC full_page_writes to control writing full pages to WAL. Bruce Momjian 2005-07-05 23:18:10 +00:00
  • c19aa704c8 Fix contrib/pgcrypto to autoconfigure for OpenSSL when --with-openssl is used in the toplevel configure. Per Marko Kreen. Tom Lane 2005-07-05 23:13:57 +00:00
  • d22a3727a5 Remove, now have GUC: Bruce Momjian 2005-07-05 22:59:36 +00:00
  • 3bf4e4120d Add: < 881a881,882 > o Improve xid wraparound detection by recording per-table rather > than per-database Bruce Momjian 2005-07-05 19:37:54 +00:00
  • 2d6c375c5f Back out patch. This should be done like other server-side languages. Bruce Momjian 2005-07-05 18:15:51 +00:00
  • 576ac4b8c9 Fix initialization bug in pgcrypto openssl code. Marko Kreen Tom Lane 2005-07-05 18:15:36 +00:00
  • 7e33fae3c1 Add NO_PGPORT defines to fix win32/cygwin builds for new target platform build of zic. Bruce Momjian 2005-07-05 17:24:30 +00:00
  • 4f979e8bac Restructure zic #define fprintf checks to use a NO_PGPORT macro instead. Bruce Momjian 2005-07-04 19:54:51 +00:00
  • 8a79451152 I have to admit that I got the case of the preprocessor symbol on amd64 wrong. __AMD64__ is not defined, __amd64__ is. Bruce Momjian 2005-07-04 19:05:45 +00:00
  • af8756713f This patch allows the PL/Python module to do (SRF) functions. Bruce Momjian 2005-07-04 19:03:30 +00:00
  • 109f079be6 I made the patch that improved the performance of replace_text(). The content of the patch is as follows: Bruce Momjian 2005-07-04 18:56:44 +00:00
  • 4b97d51c0a Fix compile if zic because it now doesn't use libpgport. Bruce Momjian 2005-07-04 18:21:40 +00:00
  • de5d30069b More TODO list section restructuring. Bruce Momjian 2005-07-04 17:43:42 +00:00
  • 8ea398513e Restructure TODO sections. Bruce Momjian 2005-07-04 17:00:32 +00:00
  • 75aed9f0c2 Backpatch to 8.0.X openssl portability fixes to pgcrypto. Bruce Momjian 2005-07-04 14:42:39 +00:00
  • b9fe8ee225 Fix date_trunct for December dates that are in the next year, e.g.: Bruce Momjian 2005-07-04 14:38:31 +00:00
  • 0a056c3716 Fix date_trunct for December dates that are in the next year, e.g.: Bruce Momjian 2005-07-04 14:12:45 +00:00
  • e652d2c476 Update > * Allow GIST indexes to create certain complex index types, like digital > trees (see Aoki) > 783a787 > Bruce Momjian 2005-07-04 12:32:38 +00:00
  • eb5949d190 Arrange for the postmaster (and standalone backends, initdb, etc) to chdir into PGDATA and subsequently use relative paths instead of absolute paths to access all files under PGDATA. This seems to give a small performance improvement, and it should make the system more robust against naive DBAs doing things like moving a database directory that has a live postmaster in it. Per recent discussion. Tom Lane 2005-07-04 04:51:52 +00:00
  • 7504f0bae8 Reverse this patch: Bruce Momjian 2005-07-04 04:17:00 +00:00
  • 3848532c79 Update wording: Bruce Momjian 2005-07-04 04:06:43 +00:00
  • 3f39cbdce1 Fix build break for out of tree (vpath) builds, induced by recent zic changes. Neil Conway 2005-07-04 02:55:59 +00:00
  • a3ff1aad5d Bruce, please apply this additional patch, that fixes the auto-detection of AES. Bruce Momjian 2005-07-04 02:02:01 +00:00
  • bb630623a4 Fix memory leak in plperl_hash_from_tuple(), per report from Jean-Max Reymond. Tom Lane 2005-07-03 21:56:27 +00:00
  • bee9aef43b Fix memory leak in plperl_hash_from_tuple(), per report from Jean-Max Reymond. Tom Lane 2005-07-03 21:56:16 +00:00
  • ae9a07bf9e Don't try to constant-fold functions returning RECORD. We were never able to do this before, but I had tried to make an exception for functions with OUT parameters. Michael Fuhr found one problem with it already, and I found another, which was it didn't work for strict functions with a NULL input. While both of these could be worked around, the probability that there are more gotchas seems high; I think prudence dictates just reverting to the former behavior for now. Accordingly, remove the kluge added to get_expr_result_type() for Michael's case. Tom Lane 2005-07-03 21:14:18 +00:00