Thanx for tip, Tom. I'll definitely give that a try in my spare time.
Cheers,
Kevin
Tom Lane wrote:
Kevin Neufeld <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
A superuser can create whatever he wants in pg_catalog. Whether this
is a good idea or will behave smoothly is a topic t
Tom Lane wrote:
A superuser can create whatever he wants in pg_catalog. Whether this
is a good idea or will behave smoothly is a topic that has not been
thought about, to my knowledge.
regards, tom lane
Sorry, Tom. I think you are mistaken. In my 8.3 instance, system
catalo
Really? I didn't know that ... guess I never tried. I'll have to do
some experimenting! Thanx Tom.
-- Kevin
Tom Lane wrote:
Kevin Neufeld <[EMAIL PROTECTED]> writes:
This might seem like a silly question, but what are the implications of
PostgreSQL allowing developers
This might seem like a silly question, but what are the implications of
PostgreSQL allowing developers to create custom catalogs?
For example, PostgreSQL currently uses the pg_catalog schema to store
system catalogs / relations / functions / etc. Has thought gone into
extending the scope to a
Hi Fernando,
I ran into something similar ... with hard-coded queries in a function
that ends up getting cached. My solution was to store the referenced
table in a variable and, as you suggested, use EXECUTE to dynamically
build up and run the query.
Cheers,
Kevin
Fernando Moreno wrote:
2
A wish-list feature for me is for postgresql to keep a record of a table
creation date and modified date. This could be added to the '\dt+'
shortcut.
I have well over 100 tables and I find I'm always asking myself when
certain tables were created. I realize I could always look at the
relfil
> > Does anyone know how to adjust the IPC settings in Windows?
There aren't any such settings in Windows, AFAIK.
Correct. The only real adjustable limit is the size of the Windows
pagefile, but that one is normally dynamic.
[Lee Keel]
What if the page file exceeds the sh
That makes sense, thanx.
Another individual was having problems adjusting the shared_memory
settings higher than 1.2GB on a 8GB 64bit machine running Vista.
Whenever he would adjust higher than that, the postgresql service
wouldn't start throwing some kind of error. In linux, one would simpl
Does anyone know how to adjust the IPC settings in Windows?
If I wanted to increase shared_buffers settings, in linux I would simply
adjust the SHMMAX and SHMMIN settings, following the docs
(http://www.postgresql.org/docs/8.2/static/kernel-resources.html#SYSVIPC).
In Windows, ?
Cheers,
ibe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7
Phone: (250) 383-3022
Email: [EMAIL PROTECTED]
---
GRANT SELECT ON ' || schemaname || '.' || tablename || ' TO d;'
from pg_tables where schemaname = 'abcs';
-- stop writing to script file.
/o
-- run your script
/i script.sql
You can create a cron job that will do these sequence of commands
nightly if you wis
le).
I traced the error to the gistUserPicksplit
function in the
gistsplit.c ... I surmise that this method is called whenever a page
split is necessary.
So, I know when this error occurs, but I don't know why.
Thoughts anyone?
Cheers,
Kevin
--
Kevin Neufeld
Software Developer
Refr
12 matches
Mail list logo