0' 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
> 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@postgresql.org)
To ma
database 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
he 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 integer = 1048576;
v_start
ebsite 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)
To
ng 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
> On Nov 8, 2016, at 8:46 AM, Michelle Konzack wrote:
>
> Can someone recommend me a shop system which met my requirements?
Drupal with Ubercart? Probably does not qualify as "simple" but should be able
to do everything you listed.
https://www.drupal.org/project/ubercar
ostgresql.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
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.org)
To make changes to your subs
n, 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
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 make changes to your s
e ] && 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
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
e
> URLs like
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 ch
-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
ws"). The
> result-row count is only meaningful for portals containing commands that
> return row sets; in other cases the command is always executed to completion,
> and the row count is ignored. The possible responses to Execute are the same
> as those described above for qu
connect to it and make read-only 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
ed shared memory configuration values
LOG: consistent recovery state reached at 10F/300
LOG: database system is ready to accept read only connections
LOG: restored log file "0001010F0003" from archive
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
ry, right? Yes, I have one 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@postgre
ry, right? Yes, I have one 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@postgre
ackup %r'
I have a ssh tunnel setup on localhost 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
on master or slave.
It appears I solved it by adding --timeout=30 to my rsync command. My guess was
some kind 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 funct
and; 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.
J
rk. There must be more required related to
ssh and/or rsync. Anyone solved this (without just 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
parse" (P) 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
://github.com/desoi/pgedit-textmate
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
ode, rather than having to
> embed some 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 D
e connection is reestablished,
> 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 pgsq
.org/support/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-message-formats.html
See this section to understand the role of the Sync message:
http://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
d talk directly to Postgres from the browser:
http://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
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-ge
ield. If different I want to log both values in a
> history/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:
ggers have some simple way of identifying them in a query on
pg_trigger, 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_s
version 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
ent on my Macs and I've never had 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
used any of them. But if you 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@postgresq
w-leopard-and-php/
There also seems to be some 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
wo song titles:
FONTAINE DI ROMA AKA 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
Jo
ks 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
access to your
databases. You also 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.
you hear 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 change
> I have sign 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, 20
ind any that will let
you create languages. 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 l
x27;ve used this in the past but it looks 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 subs
quot;portal xxx does not exist"
I send:
parse
bind
describe
execute
sync
and then loop 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
gt; How I can get those 1000 rows ?
Are you using a named portal? Are you reading all responses until you receive a
ready for query response? There are a lot of details - 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
ld and execute with a single network 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 c
t, but maybe this will help:
(write-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
about $5/month. If you really need an older version, they
might be willing to add your account 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 ma
ers and databases. So yes, you will have to install two clusters, 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
at happens 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.
-
An easy way 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
side 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
ckend 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 pgs
worry about
processing 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
it?
Write it exactly as you have 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
_ctl start -D /usr/local/pgsql/
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
1)
-> Sort (cost=309.83..312.33 rows=1000 width=8) (actual
time=15.420..15.946 rows=4308 loops=1)
Sort Key: c.pk
Sort Method: quicksort Memory: 297kB
-> Function Scan on cursor_pk_order c
(cost=0.00..260.00 rows=1000 width=8) (actual time=12.67
Thanks for the suggestion.
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
ooking at the column type. 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
tails:
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
built-in or user-defined base type, enum type, 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
re 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
b4 = get_byte(p_array, i);
val = (b1 << 24) + (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
ea
seems easy 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
separately from the rest 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 chan
mercial purpose,
legally, 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 yo
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
tion.
Note that you can 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.post
when comparing schemas 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
blished 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
e
parsing the text.
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
pg_dump.
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 /usr/lo
ng DEFAULT in
your insert list will give you 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 DeS
@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
-work':1
which is much more desirable for this application.
Is there an easy way 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 '
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
e file.
If the dbf file 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
ransaction is rolled 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
ould be nice 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@pos
the Xcode 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
e build? I want 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
I 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
Using 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
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
applic
ject/Modules
. The user/login system 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
rk without
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 d
. 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
pical 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 316 matches
Mail list logo
