I noticed a lot of people gave some good advice, but one thing they forgot
to mention is the AddSlashes command of php. It basically does all the
necessary special-character escaping for you, so the worst thing someone
can do by enterring bad data in your forms is bring up a page with bad
res
I can't seem to figure out how to back up the large ogjects I have in my
DB.
Here's the situation:
I insert a large object (via PHP) into my DB. I also insert a record
into a table that uses the OID of the LO I inserted. I later expect to
pull the record out of the table, get the OID I stored
Tom Lane and I will be speaking at the Open Source Database Summit,
October 30 and 31, in San Jose, California.
There will be representatives there from the other open-source databases
too. The URL is:
http://www.osdn.com/conf/osd/conf_index.shtml
--
Bruce Momjian
"Kevin O'Gorman" <[EMAIL PROTECTED]> writes:
> But I cannot seem to get two selects in the same rule.
> So the question becomes: is this a bug or a feature?
The writer of the grammar seemed to think it was a feature, because
the productions for CREATE RULE go out of their way to prevent it.
I do
Neil Conway <[EMAIL PROTECTED]> writes:
> I would expect the rule it cause a bit of overhead (maybe
> taking twice or three times as long as w/o the rule), but
> it's taking ~52x longer.
Ouch.
> I've tried creating an index on messages.poster, but it has
> no effect (performance is the same). I
Travis Bauer <[EMAIL PROTECTED]> wrote:
> When you compiles php, did you ./configure with --with-pgsql? If you did
> not compile php explicitly telling it to includ pgsql support, it probably
> didn't.
Yes I did, and postgresql is installed in the default location. Notice that
the pg_connect fr
Larry Rosenman <[EMAIL PROTECTED]> wrote:
> And, is the postmaster started with -i?
Yup.
Larry Rosenman <[EMAIL PROTECTED]> wrote:
> And, is the postmaster started with -i?
Yup
I'm trying to understand rules, because I'm about to use them
heavily in some research I'm doing on query optimization.
It seems a natural.
I've notices what looks like an anomaly. I can define a rule
with two delete commands like this:
> CREATE RULE rule1 AS ON delete TO dummy DO INSTEAD
>
Philip Hallstrom <[EMAIL PROTECTED]> writes:
> larger than the builtin limit for tuples. Is there anything I should be
> aware of before changing the below value and recompiling?
Only that it will force an initdb. Note the 32k limit, too.
A trick you can use in 7.0.* to squeeze out a little mo
Tom Walta <[EMAIL PROTECTED]> writes:
> "ERROR: fmgr_info: Cache lookup for language failed 18977"
Did you perchance drop and recreate the plpgsql language when
you already had functions defined in the language? The system
will let you do that :-(, but then the old functions refer to
a language
mark <[EMAIL PROTECTED]> writes:
> I noticed that a large number of log notice messages announcing a
> deadlock being detected together with transactions being aborted
> The tables impacted in the benchmark had HASH indexes. ( only = scans
> were being performed, it seemed a good idea at the tim
And, is the postmaster started with -i?
* Travis Bauer <[EMAIL PROTECTED]> [001018 13:49]:
>
> When you compiles php, did you ./configure with --with-pgsql? If you did
> not compile php explicitly telling it to includ pgsql support, it probably
> didn't.
>
> Travis
>
> Brian Edginton ([EMAIL P
Hi,
I have been experimenting with the Apache Benchmarking Tool ( ab ) to
give my demo web site a bit of a hiding. The database backend is
Postgresql 7.1 ( dev from 25/09/00) .
I noticed that a large number of log notice messages announcing a
deadlock being detected together with transactions b
On Wed, Oct 18, 2000 at 03:11:12PM -0700, Nate Lawson wrote:
> In MySQL, I can get a hash of a VARCHAR by using the PASSWORD('') call. I
> know for DB admin there is pg_passwd, but is there a function interface so
> that I can get password hashes of arbitrary strings in SQL? (Note that I
> mean c
hi all,
where can I find info about the function to_char
TIA
--Yohans
~~~
Yohans Mendoza System Analyst
[EMAIL PROTECTED]Sirius Images Inc.
http://www.sir
In MySQL, I can get a hash of a VARCHAR by using the PASSWORD('') call. I
know for DB admin there is pg_passwd, but is there a function interface so
that I can get password hashes of arbitrary strings in SQL? (Note that I
mean crypto hashes like MD5 and hopefully compatible with the hashes used
f
On Wed, Oct 18, 2000 at 02:46:36PM -0700, Philip Hallstrom wrote:
> I'm thinking about using postgres for an app that will store
> various email messages which might (although probably not likely) be
> larger than the builtin limit for tuples. Is there anything I should be
> aware of before
Hi -
I'm thinking about using postgres for an app that will store
various email messages which might (although probably not likely) be
larger than the builtin limit for tuples. Is there anything I should be
aware of before changing the below value and recompiling?
Also, it looks like the
In testing my database, I've encountered what appears to be a
concerning performance problem using a rule (ON INSERT). Here's
the situation:
Every time a row is inserted into a table (called 'messages'), I want
to increment a counter in a different table (called 'users'). The
best way I could thi
I entered the following to load plpgsql:
"$createlang -L/usr/lib/pgsql plpgsql testdb"
postgresql appeared to have no problem with it. A
subsequent "$createlang -l -dtestdb" showed plpgsql as
being a trusted procedural language. But whenever I
attempt to use it in a function I get the following
e
I don't think that is it. It has been a while, but I thought if you didn't
compile php with psql, it returned an "undefined function" error.
By the way... I just found out a little bit ago that the pgsql-php list is
still alive. :)
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
-
Guys -
We are about to start a large for us project that has some pretty
complicated requirements. First of all, we have to have real time
synchronization/replication. Second of all, we are in a hub and spoke setup
where each spoke will need to replicate everything it knows about to the
hub, b
Bruce Momjian wrote:
>
> Let me ask. Could people who need to be up all the time dump their
> data, install PostgreSQL on another machine, load that in, then quickly
> copy the new version to the live machine and restart. Seems like
> downtime would be minimal.
>
Rsync to mirror a node first a
When you compiles php, did you ./configure with --with-pgsql? If you did
not compile php explicitly telling it to includ pgsql support, it probably
didn't.
Travis
Brian Edginton ([EMAIL PROTECTED]) wrote:
>
>
> I'm trying to use the php/postgresql interface via my apache server.
> When I tr
On Tue, Oct 17, 2000 at 11:58:50AM -0400, Tom Lane wrote:
> Victor Ivanov <[EMAIL PROTECTED]> writes:
> > I'm using PostgreSQL 7.0.2 and I'm trying to create my own types with
> > input and output functions in C. Everything works fine, but when the input
> > is invalid and the function returns NUL
You need to use the createlang script to enable the
procedural languages you wish to use.
I believe it's createlang
> db'# physionetdb'# physionetdb'# ERROR: Unrecognized language specified in
> a CREATE FUNCTION: 'pltcl'. Recognized languages are sql, C, internal
> and the created p
On Wed, Oct 18, 2000 at 06:18:07PM +0200, Peter Eisentraut wrote:
> > - Any other limitation I don't achieve to view?.
>
> Nope, this is really a relatively standard thing. The oid column isn't
> special as compared to other columns, aside from the fact that it is
> automatically created.
Hello,
I want to apologize in advance if I sent this to the wrong mailing list.
I'm was trying out the example functions using TCL, but for function
was not created. Here's the error:
db=# CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS '
if {$1 > $2} {return $1}
return $2
' LANG
DaVinci writes:
> Can I use OIDs for joins between tables without losing functionality?
Sure.
> The problems I am afraid of are:
>
> - pg_dump/psql: Can I recover OIDs from security copies?.
pg_dump -o
> - Indexes: joins between tables linked with OIDs use indexes from
>
chris markiewicz writes:
> Sorry, too many clients already
>
> hello. i am getting the above message when i try to connect. where do i
> find documentation about connection management?
man postmaster, -N option
> i want to be able to see all current connections and kill some of
> them. how
"Jarmo Paavilainen" <[EMAIL PROTECTED]> writes:
> Well thats the point. Why do I need to allocate one extra space for the
> string (the first one allready allocate space for the NULL). While the
> second example allocates one char too much.
The given fragment of code clearly isn't overwriting any
Sorry, too many clients already
hello. i am getting the above message when i try to connect. where do i
find documentation about connection management? i want to be able to see
all current connections and kill some of them. how do i do that?
thanks
chris
33 matches
Mail list logo
