many different Lisp implementations to provide a
Lisp IDE in Emacs.
BTW, this is Lisp's 50th birthday being celebrated today at OOPSLA.
http://www.lisp50.org/
John DeSoi, Ph.D.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
;m not very
proficient with C. If anyone is interested in leading the way, I would
be happy to help.
John DeSoi, Ph.D.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
r column names. It would be nice to have something like "declare
$myvar integer;" so it would be very easy to distinguish variable and
parameter names from structure names or reserved words.
John DeSoi, Ph.D.
---(end of broadcast)
o get simple session going (e.g. how to start a session and
request the source for a procedure).
Thanks,
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list arc
out t text, out i integer)
returns record as $$
begin
t := 'test 1';
i := 10;
return;
end;
$$ language plpgsql;
I did the following:
1. Right click the function and chose "Debug" from the "Debugging"
submenu.
2. Clicked the OK button on the di
evening. Possible hint: the function had no IN parameters, but many
OUT parameters.
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
a pgAdmin bug when you start a debug session
on a function that has no parameters:
ERROR: syntax error at or near ")"
LINE 1: SELECT * FROM myschema.myfunction)
^
Thanks for doing this project -- looks great.
John DeSoi, Ph.D.
http://pgedit.
on
'stringToQualifiedNameList'
plugin_profiler.c: In function 'dumpStatsXML':
plugin_profiler.c:847: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
plugin_profiler.c:850: warning: f
ments which can be a hassle for large
argument lists.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
for postgres by the tools.
I would like to have this functionality (yesterday :) -- I'm
currently working on this for pgEdit. Let me know if you need help
with review or testing.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broa
ace to the
debugger would work. From previous threads I saw DBGP mentioned
(http://xdebug.org/docs-dbgp.php), but I don't recall seeing any
final commitment to it.
Thanks,
John
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(e
On Jul 14, 2006, at 12:32 PM, Joshua D. Drake wrote:
Doesn't our inclusion of md5() pretty much blow that argument away?
(Just asking).
I don't think so because md5 is just a one way hash function. There
is no method to decrypt anything :).
John DeSoi, Ph.D.
http://pgedit.
to compile from source on Win32 freely
available?
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
mysql/gotchas.html#1_14
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ysqlcompat/
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(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
several other
possible PL/PHP issues that would warrant a SoC project.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org
s, I'll be happy to spread the word.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
references, but at
least I found a solution without having to understand gcc.
http://www.pgadmin.org/archives/pgadmin-support/2006-03/msg00053.php
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TI
ility version 1.0.0,
current version 369.1.5)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0,
current version 88.1.2)
/usr/lib/libmx.A.dylib (compatibility version 1.0.0, current
version 92.0.0)
It would be really nice to have relative references.
John DeSoi, Ph.D.
her way to deal with non-ascii characters?
Thanks,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
this affliction.
So are the database/user names in the startup message compared using
the default encoding of the cluster or is just a straight byte
comparison with no consideration of the encoding?
Thanks,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
I could not find anything in the Frontend/Backend protocol docs about
character encoding in the StartupMessage. Assuming it is legal for a
database or user name to have unicode characters, how is this handled
when nothing yet has been said about the client encoding?
Thanks,
John DeSoi
d on the super user in a
hosted environment.
Maybe the best solution here would be some web interface setup by the
hoster to perform specific approved tasks like tsearch install. This
is already the mechanism used to allow users to create their own
databases.
Thanks for taking t
want it or not, (2) restoring the database is going
to have permission problems.
Would it be reasonable for there to be a way for the super user to
grant access to load "approved" modules and/or C language functions?
John DeSoi, Ph.D.
http://pgedit.com/
Power
commands
for specific completion types, e.g. complete table, complete
function, etc.
I hope to have a beta out soon with 8.1 psql and updated tab
completion for the new commands (roles, etc).
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(e
SSH tunneling implies another level of software, user accounts, and
permissions. It would be nice to handle the entire sphere of users
and permissions from within PostgreSQL. For database access
requirements, I would much rather allow DNS names in pg_hba.conf than
provide SSH access.
tions.
http://archives.postgresql.org/pgsql-hackers/2005-04/threads.php
It seems pretty simple and non-invasive. I don't recall seeing the
reasons against doing it.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of
. Sorry I don't recall
what, if any, limitations that involves.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote:
To others who've written their own sleep() function: what are you
using it for?
I need it for API and user interface testing. I want to be sure
things behave correctly when a long running query is interrupted.
John DeSoi, Ph.D.
e nice to be able to override the default.
Thanks,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
wnload a single file. This makes it
a pain to get accurate download statistics.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
may execute a \i
command and the user wants to stop before the file is processed. What
mechanism is used to do this on win32? I thought it could be
accomplished on Unix with kill -2, hence my original question. But
maybe I'm looking in the wrong place.
Thanks,
John DeSoi, Ph.D.
dback and suggestions. Since I need this
to work on win32, I guess I'll just abort the stream and reconnect. The
main issue with this is trying to restore any state associated with the
connection (e.g. search_path).
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for
g if there was some way to work around this short of
recompiling the source. I need to do the same thing on Windows.
Thanks for any suggestions,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 8: explain
here: http://developer.postgresql.org
and
http://developer.postgresql.org/readtext.php?src/FAQ/
FAQ_DEV.html+Developers-FAQ
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
-rc1, so I would hate
to see it go away over this one issue. I did not realize that 95/98
worked at all. I don't think anyone really wants to setup a server on
95, 98, or even NT4, but it would be really nice if psql would work.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for
ller gives me.
SSL suport possibly? Use pg_config from the installer to find the exact
commandline used for that. If that's not it, then different version of
mingw gcc probably.
That's it -- thanks.
If I'm posting to the wrong list for this, please let me know.
John DeSoi, Ph.D.
http:
mess.
hackers-win32 is prboably slightly more on-topic
OK, will do for next time.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
r than what the installer gives me.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
help!
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
=
pgEdit is a high performance SQL editor and development environment
designed specifically for PostgreSQL relational databases. pgEdit
features include:
* SQL Syntax coloring specifically designed for PostgreSQL
Postg
n spare
a little time to take a look and provide some feedback.
Thanks!
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
=
pgEdit is a high performance SQL editor and development environment
designed specifically for PostgreSQL relational databases. It supports
Emacs style ed
to be
the OID of the created type.) What I want to do is store text but know
that the column is a specific text format so that it can be parsed
properly by the front end.
Thanks,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Did I mis-analyze the situation in the previous email? Is it not just
one query to the database to get the base type compared to a lot more
effort to get the domain?
Thanks,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 6: Have you search
and add
connection-specific setting for clients that need it. I don't think a
postgresql.conf option (alone) is viable because users might want to
use different kinds of front ends for the same server.
Best,
John DeSoi, Ph.D.
---(end of broadcast)
d all the reasonable keywords I can think of in the archive
search, but I can't seem to find anything.
Thanks,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
. 7.4 bug or something I need to work out on my own?
Thanks,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ve to wait a while for 4 billion bytes :).
BTW, very nice job on the 3.0 protocol. Very clean and pretty
straightforward to implement.
Thanks for your help,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
is past
weekend.
Thanks,
John DeSoi, Ph.D.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
48 matches
Mail list logo
