There's bound to be a better way, but in the NT resource kit there was a
tool you can use to make any .exe a service.
I have a bash script running under Cygwin as a service here using it.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROTECTED]
WWW: h
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Ah. What about in 7.0.3 and below?
There is no good way --- if there were, we'd not have bothered to invent
datlastsysoid. pg_dump used to use the OID of the template1 database
as an estimate of the last built-in OID. This was wrong to be
Ah. What about in 7.0.3 and below?
Basically this because I am attempting to select all built-in functions. I
would like it to be backwards compatible, if at all possible.
Chris
> -Original Message-
> From: Philip Warner [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 24, 2000 11:
At 11:27 24/11/00 +0800, Christopher Kings-Lynne wrote:
>
>SELECT datlastsysoid from pg_database where datname = 'dbname'
>
>But as far as I can tell, the datlastsysoid field does not exist in
>pg_database.
>
If you build from CVS and do an initdb, you will find datlastsysoid should
exist...
--
Hi,
What is the current way of getting the last built-in oid?
I looked at the source of pg_dump, and it does this:
SELECT datlastsysoid from pg_database where datname = 'dbname'
But as far as I can tell, the datlastsysoid field does not exist in
pg_database.
What gives?
--
Christopher Kings-
Kevin Brown <[EMAIL PROTECTED]> writes:
> The reason is that as a DBA, I want to
> be able to kill off backend processes (with SIGKILL if necessary)
> without hanging the rest of the PostgreSQL system.
That has never been safe (or even possible, given how the postmaster
will respond).
* Larry Rosenman <[EMAIL PROTECTED]> [001123 01:10]:
> * Tom Lane <[EMAIL PROTECTED]> [001122 22:44]:
> Makes sense. Here's a new patch, now the output even looks better:
> Nov 23 00:58:04 lerami pg-test[9914]: [2-1] NOTICE: QUERY PLAN:
> Nov 23 00:58:04 lerami pg-test[9914]: [2-2]
> Nov 23 00:
I've been reading with interest the comments about the transaction log
management.
First, I'm pretty new to PostgreSQL so please forgive any blatant
errors or misunderstanding on my part.
We want access to the log to be serialized and similarly we don't want
fsync()s to happen in parallel nor d
Max Fonin <[EMAIL PROTECTED]> writes:
> I guess the problem is that PL/pgSQL doesn't handle opaque type correctly.
No it doesn't, which is not surprising considering that opaque isn't
really a type at all. The error message could be improved though :-(
Currently I believe that the only way to w
At 09:44 AM 11/21/00 -0700, Tim Uckun wrote:
>What about the php module? Does it take advantage of API?
I don't know. If not, though, there wouldn't be much point in using
AOLserver, since the simple and efficient database API is the main
attraction. So I think there's a pretty good chance it
xuyifeng (<[EMAIL PROTECTED]>) wrote:
> it's obviously there is a query plan optimizer bug, if int2 type used
> in fields, the plan generator just use sequence scan, it's stupid, i
> am using PG7.03, this is my log file:
>
> -
> stock# drop table a;
> DROP
> stock# create table a(i int
>
> > AOLServer isn't the only system that can pool database connections, so
> >can servlets/JSP, ColdFusion, ASP, etc. No doubt AOLServer would be more
> >widely accepted if it used something other than TCL.
>
>There's also support available for Python, though there's still a lot of
>work to b
Christopher Kings-Lynne wrote:
> Speaking of - I simply cannot find a standard SQL specification anywhere on
> the net, without buying one from ANSI. I'm forced to rely on
> vendor-specific docs - which are not standard in any way. Is anyone able to
> mail me such a thing?
You may want to take
I sent this to the general list and got no response so I figure I can take
it to the people who actually make the decisions.
Is this a security bug or is it by design?
- Original Message -
From: "Dan Wilson" <[EMAIL PROTECTED]>
To: "pgsql general" <[EMAIL PROTECTED]>
Sent: Sunday, Novemb
Hi:
Wonder if any of you know how to setup a postgreSQL server as a windows 2000 service
or have a URL or document on how to do it.
Thank you
--
Luis Magaña
Gnovus Networks & Software
www.gnovus.com
Tel. +52 (7) 4422425
[EMAIL PROTECTED]
Tom Lane writes:
> Pete Forman wrote:
> > The basic problem is that is a BSD header. The
> > correct header for TCP internals such as TCP_NODELAY on a UNIX
> > system is . By UNIX I mean UNIX95 (aka XPG4v2 or SUSv1)
> > or later. The 2 files which conditionally include
> > need also to
I backed up my database from Postgres 6.5.3 and migrated to 7.0.2
several a few months ago. For some reason, data was lost in the
transition. I've finally pinned it down to the attached file (abridged
to point out the problem).
It looks like two things happened in the backup. First, when I move f
Title: Hung backends
Hi,
I'm new to PostgreSQL and have been asked to determine the cause of what appear to be hung processes on FreeBSD after one or more frontend apps crash. I did alot of searching through the msg lists and found a few discussions that seem related, but I was unable to find
Guys, hello.
Here is a problem.
--
-- Creating 2 new functions and new type
--
BEGIN;
CREATE FUNCTION enum_week_in (opaque)
RETURNS int2
AS '
DECLARE
invalue ALIAS for $1;
BEGIN
IF invalue= OR invalue=''0'' THEN RETURN 0; END IF;
Hi:
I have a MS Access database with tables containing TEXT fields.
I need import that info in a postgres 7 table.
How to do it?
If I use copy from, dont work.
tia
Carlos Jacobs
"john huttley" <[EMAIL PROTECTED]> writes:
>> We've had parameterized triggers for years. Maybe you attach some
>> meaning to that term beyond what I do?
> I'm referring to the manual that says functions used for triggers must
> have no parameters and return a type Opaque.
The function has to b
I missed the proposal, discussion, implementation, and announcement of
the recent changes to make dump/reload more robust (it seems that I was
unsubscribed from -hackers for a few days, then out of town for a few
more :/ Amazing what a single week can bring!
Anyway, there were a couple of fields
At 23:07 16/11/00 -0500, Tom Lane wrote:
>Philip Warner <[EMAIL PROTECTED]> writes:
>>
>> - call pg_fmgr_api_version() to get the protocol version
>> - when it wants to call a function 'foo' see if there is a 'pg_api_foo'
>> entry point, and if so, use the new interface, o/wise use the old one. No
At 06:00 PM 11/23/00 +1300, John Huttley wrote:
>1. Calculated fields in table definitions . eg.
>
> Create table test (
>A Integer,
>B integer,
> the_sum As (A+B),
>);
...
>These are _extraordinarily_ useful for application development.
>
>If anyone has a
At 12:28 PM 11/23/00 +0100, Zeugswetter Andreas SB wrote:
>
>> Reason: I want to know if any of these features are scheduled.
>>
>> 1. Calculated fields in table definitions . eg.
>>
>>Create table test (
>> A Integer,
>> B integer,
>>the_sum As (A+B),
> >We lack a syntax that would enable us to write an on update/delete do instead rule
> >that would efficiently map an update/delete to a table that is referenced by a
>view.
> >
> >Currently the only rule you can implement is one that uses a primary key.
> >This has the disadvantage of needing
At 13:22 23/11/00 +0100, Zeugswetter Andreas SB wrote:
>
>We lack a syntax that would enable us to write an on update/delete do
instead rule
>that would efficiently map an update/delete to a table that is referenced
by a view.
>
>Currently the only rule you can implement is one that uses a primary
We lack a syntax that would enable us to write an on update/delete do instead rule
that would efficiently map an update/delete to a table that is referenced by a view.
Currently the only rule you can implement is one that uses a primary key.
This has the disadvantage of needing a self join to fi
At 18:00 23/11/00 +1300, John Huttley wrote:
>
>1. Calculated fields in table definitions . eg.
>
Can't really do this - you might want to consider a view with an insert &
update rule. I'm not sure how flexible rules are and you may not be able to
write rules to make views functions like tables,
> Reason: I want to know if any of these features are scheduled.
>
> 1. Calculated fields in table definitions . eg.
>
>Create table test (
> A Integer,
> B integer,
>the_sum As (A+B),
> );
This is currently easily done with a procedure that takes a t
30 matches
Mail list logo
