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
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
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
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
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
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
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
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)-
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
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
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
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
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
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
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
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
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
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
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
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
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
: 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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
> 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
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
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
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
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
> 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
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
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
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)
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
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
about them?
TIA,
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
erely,
Wolfgang Keller
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, 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
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
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
56 matches
Mail list logo
