Colin,
To query for Postgresql services on Windows use:
sc query type= service | find postgresql
sad news is that (at least on my computer) it only finds running services.
Harald
--
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
Amtsgericht Stuttgart,
Bruce,
NET STOP postgresql-8.4
NET STOP postgresql-9.0
which should be extended by
net stop postgresql-x64-9.0
for Windows 64 bit.
Interesting. What I have added to HEAD and 9.0 docs is the attached
patch that explains the proper service name should be used. I don't
Hello,
just doing an upgrade form PostgreSQL 8.4.4 on Windows 2007 64bit to
PostgreSQL 9.0 64bit on the same system.
I am working along
http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html
There is written:
NET STOP postgresql-8.4
NET STOP postgresql-9.0
or
NET STOP pgsql-8.3
I, for one, think it would be great if the JSON datatype were all in
core :-) However, if and how much JSON code should go into core is up for
discussion. Thoughts, anyone?
in my opinion: As soon as possible. Spinning PostgreSQL as the
Ajax-enabled-database has many great uses.
Harald
--
Pavel,
b) create MV syntax?
- CREATE MATERIALIZED VIEW mvname AS ..., I think it is quite
obvious to do so, but I had to ask
please do not fortget the:
create or replace MATERIALIZED VIEW
option.
And also the
DROP if exists
for the drop-command
Best wishes
Harald
--
GHUM Harald
The pg8000 / bpgsql seem to be toy projects, and anyway you dont
want to use pure-Python drivers in high-performance environments.
I agree that there are some performance-challenges with pure-Python drivers.
And we should not forget to look for the reasons for the incubation of that
many
Greg,
The point isn't so much standardizing. Having a low performance Python
driver turns into a PostgreSQL PR issue.
I totally agree.
And if you're writing a database driver with performance as a goal, native
Python is simply not an option.
yes. Additionally: performance is not the only
Marko,
I thought the topic was Confusion over Python drivers?
The only bug there was likely app one, or at least its not widespread
so off-topic. Rest are more like non-essential cool features,
so again off-topic.
Those lack of non-essential cool features is right on topic - because
Bruce,
http://wiki.postgresql.org/wiki/Python
The first one listed, Psycopg, is noted as preferred libpq-based
driver, but the license is GPL. Isn't that a problem for many client
applications?
The licence of psycopg2 is a little more complicated; the GPL in that
summary just tries
Wait for it
9.0.
Yeah!!!
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
%s is too gigantic of an industry to bend to the whims of reality
--
Sent via pgsql-hackers mailing list
Tatsuo,
Ok. Your suggestion is very helpfull. In general Tsutomu will wait for
feedbacks come in, probably until Jan 15th.
BTW, is there anyone who wishes the patches get in 8.5? Apparently
Tstutomu, Magnus and I are counted in the group:-) But I'd like to
know how other people are
Kevin,
md5sum of each tuple? As an optional system column (a la oid)?
I am mainly an application programmer working with PostgreSQL. And I
want to point out an additional usefullness of an md5sum of each
tuple: it makes comparing table-contents in replicated / related
databases MUCH more
I am in the process of adding a user-space myhash column to all my
applications tables, filled by a trigger on insert / update. It really
speeds up table comparison across databases; and it is very helpfull
in debugging replications.
Have you seen pg_comparator?
yes, saw the lightning talk
Sure. Here's a nice example from SQL Server as well as related doc links:
http://blog.benhall.me.uk/2007/10/sql-connection-application-name.html
http://msdn.microsoft.com/en-us/library/ms189770.aspx
I can have libpq look at the environment as it does for
PGCLIENTENCODING, but I'd certainly like to be able to use the
connection string as well, as environment variables are not really the
another challenge with the Environment variable: they are (at least on
windows) usually set for one logged
I think Josh Tolley has some slides on how we built PL/LOLCODE that
could prove useful.
BTW I've seen requests for PL/Js so I'm sure it'll be welcome. What
license is v8 under?
the new BSD License
http://code.google.com/p/v8/
--
GHUM Harald Massa
persuadere et programmare
Harald Armin
within source code, build options there is:
- Reserve the shared memory region during backend startup on Windows,
so that memory allocated by starting third party DLLs doesn't end up
conflicting with it. Hopefully this solves the long-time issue with
could not reattach to shared memory
The impression I have is that (to misquote Churchill) XML is the worst
option available, except for all the others. We need something that can
represent a fairly complex data structure, easily supports addition or
removal of particular fields in the structure (including fields not
foreseen
18 matches
Mail list logo