t does 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
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
--
I could have swore that this worked in earlier releases of Postgresql
i.e. 7.4.
CREATE TABLE public.test
(
junk double NOT NULL,
CONSTRAINT junk_pkey PRIMARY KEY (junk)
)WITHOUT OIDS;
Now it gives a error that type double does not exist.
During the summer of 2004 I ported a large Firebird data
.
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
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
e 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,
--
T
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
your 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.amsoftware
mostly windows 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)---
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 valida
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 SERIALIZA
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 one transaction, or did that change with 8.1? Is there
now a SNAPHOST
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';
s
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 th
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&#
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
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 i
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 apps
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.
This
server setup blowing away 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
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)
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 wou
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 f
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 functio
d, but was not as expected.
Thanks,
Tony Caduto
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
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
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
i
I have verfied this bug exists in all pg_restore versions greater than 8.0.0
Someone else reported it way back in Feb:
http://groups.google.com/group/mailing.database.pgsql-bugs/browse_thread/thread/4dacdd43b894a2c3/e59e3203bb22745b?lnk=st&q=pg_restore+password+authentication+failed&rnum=9&hl=en#e
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 r
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 ch
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 becasus
Hi,
I did restore from a 8.0 dump.
here is the output from the query:
lanname | lanplcallfoid | lanplcallfoid | lanvalidator |
lanvalidator
--+---++--+--
internal | 0 | -
asfdfdfdfafdsfsdfsdf
sdf 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 execu
but it
raises no errors at create.
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 -0
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?
T
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
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 als
th the 8.0 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
40 matches
Mail list logo
