full.
I use 'archive_timeout = 300' to send it every 5 minutes. If the lag is greater
than 15 minutes, the alarm bells start going off.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d be on my side but I can’t
> find anything on my code that doesn’t match the manual.
I have written something like this recently without any problems. Maybe post
the code if you think more eyes would be helpful.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general
ase abstraction layer works for the most part. The main benefit of Drupal
is to get a base website up and going quickly. You can then write your own
custom (Postgres only) module to implement the non-core features you need.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
re immediately
written to the download stream so there is no need to have the entire document
in RAM on the application side. I have included the function I use below.
John DeSoi, Ph.D.
create or replace function blob_content_chunked(p_dbid integer)
returns setof bytea as $$
declare
v_chunk i
site for user access. Using Postgres has made this easy to
manage and verify. And with replication we automatically have the document
database available on the backup web server without additional effort.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
without seeing the exact code you are using to
insert and the exact error message you are seeing.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.drupal.org/project/ubercart
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uld just need one function.
https://www.postgresql.org/docs/current/static/event-trigger-definition.html
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> practice).
Maybe create an event trigger that updates a simple table with the last
modification time or sends a notification?
https://www.postgresql.org/docs/current/static/sql-createeventtrigger.html
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
TREAM*. Not sure what is going on, will do some
> more digging later.
See
https://github.com/dimitri/pgloader/issues/296
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
too
many problems. Since version 7 all of Drupal core works with PostgreSQL and I
have encountered very few non-core modules that are MySQL specific. SQLite is
also a core-supported database for Drupal.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
amp; source /var/lib/pgsql/.pgsql_profile
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to fix them for Postgres import.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-count solutions.
For some discussion and preliminary design, see also
https://wiki.postgresql.org/wiki/HTTP_API
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I did not write the spec, so you'll have to post to the wiki to ask questions.
Just thought it might be relevant for anyone interested in this topic.
Best,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
is always executed to completion,
and the row count is ignored. The possible responses to Execute are the same
as those described above for queries issued via simple query protocol, except
that Execute doesn't cause ReadyForQuery or RowDescription to be issued.
John DeSoi, Ph.D.
--
Sent via pgsql
queries. I think it
would be helpful for pg_standby to emit a warning if primary_conninfo is set it
the recovery.conf.
I changed the restore command to use cp and now everything appears to be
working as expected.
Thanks very much for your help and to everyone who offered suggestions.
John
DEBUG: got WAL segment from archive
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and have verified the replication user
can connect to the primary.
Am I missing something obvious? Do I have to back up the primary again to make
this change?
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
there. But even if I did not, I
would expect to see a connection error in the log on the standby. No error or
any indication the streaming replication process is running on the standby.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
there. But even if I did not, I
would expect to see a connection error in the log on the standby. No error or
any indication the streaming replication process is running on the standby.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
of network hang and then rsync would just wait forever and never
return.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I was surprised to discover this today. I can work around it, but it seems
counterintuitive. If 5 can't be parsed as a smallint, I would feel better if
'5' was not one either.
John DeSoi, Ph.D.
psql (9.2.4)
Type help for help.
temp=# create or replace function itest (param smallint) returns
; hopefully this will fix it.
John DeSoi, Ph.D.
2013-07-08 21:06:02 EDT [27170]: [1-1]
user=main,db=main8,remote=127.0.0.1(62194) FATAL: the database system is
shutting down
2013-07-08 21:07:29 EDT [27189]: [1-1]
user=postgres,db=postgres,remote=127.0.0.1(62195) FATAL: the database system
problems for about 12
hours. Then it just stopped and I don't see any errors in the Postgres log
(primary or standby). I looked at other system logs and still don't see any
problems.
I'm running Postgres 9.2.4 on CentOS 6.4. Thanks for any ideas or debug
suggestions.
John DeSoi, Ph.D
disabling SELinux)?
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) messaged followed by describe (D), you can get a
row description for the return type without executing anything.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Javascript/Ace:
https://github.com/desoi/ace
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
monster package.
Does anyone know of such a beast? TIA for any help provided.
Not stand alone, but the phpPgAdmin project colors SQL/PostgreSQL code and I
believe the license is GPL.
http://phppgadmin.sourceforge.net/doku.php?id=start
John DeSoi, Ph.D.
--
Sent via pgsql-general
,
or I'll need to restart Slave PostgreSQL to put it in sync again?
If I restart Slave PostgreSQL, I get:
Yes, it automatically catches up when the connection is working again. You
should not have to restart the slave.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general
/professional_support_northamerica
Best,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.postgresql.org/docs/current/static/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://ajaxian.com/archives/tcpsocket-sockets-in-the-browser
http://www.postgresql.org/docs/9.0/interactive/protocol.html
I'm not saying this is the right approach, but if that is what you are really
after...
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
from overwriting
files, but I don't see any options for generating an error if the file exists.
Anyone care to share a method or script for handling this correctly with rsync
or some other common utility?
Thanks!
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general
/audit-trail table.
Is there some way to loop the fields of a trigger's Record? I've read other
people's frustration at not being able to get an array of fields from the
Record.
This might help you:
http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers
John DeSoi, Ph.D.
--
Sent via
, the function below can be altered to easily enable or disable them.
John DeSoi, Ph.D.
=
create or replace function enable_link_clean_triggers(p_enable boolean)
returns void as $$
declare
v_action text;
v_sql text;
v_tg record;
begin
if p_enable
is linked to PHP should work just fine with Postgres 9.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nice looking native iPad/iPhone apps with the
ability to perform ad-hoc queries using PostgreSQL.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
google
ipad postgresql you'll see DataGlass on the first page of the results. I'm
sure you'll also find some with a search in the app store.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
a problem replicating my
production environments whether in Solaris or Linux.
It does not blow anything away as far as I can tell :).
Yes, I tried MacPorts. I seemed get caught in some kind of dependency hell and
could not get things to update correctly.
John DeSoi, Ph.D.
--
Sent via pgsql
FOUNTAINS OF ROME
FOUNTAINS OF ROME A/K/A FONTANE DI ROMA
Trigrams can be indexed, so it is relatively fast to find an initial set of
candidates.
There is a nice introductory article here:
http://www.postgresonline.com/journal/categories/59-pgtrgm
John DeSoi, Ph.D.
--
Sent via pgsql-general
are working on PL/Parrot. I'd really like to have PHP and
Lisp for PL languages :).
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
this? I have a reseller account and I have created many
triggers using pl/pgsql. Are you wanting to create triggers with C or some
other language that requires superuser access?
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
have access via phpPgAdmin which can create functions and
triggers. Your account user owns the databases you create, so I don't see how
they can prevent you from creating triggers.
They have a 30 day money back guarantee, so it might be worth trying out.
John DeSoi, Ph.D.
--
Sent via
. But if you need to create triggers with SQL or pl/pgsql,
that should not be a problem.
Of course, many offer VPS hosting where you could setup Postgres yourself and
configure it any way you like.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
an account with HostNine.com, but PostgreSQL version is 8.1 and
don't allow triggers... I must to change host, the web app is using
triggers...
Anyone know a host that have triggers available?
Best Regards,
On Sun, Feb 14, 2010 at 3:34 PM, John DeSoi de...@pgedit.com wrote:
On Feb 13
like support was dropped a few months
ago. Hopefully some one else will pick it up.
http://sourceforge.net/projects/lingon/
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
- it really helped me to
look at the psql source.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on the connection stream to receive the responses.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
write and read. You get the safety
of parameterized execution and you don't have a prepared statement to dispose
of in another operation.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
-byte p stream)
(write-int32 (+ int32-length (length name) 1 (length sql-string) 1 int16-length
(* int32-length param-count)) stream)
(write-cstring name stream)
(write-cstring sql-string stream)
(write-int16 param-count stream)
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list
to an older shared server. I know they
used to have contrib tsearch installed with older versions.
http://www.a2hosting.com/services/web-hosting/
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
, or
(depending on your platform) there is probably some easy port forwarding trick
where you can have one cluster but two possible ports. Installing two clusters
means running initdb for two different directories and configuring them for
different ports.
John DeSoi, Ph.D.
--
Sent via pgsql-general
when
the user or database name has non-ascii characters. The client
encoding is not established until after authentication.
I asked about that a while ago but did not get any responses.
http://archives.postgresql.org/pgsql-general/2008-12/msg00808.php
John DeSoi, Ph.D.
--
Sent via
cursor but still have the first 1000 rows for
immediate display to the end user.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to test this out is to call pg_sleep with a big number and
then cancel the query on another connection. You won't have to worry
about the timing of receiving all rows or not.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
a massive result set or somehow parsing the query to add a
limit clause.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
protocol has changed since version
7.4. All data can be in text format; you don't have to deal with binary.
I have implemented an interface in Lisp. I found it much easier and
more flexible than the foreign function interface with C and libpq.
John DeSoi, Ph.D.
--
Sent via pgsql-general
above, but replace the first line with:
CREATE OR REPLACE FUNCTION f_active_client(character varying)
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Sort Method: quicksort Memory: 297kB
- Function Scan on cursor_pk_order c
(cost=0.00..260.00 rows=1000 width=8) (actual time=12.672..13.073
rows=4308 loops=1)
Total runtime: 51.886 ms
Thanks for any further suggestions.
John DeSoi, Ph.D.
--
Sent via pgsql-general
.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it should be easy, but I'm not seeing it.
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:
http://www.postgresql.org/docs/8.3/static/protocol-message-formats.html
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. For example, instead of
using int in CREATE TYPE above, create a your own type equivalent to
an integer.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, or
composite type. So maybe you could define a composite type and stuff
those into a single array?
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
making
this change?
pg_ctl reload -D /path/to/your/data
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that ensures there is foo_audit for
table foo?
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
enough using to_hex.
Thanks for any suggestions,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) + (b2 16) + (b3 8) + b4;
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of the text, try
select to_tsvector('simple', 'claude Jones');
to_tsvector
--
'jones':2 'claude':1
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
, at no cost?
You can use PostgreSQL legally at no cost. There is no requirement to
purchase any kind of license for commercial (or non-commercial)
purposes.
John DeSoi, Ph.D.
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
add a new table, sequence, schema...
There is some pl/pgsql code here grant on more than one object at a
time:
http://pgedit.com/tip/postgresql/access_control_functions
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
declare and assign the value in a single line in the
DECLARE section of the function, e.g.
text_var text := text_param;
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
or detecting DDL changes.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
an encoding?
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
they completely abstracted the schema building API. Previously,
MySQL and PostgreSQL had to be specified separately which is the main
reason a lot of modules did not work with PostgreSQL. Things should
improve as modules are upgraded to Drupal 6.
John DeSoi, Ph.D.
--
Sent via pgsql
MySQL to
PostgreSQL because of MyISAM data corruption and InnoDB was too slow.
http://groups.drupal.org/node/15793
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
``,
e.g.
= \echo `date`
Wed Sep 10 08:07:19 EDT 2008
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Aug 2, 2008, at 7:13 PM, Manoj Patwardhan wrote:
bash-3.2$ initdb -D /usr/local/pgsql/data
dyld: Library not loaded: /usr/local/pgsql/lib/libpq.4.dylib
Referenced from: /usr/local/bin/initdb
Reason: image not found
Trace/BPT trap
Any ideas? This is on Mac OS 10.5.4. What I see in
the default value of zero. But if you
include NULL in your insert list -- you'll get NULL, not zero. If
nothing is included for the column in your insert list, you'll get the
column default if it has one, otherwise NULL.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql
@executable_path/../lib/libpq.dylib psql
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to change '/' to be treated like '-' ? I've
looked over the documentation several times and could not find
anything. Even just a way to get the two tokens 'home' and 'work'
without the joined form would be helpful.
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql
number of messages to search.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is really broken (invalid sequences no mater how it is
encoded) then you'll need to fix that first.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
if PostgreSQL had some kind of unique reference for
the column, but I think columns are just numbered sequentially as they
are added. It would also be neat to have a built-in way to log the
schema changes.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
back. Correct?
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
was using the execute because I had a variable called the same as
a field, not good, I changed it.
So now it's working perfectly!!!
You don't need SELECT at all:
INSERT INTO demo_tab VALUES (demo_tab_row.*);
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general
to build a binary that will run on
10.3 and I don't think it has /usr/lib/libgcc.
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
disk, but it's not installed
by default.
OK, so it is really and XCode issue and nothing that changed with 8.3.
Thanks,
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
the schema below and a simple prepared statement API (http://pgedit.com/resource/php/pgfuncall
), I can insert/load documents with a single line like:
$db-blob_insert($content);
$content = $db-blob_content($this-object_ref);
John DeSoi, Ph.D.
--
-- blobs
--
create table blob (
dbid
On Feb 2, 2008, at 9:40 PM, Brian A. Seklecki (Mobile) wrote:
On Thu, 2008-01-24 at 13:10 -0500, John DeSoi wrote:
. The user/login system is extensible, so you could write your own.
I'm not sure if I follow:
Are you suggestion that the CMS system, Drupal, is an example of an
application
is extensible, so you could write your own.
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
problems.
http://www.entropy.ch/software/macosx/php/
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
. Korry posted
a more detailed example here (which was to be added to the readme file):
http://archives.postgresql.org/pgsql-hackers/2007-09/msg00241.php
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 5: don't forget to increase your free
Mac
application.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
create your function using the SECURITY
DEFINER option?
http://www.postgresql.org/docs/8.2/interactive/sql-createfunction.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched
1 - 100 of 312 matches
Mail list logo