On Jul 30, 2005, at 2:30 PM, Jon Christian Ottersen wrote:We are trying to find a good way to document our database design – what is the rationale behind each table/field, what kind of information is each field supposed to contain, perhaps also something about the linking between the tables etc.
Depending on how your version of PG was built, there will probably be
hardly any difference in speed as far as the CPU is concerned as the
FPU should be happy with both, and I think MMX/MMX2/SSE/SSE2/3dNow!
have some relevant optimisations for that sort of thing as well. You
will be
Dann Corbit wrote:
There is a privacy hole from using the MAC address. (Read it in the
WIKI article someone else posted).
Probably, it would be better to use a one way hash of the MAC address.
The chances of MAC addresses colliding (through some low-end network
card vendor's sloppy
Hi
Im running postgres on OS X 10.4.2. Im having a problem starting
postgres though... but its maybe something dumb im doing...
So i su -l postgres and cd to my /opt/local/bin where postmaster is...
But i always get a:
-su: postmaster: command not found
Its there. Anyone know what im doing
Hi!
I'm using dblink with some DBs and i'm having a few problems, more
precisely with the dblink_current_query() function.
First I create the following views on a DB:
- create or replace view users as
select *
from dblink('hostaddr=127.0.0.1 dbname=teste user=postgres
I use a combination of the gnome-based diagraming application Dia (http://www.gnome.org/projects/dia/) and the tedia2sql diagram-to-DDL SQL translation script, which is written in Perl (http://tedia2sql.tigris.org/).It's a bit awkward, but: 1) Dia is a wonderful, open source diagramming tool I
Hi,
I'm looking to solve a problem where a client application is leaving
idle sessions open, eventually filling up the maximum connections and
stopping anyone from connecting.
It seems like there's no way to disconnect sessions after a given idle
timeout. There is a statement timeout, but that
eoghan [EMAIL PROTECTED] writes:
Im running postgres on OS X 10.4.2. Im having a problem starting
postgres though... but its maybe something dumb im doing...
So i su -l postgres and cd to my /opt/local/bin where postmaster is...
But i always get a:
-su: postmaster: command not found
Its
Joao Afonso [EMAIL PROTECTED] writes:
So (finally), my question is why does this happen? Using instead on
the users_util insert rule shouldn't discard the original query and
rewrite it according to the specified on the rule?? Is this a problem
of dblink?
I hadn't noticed the
Hi;
I have just posted a MySQL to PostgreSQL migration guide at
http://www.metatrontech.com/wpapers and it is free for pretty much any
use (I do have a somewhat toned-down advertising clause in the copyright
license).
It is a first draft and formatting and other stuff will be likely
10 matches
Mail list logo