2007/9/13, Nikolay Samokhvalov [EMAIL PROTECTED]:
Hi all,
does anybody know where to find a good list of PostgreSQL terms
(including both traditional terms and Postgres-specific ones)?
Yes.
Use http://www.postgresql.org/docs/8.2/static/bookindex.html
--
Filip Rembiałkowski
On Thu, 2007-09-13 at 15:13 -0500, Erik Jones wrote:
On Sep 13, 2007, at 3:02 PM, Jeff Davis wrote:
On Thu, 2007-09-13 at 14:05 -0500, Erik Jones wrote:
If you include the -d option pg_standby will emit logging info on
stderr so you can tack on something like 2 logpath/standby.log.
What
On Thu, 2007-09-13 at 11:38 -0700, Jeff Davis wrote:
I think it would be useful if pg_standby (in version 8.3 contrib) could
be observed in some way.
Right now I use my own standby script, because every time it runs, it
touches a file in a known location. That allows me to monitor that file,
On Sat, 15 Sep 2007, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/15/07 19:59, Panagiwths Pediadiths wrote:
On Sat, 15 Sep 2007, Ron Johnson wrote:
On 09/15/07 03:28, Panagiwths Pediadiths wrote:
Thats the fun part, I actually need to allow duplicates in
On 9/15/07, Panagiwths Pediadiths [EMAIL PROTECTED] wrote:
Shouldn't the serializable level prevent these duplicates? As I understand
it serializable
should give the same result as if the transactions were performed the one
after the other.
Well first question: how can I check if autovacuum is working?
On 04/09/2007, Tom Lane [EMAIL PROTECTED] wrote:
Phoenix Kiula [EMAIL PROTECTED] writes:
Basically, what I am missing is some info on actually tweaking the
postgresql.conf to suit my system.
No, that's *not* what you're
On Sun, 2007-09-16 at 09:25 +0100, Simon Riggs wrote:
Well, the definition of it working correctly is that a restored log
file... message occurs. Even with archive_timeout set there could be
various delays before that happens. We have two servers and a network
involved, so the time might spike
Thanks.
On 9/15/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Change made. Thanks. Your documentation changes can be viewed in five
minutes using links on the developer's page,
http://www.postgresql.org/developer/testing.
I've created a new custom datatype
eg:
create type foo as (
id smallint
data1 int
data2 int
)
to view the datatype in psql I do
= \d foo
what is the equilvalent on pgadmin3 or any other SQL query tool?
As i understand from the docs, I can't alter / change the datatype
definition. If I need
On Mon, 2007-09-17 at 09:21 +0800, Ow Mun Heng wrote:
Hi,
I want to use a SRF to return multi rows.
current SRF is pretty static.
create type foo_type as (
id smallint
data1 int
data2 int
)
CREATE OR REPLACE FUNCTION foo_func()
RETURNS SETOF foo AS
$BODY$
SELECT
Alvaro Herrera wrote:
novnov escribió:
I think I get the picture; this post is the closest to making sense to me (my
lack of understanding is the issue, obviously). But:
What's the postgresql client, in a web app?
When you write The web app sets timezone='EST5EDT' and inserts a time of
11 matches
Mail list logo