Scott Ribe wrote:
I don't remember if MagicDraw supports multiple schema or not, but back when
I was looking at CASE-type tools it was one the nicer ones that I found that
would run on platforms other than Windows.
For Windows, I've been using Case Studio for several years and I've been
very
Bohdan Linda wrote:
The frontend is web based so it is stateless; it is connecting to database
on every get/post. There is also a requirement that the user is
transparently logged in for some period of time.
Tha most easy way is to store login credentials into the session. The
drawback is that
Bohdan Linda wrote:
On Thu, May 15, 2008 at 05:40:49PM +0200, Steve Manes wrote:
I keep the user's login credentials in a TripleDES-encrypted,
non-persistent cookie, separate from session data.
This is the approach I am/will be heading to. Having the cookie with login
and password encrypted
Steve Manes wrote:
This one has me stumped. Does anyone know under which circumstances
this error would be returned by PHP's pg_query_params() even if the
procedure completed without an apparent error?
The procedure and PHP API code haven't changed in weeks. I started
getting this after I
Steve Manes wrote:
Steve Manes wrote:
This one has me stumped. Does anyone know under which circumstances
this error would be returned by PHP's pg_query_params() even if the
procedure completed without an apparent error?
The answer was right in front of me. An (*ahem*) associate
This one has me stumped. Does anyone know under which circumstances
this error would be returned by PHP's pg_query_params() even if the
procedure completed without an apparent error?
The procedure and PHP API code haven't changed in weeks. I started
getting this after I upgraded the
I've got 8.1 running fine. I want to upgrade to 8.2. Problem is,
FreeBSD's portupgrade utility only wants to upgrade my existing 8.1
installation.
So I grabbed the latest ports collection, which includes
postgresql82-client and postgresql82-server. Running 'make install' on
Steve Manes wrote:
What's the portupgrade process in FreeBSD??
(Fixed. The answer is to use pg_delete -f on the old package to force
the delete)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
Ron Johnson wrote:
Interesting. Does PG have to initiate the Perl interpreter every
time you call a Perl-written SP?
I mean the *application* language was Perl for both the inline insert
and the proc call. The proc was written in plpgsql.
---(end of
Guy Rouillier wrote:
I have a thread I started ages ago over on the PERFORM list that I'm
sadly just now being able to provide some insight on. I'll be replying
on that thread in more detail, but the short of it turns out to be that
at least in this one application, using stored procs for
Ron Johnson wrote:
Moving all the application-bound inserts into stored procedures didn't
achieve nearly the performance enhancement I'd assumed I'd get, which I
figured was due to the overhead of the procs themselves.
Would that be because the original app was written in a compiled
language,
On 8/15/07, Rohit [EMAIL PROTECTED] wrote:
I have few queries regarding the use of Stored Procedures, Functions
and Triggers in an RDBMS.
(1) When to use Stored Procedure? Writing an INSERT query in a Stored
Procedure is better or firing it from the application level?
(2) Can a Trigger call a
Trevor Talbot wrote:
Another is because I want transactions to start and end in the database,
not in external application code which might crash before a COMMIT.
Hmm, how do you handle this logically? Do your applications never
need to submit chunks of work at once? Or do you do something
I apologize if I'm having a rookie brain block, but is there a way to
massage a string inside a proc to, for instance, strip it of all
non-alpha characters using a regular expression?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Marc G. Fournier wrote:
As of this moment, if Oracle buys Zend, they could effectively kill PHP
... the core engine that PHP is built around is a Zend engine, so if
they were to revoke the license for that, PHP would be dead ... kinda
like MySQL with InnoDB ... now, there was talk at one point
Leonard Soetedjo wrote:
Is it possible that Oracle is trying to buy MySQL to kill off other open
source competitor, e.g. PostgreSQL? MySQL has a strong number of users and
therefore it is a good deal for Oracle to buy MySQL. Then by doing that,
Oracle will market MySQL as the low-end
Questions: is there a hard limit to the number of schemas you could have
in a database? Are there any caveats/pitfalls/pitbulls to having a
large number of duplicate schemas in a database?
---(end of broadcast)---
TIP 6: explain analyze is your
In plpgsql, is it possible to indirectly reference a column in a record
object?
For instance, in a trigger function I've got a variable, v_column_name
containing (predictably) a column name in existing in OLD and NEW. I
want to reference that column. This of course doesn't work:
IF
I need to extract a SETOF column names for a table in plpgsql. How is
this done?
-=oo-
Steve Manes http://www.magpie.com
Brooklyn, NY
---(end of broadcast)---
TIP 1: if posting/reading
Greg Stark wrote:
My first reaction to this description was to consider some sort of model where
the master database publishes text dumps of the master database which are
regularly downloaded and loaded on the slaves. The slaves treat those tables
as purely read-only reference tables.
If you
I have a project on my plate which will involve potentially hundreds of
PG8 databases in the field which will need to synchronize data with a
central database. The company is a secular nonprofit which delivers
medical services to underprivileged kids as well as to disaster victims
like those
Has anyone applied this patch? Any comments on it?
---(end of broadcast)---
TIP 6: explain analyze is your friend
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. Is there anybody who has
Joshua D. Drake wrote:
My company has been looking for a good database modelling tool for
postgres and have yet to find something that completely satisfies our
needs. We are currently using a product called DBWrench which is
pretty good and has all the features we are looking for but is full
Karel Zak wrote:
It must be pretty difficult maintain these header and body patterns
and the others lists. I had same problem and I resolve if by
spamassassin, it knows learn and it's more simple than procmailrc
coding. Now I have cca 5% of all spams in my INBOX.
It's not
I'm flummoxed on this one. I have a class that's building a query which
selects data from 1-n tables based on a common indexed id, io_id. These
tables may contain 1-n rows of data keyed on io_id. What I want the
query to do is return nulls for replicated columns rather than just
replicating
needed
to make the target db look like the master.
Is anyone aware of such a tool for PG? I've only found it for MSSQL.
-=oo-
Steve Manes http://www.magpie.com
Brooklyn, NY
---(end of broadcast
27 matches
Mail list logo