Clodoaldo escribió:
> 2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>:
> > A quick look into pg_locks should tell you if it's blocking.
>
> pg_prepared_xacts is empty and pg_locks has 288 rows:
>
> # select locktype, mode, count(*) as total
> from pg_locks gro
ey preprocess a different
repository in order to create an obfuscated GPL source tree.
(I have a memory of comments in the source that looked like it referred
to some internal knowledge base or bug tracking system. But frankly it
is a dim memory and could very well be related to the PHP source o
all methods and functions). Have I to Lock the table, perform some
> operation on this table, and unlock the table all in the same function
> scope?
What do you mean it doesn't work? How exactly it fails?
If anything, I'd suggest to send the LOCK TABLE in a separate PQexec()
c
Steve Crawford escribió:
> Alvaro Herrera wrote:
>> Also, it is MVCC-safe only from 8.3 upwards; on older versions
>> it (incorrectly) deletes dead tuples that are still visible to old
>> transactions.
>
> More interesting. I may have a broken mental-model. I *thought
somebody already holds the lock, so
your LOCK TABLE is just waiting for the holder to release it ...
Have a look around the pg_locks view.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
-
s how much shared memory the server will
use.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
/pgSQL does no
caching at all for that query, and asks the planner for a new plan each
time.
Also, new in 8.3 is a facility for "plan invalidation", which means that
every time the server executes something that makes that plan stale, the
cache is dropped and the plan is rebuilt next time
's something like
> execute select res fron functionB() into _res;
> since the "complicated" part is inside each functionB I shouldn't
> expect any great loss.
>
> Is it?
Correct -- the part that's being discarded each time here is the SELECT
that
to a column after creation created issues, versus using the
> serial type which did not.
He is wrong in that you *can* attach the same information that SERIAL
does if you use ALTER SEQUENCE .. OWNED BY after the fact. If you
don't, then he's right. pg_dump d
srdjan wrote:
> /*
> *My goal is to calculate and insert automatically the value of "tot"
> when I insert a row into table b.*
> */
Use a trigger. It's a lot simpler.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Repl
e argument type(s) as well.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Please stop reposting your questions to multiple groups. Since all your
questions are about performance, please stick to the pgsql-performance
list. Posting to pgsql-sql is not really appropriate, and in
pgsql-admin you're totally off-topic.
--
Alvaro He
8.0 I'm not sure.
Was this issue solved?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
o do.
> Perhaps something like changing "postmaster" to "postgresqld",
It is already called "postgres" on newer versions.
> "pg_ctl" to "safe_postgresqld",
Now that's plain weird.
--
Alvaro Herrerahttp://w
ch were a step towards that goal. (The point here is that a hot
standby needs to be able to execute readonly transactions.)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-
>
> That sort of looks like it could be data loss, can someone explain what
> happened?
It means someone extended the table, but didn't get around to actually
putting tuples on it and committing. Four transactions were doing this
when the system crashed. No co
xec them.
> If we are OK with restricting the scope of the "pg" program to
> client-side functionality, then there's no problem.
Perhaps we can put the server-side functionality on pg_ctl.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The Postgr
e it
conflicts with pg_ctl on 4 chars before presenting a useful tab
completion on the shell. Sadly, pg is already taken so we would need to
find an alternative.
Also I would vote for less verbose names -- pg vacuumdb, etc, and not
"pg database vacuum".
--
Alvaro Herrera
were all
> > contiguous though. Do you know that this table was under heavy insert
> > load at the time?
>
> It was. This table is an insert only log table that was being heavily
> was being heavily written to at the time of the crash.
Is it possible
Greg Smith wrote:
> And if anybody suggests putting a "_" in something I have to type all the
> time, I will stick my fingers in my ears and start yelling until they
> stop. Bad enough I have to type pg_ctl a few times every day now.
alias pgctl=pg_ctl
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Greg Smith wrote:
> >> And if anybody suggests putting a "_" in something I have to type all the
> >> time, I will stick my fingers in my ears and start yelling until they
> >>
Zdenek Kotala wrote:
> And what about two commands one for create and one for drop?
> It save 6 or 4 chars.
>
> pgc db (as create db)
> pgc user
> pgd db (as drop db)
> pgd user
Well, there are things besides create and drop -- for example vacuum
Dawid Kuroczko escribió:
> On Thu, Mar 27, 2008 at 11:49 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> > pgc cluster
>
> Agree, except I would prefer "pg" instead of "pgc".
pg is already taken by an ancient Unix pager utility (predecesso
gt; be related to using an old version of "tar" that fails to extract such
> long filenames correctly. Please install the latest tar you can get
> your hands on, and see if it gets better...
Also, do not use Midnight Commander to extract the files.
--
Alvaro Herrera
have
> to handle temp tables in plpgsql functions via EXECUTE?
Yes, it should work on 8.3.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-gene
, because there's no need for the index entries
at all.
If you want to test, try SET enable_seqscan TO 0 and then rerun the
explain analyze. My bet is that it will use the index, and it will take
longer.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The P
ing. (They would have a very old
relfrozenxid.)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
Tom Lane escribió:
> What I think you'll find, though, is that once you do force an indexscan
> to be picked it'll be slower. Full-table index scans are typically
> worse than seqscan+sort, unintuitive though that may sound.
Hmm, should we switch the CLUSTER code to do that?
nt the kind of "distinct scan" that you suggest, even though it
certainly is a nice idea.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
f pgsql?
You should request that to your package provider.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
openssl.org/news/changelog.html
http://www.columbia.edu/~ariel/ssleay/stack.html
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@pos
y?, Any other idea?.
Hmm, nope -- take away the relnamespace check, because there is a
different namespace for each backend (pg_temp_2, pg_temp_3, etc). And
as far as I've seen, most leftover temp tables are on "high" temp
schemas (i.e. those belonging to backends that are only us
Manuel Sugawara wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>
> > Hmm, nope -- take away the relnamespace check, because there is a
> > different namespace for each backend (pg_temp_2, pg_temp_3, etc).
>
> Still no luck, changed the query to:
>
>
, len = 64, typmod = -1, byval = f)
> 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byval = t)
> 1: relname = "pg_auth_members"(typeid = 19, len = 64, typmod = -1,
> byval = f)
> 2: age = "2146484675" (typeid = 23, len = 4, typmod = -1, byva
se out in
500k transactions ...
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
to the fact that they can only be vacuumed by
a superuser, but in a standalone backend you are always superuser. So
if you ran a database-wide vacuum, they should have been processed.
What happens if you try "vacuum pg_database", etc? Does the
age(relfrozenxid) change
re than enough. For the rare cases that it's not, you can
use CLUSTER to compress the dead space.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing lis
rsion. After that, we shutted down the
> Postgres service and restarted the service again.
>
> The problem is that the folder where the tablespace of the database is
> placed has been removed.
I assume you understand that was a pretty silly thing to do. Do you
have back
cation functions, such as isupper(3) and toupper(3), and the
multi-byte character functions such as mblen(3) or wctomb(3).
On my system, though, locale does report the full locale, not just
encoding, when I change LANG.
--
Alvaro Herreraht
;t. If it did, it'd be at least as
> large as timetz.
Hmm, so timetz does that? Amazing ... I didn't know that.
Which means that storing date + timetz in two separate columns is not
quite the same as storing a timestamptz. Oops.
--
Alvaro Herrerahttp
() now?
> (I use my own datatype which is similar to varchar/text
> and for a CREATE CAST (int8 as myType) WITH FUNCTION myFunction(int8) AS
> ASSIGNMENT;
> I call the int8_text() function.)
IIRC the casts now use the type's output function. I'm guessing you
should be ab
e from the central server to the branches.
>
> Try with bucardo ("http://bucardo.org/";) may be help you :).
Unfortunately, Bucardo only seems to work with 2 masters -- you can't
have 20.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The Post
Craig Ringer escribió:
> It's not stated explicitly, but I'm pretty sure discussion here has
> mentioned that too. Given that, VACUUM FULL on a just-CLUSTERed table
> should be redundant.
It is, and a REINDEX is redundant too because CLUSTER does it
internally.
ardo.html#BucardoLimitations
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
Rodrigo Gonzalez escribió:
> Yes and no
>
> bucardo cannot handle master-master-master
>
> What I am doing is
>
> masterA-masterB
> masterA-masterC
> masterA-masterD
Oh, I see -- makes sense. Quite misleading docs, then.
--
Alvaro Herrera
ld end up
pointing to incorrect places in the heap.)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
ld be unable to help you upgrade
here. Obviously you can upgrade one database at a time.
Also, mostly it's not the database size what's a concern, but rather the
size of the largest table.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL
Joshua D. Drake wrote:
> On Fri, 18 Apr 2008 14:59:34 -0400
> Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> > I find it pretty unlikely that Slony would be unable to help you
> > upgrade here. Obviously you can upgrade one database at a time.
> >
> >
ose still have an effect in
versions earlier than 8.3.)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
-
PostgreSQL 8.4devel on x86_64-unknown-linux-gnu, compiled by GCC gcc-4.1 (GCC)
4.1.3 20080114 (prerelease) (Debian 4.1.2-19)
(1 fila)
So I'm thinking you've got encoding problems. Did you set up
client_encoding app
seeing schedrec
> correctly. Which part should be in an execute query statement?
All sentences referring to the temp table.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list
remove the old rows?
It does.
> -With autovacuum, does it skip these rows still being referenced in a
> transaction or does it wait?
It skips them, the idea being that a future vacuum will remove them.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
P
- for example when setting up large
replication sets with Slony, or during a pg_dump, no dead rows can be
removed. Since the Slony thing can take a very long time, dead rows
start to pile up in a way that can really harm performance.
We're currently working on it so tha
, or PL/SQL
words differently on Oracle. If either of these cases is true, we will
need to attack the problem sooner or later.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list
ing on Postgres as "not a transaction".
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
at the current ENUM implementation is
completely new.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
esql table?
> >
> > You can add comments: COMMENT ON IS 'text' - see
> > manuals for details.
>
> However, COMMENTS don't append.
But you can add one to the new column.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The P
pare the stats, so you should theoretically get more
>> accurate stats for the other columns too, even though they'll still get
>> boiled down to the same array lengths as before.
How larger is the sample, I don't know.
--
Alvaro Herrerahttp
autovacuum.freeze_max_age).
Hmm, maybe it's called max_freeze_age, I don't recall offhand.
Beware of the pg_autovacuum column being zero.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via
384 | pslogin | COMMIT | f
>| 2008-04-24
Do you have deferred constraints? Maybe some of them are missing
indexes.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-g
so often.
Agreed, that's a good strategy. You only need to keep an eye on how
often is pg_clog going to be trimmed. (The only disadvantage is how
much spaces it occupies on disk.)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consult
ind anything very helpful. If not, could
> someone help me understand what my c struct would look like and what values
> I need for INTERNALLENGTH, ALIGNMENT, STORAGE, etc in the CREATE TYPE
> command?
Probably what's biting you is that the type needs to be
pass-by-reference a
and start testing, does this mean
> auto-vacuum won't analyze it? Is this maybe related to question
> 1 where I think auto-vacuum actually wasn't running?
It might mean it hasn't been analyzed _yet_. If there are too many
databases, it may take a while.
--
Alvaro Herrera
doesn't yet handle
> error cases. How liberal should we be about capitalization, spelling,
Hmm, there's already code for parsing boolean variables in psql, see
ParseVariableBool.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - C
e any manual re-sync steps before it can
>>> resume recovery?
>>
>> I think you'll need to redo the whole process : restore the full data
>> backup, create the recovery.conf file, etc.
No, you don't. The server can continue replaying files.
--
Alvaro Herrer
David Fetter escribió:
> Thanks for the heads-up :)
>
> Second patch attached, this time with some docs.
Added to July commitfest.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Tom Lane escribió:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > David Fetter escribi�:
> >> Thanks for the heads-up :)
> >>
> >> Second patch attached, this time with some docs.
>
> > Added to July commitfest.
>
> Surely this is mer
igned is the default mode, \a should not toggle
between last state and aligned, but rather between last state and
unaligned. Which makes it a misnomer.
Or maybe the thing to do is leave them damn well alone and just fix
\timing.
--
Alvaro Herrerahttp://www.Comman
exit 0;
> fi
> # startup triggered
> if test -f $triggerfile; then
> exit 0;
> fi
> sleep 2;
> done
> --snipp--
You should not remove the segment until it's no longer needed. To
figure that out you can use %r of restore_command.
--
Alvaro Herrera
er machine I could try
> to connect from.
There are no other negotiation ports in PostgreSQL.
What's the exact error message you're getting?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via p
problem is that it does a table scan only to find that all values
are NULL, which is pretty pointless.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general
tion to psql, I think, but check the manual).
>
> There's probably a way to turn off tab-completion without
> disabling readline altogether, but I don't know how offhand.
This can be done by adding
$if psql
set disable-completion on
$endif
to .inputrc.
--
Alvaro Herre
ssed something on the install). Hope that helps
Do you have CSV logging enabled?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
Celso Pinto wrote:
> So my questions are: is this at all possible? If so, is is possible to
> increate that maximum size?
Indexing the arrays themselves is probably pretty useless. Try indexing
the elements, which you can do with the intarray contrib module.
--
Alvaro H
uot;not
valid/ready").
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Ati Rosselet escribió:
> sorry, forgot to cc: to the group..To: Alvaro Herrera <
> [EMAIL PROTECTED]>
>
>
> not as far as I can tell... I have log_destination='stderr'. unless csv
> logging is enabled in another location?
No, that should mean it's disa
Celso Pinto wrote:
> What, if any, would be the recommended options to improve this
> scenario? Not using intarray? :-)
Not using a broken design. Arrays are a poor fit in the relational model.
Avoid them.
--
Alvaro Herrerahttp://www.CommandProm
t
> me in the right direction, I'd appreciate it.
Huh, you really need a proper hex editor. Try "hexedit" for example.
And you need to convert the values to hexadecimal.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consu
a recent release. 8.0 is an old
release.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postg
eed the data. The new server already has
> the table structure, I just need the most current data to put into the
> server.
Yes, you can use COPY table TO STDOUT. This can probably be piped
directly from one server to the other.
--
Alvaro Herrerahttp:
sufficiently similar to make the deltas small enough to
> warrant this approach?
Hmm, perhaps a not completely insane thing to do would be to use another
pg_dump "format" (i.e. a new -F option) which installs stuff on a GIT
repo.
--
Alvaro Herrerahtt
etween two dumps of the same table. To get any benefit, you'd need to
get pg_dump to dump sorted tuples.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it.
Unless I'm misunderstanding the issue completely.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
st postgres 2008-06-19 17:58:05.185 EEST LOG: duration:
> 2315.420 ms statement: EXECUTE foo(1000);
The parameter is on the above line, isn't it?
> migration_test postgres 2008-06-19 17:58:05.185 EEST DETAIL: prepare:
> PREPARE foo (int) AS SELECT S.i * T.i FROM generate_s
s numbers for all the lock modes
> and just test to see if one lock is higher than another.
This is not always the case.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-ge
note this?
Absolutely. Care to submit a patch?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
Antonio Perez wrote:
> example
>
> SELECT name FROM table1 where name
> ~* '*Ã*'
Actually this regex is flawed. It looks like a common shell "glob"
pattern (I don't know the real name of these things), which is a very
different and simpler ani
just need to be able to pass the list
of affected tuples to the trigger function, which until now has remained
unimplemented.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-gen
f7a039648990d1037119efb61146d
(This is the HEAD version of the patch; 8.3 should be identically
patched.)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
gs are fixed" (or very
quickly if a security problem is found), so you could be waiting for a
while.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Amanece. (Ignacio Reyes)
El Cerro San Cristóbal me mir
e stealthily.
Maybe it's something we're being linked against -- pthread perhaps?
OpenSSL? Maybe you'd have more luck if you noted what is libpq doing
when this invalid free is called. Perhaps call abort() and get a stack
trace from the resulting dump.
--
Alvaro Herrera
Nico Sabbi wrote:
> Alvaro Herrera ha scritto:
>>> I'm not speaking of object ownership, but of GRANTs.
>>
>> As Tom says, it's a known limitation. Did you try REASSIGN OWNED and/or DROP
>> OWNED?
> No, I didn't because the tables weren't o
e it would be better if the dump has a RESET default_tablespace
before the SET.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-gen
h of pages with only dead tuples at the start of the
table? Maybe a lot of empty pages at the start of the table (If this
is 8.3 you have to consider sync_seqscan as well)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
-------
PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian
4.3.3-3) 4.3.3
(1 fila)
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ng an AT TIME ZONE 'UTC' specification,
which will cause it to be turned into a plain timestamp (without tz).
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-gen
alias my_sequence_alias for my_sequence;
> select nextval('my_sequence_alias');
No. What would this be used for?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing lis
t; facilities yourself.
I have added this to the FAQ
http://wiki.postgresql.org/wiki/FAQ#Is_there_a_way_to_leave_an_audit_trail_of_database_operations.3F
... he says, hoping that it'll help generate interest in getting the FAQ
updated ...
--
Alvaro Herrera
month.
Sounds a bit like what Truviso does ...
--
Alvaro Herrera
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ctionality by setting up a prepared
> >statement to define the function call. Then, executing the statement
> >with binary transmission of parameters and results substitutes for a
> >fast-path function call.
--
Alvaro Herrerahttp://w
701 - 800 of 2203 matches
Mail list logo
