Commit Graph

  • 53c4f1233f UPDATE ... SET <col> = DEFAULT Bruce Momjian 2003-06-25 04:19:24 +00:00
  • 612cbaf5ed [ Backpatch to 7.3.X.] Bruce Momjian 2003-06-25 04:09:15 +00:00
  • a09ccc70dd If they're not, the below causes problems, as the foreign key is added after the CHECK. Cluster depends on the index name, so I thought it wise to ensure all names are available, rather than leaving off the CONSTRAINT "$n" portion for internally named constraints. Bruce Momjian 2003-06-25 04:08:19 +00:00
  • ca64391d6c Updated the pg_get_constraintdef() to use conbin. Update pg_dump to use pg_get_constraintdef() for >= 70400. Bruce Momjian 2003-06-25 03:56:31 +00:00
  • be94f198c3 Add missing </row>'s. Bruce Momjian 2003-06-25 03:50:52 +00:00
  • c70e606a4c Includes: Bruce Momjian 2003-06-25 03:40:19 +00:00
  • dbca370278 Back out commit. Bruce Momjian 2003-06-25 03:02:37 +00:00
  • ad41cd6c4a Adjust expected output for new functions. Bruce Momjian 2003-06-25 03:01:35 +00:00
  • a804f9c795 Add: Bruce Momjian 2003-06-25 02:43:54 +00:00
  • ebbd2edf82 Seems the runtime.sgml and perform.sgml patches combined are incompatible. Bruce Momjian 2003-06-25 02:07:33 +00:00
  • d57d000627 Update catversion for ipv6 addition. Bruce Momjian 2003-06-25 01:26:16 +00:00
  • eaef65f68e Documentation about using CIDR addresses in pg_hba.conf. Bruce Momjian 2003-06-25 01:20:50 +00:00
  • d9ddbdaa95 > This change (I'm sure this will wrap poorly -- sorry): > http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/libpq/pqcomm.h.diff?r1=1.85&r2=1.86 > > modified SockAddr, but no corresponding change was made here > (fe-auth.c:612): > > case AUTH_REQ_KRB5: > #ifdef KRB5 > if (pg_krb5_sendauth(PQerrormsg, conn->sock, &conn->laddr.in, > &conn->raddr.in, > hostname) != STATUS_OK) > > It's not obvious to me what the change ought to be though. Bruce Momjian 2003-06-25 01:19:47 +00:00
  • afb17d912b > I've worked with the Pl/Python code in the past and will see about removing > rexec and making it an untrusted language. Last time I looked, it didn't > look particularly difficult. I've set aside some time next week, so stay > tuned. Bruce Momjian 2003-06-25 01:18:58 +00:00
  • b24a0293cc Attached is a patch that provides *VERY* limited support for multiple slave servers. I haven't tested it very well, so use at your own risk (and I recommend against using it in production). Bruce Momjian 2003-06-25 01:17:44 +00:00
  • e1be2ee831 Here's a small patch to pg_hba.conf.sample that explains the use of CIDR addresses. Bruce Momjian 2003-06-25 01:15:24 +00:00
  • 861ea4ba53 Create <link> entries for the foreign keys in the system catalog chapter. Bruce Momjian 2003-06-25 01:14:37 +00:00
  • 503a88a632 client-auth.sgml references a renamed ID in runtime.sgml Bruce Momjian 2003-06-25 01:14:05 +00:00
  • 2a5e0bb612 Attached is the fully corrected version of the re-ording patch for Runtime.sgml and dependant files. Bruce Momjian 2003-06-25 01:13:24 +00:00
  • 51d16423ae - Corrections for tables, columns with uppercase characters - Don't attempt to convert partial or expressional unique indexes - Don't attempt to convert unique indexes based on a non-default opclasses Bruce Momjian 2003-06-25 01:11:09 +00:00
  • 8f337e86cd Please apply attached patch to contrib/dblink. It adds named persistent connections to dblink. Bruce Momjian 2003-06-25 01:10:15 +00:00
  • 92798de02e This is a bug in python interface module, postgresql-7.3.3/src/interfaces/python/pg.py. Bruce Momjian 2003-06-25 01:09:24 +00:00
  • dd23a882fa >> If a transaction marks a tuple for update and later commits without >> actually having updated the tuple, [...] can we simply >> set the HEAP_XMAX_INVALID hint bit of the tuple? > >AFAICS this is a reasonable thing to do. Bruce Momjian 2003-06-25 01:08:13 +00:00
  • fce529e102 Most of the synopsis areas for DROP commands use "name" as the identifier, while some areas do not. Bruce Momjian 2003-06-24 23:29:25 +00:00
  • 7eac8e3809 Revert ORDBMS change, per Peter. Bruce Momjian 2003-06-24 23:27:24 +00:00
  • db57396c1f Alter query.sgml to mention PostgreSQL as an ORDBMS. This falls in line with advocacy and 'portal' websites. Bruce Momjian 2003-06-24 23:26:46 +00:00
  • 7f7919256a In an attempt to simplify my life I'm submitting this patch that restructures the deferred trigger queue. The fundamental change is to put all the static variables to hold the deferred triggers in a single structure. Bruce Momjian 2003-06-24 23:25:44 +00:00
  • aa62f7f74a Add x86_64 support for spinlocks. Bruce Momjian 2003-06-24 23:20:08 +00:00
  • 7cb4278e82 Small patch to link to the proper place in the "runtime" file, and to add the "schemaname" column to the description of the pg_stats view. Bruce Momjian 2003-06-24 23:19:11 +00:00
  • 46bf651480 Array mega-patch. Bruce Momjian 2003-06-24 23:14:49 +00:00
  • 50e53236af Done: Bruce Momjian 2003-06-24 23:05:20 +00:00
  • 7b1f6ffaab Jim C. Nasby wrote: > Second argument to metaphone is suposed to set the limit on the > number of characters to return, but it breaks on some phrases: > > usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from > (select 'Hello world'::varchar AS a) a; > HLW | HLWR | HLWRLT > > usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from > (select 'A A COMEAUX MEMORIAL'::varchar AS a) a; > AKM | AKMKS | AKMKSMMRL > > In every case I've found that does this, the 4th and 5th letters are > always 'KS'. Bruce Momjian 2003-06-24 22:59:46 +00:00
  • 4b1fe23153 Prevent compiler warning from sprintf in recent ipv6 patch. Bruce Momjian 2003-06-24 22:42:42 +00:00
  • 945543d919 Add ipv6 address parsing support to 'inet' and 'cidr' data types. Bruce Momjian 2003-06-24 22:21:24 +00:00
  • 4dab978c52 Update: Bruce Momjian 2003-06-24 18:45:38 +00:00
  • 975674a952 Add -L../ecpglib -lecpg for Cygwin compile. Bruce Momjian 2003-06-24 14:45:46 +00:00
  • b235fe3c25 Add: Bruce Momjian 2003-06-24 03:42:44 +00:00
  • 2e9632297b Add: Bruce Momjian 2003-06-24 03:40:09 +00:00
  • c4ac870544 Add: Bruce Momjian 2003-06-24 02:54:23 +00:00
  • 3b2e94de84 Add: Bruce Momjian 2003-06-24 02:53:36 +00:00
  • 9b2cee0b54 Add: Bruce Momjian 2003-06-24 02:39:49 +00:00
  • f703dee32e Update: Bruce Momjian 2003-06-24 01:54:57 +00:00
  • 5249172e1f typedef sa_family_t for cygwin. Bruce Momjian 2003-06-24 01:49:22 +00:00
  • 94468c6f04 Add: Bruce Momjian 2003-06-24 01:08:20 +00:00
  • 646e7f8415 Do not include: Bruce Momjian 2003-06-24 00:44:29 +00:00
  • 99308891ef Remove references to sa_family_t, except when SOCKADDR_STORAGE requires it. Bruce Momjian 2003-06-23 23:52:00 +00:00
  • 6403a6729c Add with '?': Bruce Momjian 2003-06-23 19:33:40 +00:00
  • 3bfabc36b6 Add mention that the grep's have to be adjusted in pgtest. Bruce Momjian 2003-06-23 19:33:25 +00:00
  • 5c65c94e4f Remove '?': Bruce Momjian 2003-06-23 19:22:30 +00:00
  • ab5c775116 Change pqInternalNotice to accept a format string and args instead of just a preformatted message; per suggestion by Sean Chittenden. Tom Lane 2003-06-23 19:20:25 +00:00
  • 408625321c Remove crypt.h from fe-connect.c --- not needed, and caused problems on Solaris with Open SSL version 0.9.7b Bruce Momjian 2003-06-23 17:03:19 +00:00
  • 9542debae3 Update Russian version of FAQ. Bruce Momjian 2003-06-23 16:58:21 +00:00
  • 5b106845f9 Add: Bruce Momjian 2003-06-23 04:31:25 +00:00
  • 52001f615e Add: Bruce Momjian 2003-06-23 04:00:10 +00:00
  • ec5020f0a7 Add: Bruce Momjian 2003-06-23 03:52:24 +00:00
  • bff0422b6c Revise hash join and hash aggregation code to use the same datatype- specific hash functions used by hash indexes, rather than the old not-datatype-aware ComputeHashFunc routine. This makes it safe to do hash joining on several datatypes that previously couldn't use hashing. The sets of datatypes that are hash indexable and hash joinable are now exactly the same, whereas before each had some that weren't in the other. Tom Lane 2003-06-22 22:04:55 +00:00
  • 0dda75f6eb Fix some index entries. Tom Lane 2003-06-22 16:17:01 +00:00
  • a171edf8fc Adjust chapter ordering in Internals part to something that seems more reasonable. Tom Lane 2003-06-22 16:16:44 +00:00
  • 36fe7577f8 Added missing terminating '\0' char for data put into char *. Michael Meskes 2003-06-22 11:00:48 +00:00
  • 14847af48d Remove a lot of desperately obsolete material (which was all out of sight, out of mind, because it'd been commented out years ago). Try to bring the remains up to a reasonable level of currency, and give it all approximately the same high level of abstraction. Tom Lane 2003-06-22 05:48:26 +00:00
  • 82de7b0a44 Add question mark to item: Bruce Momjian 2003-06-22 05:04:52 +00:00
  • 4a49d69c90 Add: Bruce Momjian 2003-06-22 05:01:17 +00:00
  • c1ae39a0cd Add pgtest script. Bruce Momjian 2003-06-22 04:22:57 +00:00
  • dd81eee222 Use libpq's new logic to get the server version, instead of doing it ourselves. Tom Lane 2003-06-22 00:56:58 +00:00
  • e92dc1e199 Bring the libpq example programs into the 21st century. Tom Lane 2003-06-22 00:29:29 +00:00
  • 21e0b7b8f2 Get rid of extraneous newline in PQendcopy error output (was causing regression test diffs...). Tom Lane 2003-06-21 23:25:38 +00:00
  • efc3a25bb0 Update libpq to make new features of FE/BE protocol available to client applications. Some editorial work on libpq.sgml, too. Tom Lane 2003-06-21 21:51:35 +00:00
  • b8d601e735 Fix some markup problems. Tom Lane 2003-06-21 19:33:36 +00:00
  • 4342e6ea18 Fix for extended-query protocol: in event of error, backend was issuing a ReadyForQuery (Z message) immediately and then another one after the Sync message arrives. Suppress the first one to make it work per spec. Tom Lane 2003-06-20 21:58:02 +00:00
  • 94b59faeb7 Synced with backend. Michael Meskes 2003-06-20 15:16:06 +00:00
  • 2cbaaee6c3 Just another Informix compatibility change. They uses "free" for cursors as wellafter closing them. Michael Meskes 2003-06-20 13:36:34 +00:00
  • d9b2401d90 Just another ecpg todo done. Michael Meskes 2003-06-20 13:20:09 +00:00
  • cf5ec3d12b Sorry, missed a file. Michael Meskes 2003-06-20 12:01:46 +00:00
  • abd310a3b1 Allow constants in using clauses. Michael Meskes 2003-06-20 12:00:59 +00:00
  • 5fc9f3d574 We neglected to set conn->raddr.salen, leading to breakage of CANCEL and probably other stuff. Tom Lane 2003-06-20 04:09:12 +00:00
  • 1bd22f55cf Disallow dollar sign in operator names, instead allow it as a non-first character in identifiers. The first change eliminates the current need to put spaces around parameter references, as in "x<=$2". The second change improves compatibility with Oracle and some other RDBMSes. This was discussed and agreed to back in January, but did not get done. Tom Lane 2003-06-19 23:22:40 +00:00
  • 8902aaaa6c Fixed fetch into char * and added missing prototype for an Informix function. Michael Meskes 2003-06-19 09:52:11 +00:00
  • 4d9eede82f Move thread checking code farther down in conflgure. Bruce Momjian 2003-06-18 16:04:15 +00:00
  • f374a9dae9 Change clusterdb and vacuumdb into C programs. Peter Eisentraut 2003-06-18 12:19:11 +00:00
  • eab5d643b2 Make FLOAT(p) measure the precision p in bits, not decimal digits, to match the SQL standard. Document FLOAT and FLOAT(p) notations in datatype.sgml. Per recent pghackers discussion. Tom Lane 2003-06-17 23:12:36 +00:00
  • 596652d6eb More information schema views. Peter Eisentraut 2003-06-17 18:00:48 +00:00
  • 3d6fd2557c Add missing file to clean target. Peter Eisentraut 2003-06-17 17:58:54 +00:00
  • 8a2aa79fee Fixed several more parsing bugs. Michael Meskes 2003-06-17 07:28:22 +00:00
  • f12f8990e4 Fix error line numbers reported for errors in plpgsql_parse_word and siblings. Tom Lane 2003-06-17 04:35:03 +00:00
  • 5fbc1d4a45 Fix bugs in interval-to-time conversion: HAVE_INT64_TIMESTAMP case did not work at all, and neither case behaved sanely for negative intervals. Tom Lane 2003-06-16 18:56:53 +00:00
  • 3467b1a1f9 Fix bugs in interval-to-time conversion: HAVE_INT64_TIMESTAMP case did not work at all, and neither case behaved sanely for negative intervals. Tom Lane 2003-06-16 18:56:45 +00:00
  • 76924b5d94 Fixed two small bugs. Michael Meskes 2003-06-16 16:58:11 +00:00
  • a499725469 Allow GROUP BY, ORDER BY, DISTINCT targets to be unknown literals, silently resolving them to type TEXT. This is comparable to what we do when faced with UNKNOWN in CASE, UNION, and other contexts. It gets rid of this and related annoyances: select distinct f1, '' from int4_tbl; ERROR: Unable to identify an ordering operator '<' for type unknown This was discussed many moons ago, but no one got round to fixing it. Tom Lane 2003-06-16 02:03:38 +00:00
  • cb02610e50 Adjust nestloop-with-inner-indexscan plan generation so that we catch some cases of redundant clauses that were formerly not caught. We have to special-case this because the clauses involved never get attached to the same join restrictlist and so the existing logic does not notice that they are redundant. Tom Lane 2003-06-15 22:51:45 +00:00
  • 3fb6f1347f Replace cryptic 'Unknown kind of return type' messages with something hopefully a little more useful. Tom Lane 2003-06-15 17:59:10 +00:00
  • 996fdb9af1 Cause GROUP BY clause to adopt ordering operators from ORDER BY when both clauses specify the same targets, rather than always using the default ordering operator. This allows 'GROUP BY foo ORDER BY foo DESC' to be done with only one sort step. Tom Lane 2003-06-15 16:42:08 +00:00
  • da78e3e2eb index() -> strchr(). Tom Lane 2003-06-15 16:21:39 +00:00
  • a0f29e3afd Typo in version number. Michael Meskes 2003-06-15 12:06:50 +00:00
  • 86a8331935 Some minor changes for new version numbering. Michael Meskes 2003-06-15 11:10:09 +00:00
  • 7ea9c94814 Updating ECPG todo items. Michael Meskes 2003-06-15 10:34:10 +00:00
  • a64927f995 Ecpg cleanups for prototypes. Bruce Momjian 2003-06-15 04:56:45 +00:00
  • 228c02c3e5 Run autoconf/autoheader for ecpg change. Bruce Momjian 2003-06-15 04:09:18 +00:00
  • 4f70680177 Make ecpg thread safe. Bruce Momjian 2003-06-15 04:07:58 +00:00
  • ffa3bfbc30 Move thread os defines into template files. Bruce Momjian 2003-06-14 19:21:42 +00:00
  • 467839df26 Handle threading in two more gethostbyname calls. Bruce Momjian 2003-06-14 18:20:33 +00:00