"Kendall Koning" <[EMAIL PROTECTED]> writes:
> Postgres doesn't seem to make use of indexes when doing operations with the
> CIDR '<<' (contains) operator.
You're right --- the system has no idea that the '<<' operator has any
relationship to the sort ordering of CIDR indexes.
Seems like it'd be
[EMAIL PROTECTED] (Wade D. Oberpriller) writes:
> I was wondering if PostgreSQL protects itself when executing user-defined
> functions?
User-written functions coded in C are insecure by definition; it's up
to you to get them right. The other available programming languages
are considerably safe
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> Now I'm pretty confused (as I'm sure others are) -- can someone that knows
> beyond a reasonable doubt beat us with a clue stick on this? Are we taking
> a huge risk if we use -F and disable fsync() or no?
Postgres will write() modified pages out to
This sequence of events seems to break something.
1) Create table foo
2) create table bar
3) create view foobar linking the two tables.
4) drop table foo
5) Create table foo (identical to first table)
6) SELECT from view foobar.
step six causes a relation not found error.
Is this a bug? As long
Greetings!
Why I have got the message during installation postgrsql 7.0.2:
utils/SUBSYS.o : In function 'load_file':
utils/SUBSYS.o (text+0*3465d): undefined reference to 'dlclose'
make: *** Error 1.
There is the file dlfcn.h in /usr/include. Nina.
Postgres doesn't seem to make use of indexes when doing operations with the
CIDR '<<' (contains) operator. Is this intended behavior or impossible for
some reason?
test=> \d a
Table "a"
Attribute | Type | Modifier
---+--+--
a | cidr | not null
Index: a_pk
Hello all,
I was wondering if PostgreSQL protects itself when executing user-defined
functions? Or does it go under the assumption that all user-defined functions
will NOT crash (if they do you have a serious problem and need to fix the
function)?
We are building an app where we want 3rd partie
When I used postgres on linux, I found the following happened when the
system failed in the middle of transactions:
* ext2 + fsync: file system screwed-up, db OK
* ext2 - fsync: much faster than above, file system screwed-up, db needed to
be restored sometimes
* reiserfs + fsync: as fast as ext2
Hmm, it seems we all know just enough to be dangerous :-)
I have seen many threads on the "to fsync() or not to fsync()" and
overwhelmingly people have come out and said that to not fsync() is A Bad
Thing(TM). -- If Neil is right then it being bad or not is going to depend
very much on the files
On Wed, Oct 04, 2000 at 02:09:47PM -0400, Mike Biamonte wrote:
> I understand from the docs that -F ".. prevents fsync()'s from
> flushing to disk after every transaction.." and that this boosts
> performance because RAM accesses are far faster than disk accesses. I
> have also seen some impressi
On Wed, 4 Oct 2000, Mitch Vincent wrote:
> That's what it does when -F is *not* used, right? -F disables calling
> fsync() after each transaction, right?..
Yes, sorry - when -F is _not_ used, fsync() _is_ called after each
transaction - when -F _is_ used, fsync() is _not_ called.
Sorry for the
> > 1. How often DOES PG flush to disk - if at all - when the -F option is
> > invoked? Can this be controllled?
>
> Once after each transaction.
That's what it does when -F is *not* used, right? -F disables calling
fsync() after each transaction, right?..
-Mitch
On Wed, 4 Oct 2000, Mike Biamonte wrote:
> I understand from the docs that -F ".. prevents fsync()'s from
> flushing to disk after every transaction.." and that this boosts
> performance because RAM accesses are far faster than disk accesses. I
> have also seen some impressive stats regarding th
Hi,
Is it possible to run VACUUM ANALYZE while other backends are running,
or should I shutdown them before vacuuming?
Regards,
Mikhail
I would be grateful if someone could help me understand exactly how
the -F option changes Postgres' behaviour. I am trying to tweak the
speed at which it operates:
I understand from the docs that -F ".. prevents fsync()'s from
flushing to disk after every transaction.." and that this boosts
pe
The consensu from the FreeBSD -STABLE lists are that SOFTUPDATES helps
ANY UFS FileSystem, and makes it MORE robust because of the logging
and the way FSCK works.
I've turned SOFTUPDATES on all my FS's on 4.1.1-STABLE.
Larry
* The Hermit Hacker <[EMAIL PROTECTED]> [000926 10:32]:
>
> I've b
On Wed, 4 Oct 2000, Philip Warner wrote:
> >The other part could probably be done by creating after
> >insert/update/delete triggers on those tables with the oid of
> >the constraint row as data. I'm not sure of the best way to do
> >the actual check... it'd be easy to do in spi, but that has i
Hi guys,
I am trying to put together a web database for a series of pages that
will be in the format of a journal or magazine. I was wondering if you
knew of any urls that discuss the pros and cons of different structures
of implementation. I have an idea, I just want to see if someone has a
bett
You don't :)
Currently you can't drop an column from a table, but I think you can in
version 7.1. So you have to wait to november. In the mean time, just
rename it.
Andrew Gould wrote:
>
> How do you drop a column from a table? I'm using
> PostgreSQL 7.0.2.
>
> Thanks,
>
> Andrew Gould
>
>
On Wed, 4 Oct 2000, Andrew Gould wrote:
> How do you drop a column from a table? I'm using
> PostgreSQL 7.0.2.
>From the FAQ.
4.5) How do you remove a column from a table?
We do not support ALTER TABLE DROP COLUMN, but do this:
SELECT ... -- select all columns but the one you w
Create a new table and select insert from the old one to the new one without
the column of data.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Andrew Gould" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 10:39 AM
S
How do you drop a column from a table? I'm using
PostgreSQL 7.0.2.
Thanks,
Andrew Gould
__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
This has discussed before (I brougt it up) and there was talks of using
the http://openacs.org/ site to do this. But I don't think there has
happened anything on that matter.
I think we should either use the openACS site, or write our own
extension of the manual in PHP.
Poul L. Christiansen
Pet
23 matches
Mail list logo
