re any way to run an update query and specify that it should not
activate the trigger.
I know that I can disable the trigger and reenable it later;
however other concurrent updates mights need it
Best regards
Wolfgang Hamann
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
Am 2016-01-29 um 10:21 schrieb Artur Zakirov:
On 28.01.2016 20:36, Wolfgang Winkler wrote:
I'm using 9.4.5 as well and I used exactly the same iconv lines as you
postes below.
Are there any encoding options that have to be set right? The database
encoding is set to UTF8.
ww
What output
an 28, 2016 at 6:04 PM, Wolfgang Winkler
mailto:wolfgang.wink...@digital-concepts.com>> wrote:
Hi!
We have a problem with importing a compound dictionary file for
german.
I downloaded the files here:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/is
Hi!
We have a problem with importing a compound dictionary file for german.
I downloaded the files here:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz
and converted them to utf-8 with iconv. The affix file seems ok when
opened with an editor
penoffice Base uses
H2 and there are plenty of reports by users about data losses due to
database corruption.
Personally I'd *never* use an "embedded" database for anything.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
G (like
> Access/FileMaker/Foxpro), script-based (e.g. XForms) or pure
> programming based.
If I had the skills, I'd pick up Pypapi. It is in production use with
several italian municipalities, but the developer has switched to Java
for whatever reason.
Sincerely,
Wolfgang
--
Sent via p
ww.glom.org
- Gemello: abu.sourceforge.net
With wxPython:
- Gui2Py: code.google.com/p/gui2py/
- Dabo: www.dabodev.com
- Defis: sourceforge.net/projects/defis (Russian only)
- GNUe: www.gnuenterprise.org
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
http://postgres-xc.sourceforge.net/
As does Bettina Kemme (of Postgres-R fame).
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
em, she should at least make sure to
get them a reasonably useful WWW site.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
quot;News" on
the right with a date of 2010-07-14.
http://git.postgres-r.org/ lists the "Last Change" to Postgres-R as "2
years ago".
http://www.postgres-r.org/downloads/ lists the last "Snapshot patch"
with a date from 2010-08-29.
The "Postgres-R Live-CD&q
re than it would take to put it there once for good. That's the kind
of pointy-haired dysfunctionality I'd expect from a managed corporation,
not from an open-source project.
In fact I would guess that given how closely PostgreSQL-XC follows the
releases of "pure" PostgreSQL a
at there's no such thing should have been less work than
replying to me.
>;->
Disclaimer: I have nothing to do with PostgreSQL-XC, I don't even use
it myself, I just happen to know that it exists, even though I am just a
"casual" user of PostgreSQL.
Sincerely,
Wolfgang
--
Sent v
er you may call it, as long as they're open-source.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rview
*snip*
> Features of PG-XC include:
*snip*
> 2. Synchronous multi-master configuration
Seems to me that the editing process of the different parts of
postgresql.org somewhat lacks transactional semantics.
>;->
Sincerely,
Wolfgang
--
Sent via pgsql-general mai
lly unusable crap.
> It's just the way things are and if you know your technologies you
> can settle on a stack that approaches the RAD platforms of old in
> terms of programming efficiency.
Certainly not. Not to mention the issue of end-user productivity. Not
to mention the deployme
ductive "information
workers" to get useful work done with at least some efficiency.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Forms these days are written in HTML.
Only by clueless/careless morons.
HTML has never been, is not and will never be a usable GUI framework.
And "web apps" are unusable garbage.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
: code.google.com/p/gui2py/
Dabo: www.dabodev.com
Defis: sourceforge.net/projects/defis (Russian only)
GNUe: www.gnuenterprise.org
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
r France
11 million families and 30 million people as "customers"
69 bio EUR annual turnover
168 databases, 4TB all databases together, largest database is 250 GB
1 bio SQL statements a day
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
SQL instead.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ntime with about a million entries in tab1 and 800
entries in tab2
is about 40 seconds.
Regards
Wolfgang Hamann
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lises "one to
many"-attributes at the object level. No need to implement *any*
"controllers" at all.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing with PostgreSQL on MacOS X, I used
the installer from
http://www.postgresqlformac.com/
There's also a different approach, that I've never tried:
http://postgresapp.com/
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
alified key) if
required to prove authenticity?
After all, PostgreSQL maintains this automatically anyway, so why not
use it?
TIA,
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Can anyone tell me which free GUI based tools are available for
> creating database diagrams for my database in postgresql.
One standard answer to this frequently asked question is:
http://www.databaseanswers.org/modelling_tools.htm
Sincerely,
Wolfgang
--
Sent via pgsql-general m
le storage.
>
> You're better off storing the blob on disk somewhere and storing a
> row that refers to its location. Either key pieces for a naming
> scheme or the full path.
What's the state of implementation (planning) for this?:
http://wiki.postgresql.org/wiki/DATALINK
iple inheritance in PostgreSQL,
> namely that you can define interfaces across column combinations and
> combine those column combinations into a table.
What's the difference from the use of custom composite types to
aggregate tables? Except for access syntax?
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nship model.
It means that the dependency graph does not contain directed cycles
("hen-and-egg"-type foreign key relations).
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
l (given
a standard alorithm such as Graphviz) be used as a criterion to judge
whether the model is actually well-structured?
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> I could not get the script sqlalchemy_schemadisplay3.py to work with
> sqlalchemy 0.7.8-1 (on Debian).
Have you asked on the SQLalchemy mailing list?
http://www.sqlalchemy.org/support.html#mailinglist
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-g
well-typographed PDF documentation of any PostgreSQL database
from within Pgadmin, through LaTeX.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
re's a pretty comprehensive
list:
http://www.databaseanswers.org/modelling_tools.htm
Sincerely,
Wolfgang Keller
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ly) arbitrarily complex mappings between your object model and the
database tables. GUI frameworks that use SQlalchemy are: Sqlkit,
Pypapi, Camelot, Qtalchemy.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
ot of others:
http://www.databaseanswers.org/modelling_tools.htm
Sincerely,
Wolfgang
--
Führungskräfte leisten keine Arbeit(D'Alembert)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
e same
string in one language will be different in other languages.
TIA,
Sincerely,
Wolfgang Keller
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
has anyone ever implemented something similar to postgresql_autodoc in Python?
TIA,
Sincerely,
Wolfgang
--
NO "Courtesy Copies" PLEASE!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
dd an
"instance-id" column (and make this column also part of the primary key of each
table).
Sincerely,
Wolfgang
--
NO "Courtesy Copies" PLEASE!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ne I like the most is DB-Main
(http://www.db-main.com/doc.php?id=to1&lang=2). Which is not mentioned on the
page above.
Sincerely,
Wolfgang
--
NO "Courtesy Copies" PLEASE!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
Hello,
what would be the easiest way to generate documentation for a PostgreSQL
database in LaTeX/LyX format? Autodoc doesn't seem to support LaTeX output
directly...
TIA,
Sincerely,
Wolfgang
--
NO "Courtesy Copies" PLEASE!
--
Sent via pgsql-general mailing list
re developer of Postgres? :-)
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
tus_type_key_type,
PRIMARY KEY (db_key)
)
;
The objective was to make the table definitions more readable (less
fields) and to simplify the work in case the identification schema
changes.
Nonsense? Am I nuts? Is that in fact totally useless? Or is there a
better (simpler) way to achieve
dministration" must be taken into account. A dedicated individual
just for that is simply out of question in this world where I live. So
someone who's already available has to do all that in a (as tiny as
possible) fraction of his/her worktime. With MacOS X it's feasibl
c.) on the same hardware?
And Linux to (Free-/Net-/whatever) BSD?
No flamebait, I'm just wondering whether the performance gain is worth
the learning effort required for Linux or BSD compared to the Mac.
Sincerely,
Wolfgang Keller
---(end of broadcast)-
c.) on the same hardware?
And Linux to (Free-/Net-/whatever) BSD?
No flamebait, I'm just wondering whether the performance gain is worth
the learning effort required for Linux or BSD compared to the Mac.
Sincerely,
Wolfgang Keller
---(end of broadcast)-
nd make it more "readable" for
clueless morons like me. >;->
You can learn a lot by a few minutes of
exploration at a psql prompt.
Yes, I will have to get used to using the Postgres prompt just like I
do with the Python prompt. ;-)
Sincerely,
Wolfgang Keller
d also simplify mapping it
to a logical model in Python quite a bit.
TIA,
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
erely,
Wolfgang Keller
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello,
> Both have trials - try it ;-)
That's what I've done, as I mentioned. But sometimes others know/see
things that I don't see/know, at least not within a restricted trial
period.
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
about them?
TIA,
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
---(end of broadcast)---
TIP 6: explain analyze is your friend
of as
being the "best of their breed" from personal experience through using
them on a daily basis to earn my living simply wouldn't exist - as they
have all been implemented by people who don't have a CS degree.
And I'm not talking about trendy webcrap
ive but MacOS cannot now run without firewire on a 4
> year old computer.
Well, Jobs doesn't want to allow it to do so, because Apple needs to
pay the fuel bills for his bizjet, I guess...
Sincerely,
Wolfgang Keller
---(end of broadcast)---
T
ever one chooses to learn, if it is tied to
> Windows, then its future is tied to the whims of Microsoft.
Not necessarily.
With Pyhon and wxWidgets or Qt, you can easily work on Windows, Linux,
*BSD (and MacOS and Windows CE and PalmOS and your series 60 Nokia
mobile phone and and and)
the forest of system catalogs, its OIDs, the
information schema...?
Thank you!
Best regards,
Wolfgang
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PRO
ite more elegant (and
generic). And that may be the reason why it is mentioned in the docs: it
seems to be an elegant and natural way the check a domain.
Best regards,
Wolfgang
---(end of broadcast)---
TIP 3: if posting/reading through Usen
can't find it there. Or do I
overlook something?
This is also stated in the page about CREATE TABLE.
Best regards,
Wolfgang
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
, maybe using
SQLite for the mobile clients.
Is there a solution which allows for automatic (but fully
user-configurable) asynchronous replication between PostgreSQL and SQLite?
TIA,
Best regards,
Wolfgang Keller
---(end of broadcast)---
TIP 6
56 matches
Mail list logo
