summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-04-05I was tinkering with creating rules on views (so, for instance, one couldBruce Momjian
insert on a view), and noticed that psql wouldn't show the list of rules set up on a view, like it does for tables. The fix was extremely simple, so I figured I'd share it. Not sure what the standard is for communicating these things, so I've attached the diff file for /src/bin/psql/describe.c. Paul (?)
2002-04-05Adds domain dumping support to pg_dump.Bruce Momjian
Rod Taylor
2002-04-05When a macro is replaced by the preprocessor, pgc.l reaches a end ofBruce Momjian
file, which is not the actual end of the file. One side effect of that is that if you are i n a ifdef block, you get a wrong error telling you that a endif is missing. This patch corrects pgc.l and also adds a test of this problem to test1.pgc. To convince you apply the patch to test1.pgc first then try to compile the test the n apply the patch to pgc.l. The patch moves the test of the scope of an ifdef block to the end of the file b eeing parsed, including all includes files, ... . Nicolas Bazin
2002-04-05Looks like a small patch is needed as well to do the right thing on Linux.Bruce Momjian
The patch enables the mips2 ISA for the ll/sc operations, and then restores it when done. The kernel/libc emulation code will take over on CPUs without ll/sc, and on CPUs with it, it'll use the operations provided by the CPU. Combined with the earlier fix (removing -mips2), postgresql builds again on mips and mipsel. The patch is against 7.2-7. Oliver Elphick
2002-04-05Undo not-so-hot decision to postpone insertion of default values intoTom Lane
INSERT statements to the planner. Taking it out of the parser was right (so that defaults don't get into stored rules), but it has to happen before rewrite rule expansion, else references to NEW.field behave incorrectly. Accordingly, add a step to the rewriter to insert defaults just before rewrite-rule expansion.
2002-04-05Divide functions into three volatility classes (immutable, stable, andTom Lane
volatile), rather than the old cachable/noncachable distinction. This allows indexscan optimizations in many places where we formerly didn't. Also, add a pronamespace column to pg_proc (it doesn't do anything yet, however).
2002-04-04Fix a bug in SQLError().Hiroshi Inoue
2002-04-04This patch against 0.98.7 lib/tables.tcl will allow PGAccess to create newBruce Momjian
records containing apostrophes in text fields without altering the appearance of the entry in the GUI interface (by copying the fldval to fldvalfixed). This will alleviate the need for users to create a record and then go back to edit apostrophes into the text they entered. Ryan Grange
2002-04-04Cleanup of level ordering and add missing LOG entry.Bruce Momjian
2002-04-04Add missing mention of 'log' option for client_min_messages.Bruce Momjian
2002-04-04Authentication improvements:Bruce Momjian
A new pg_hba.conf column, USER Allow specifiction of lists of users separated by commas Allow group names specified by + Allow include files containing lists of users specified by @ Allow lists of databases, and database files Allow samegroup in database column to match group name matching dbname Removal of secondary password files Remove pg_passwd utility Lots of code cleanup in user.c and hba.c New data/global/pg_pwd format New data/global/pg_group file
2002-04-04Fix a bug in multibyte_strchr().Hiroshi Inoue
2002-04-03Locale support is on by default. The choice of locale is done in initdbPeter Eisentraut
and/or with GUC variables.
2002-04-03Replace perror() calls by elog()s, so that messages can be routed toTom Lane
syslog when appropriate. These were the last perror() calls remaining in the backend; let's not reintroduce any...
2002-04-03Allow postmaster to start up anyway when PGSTAT code fails to initialize,Tom Lane
per recent discussion on pghackers. Also, fix PGSTAT code to report errors via elog, not scribbling directly on stderr.
2002-04-02Fix compiler warnings.Hiroshi Inoue
2002-04-02[HACKERS] Proposed patch for ODBC driver w/ C-a-n-c-e-lHiroshi Inoue
From: Bradley McLean <brad@bradm.net> Patch against 7,2 submitted for comment. This seems to work just fine; Now, when our users submit a 2 hour query with four million row sorts by accident, then cancel it 30 seconds later, it doesn't bog down the server ...
2002-04-02Removed obsolete DROP_COLUMN_HACK stuff.Hiroshi Inoue
2002-04-02Tweak SERIAL column creation to emit a fully qualified sequence nameTom Lane
as argument for nextval().
2002-04-02Removed error message that was incorectly being issued. This fixes a ↵Barry Lind
problem reported a few months ago where a select in a rule was causing an insert statement to return a result set which the code was explicitly prohibiting.
2002-04-02Fix CLOG truncation code to not do the Wrong Thing when there are alreadyTom Lane
wrapped-around databases. The unvacuumed databases might be fine, or they might not, but things will definitely not be fine if we remove the wrong CLOG segments. Per trouble report from Gary Wolfe, 1-Apr-2002.
2002-04-02Make VACUUM handle schema-qualified relation names properly.Tom Lane
2002-04-01Add tgconstrrelid to stored Trigger structures, make RI trigger functionsTom Lane
depend on this rather than the trigger argument strings to locate the other relation to test. This makes RI triggers function properly in the presence of schemas and temp tables. Along the way, fix bogus lack of locking in RI triggers, handle quoting of names fully correctly, compute required sizes of query buffers with some semblance of accuracy.
2002-04-01Attached is a patch which adds 2 missing semi-colons toBruce Momjian
bootstrap/bootparse.y, so that recent versions of bison don't emit a warning. Neil Conway
2002-04-01ALTER TABLE SET/DROP NOT NULL, from Christopher Kings-Lynne.Tom Lane
2002-04-01Create a new GUC variable search_path to control the namespace searchTom Lane
path. The default behavior if no per-user schemas are created is that all users share a 'public' namespace, thus providing behavior backwards compatible with 7.2 and earlier releases. Probably the semantics and default setting will need to be fine-tuned, but this is a start.
2002-04-011) Add rollback functionality to updatable cursors.Hiroshi Inoue
2) Implement some options for SQLGetDescField(). 3) Handle *Inifinity* timestamp for SQL_C_CHAR type output. 4) Separate Unicode conversions from common implementations. 5) Improve internal parse_statement() function.
2002-04-01Temporary kluge to let RI triggers work on tables outside the systemTom Lane
catalog namespace. This will not do as a production solution because the interpretation of RI trigger arguments will vary depending on the current namespace search path. I'm just putting it in so that the RI regression tests don't fail while schema development proceeds. We must find a better answer before 7.3 can be released.
2002-03-31Make renamerel take an OID, not a RangeVar, to identify the relationTom Lane
to rename. Avoids some corner-case bugs in cluster.c, improves consistency with renameatt.
2002-03-31Reimplement temp tables using schemas. The temp table map is history;Tom Lane
temp table entries in pg_class have the names the user would expect.
2002-03-30Further cleanups for relations in schemas: teach nextval and otherTom Lane
sequence functions how to cope with qualified names. Same code is also used for int4notin, currtid_byrelname, pgstattuple. Also, move TOAST tables into special pg_toast namespace.
2002-03-29Mop-up some infelicities in new relation lookup handling.Tom Lane
2002-03-29pg_type has a typnamespace column; system now supports creating typesTom Lane
in different namespaces. Also, cleanup work on relation namespace support: drop, alter, rename commands work for tables in non-default namespaces.
2002-03-29Upgrade to Autoconf version 2.53. Replaced many custom macroPeter Eisentraut
calls with new or now-built-in versions. Make sure that all calls to AC_DEFINE have a third argument, for possible use of autoheader in the future.
2002-03-29Fix ODBC warnings about missing parens and pg_ismb not used (addedBruce Momjian
#ifdef NOT_USED).
2002-03-29Fox for old python PyMem_DEL, was PyMem_Del,Bruce Momjian
2002-03-29Fix '#' commant to be proper C comment.Bruce Momjian
2002-03-28[2002-03-28]Hiroshi Inoue
1) Prepare to separate 4 kinds of Descriptor handles. 2) Detect the transaction status more naturally. 3) Improve Parse Statement functionality for the use of updatable cursors. 4) Improve updatable cursors. 5) Implement SQLGetDescField() and improve SQLColAttribute(). 6) etc.
2002-03-27Reset parenthesis level counter upon \r.Peter Eisentraut
2002-03-27applied patch from Liam Stewart fixing a message in the properties fileBarry Lind
also fixed a NPE when calling the next() method on a result set after the connection or resultset has been closed. (bug reported by Hans Deragon)
2002-03-26pg_class has a relnamespace column. You can create and access tablesTom Lane
in schemas other than the system namespace; however, there's no search path yet, and not all operations work yet on tables outside the system namespace.
2002-03-26applied patch submitted by Florian (mailing-list@urbanet.ch) for BigDecimal ↵Barry Lind
support
2002-03-26Changed QueryExecutor.java to correctly read responses from the backend.Barry Lind
Fixed NPE when database name was not passed on the jdbc connection URL Fixed Connection.isClosed() to not hit the DB for every call
2002-03-26Update release list.Bruce Momjian
2002-03-26Update sgml version properly.Bruce Momjian
2002-03-26Further changes following discussion on INTERFACES mailing list:D'Arcy J.M. Cain
- Use PyObject_Del() rather than macro version - Check version and drop back to PyMem_Del() for older systems.
2002-03-25Re-allow CREATE AS (but not SELECT INTO) in EXECUTE.Tom Lane
2002-03-25Fix for ODBC compile warnings.Bruce Momjian
2002-03-24Indenting #if commands is not portable, is it?Tom Lane
2002-03-24Tweak labeling of plan qual conditions for more consistency.Tom Lane