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 Stuttg
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
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 (Postg
> 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
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
>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 pure-P
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 - b
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 ju
> 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 (pgsql-ha
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 int
>> 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 ligh
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 feasi
> 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
>
> http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionst
>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 logge
>
> 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
Haral
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" er
> 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
> forese
18 matches
Mail list logo