aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Fix compile warnings.Tom Lane2003-06-27
|
* Missing calls to PQclear in large_obj.c and describe.c.Tom Lane2003-06-27
| | | | Greg Sabino Mullane
* First batch of object rename commands.Peter Eisentraut2003-06-27
|
* Create real array comparison functions (that use the element datatype'sTom Lane2003-06-27
| | | | | | | | | | | | | | | | comparison functions), replacing the highly bogus bitwise array_eq. Create a btree index opclass for ANYARRAY --- it is now possible to create indexes on array columns. Arrange to cache the results of catalog lookups across multiple array operations, instead of repeating the lookups on every call. Add string_to_array and array_to_string functions. Remove singleton_array, array_accum, array_assign, and array_subscript functions, since these were for proof-of-concept and not intended to become supported functions. Minor adjustments to behavior in some corner cases with empty or zero-dimensional arrays. Joe Conway (with some editorializing by Tom Lane).
* Add comment pointing out that XLByteToPrevSeg macro is not broken.Tom Lane2003-06-26
|
* Added just another compatibility level for Informix.Michael Meskes2003-06-26
|
* Wrap LONG_LONG_MIN redfinition around HAVE_LONG_LONG_INT_64.Bruce Momjian2003-06-26
|
* Fix compile problem for missing LONG_LONG_MIN on BSD/OS.Bruce Momjian2003-06-26
|
* Back out array mega-patch.Bruce Momjian2003-06-25
| | | | Joe Conway
* In ISO datestyle, never emit just HH:MM, always emit HH:MM:SS orTom Lane2003-06-25
| | | | | | | | HH:MM:SS.SSS... when there is a nonzero part-of-a-day field in an interval value. The seconds part used to be suppressed if zero, but there's no equivalent behavior for timestamp, and since we're modeling this format on timestamp it's probably wrong. Per complaint and patch from Larry Rosenman.
* Don't generate 'zero' typeids in the output from gen_cross_product.Tom Lane2003-06-25
| | | | | | This is no longer necessary or appropriate since we don't use zero typeid as a wildcard anymore, and it fixes a nasty performance problem with functions with many parameters. Per recent example from Reuven Lerner.
* The remaining files ...Michael Meskes2003-06-25
|
* remove including of postgres_fe.hMichael Meskes2003-06-25
|
* Some systems need another header file included.Michael Meskes2003-06-25
|
* Implemented Informix special way to treat NULLs, removed warnings, synced.Michael Meskes2003-06-25
|
* Fix up JOIN .. USING with domainsBruce Momjian2003-06-25
| | | | | | | | | | | | | | | | The attached fixes select_common_type() to support the below case: create table t1( c1 int); create domain dom_c1 int; create table t2(c1 dom_c1); select * from t1 join t2 using( c1 ); I didn't see a need for maintaining the domain as the preferred type. A simple getBaseType() call on all elements of the list seems to be enough. -- Rod Taylor <rbt@rbt.ca>
* UPDATE ... SET <col> = DEFAULTBruce Momjian2003-06-25
| | | | Rod Taylor
* If they're not, the below causes problems, as the foreign key is addedBruce Momjian2003-06-25
| | | | | | | | | | | | | | 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. CREATE TABLE jkey (col integer primary key); CREATE TABLE j (col integer REFERENCES jkey); ALTER TABLE j ADD CHECK(col > 5); This is a problem in 7.3 series as well as -Tip. Rod Taylor <rbt@rbt.ca>
* Updated the pg_get_constraintdef() to use conbin. Update pg_dump to useBruce Momjian2003-06-25
| | | | | | pg_get_constraintdef() for >= 70400. Rod Taylor <rbt@rbt.ca>
* Includes:Bruce Momjian2003-06-25
| | | | | | | | | | | | | | | | - LIKE <subtable> [ INCLUDING DEFAULTS | EXCLUDING DEFAULTS ] - Quick cleanup of analyze.c function prototypes. - New non-reserved keywords (INCLUDING, EXCLUDING, DEFAULTS), SQL 200X Opted not to extend for check constraints at this time. As per the definition that it's user defined columns, OIDs are NOT inherited. Doc and Source patches attached. -- Rod Taylor <rbt@rbt.ca>
* Back out commit.Bruce Momjian2003-06-25
|
* Adjust expected output for new functions.Bruce Momjian2003-06-25
|
* Update catversion for ipv6 addition.Bruce Momjian2003-06-25
|
* > This change (I'm sure this will wrap poorly -- sorry):Bruce Momjian2003-06-25
| | | | | | | | | | | | | | | | | | | > 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. This patch should hopefully fix both kerberos 4 and 5. Kurt Roeckx
* > I've worked with the Pl/Python code in the past and will see about removingBruce Momjian2003-06-25
| | | | | | | | | | | | | > 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. Attached is a patch that removes all of the RExec code from plpython from the current PostgreSQL CVS. In addition, plpython needs to be changed to an untrusted language in createlang. Please let me know if there are any problems. Kevin Jacobs
* Here's a small patch to pg_hba.conf.sample that explains the use of CIDRBruce Momjian2003-06-25
| | | | | | addresses. Andrew Dunstan
* This is a bug in python interface module,Bruce Momjian2003-06-25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | postgresql-7.3.3/src/interfaces/python/pg.py. _quote() function fails due to integer overflow if input d is larger than max integer. In the case where the column type is "BIGINT", the input d may very well be larger than max integer while its type, t, is labeled 'int'. The conversion on line 19, return "%d" % int(d), will fail due to "OverflowError: long int too large to convert to int". Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- [1] create a table with a column type 'BIGINT'. [2] use pg.DB.insert() to insert a value that is larger than max integer If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- Just changing the conversion at line 19 of pg.py to long(d) instead of int(d) should fix it. The following is a patch: Chih-Hao Huang
* >> If a transaction marks a tuple for update and later commits withoutBruce Momjian2003-06-25
| | | | | | | | | | | | | | | >> 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. Thanks for the confirmation. Here's a patch which also contains some more noncritical changes to tqual.c: . make code more readable by introducing local variables for xvac . no longer two separate branches for aborted and crashed. The actions were the same in all cases. Manfred Koizar
* In an attempt to simplify my life I'm submitting this patch thatBruce Momjian2003-06-24
| | | | | | | | restructures the deferred trigger queue. The fundamental change is to put all the static variables to hold the deferred triggers in a single structure. Alvaro Herrera
* Add x86_64 support for spinlocks.Bruce Momjian2003-06-24
| | | | Jeffrey W. Baker
* Small patch to link to the proper place in the "runtime" file,Bruce Momjian2003-06-24
| | | | | | | and to add the "schemaname" column to the description of the pg_stats view. Greg Sabino Mullane
* Array mega-patch.Bruce Momjian2003-06-24
| | | | Joe Conway
* Prevent compiler warning from sprintf in recent ipv6 patch.Bruce Momjian2003-06-24
|
* Add ipv6 address parsing support to 'inet' and 'cidr' data types.Bruce Momjian2003-06-24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Regression tests for IPv6 operations added. Documentation updated to document IPv6 bits. Stop treating IPv4 as an "unsigned int" and IPv6 as an array of characters. Instead, always use the array of characters so we can have one function fits all. This makes bitncmp(), addressOK(), and several other functions "just work" on both address families. add family() function which returns integer 4 or 6 for IPv4 or IPv6. (See examples below) Note that to add this new function you will need to dump/initdb/reload or find the correct magic to add the function to the postgresql function catalogs. IPv4 addresses always sort before IPv6. On disk we use AF_INET for IPv4, and AF_INET+1 for IPv6 addresses. This prevents the need for a dump and reload, but lets IPv6 parsing work on machines without AF_INET6. To select all IPv4 addresses from a table: select * from foo where family(addr) = 4 ... Order by and other bits should all work. Michael Graff
* Add -L../ecpglib -lecpg for Cygwin compile.Bruce Momjian2003-06-24
|
* typedef sa_family_t for cygwin.Bruce Momjian2003-06-24
|
* Do not include:Bruce Momjian2003-06-24
| | | | | | | #include <pwd.h> #include <netdb.h> in MS CC/Borland builds.
* Remove references to sa_family_t, except when SOCKADDR_STORAGE requiresBruce Momjian2003-06-23
| | | | | | | | it. Also handle __ss_family as a synonym for ss_family. Kurt Roeckx
* Add mention that the grep's have to be adjusted in pgtest.Bruce Momjian2003-06-23
|
* Change pqInternalNotice to accept a format string and args instead ofTom Lane2003-06-23
| | | | just a preformatted message; per suggestion by Sean Chittenden.
* Remove crypt.h from fe-connect.c --- not needed, and caused problems onBruce Momjian2003-06-23
| | | | Solaris with Open SSL version 0.9.7b
* Revise hash join and hash aggregation code to use the same datatype-Tom Lane2003-06-22
| | | | | | | | 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.
* Added missing terminating '\0' char for data put into char *.Michael Meskes2003-06-22
|
* Add pgtest script.Bruce Momjian2003-06-22
|
* Use libpq's new logic to get the server version, instead of doing it ourselves.Tom Lane2003-06-22
|
* Bring the libpq example programs into the 21st century.Tom Lane2003-06-22
|
* Get rid of extraneous newline in PQendcopy error output (was causingTom Lane2003-06-21
| | | | regression test diffs...).
* Update libpq to make new features of FE/BE protocol available toTom Lane2003-06-21
| | | | client applications. Some editorial work on libpq.sgml, too.
* Fix for extended-query protocol: in event of error, backend was issuingTom Lane2003-06-20
| | | | | a ReadyForQuery (Z message) immediately and then another one after the Sync message arrives. Suppress the first one to make it work per spec.
* Synced with backend.Michael Meskes2003-06-20
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-29 23:41:51 +0000