Richard Broersma Jr [EMAIL PROTECTED] writes:
3. If you call currval() will it return 20? I would think it does.
Yes it does.
My understanding is that it will provided your are within a transaction.
As long as you're in the same session you're fine. You would have to go out of
your way
3. If you call currval() will it return 20? I would think it does.
Yes it does.
My understanding is that it will provided your are within a transaction.
As long as you're in the same session you're fine. You would have to go out of
your way to break it but if you're using some
# [EMAIL PROTECTED] / 2006-07-07 14:08:08 -0600:
--On July 7, 2006 12:35:53 PM + Roman Neuhauser [EMAIL PROTECTED]
wrote:
# [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
OK I know this is an odd question but I'm working on an app that will
rely more and more on database driven
Hi,
We´re looking for a replication solution that could address the following
situation: every morning our sellers connect to the master server and make a
copy of all tables they will need during the day to their laptop database.
After a day of work, with a lot of work done at their local
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Carlos H. Reimer
Sent: 09 July 2006 12:17
To: pgsql-general@postgresql.org
Subject: [GENERAL] Mobile servers replication
Hi,
We´re looking for a replication solution that could address
the
rstp [EMAIL PROTECTED] writes:
pg_config is telling us that we are running version 7.3.6-RH, but when
we start psql it shows that we are running 8.1.4 (which is the correct
version).
[EMAIL PROTECTED] bin]$ pg_config --version
PostgreSQL 7.3.6-RH
[EMAIL PROTECTED] bin]$ which
Richard Broersma Jr [EMAIL PROTECTED] writes:
Just to clarify, currval() is isolated by the session on not
necessarily by a transaction?
Yes, this is spelled out quite clearly in the docs if you care to read
them. :)
-Doug
---(end of
On Sat, Jul 08, 2006 at 11:02:26PM -0700, Richard Broersma Jr wrote:
3. If you call currval() will it return 20? I would think it does.
Yes it does.
My understanding is that it will provided your are within a transaction.
As long as you're in the same session you're fine.
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does not have PL/Perl
installed, and a hacker's server B (let's
On 7/9/06, Mark Morgan Lloyd [EMAIL PROTECTED] wrote:
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does
Merlin Moncure wrote:
Similarly, if I have PostGIS or PL/R on the hacker's server, or- heaven
forfend- both, is the best way to get at the production server still to use
dblink?
dblink allows you to send queries from one server to another in a
couple of different ways. What the
On Sun, Jul 09, 2006 at 12:40:56PM +, Mark Morgan Lloyd wrote:
I know that the FAQ says that the only way to implement a query
across databases is to use dblink,
The FAQ doesn't say dblink is the only way, it says contrib/dblink
allows cross-database queries using function calls. However,
On Fri, Jul 07, 2006 at 04:53:14PM +0200, Martijn van Oosterhout wrote:
On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote:
I am the maintainer of Debian's packages for exim4, a powerful and
versatile Mail Transfer Agent developed in Cambridge and in wide use
throughout the Free
Hi,
On Fri, Jul 07, 2006 at 05:15:11PM +0200, Martijn van Oosterhout wrote:
On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote:
From what I understand, the correct way would be to use
PQescapeStringConn, but that function needs an established connection,
and exim performs string
On Sun, Jul 09, 2006 at 03:00:08PM +, Mark Morgan Lloyd wrote:
The other thing that I'm thinking is that it's quite possible that (as
hypothetical examples) PL/Perl, PostGIS and PL/R wouldn't be happy on the same
machine, at which point the only way to merge their functionality in complex
* Martijn van Oosterhout:
* If application always sends untrusted strings as out-of-line
parameters, instead of embedding them into SQL commands, it is not
vulnerable.
This paragraph should explictly mention PQexecParams (which everybody
should use anyway).
It seems that Exim's
On Sun, Jul 09, 2006 at 06:16:48PM +0200, Marc Haber wrote:
I'd suggest adding a PQsetClientEncoding(conn, Latin1) right after
you establish a connection. I'm not sure if Exim has any kind of
declaration about what encoding strings have internally.
No, it does not.
That's your
Mark Morgan Lloyd wrote:
Thanks for that. One of the reasons that I am contemplating this is that when
I
built the server it wouldn't build PL/Perl since the underlying distro didn't
provide a libperl.so file. Now I could obviously recompile the distro's Perl
sources but that would mean I'd
Marc Haber wrote:
Please note that exim is so flexible that it is possible to implement
mail spool storage in an SQL database. In this case, we'd write data
which originated in an untrusted source to the database, not knowing
about encoding at all.
If you are going to store things in
With the untrusted version of a language you can do essentially
anything that language supports. For example, with plperlu, you
could use DBI to open a connection to another database (even another
DBMS like Oracle, MySQL, etc.), issue a query, fetch the results,
and do whatever you want with
On 7/7/06, Francisco Reyes [EMAIL PROTECTED] wrote:
I am currently using a log with the file name format:
log_filename = 'postgresql-%Y-%m.log'
Is there any way to change the filename do start witht he database name?
For now just added to add the database name to each line, but it would be
Michael Fuhr wrote:
The other thing that I'm thinking is that it's quite possible that (as
hypothetical examples) PL/Perl, PostGIS and PL/R wouldn't be happy on the
same machine, at which point the only way to merge their functionality in
complex work would be to use a farm.
What sort
Alvaro Herrera wrote:
I'm considering building a .so on a scratch machine and copying it to the
production server but I'm not confident that I understand every possible
implication.
Or maybe you could install the development Perl package, which at least
on some distros I know include the
Jaime Casanova writes:
so you want a different logfile for every database you connect to?
An option to specify a log for database.
where do you will log database shared operations like autovacuum, role
creation, maybe even a database creation, tablespace creation, etc...
In a global
Douglas McNaught wrote:
rstp [EMAIL PROTECTED] writes:
pg_config is telling us that we are running version 7.3.6-RH, but when
we start psql it shows that we are running 8.1.4 (which is the correct
version).
[EMAIL PROTECTED] bin]$ pg_config --version
PostgreSQL 7.3.6-RH
[EMAIL
On Saturday 08 July 2006 22:34, Michael Glaesemann wrote:
On Jul 8, 2006, at 9:57 , [EMAIL PROTECTED] wrote:
FTS will get more and more important for a DBMS system, i think pgsql
should also consider improving this, isn't?
I believe a very common FTS solution used with PostgreSQL is
Hi, I've been trying to see whether or not autovacuum is vacuuming all
of my tables, and how often (for my peace of mind). I can see that it is
running, but I don't know what it's doing. There are a handful of key
tables in our database which suffer quite a bit if their not vacuumed
regularly
27 matches
Mail list logo