rly as big of a performance gain by splitting
your index up.
Take a look at partial indexes (with the WHERE clause).
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createindex.html
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key: http://www.rbt.ca/rbtpub.asc
signatu
Display it grey'd out or something...
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
Spiffy...
--
Rod
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Rod Taylor" <[EMAIL PROTECTED]>; "P. Jourdan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 20
[cross posting to pgadmin-hackers]
That makes sense, except pgAdmin shouldn't try to connect to a
database marked that it doesn't accept connections.
--
Rod
- Original Message -
From: "P. Jourdan" <[EMAIL PROTECTED]>
To: "Rod Taylor" <[EMAIL P
> > I suggest a good replacement would be a simple 'log' mode
> > which writes text based queries to a log file. PGAdmin
> > should be able to play an arbitrary text file against a
> > database connection. This would preserve most of the
> > functionality and should be straight forward to
> > im
Thats fair. The ability to rollback most changes isn't overly useful.
What is useful is the ability to replay commands on another database.
I suggest a good replacement would be a simple 'log' mode which writes
text based queries to a log file. PGAdmin should be able to play an
arbitrary text f
it's used in a ton of places...
Mind you, CASCADE on drop of type OID could be interesting...
--
Rod Taylor
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "'Rod Taylor'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sen
er -- then
again, maybe not.
--
Rod Taylor
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "'Rod Taylor'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "'Frank_Lupo'" <[EMAIL PROTECTED]>
Sent: Friday, A
maybe part of
7.4) to support 7.2 and prior with a 'pg_public' or default namespace.
ie. Pretend a namespace exists for public stuff, as when they upgrade
to 7.3 that would be where it all ends up (I think), so it's somwhat
appropriate.
--
Rod Taylor
Your eyes are weary from sta
Is there anyway that a monospaced font could use used in the
'Definition' tab in the function properties window -- possibly for the
definition pane as well?
It's much easier to format that stuff when all the characters are the
same width.
--
Rod Taylor
Your eyes are weary from
Create a column (default initally empty).
Set default to a valid value.
Setting default back to 'empty' doesn't work. Must set NULL.
While this is fine, it's kinda confusing. Could the interface display
NULL where it's not otherwise set?
--
Rod Taylor
Your eyes
pain in the ass, but technically to allow inline editing one
would need to block on the row anytime someone opened it so synchronous access
would be limited anyway. That or a diff would need to be done against the
original to ensure no change before any write.
--Rod Taylor
This message represents
> > The historical information (RCS) is quite interesting. Is
> > there any chance that the 'Publishing' wizard will be able to
> > publish diffs between the database you're publishing to and
> > the test version(s)? As a step between these, the ability to
> > dump (in SQL form) the difference
d another (that is, the commands to bring the
one up to the level with another) would be extreamly useful. Of
course, both have to be managable without any dataloss.
--
Rod Taylor
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. C
14 matches
Mail list logo
