not use the RunAs service at all and handles the initDB.
You could also use a C or C++ dll just as easily.
Just reminding everyone it's out there.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
Has there ever been any talk of adding a first aggregate function?
It would make porting from Oracle and Access much easier.
Or is there something in the contrib modules that I might have missed?
Thanks,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning
remotely, and does it pretty much the same
way as pgAdmin III.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 4: Have
Peter Eisentraut wrote:
There has never been a type named double in PostgreSQL. The type name
mandated by the SQL standard is double precision, and PostgreSQL
supports that.
Ok, Thanks for clearing that up for me :-)
Maybe it was pgAdmin that did the substitution.
Thanks,
Tony
Hi,
Does anyone know how the win32 server checks if the user is non
priveleged? Does it just check if the user is in the admin or power
user group?
Thanks,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
.
Later,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
the litest possible setup for use in my IM server
(Lightning Messenger), and eliminate any unneeded files so I can have
the smallest setup I can get.
I already have a complete working setup built with Inno setup(it's 4.8
mb), now I just need to get it as lite as posssible.
Thanks,
--
Tony Caduto
install
using the zip file.
If this is not used for the server what is it used for?
Thanks,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 4: Have you searched
welcome to
a copy. There are no strings attached and you don't have to do anything
other than keeping the setup password to yourself.
Just let me know via email.
Thanks,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
Hi,
I just noticed today that Postgresql accepts a value of 24:00:00, this
is for sure not correct as there is no such thing as 24:00:00
PG Admin III will display this value just fine which is also incorrect,
PG Lightning Admin catches it as a invalid time, but shouldn't there be
some
users with my product, I guess for
now I will just allow it to be flagged as invalid.
Later,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 4: Have you
Tom Lane wrote:
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-set-transaction.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/transaction-iso.html
It's a bit amusing that this person is dissing us for not having
REPEATABLE READ, when what he actually seems to want is
We found PostgreSQL a mature product, but in two things Firebird was
simply better than PostgreSQL: Two-Phase commit (ok, that is gone with
PG 8.1), but the second is a SNAPSHOT / REPEATABLE READ transaction
isolation. I can't live without that when it comes having a stable view
of data during
Hi,
I have been playing around with pg_reload_conf() and the pg_settings view.
I understand that the pg_settings view, if updated, applies to the
current session only.
However I was under the impression that if I did a pg_reload_conf(), the
pg_settings view would be updated at that time, but
Andrew Dunstan wrote:
Qingqing Zhou wrote:
test=# LOG: received SIGHUP, reloading configuration files
test=# select setting from pg_settings where name =
'constraint_exclusion';
setting
-
off
(1 row)
test=# select setting from pg_settings where name =
'constraint_exclusion';
that is the exact same
hardware and OS version, I will report back what happens.
Not sure what is going on, has anyone else had this problem with CentOS
4.2 or Red Had EL 4.2?
Thanks,
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
I tried changing the sleep command in the script to 2, but at boot it
still says [FAILED].
even though the script reports it failed, the db is up an running.
This seems to happen for some people and not others. I've been wanting
Hi,
I installed 8.04 via RPM on Centos 4.2 which is the same as RedHat 4.2
and while booting the init script reports that the daemon [FAILED], but
after I logon it shows the postmaster running and I am able to connect
from any client remotely.
I made not modifcations to the script and there
libpq.dll. Who would care if it made
the dll bigger? you have to deploy all the files anyway. (I don't know
any thing about C, so I can't try myself)
Thanks,
--
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
---(end
Hi all,
I sent out a message about this before, but for reasons beyond my
control, I could not continue that thread.
Anyway, not only does the installer blow away libpq.dll, it also removes
all the Open SSL dlls, this is even more troubling
because LOTS of other apps depend on OpenSSL.
Magnus Hagander wrote:
Hi all,
I sent out a message about this before, but for reasons
beyond my control, I could not continue that thread.
Anyway, not only does the installer blow away libpq.dll, it
also removes all the Open SSL dlls, this is even more
troubling because LOTS of other
Tom Lane wrote:
Mike Rylander [EMAIL PROTECTED] writes:
Using that logic, a functions with one OUT param would be the same as
a function returning a rowtype with only one column,
But it's not (and no, I don't want to make it so, because the overhead
for the useless record result
Martijn van Oosterhout wrote:
On Fri, Sep 30, 2005 at 10:20:34AM -0500, Tony Caduto wrote:
Tom,
I hardly think the overhead would be significant on modern processors, I
don't think the majority of users are running on Pentium 90s.( I am
assuming you mean a performance overhead)
Um
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
Please don't take this the wrong way, but don't you think even if a
single param is declared as OUT it should return the name of the OUT param?
Not really, because create function foo (in x int, out y float) is
supposed to have
,
Tony Caduto
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
If I call it like this:
select * from FIND_USER_SOCKET_BYNAME('juser');
I would expect to get back 1 value with the name of the OUT param
(OUT_SOCKET_ADDRESS).
However it comes back with the name of the function
With there be a win32 version of beta2? or a beta1?
Thanks,
Tony
---(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
I have verfied this bug exists in all pg_restore versions greater than 8.0.0
Someone else reported it way back in Feb:
Tom Lane wrote:
I wrote:
Hmm. The only relevant-looking change between 8.0.0 and 8.0.1 is
this one:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_backup_archiver.c.diff?r1=1.101.4.2;r2=1.101.4.3;f=h
I wonder if this could be messing up the password acceptance --- for
Hi,
I have been playing around with 8.1(it's very nice by the way) and was
trying to get OUT params to return more than 1 row.
I came up with the function below, and it does work, however I had to
declare another record to use in the FOR ..IN loop.
From my reading of the docs the out params
I saw in the release notes that 8.1 is supposed to do function syntax
checking at create rather than run time, but with the first beta this
does not seem to work. check function bodies is on by default in the
postgresql.conf file. Is there a setting that didn't make it into the
conf file?
.
here is my version string:
PostgreSQL 8.1beta1 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.3.5-20050130 (Gentoo Linux
3.3.5.20050130-r1, ssp-3.3.5.20050130-1, pie-8.7.7.1)
Alvaro Herrera wrote:
On Wed, Aug 31, 2005 at 11:39:48AM -0500, Tony Caduto wrote:
I saw
bla bla
sdf yada yada
s
df
sd
fsd
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Thanks,
Tony
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
notice the for in select, it's for sure wrong, but it raises no errors
until I execute the function
also note the declaration for row
Hi,
I did restore from a 8.0 dump.
here is the output from the query:
lanname | lanplcallfoid | lanplcallfoid | lanvalidator |
lanvalidator
--+---++--+--
internal | 0 | -
I just found out the databases on 8.0 where originally restored from a
7.4 server, so it seems I have never had the
lanvalidator function even while running on 8.0 for the last 10 months :-(
So how can I update my restored databases, i tried dropping the
language, but it wouldn't let me
Tom,
I successfully updated my database to use the validator function without
dropping it using:
CREATE FUNCTION plpgsql_validator (oid) RETURNS void AS
'$libdir/plpgsql' LANGUAGE C;
UPDATE pg_language SET lanvalidator = 'plpgsql_validator'::regproc
WHERE lanname = 'plpgsql';
The create
When I run this I get this error in the database:
PostgreSQL Error Code: (1)
ERROR: function plpgsql_validator does not exist
In an already-loaded database, I think the following should work:
UPDATE pg_language SET lanvalidator = 'plpgsql_validator'::regproc
WHERE lanname = 'plpgsql';
I'd
check out http://www.zeoslib.net
I tried some of the commercial ones below and the postgresdac one had
problems with schemas.
It seems it does not fully support Postgres 7.3 and up.
There really is a shortage of quality postgres TDataSet components for
Delphi, Zeoslib is the best one, but it
release so
I will understand if no one replies.
Thanks,
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
39 matches
Mail list logo