I've just committed a log-parsing front-end for mk-query-digest, a
tool included in Maatkit, so it can parse and analyze Postgres log
files. I encourage people to try this functionality and give feedback
by replying here, adding to
http://code.google.com/p/maatkit/issues/detail?id=535, or jumping
Thomas wrote:
> File -> Options -> User Language -> English
>
> works for me
*groan*
I was looking at that dialog, but still missed that. Thanks again!
Regards,
--
Nils Gösche
"Don't ask for whom the tolls."
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Nils Gösche wrote on 20.02.2010 00:20:
set LC_MESSAGES=English
Yes, that works very well for psql, thanks! However, pgAdmin is still in
German. Any other trick?
File -> Options -> User Language -> English
works for me
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Thomas wrote:
> set LC_MESSAGES=English
Yes, that works very well for psql, thanks! However, pgAdmin is still in
German. Not even setting LC_ALL to en_US seems to help. Any other trick?
Regards,
--
Nils Gösche
"Don't ask for whom the tolls."
--
Sent via pgsql-general mailing list (pgsql
Nils Gösche wrote on 19.02.2010 23:29:
Hi!
I am running PostgreSQL on a German Windows machine. Client programs like
psql and pgAdmin are printing German translation strings everywhere, even
though I told the installer to use English/United States locale. How can I
disable all translations and s
Hi!
I am running PostgreSQL on a German Windows machine. Client programs like
psql and pgAdmin are printing German translation strings everywhere, even
though I told the installer to use English/United States locale. How can I
disable all translations and simply use the English version of all prog
Job Responsibilities
The Sr. Linux Systems Architect will be responsible for production and
supporting infrastructure behind the WordStream Suite of products.
If you enjoy a startup experience which is both challenging and very
rewarding, then this is the position for you! As a part of a small
t
Hello,
After I install PostgreSQL to Windows Server 2008, I cannot connect to
it through another computer. I believe the Window's firewall is
blocking the traffic.
So I go to the firewall setup to create a new "Inbound" rule. When
creating a "Custom-type" rule to specify the details, I hav
Is changing the OS/X wal_sync_method default something we should
consider?
---
Greg Smith wrote:
> Michael Clark wrote:
> > The solution to the problem seemed to be to change the value for the
> > wal_sync_method setting to
On Thu, Feb 18, 2010 at 11:08 PM, Scott Marlowe wrote:
> Oracle and postgres are definitely different here. There's really no
> equivalent to rowid in pgsql. oid has no special optimizations. An
> indexed PK of a serial is about as good as it gets, possibly
> clustered.
access by CTID is the f
David Fetter writes:
> On Fri, Feb 19, 2010 at 12:07:42AM -0500, Tom Lane wrote:
>> SQL:1999 and later use a slightly different definition which is not
>> entirely upward compatible with SQL-92. In most cases, however,
>> PostgreSQL will interpret an ORDER BY or GROUP BY expression the
>> same way
On Fri, Feb 19, 2010 at 12:07:42AM -0500, Tom Lane wrote:
> Lew writes:
> > Eric B. Ridge wrote:
> >> That explains it. Thanks. Breaks the rule of least surprise,
> >> but it is SQL.
>
> SQL:1999 and later use a slightly different definition which is not
> entirely upward compatible with SQL-92
"mike stanton" writes:
> I have a problem compiling pgc programs with ecpg.
> I always get the following error:
> /usr/local/pgsql/lib/libpgtypes.a(timestamp.o): In function `timestamp2tm':
> timestamp.c:(.text+0x2fc): undefined reference to `rint'
Seems like you need to add "-lm" to your link c
I have a problem compiling pgc programs with ecpg.
I always get the following error:
/usr/local/pgsql/lib/libpgtypes.a(timestamp.o): In function `timestamp2tm':
timestamp.c:(.text+0x2fc): undefined reference to `rint'
Version: PostgreSQL 8.3.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4
On 19/02/2010 13:10, Heddon's Gate Hotel wrote:
> I've installed postgreSQL 8.4 on a Windows XP machine, and I can't get
> it to start. Choosing Start Server from the menu produces a DOS box
> that remains blank for about 3 minutes, then comes up with this error
> message:
>
> The postgresql-8.4
I've installed postgreSQL 8.4 on a Windows XP machine, and I can't get
it to start. Choosing Start Server from the menu produces a DOS box
that remains blank for about 3 minutes, then comes up with this error
message:
The postgresql-8.4 service is starting.
The
It is...
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# SELECT version();
Jayadevan M escribió:
> I am an Oracle guy who is learning PostgreSQL. oid sounded a lot like
> rowid in Oracle. In Oracle, access by rowid is expected to be the fastest
> way of accessing a record, faster than even an index access followed by
> table access using the primary key. That was why
Exactly the same!
Thanks a ton.
On Fri, Feb 19, 2010 at 3:58 PM, Magnus Hagander wrote:
> 2010/2/19 Jignesh Shah :
> > Hello All,
> >
> > I have created role "database-users" and inserted some of users inside
> it. Could you tell me which query to use for listing out those users name? I
> went t
On 19 Feb 2010, at 6:42, Yan Cheng Cheok wrote:
>-- HOW?!?!
>--ERROR: column "rowcount" does not exist
>--LINE 1: SELECT @@ROWCOUNT=0
>IF @@ROWCOUNT=0 THEN
> EXECUTE 'INSERT INTO statistic(fk_lot_id, "value", measurement_type,
> statistic_type) VALUES ($1, $2, $3, $4)'
>
On 18 Feb 2010, at 18:47, Chris Barnes wrote:
> Right you are, I'm due to upgrade end of month on this system.
> Here I was thinking 8.4. Sorry for the spam.
>
> Chris
>
>
> [postg...@pgprd01:~/pgcheck]$ psql
> Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
> Type: \copyright f
I suppose some workaround would be to introduce temporary cursor:
CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$
declare _tmp record;
begin
select * from A1() as dummy ( x double precision ) into _tmp;
end;
$BODY$ LANGUAGE 'plpgsql';
But I'm not sure if this is more effiecent than A3 r
2010/2/19 :
> I suppose some workaround would be to introduce temporary cursor:
>
> CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$
> declare _tmp record;
> begin
> select * from A1() as dummy ( x double precision ) into _tmp;
> end;
> $BODY$ LANGUAGE 'plpgsql';
>
> But I'm not sure if thi
On 19/02/2010 09:59, wilcza...@op.pl wrote:
> Hi Ray, thanks for reply. Your solution needs to be modified with alias to
> get executed properly:
>
> CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$
> begin
> select * from A1() as dummy ( x double precision );
> return;
> end;
> $BODY$ LA
And what about that :
http://www.postgresql.org/docs/8.4/interactive/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET
Maybe my french english disallowed me to understand right the question,
but I think that this item could help in a way!
Le vendredi 19 février 2010 à 11:04 +0100, Pavel Stehule a
2010/2/19 Jignesh Shah :
> Hello All,
>
> I have created role "database-users" and inserted some of users inside it.
> Could you tell me which query to use for listing out those users name? I went
> through pg_users, pg_group but no luck.
>
> CREATE ROLE database-users
> NOSUPERUSER INHERIT NOC
Hi Ray, thanks for reply. Your solution needs to be modified with alias to get
executed properly:
CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$
begin
select * from A1() as dummy ( x double precision );
return;
end;
$BODY$ LANGUAGE 'plpgsql';
but when used: select * from A3() it genera
Hi Pavel, thanks for reply. Your solution:
CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$
begin
return query select * from A1();
return;
end;
$BODY$ LANGUAGE 'plpgsql';
generates error "cannot use RETURN QUERY in a non-SETOF function" because A3
returns VOID.
"Pavel Stehule" napisa
Heyho!
I'm writing a little toy project, part of it involves scripts that pre-
process sql and then feed it to psql.
Is it possible to set the input filename / line number in psql?
(Similar to how cpp includes this information so that the compiler can
report the filename/line number of the C fi
2010/2/19 :
> Hi Pavel, thanks for reply. Your solution:
>
> CREATE OR REPLACE FUNCTION A3() RETURNS VOID AS $BODY$
> begin
> return query select * from A1();
> return;
> end;
> $BODY$ LANGUAGE 'plpgsql';
>
> generates error "cannot use RETURN QUERY in a non-SETOF function" because A3
> returns
Hello All,
I have created role "database-users" and inserted some of users inside it.
Could you tell me which query to use for listing out those users name? I
went through pg_users, pg_group but no luck.
CREATE ROLE database-users
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
CREATE ROLE "dbuse
On 19/02/10 05:42, Yan Cheng Cheok wrote:
Of course, I get an error at line :
IF @@ROWCOUNT=0 THEN
May I know what is the correct PostgreSQL syntax for @@ROWCOUNT after update?
Best place for this sort of information is the manuals:
http://www.postgresql.org/docs/8.4/static/plpgsql-statement
Thanks. That worked.
On Fri, Feb 19, 2010 at 2:02 PM, Guillaume Lelarge
wrote:
> Le 19/02/2010 08:21, dipti shah a écrit :
> > Hi,
> >
> > I have executed below queries.
> >
> > CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
> >
> > GRANT ALL ON SCHEMA mydb_schema TO postgres;
> >
> > REVOKE
On 19/02/10 07:21, dipti shah wrote:
Hi,
I have executed below queries.
CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
GRANT ALL ON SCHEMA mydb_schema TO postgres;
REVOKE ALL ON SCHEMA mydb_schema FROM PUBLIC;
user1=> select * from mydb_schema.test1;
ERROR: permission denied for mydb
Le 19/02/2010 08:21, dipti shah a écrit :
> Hi,
>
> I have executed below queries.
>
> CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
>
> GRANT ALL ON SCHEMA mydb_schema TO postgres;
>
> REVOKE ALL ON SCHEMA mydb_schema FROM PUBLIC;
> REVOKE ALL ON FUNCTION mydb_schema.readtable() FROM PUB
Hi,
I have executed below queries.
CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
GRANT ALL ON SCHEMA mydb_schema TO postgres;
REVOKE ALL ON SCHEMA mydb_schema FROM PUBLIC;
REVOKE ALL ON FUNCTION mydb_schema.readtable() FROM PUBLIC;
GRANT EXECUTE ON FUNCTION mydb_schema.readtable() to use
36 matches
Mail list logo
