:[EMAIL PROTECTED] On Behalf Of Hrishikesh Deshmukh
Sent: May 9, 2005 6:54 PM
To: Mark Borins
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Data Modelling Tools
This is my favits just awesome...
http://www.sqlmanager.net/
On 5/9/05, Mark Borins [EMAIL PROTECTED
I am creating a system where I have a trigger on
three different tables. There is a particular Boolean field in each of
these tables that when it is set in table it should be set the same in the
other two.
So I figured I could put a trigger on each table that
when the Boolean field was
From: Franco Bruno Borghesi [mailto:[EMAIL PROTECTED]
Sent: May 11, 2005 11:24 AM
To: Mark Borins
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Disabling Triggers
You could add a TIMESTAMP field on the three tables (lets call it
last_change), and modify your
That looks like a good solution.
And that way it won't cascade.
Thanks
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: May 11, 2005 11:53 AM
To: Mark Borins
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Disabling Triggers
Postgres Newsgroup,
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
and generating change scripts, etc.
From: Matthew Terenzio [mailto:[EMAIL PROTECTED]
Sent: May 9, 2005 5:48 PM
To: Mark Borins
Subject: Re: [GENERAL] Data Modelling Tools
these are among some popular tools, the second being web based.
http://www.pgadmin.org/
http
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Eisentraut
Sent: May 6, 2005 2:12 AM
To: Mark Borins
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unicode and unaccent()
Mark Borins wrote:
My problem is that the values like \342 are for LATIN1 type encoding.
I have
I am trying to write an unaccent function because I
need to do some queries comparing data that has accents and data that does not.
The encoding on my DB is Unicode, so far I have found
an unaccent() function by looking in the mail archives it looks like the
following:
CREATE