mmm, i think this is getting out of hand. I told you on irc that a db
should be more conserned with being a db than a security policy of
people accessing it. It sounds to me like you need to set up your network
different and the security policies around this db(s).
I mean only certian ip's sho
From: "hubert depesz lubaczewski" <[EMAIL PROTECTED]>
> i would like to create c-type trigger which is used with params.
> so i created function:
> CREATE function dfti(text) RETURNS opaque as
> '/home/users/pgdba/work/lib/dfti.so' language 'C';
> o.k. created
> byt when i try to:
> CREATE trigge
From: <[EMAIL PROTECTED]>
> This isn't exactly related to pg but
> I thought some wise person might be able
> to explain.
Sorry - you got me instead ;-)
> i've been storing the number of seconds
> since Dec 31 19:00:00 1969 whenever
> I have to store a time format. For this
> integer type is g
From: "Christian Marschalek" <[EMAIL PROTECTED]>
> Since Oracle's prices are somewhat huge, I'm forced to switch to
PostgreSQL!
> I would have used it from the start, if I just knew of it's existance ;o)
One place Oracle beats PostgreSQL hands down is the size of its marketing
budget.
> Now, I
> On the other hand, the money you save on Oracle licences can be
> spent on bigger iron to run PG - so for non-exotic installations you
> should be able to come out ahead. Certainly if you were thinking of
> Intel hardware I'd expect PG to do well in terms of
> price/performance.
That is exactly
From: "Tom Lane" <[EMAIL PROTECTED]>
> Dan McGrath <[EMAIL PROTECTED]> writes:
> > Any user with access to a database on my system that isnt the
> > owner still has the ability to create tables (and possibly functions,
> > views etc.) with no aparent limits. Is this a design flaw or a bug or
> >
I would like to store some images in my Postgres database. These will
all be thumbnails, limited to 4k or 5k. I know that PG has an 8k row
limit, but this should be fine, because there's not much else in the
row. Which data type could I use to store them, and is there a
performance cost for ha
pgcrypto 0.3 / "why-dont-you-show-some-code" release
http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz
This release is give people something to play with.
Parts of it need further thinking and lots of testing,
but I am tired of sitting on it.
Here follow parts from README to give an idea
I get the followig error although TK is installed
-start
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgaccess'
make[2]: Entering directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh'
gcc -I../../include -I../../backe
Hello!
We just now got around to upgrading our production Postgres server to
7.0.3 (from 6.5.3). I've written up a tips document for people who have
not yet done this. I believe it also contains some tips that may be
generally helpful when dump/restoring Postgres. The document is here:
http:/
Hi Christian,
On Sat, 10 Mar 2001, Christian Marschalek wrote:
> Since Oracle's prices are somewhat huge, I'm forced to switch to PostgreSQL!
> I would have used it from the start, if I just knew of it's existance ;o)
Oracle's prices are through the roof. Its crazy =)
>
> Now, I wonder if Pos
> Ok, if I change to use EUC_TW or UTF-8 encoding, do I need to make any
> changes to my code?
No.
> What do I need to do differently on the web content?
Nothing, I guess.
> Thanks
>
> -Original Message-
> From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 10, 2001
<[EMAIL PROTECTED]> writes:
> I would like to store some images in my Postgres database. These will
> all be thumbnails, limited to 4k or 5k. I know that PG has an 8k row
> limit, but this should be fine, because there's not much else in the
> row. Which data type could I use to store them, and
"Richard Huxton" <[EMAIL PROTECTED]> writes:
> I'm guessing there's a Good Reason (TM) why setting permissions on pg_class
> et al don't seem to work.
Well, I dunno if it's a *good* reason, but none of the low-level
operations on system catalogs pay any attention to permissions on
the catalogs (n
Anybody on the development side care to comment on the 'exotic' features in
the to-do list? Specifically the querying-across databases feature? Way
exotic? Not-so-exotic-but-no-one-has-the-time? Would-have-to-
re-plumb the entire database engine type of exotic?
Portability with 'standard' com
Wel guys, thanks for the advice. I guess my own custom CGI would work, or
something similar. Your help has been greatly apreciated. I was merely trying to
find out if its possible to do it any other way, and you guys have already given
me some stuff to think about. Cheers!
Dan
Lincoln Yeoh wrote
> bytea is probably your best bet. The 8k limit is toast in 7.1, btw.
If you're using JDBC, you may not be able to get bytea types to work. I was
able to get the SQL type OID to work with JDBC's get/setBytes() methods.
You may also want to use 7.1 since I believe it's large object support is
im
HI,all
Is there a win32 version for PSQL, postgresql terminal client program?
JACK
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I am having some performance issues with deletion.
It appears that in deleting records from a table with a significant
number or rows ( in this case 1.3 million ) it takes about 1 hour per
100K rows deleted if deleting more then 400K at a time. This sounds
way to slow to me. If I brea
19 matches
Mail list logo
