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
to 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:
http
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)---
TIP 3: Have you checked our extensive FAQ
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 archives
. 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
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 dialog.
Best,
John
John DeSoi
type 'long
int', but argument 4 has type 'suseconds_t'
plugin_profiler.c:850: warning: format '%07ld' expects type 'long
int', but argument 4 has type 'suseconds_t'
make: *** [plugin_profiler.o] Error 1
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
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.com/
Power Tools
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 broadcast
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
---(end of broadcast
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.com/
Power
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
/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
/
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
there are 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
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
, 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)---
TIP 1: if posting
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.
http
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
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
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
.
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 the time to respond.
John DeSoi, Ph.D.
http://pgedit.com
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 Tools for PostgreSQL
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
---(end of broadcast
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.
John
.
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 broadcast
. 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.
http
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
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
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 PostgreSQL
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.
http
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 analyze
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
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 your
message can get
a 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
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://pgedit.com/
Power Tools for PostgreSQL
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 PostgreSQL
---(end
!
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
PostgreSQL
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 editing
.) 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
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
-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)---
TIP 3: if posting
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 searched our list archives?
http
. 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
0005 3137303632
D mesg len 2col col1 len5 oid 17602 len col2 here?
After the next DataRow message starts.
I'm using PostgreSQL 7.4devel on powerpc-apple-darwin6.6, compiled by
GCC gcc (GCC) 3.1 20020420 (prerelease) downloaded from cvs this past
weekend.
Thanks,
John
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?
http
48 matches
Mail list logo
