ould never occur due to a invalid statement name.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200406252215
-BEGIN PGP SIGNATURE-
iD8DBQFA3ODAvJuQZxSWSsgRAun9AKCAy13RU4mJ14J9bihiPVm15kvitACghTKv
GgSrqeg9MRROXEwP+AuLSqM=
=Tq9h
-END PGP SIGNATURE-
-
vincing argument for a change,
considering that prepared statements are very explicitly declared
and cannot be seen outside of their own connection.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200406242200
-BEGIN PGP SIGNATURE-
iD8DBQFA24ehvJuQZxSW
;s own "namespace" of prepared statements. Since they last until
an explicit deallocate, the simple use of unique names makes it
fairly easy on the application side.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200406232330
-BEGIN PGP SIGNATURE-
iD8DBQFA2krxv
ing and broken,
and should be scrapped in favor of a simple "what you see is what you get"
behavior, just like every other configuration file.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200406151936
-BEGIN PGP SIGNATURE-
iD8DBQFAz4iBvJuQZxSWSsgRAkO
ed, and
also assumes that you are reading it in a different context than from within
the configuration file.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200406100751
-BEGIN PGP SIGNATURE-
iD8DBQFAyE0rvJuQZxSWSsgRAqL3AJ0eR28O8LyWV3Kn5wgMtggqJi8/nACeI/JC
e will be allowed to use up to the value set here before it starts to put
data
## into temporary files. Also, several running sessions could be doing sort operations
## simultaneously. So the total memory used could be many times the value set here.
work_mem = 1024
- --
Greg Sabino Mulla
Generated
statements are simply named "dbdpg_1", "dbdpg_2", etc. and the
increment is increased only after a statement is created successfully.
There is also support for user-created (and user-named) statements,
with the caveat that it is up to the user, not DBD::Pg, to watch for
nam
o
understand the new feature from a developer's perspective.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200405182046
-BEGIN PGP SIGNATURE-
iD8DBQFAqq6GvJuQZxSWSsgRAuruAKCkzWbtYcfu9DR+f4JUHKPWjaPiswCg/Vcf
ZGLywaE2OOgr3Mk+Kua1fUA=
=vqHP
-END PGP SIGNATURE---
hat server it is running
against. Whenever possible, is now uses the new protocol version
information. It's much handier to just say:
if (protocol>=3) {
...
}
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200405112153
-B
ect 1 from pg_procc;
ERROR: relation "pg_procc" does not exist
pgf=> prepare yourself as select 1 from pg_proc;
ERROR: current transaction is aborted, commands ignored until end of transaction block
pgf=> rollback;
ROLLBACK
pgf=> deallocate toqualify;
DEALLOCATE
- --
Greg Sabino
ems to make the most sense. If the user does
not want it to get rolled back, let them commit it before going on
to the rest of the actions.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200405011816
-BEGIN PGP SIGNATURE-
iD8DBQFAlCIivJuQZxSWSsgRAun5AKCUWH3mb59c+iua
BI
is and gives links to DBI and DBD::mysql, both hosted on cpan.org.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200404230734
-BEGIN PGP SIGNATURE-
iD8DBQFAiQBDvJuQZxSWSsgRAqn5AJ4pEllgPCiTVfAcrK21r62RgD1tdACg4IHz
hAb4LBiqlIMbBF2bs
ptic about
what exactly the problem was). Thanks for the replies: I am going to push
for a shmmax boost and go from there. Less pain in the long run.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200404052013
-BEGIN PGP SIGNATURE-
iD8DBQFAcfbavJuQZxSWSsgRAr1
anyone familiar with these can assert that a low shmmax also affects
their performance, that would be helpful in my argument to bump it up for
the PG install.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200404050713
-BEGIN PGP SIGNATURE-
iD8DBQFAcUE6vJuQZxSWSsgRAr80A
limitation? I know
that 50 is pretty low, but the recommended way (changing shmmax)
involves rebooting a production machine and, while possible, is
not preferred. (This is for a very small database, and having a
very low shared buffers is acceptable.)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key
due to the lack of response on general)
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200402172039
-BEGIN PGP SIGNATURE-
iD8DBQFAMsKDvJuQZxSWSsgRAtbeAJ9mmm3TKSU/hLc+oN3RREzCnM7kkQCfS4TS
6UoHDhGLc8kNyG7F/pT/6IM=
=Lg+O
-END PGP SIG
em to recall some past discussion about making "help"
work in psql, but cannot remember the final outcome. Any
chance we can revisit it? I think it would be a worthwhile
addition.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 20040104144
-
Tid Scan on pg_class (cost=0.04..4.05 rows=2 width=4) (actual time=0.00..0.00 rows=0
loops=1)
Filter: (ctid = $0)
InitPlan
-> Limit (cost=0.00..0.04 rows=1 width=6) (never executed)
-> Seq Scan on pg_class (cost=0.00..9.30 rows=230 width=6) (never executed)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The archives for the following mailing lists appear to
have two identical links to November 2002:
admin
advocacy
announce
bugs
cygwin
Here's one of them:
http://archives.postgresql.org/pgsql-announce/
Greg Sabino Mullane [EMAIL PROTECTED
nt behavior can be a bit confusing, in that
some functions have implicit wildcards (\dt and friends) and some do
not (\d).
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200208091849
-BEGIN PGP SIGNATURE-
Comment: http://www.turnstep.com/pgp.html
iD8DBQE9
SQL
statement such as "SELECT * FROM foo;" This is of course the original
temp table problem with psql.
At any rate, I will play with the RelationIsVisible stuff when somebody
writes a SQL interface to it (or I write it myself, but that will take
quite a long time :)
Greg Sabino Mul
s like this. Release more often, even if more minor:
stick to beta deadlines strictly. Offer success stories.
15. Don't shoot the messenger. Some of this is my opinions, some is based
on talking to "everyday users" and developers about Postgres.
Greg Sabino Mullane [EMAIL PROTECTE
r using it? This one, maybe?:
http://developer.postgresql.org/TODO/docs/cvs.html
Thanks,
Greg Sabino Mullane
[EMAIL PROTECTED] PGP Key: 0x14964AC8 200110060755
-BEGIN PGP SIGNATURE-
Comment: http://www.turnstep.com/pgp.html
iQA/AwUBO77yubybkGcUlkrIEQKYCQCfW9SRNR3WqeHQyDlZ
401 - 423 of 423 matches
Mail list logo