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
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$
>
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
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.
>
>
> ---
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
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 y
On Sun, Sep 16, 2007 at 01:46:44PM +0300, Panagiwths Pediadiths wrote:
> Many transactions doing this in parallel end up inserting the value many
> times. Could i be missing something regarding how to set up the isolation
> level?
> Thanks!
No, the only easy way you can guarentee you won't insert
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.
http://www.postgresql.org/docs/8.2/static/tran
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 allo
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 f
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.
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
---
12 matches
Mail list logo
