where we want it to be.
cpp is my friend. I get how this was working now: didn't notice the
2nd #include like_match.c earlier and thought all definitions of
MatchText and MBMatchText were the same. Tricky with the macro
expansion and redefinitions. -sc
--
Sean Chittenden
be the default.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 8: explain analyze is your friend
template1
^^
--
Sean Chittenden
Index: src/bin/pg_ctl/pg_ctl.sh
===
RCS file: /home/ncvs/pgsql/pgsql-server/src/bin/pg_ctl/pg_ctl.sh,v
retrieving revision 1.32
diff -u
+ surrounding white space (* 300):
PERFORM TRUE FROM [temp_tbl]...;
IF NOT FOUND THEN
RAISE EXCEPTION ''my error message'';
END IF;
--
Sean Chittenden
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
the name jail_read_only_transactions
more... patch updated for new name.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
in the
pg_catalog.pg_shadow.useconfig column. Imagine adding a syntax for
every feature that a user could have vs. setting user features via a
GUC/MIB system. I'd take the MIB system any day of the week and twice
on Friday given the resulting reduction of bloat to gram.y.
-sc
--
Sean Chittenden
that the pgsql module doesn't depend on
earthdistance?
-sc
--
Sean Chittenden
Index: modules
===
RCS file: /home/ncvs/pgsql/CVSROOT/modules,v
retrieving revision 1.37
diff -u -r1.37 modules
--- modules 22 Aug 2002 00:17:58 -
. Instead of, jail_read_only_transaction=true it'd be
security.force_readonly=true or transaction.readonly_always=true.
-sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
attempt at being secure. What in
side of the backend do you trust? -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
glad to see you've come around on this given temp structures show
up regardless of the temp schema (which is, as you point out, an
implementation detail that users need not concern themselves with).
Patch/thread:
http://archives.postgresql.org/pgsql-general/2003-10/msg00613.php
-sc
--
Sean
without using that data to extract more bits from the
pg_catalogs. If they know how to go through the catalogs, why do they
need \dn to display the temp schemas?).
As always, --Sean
--
Sean Chittenden
---(end of broadcast)---
TIP 9
are currently connected to...
For the record and if Tom was referring to me, the example I gave was
to have \dn show all schemas that you have any permissions for, not
that were in the search path. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 2
,
completion_squery-namespace);
--
Sean Chittenden
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
(),
+ ACL_CREATE);
if (aclresult != ACLCHECK_OK)
aclcheck_error(aclresult, ACL_KIND_NAMESPACE,
get_namespace_name(namespaceId));
--
Sean Chittenden
---(end
);
--
Sean Chittenden
---(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
: %s(%s),
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
(MyDatabaseId, GetUserId(),
ACL_CREATE_TEMP) !=
ACLCHECK_OK)
ereport(ERROR,
(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
--
Sean Chittenden
---(end of broadcast
:32 2004
@@ -0,0 +1 @@
+libpq.so.3.2
--- /dev/null Wed May 26 13:09:20 2004
+++ src/port/.cvsignore Wed May 26 13:10:07 2004
@@ -0,0 +1 @@
+pg_config_paths.h
--- /dev/null Wed May 26 13:10:46 2004
+++ src/timezone/.cvsignore Wed May 26 13:10:49 2004
@@ -0,0 +1 @@
+zic
--
Sean Chittenden
)] | (6,6)
==
--
Sean Chittenden
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
by isspace() */
/* postmaster version ident string */
#define PM_VERSIONSTR postmaster (PostgreSQL) PG_VERSION \n
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
and you can do such weirdness
(brokeness?) as:
bool val = false;
if (val == 0) { /* blah */ }
Anyway, with Qt, it converts bool values to integers. I think Qt's
probably right on this front in that the value 1 should be considered
true and 0 should be considered false. My $0.02. -sc
--
Sean
whether the result
--
Sean Chittenden
---(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
out of time to find a
better way to do this. Were you hinting at extending libpq(3) to
having the backend send the errcode to the frontend? -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives
) add getting the raw
errcode as an 8.1 TODO item? In the mean time, are you going to commit
the pg_ctl patch? -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
).
System catalog bumps have been coming through with some degree of
regularity so I wasn't worried about providing the patch to bump the
catalog date. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 7: don't forget to increase your free space map
boolean: \%s\, b)));
-
- /* not reached */
- PG_RETURN_BOOL(false);
+ PG_RETURN_BOOL(true);
}
/*
--
Sean Chittenden
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
);
if (options.action_string) /* -f - was used */
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
) -lpostgres
DLLINIT = $(top_builddir)/src/utils/dllinit.o
AROPT = crs
--
Sean Chittenden
---(end of broadcast)---
TIP 8: explain analyze is your friend
. :( -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
29 matches
Mail list logo