e future "bug" reports.
Thanks,
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200510110941
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFDS8E4vJuQZxSWSsgRAvsYAJ9cz6yNdInOY2HbGJ5LKKBRFxe97QCgwoa4
r4sJrmQ4cHPE
neral solution is to use the features already built-in to
psql. Specifically, you can use a pager (e.g. "less" on unixy systems)
that supports horizontal scrolling, plus \pset pager always, thus fixing
the problem, regardless of what your terminal settings are.
- --
Greg Sabino Mullane [
make the default editor
wordpad instead of notepad?
The psql program opens in a small window - can it be made larger?
The psql history is not saved between sessions.
For pgadmin, one hint said "is the 8th July" instead of "8th of July"
- --
Greg Sabino Mullane [EMAIL PROT
...
> This is because we don't support readline on windows because it breaks
> in most locales.
Ouch. Those poor Windows users.
> Thanks for all your comments!
Thanks for all the work you and everyone else has done on making this
installer!
- --
Greg Sabino Mullane [EMAIL PROTECTE
am is pg-press.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200512021436
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFDkKKRvJuQZxSWSsgRAj7KAJ9lRaxONxpbFkQlDRMDDT8C5aOWtACfdZ5D
4paLbJ+QBN0ZM4NmswXcrkU=
=UK+B
-END
only option appears to be to have the application parse the string returned
from SHOW search_path, quote the dollar-values, and rebuild the string. Is
there an easier way?
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200512201205
http://biglumber.com
rch_path
to return this:
"$user",public
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200512201227
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFDqD83vJuQZxSWSsgRAj1gAKDIRGqzD7zORJQwrxLM+oKWOiAPKgCg9/xK
OGZIoWEnLd
ld affect the following:
\da \dc \dd \df \do \dT
I would rewrite the \? docs to make this more clear as well.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200409051221
-BEGIN PGP SIGNATURE-
iD8DBQFBOz0TvJuQZxSWSsgRAmdhAKCke2FfyB58/2dGoQF3Z+qmfNq3swCglmk9
aHa4jh1T2f
list large objects, same as \lo_list
\dn [PATTERN] list schemas (add "+" for more detail)
\dp [PATTERN] list table, view and sequence access privileges
\du [PATTERN] list users
Note that the confusing "t|i|v|s|S" thing has been broken up, an
> \d[S][+] NAMEdescribe table, view, sequence, or index
Very good idea. I guess I am once again in the 'S' camp, after a brief
foray into '&' land. Sorry, Bruce! :)
I'll keep working on the patch when I have the time.
- --
Greg Sabino Mullane
ome a
SQL parser, that's the backend's job, so we need a way to force
unknown, or a way to return the data types back to us when we
prepare a statement. The latter is on the 8.0 todo list, but have
not seen any progress onit)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964A
a bonus for us (DBD::Pg),
and we've never really had an issue with libpq until now, and it's getting
fixed, so no worries.
[1] Well, C and pseudo-C XS code anyway.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200409202318
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My version:
ANALYZE;
SELECT n.nspname, relname, reltuples
FROM pg_class c, pg_namespace n
WHERE c.relnamespace=n.oid
AND relkind='r'
AND NOT n.nspname ~ '^pg_'
ORDER BY 1,2;
- --
Greg Sabino Mullane [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Has a MySQL backend unfortunately - maybe I can convert them :)
We might not let you back otherwise! :)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200410192349
-BEGIN PGP SIGNAT
q/fe-exec.c
and PQserverVersion in interfaces/libpq/fe-connect.c for
more details.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200411222127
-BEGIN PGP SIGNATURE-
iD4DBQFBoqBJvJuQZxSWSsgRAleLAJQOmBAN69x7A/79IGiAV6T0GZt5AKDDDTFw
WWXPNFSsUp/iRNgM/Mgy1g==
=QV4u
-EN
ther do the latter than a broken implementation
of the former.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200411290939
-BEGIN PGP SIGNATURE-
iD8DBQFBqzU+vJuQZxSWSsgRAnWBAKCxND6C6HYplw+DO/FO3F0JIbMbeQCg4JHM
Sp/jKz0wodd4layMgdjLfbk=
=c/1R
and we get lots of free publicity.
Spending time on this is silly, IMO, unless there is a technical reason
why the feature should be replaced.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200501282155
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-B
ly get it added in to 8.1.
Thanks,
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200501282317
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iD8DBQFB+w6wvJuQZxSWSsgRAr8dAKDGfpxUaqMaJr/Az0MBWQMvBc6IWQCgrZvH
U2bNlnmWVYDgk3n
uot;);
$SQL = "INSERT INTO lii2(baz) VALUES (?)";
$sth = $dbh->prepare($SQL);
for (qw(uno dos tres quattro)) {
$sth->execute($_);
my $newid = $dbh->last_insert_id(undef,undef,"lii2",undef);
print "Last insert id wa
id() in DBI is a very useful function
anyway. It's mainly (at this point) a quick abstraction of a nextval call
between Oracle and PostgreSQL. We do go out of our way to be more compatible
to MySQL by accepting just a table name, but one should really use the
sequence directly, IMO.
but everyone
here is really good about doing that. :) Not sure if I still have
the script around, but I can dig it up if it's needed.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200502050103
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B9067149
t a memory leak that is subsequently
patched by Tom should get credit as a "developer", even if no actual patch
was submitted.
I'll give it a go for 8.0 and see what number I come up with.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200502061348
http://biglumber.co
nd if this would be a good thing or bad.
This sounds bad to me. Maybe not for things like cmin and cmax, but I
use ctid a lot, and would be quite thrown off if a table suddenly were
allowed to create it's own ctid column that did not behave as the current
one does. Perhaps if it was called "
401 - 423 of 423 matches
Mail list logo