Hello,
There is also a funny approach here with custom operators and variables
that could be adapted to build a rownum functioanlity in functions
(look for Vladimir)
http://archives.postgresql.org/pgsql-hackers/2008-11/msg00048.php
not very clean, but apparently fast
Marc Mamin
-
Hi,
I'm trying to setup a warm standby using PITRTools. Environment is
CentOS 5.2 x86_64 and PG 8.3.6 from yum.pgsqlrpms.org.
As far as I can tell everything seems to work as expected. After a
successful base backup and issuing cmd_standby -S the standby goes into
constant recovery mode and happ
On Thu, Mar 26, 2009 at 5:10 PM, Scott Marlowe wrote:
> It's also important to point out that writers don't necessarily block
> other writers. As long as they're operating on different ranges of
> the data set. You can have dozens of writers streaming data in with
> differening primary keys all
On Thu, Mar 26, 2009 at 8:55 PM, David Fetter wrote:
> In PostgreSQL 8.4, you'll be able to do:
>
> SELECT
> row_number() OVER (ORDER BY col1) AS i,
> e.col1,
> e.col2,
> ...
> FROM ...
Good news! Better late than never :)
> Until then, there are some ugly, fragile workarounds with
On Fri, Mar 27, 2009 at 10:32:33AM +1300, Tim Uckun wrote:
> > What about running a 32bit build of PG on the 64bit machine?
>
> How would one go about doing something like this?
Depending on your distribution you should be able to install 32bit
binaries alongside 64bit binaries; for example in De
What is the path format for the i (\i) command in the SQL shell?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
What is the path format for the i (\i) command in the SQL shell?
I think it's just as anywhere else on Windows, e.g.
\i c:\path\to\file.sql
Windows support forward slashes as well, only not all Windows programs
do support that (cmd.exe for example doesn't). So, it's worth a try.
>From my experience, you must use the forward slash. Using the backslash may
>give you an error:
\i C:\sql\test.sql
C:: Permission denied
Instead, use
\i C:/sql/test.sql
From: Raymond O'Donnell
To: MDB
Cc: pgsql-general@postgresql.org
Sent: Friday, March 27,
I've had lots of experience fighting with the LOAD FROM command with an
old application using an old version of Informix. When the data to be
loaded is large enough, Informix (dbaccess) hits a wall. Tracking it
down with tools generally shows that zillions of locks are accumulating.
The system th
On Fri, Mar 27, 2009 at 04:45:26PM +0200, Aurimas Černius wrote:
> Windows support forward slashes as well, only not all Windows programs
> do support that (cmd.exe for example doesn't). So, it's worth a try.
Where did you get the idea that cmd.exe doesn't support forward slashes?
It just passes
Hi all,
is possible in PostgreSQL to create query between multidatabase like Sql Server
2005?
An example:
SELECT
db1.a.id FROM db1.a
UNION
db2.b.id FROM db2.b
Where "db1" is a database and "db2" is another database. "a" is a table in
database "db1" and "b" is a table in database "db2"
B
I have a table that is partitioned on a daily basis.
Full text searches used to be respectably fast with large tables (40
million + records) but insert speed would slow down. So I went with a
partitioned approach. But now, it doesn't seem like the indexes are
being used.
Any idea why it would no
On Fri, 2009-03-27 at 10:54 +0100, Hannes Dorbath wrote:
> Hi,
>
> I'm trying to setup a warm standby using PITRTools. Environment is
> CentOS 5.2 x86_64 and PG 8.3.6 from yum.pgsqlrpms.org.
This really should be on the pitrtools list:
https://lists.commandprompt.com/mailman/listinfo/pitrtools
On 27/03/2009 14:28, MDB wrote:
> What is the path format for the i (\i) command in the SQL shell?
I think it's just as anywhere else on Windows, e.g.
\i c:\path\to\file.sql
If there are spaces in the path you may have to enclose it in double-quotes:
\i "c:\path with spaces\file.sql"
R
Happy spring.
I am new to postgres/postgis and am trying to figure out the best way to
approach documenting metadata within postgres. Has there been anything
developed to add FGDC or Dublin Core standard metadata records into postgres
for each table within the database? Is there any program t
Justin Funk writes:
> Any idea why it would not be using the indexes?
The child table you showed us has a btree index on message_index_col,
which is useless for @@ queries. Maybe you forgot to specify the
index type while rearranging the table into partitioned form?
rega
Thank you,
I also found you could drop the "C:" (e.g. "/sql/test.sql") if it is on the c
drive. The backslashes on my system threw the same error..
--- On Fri, 3/27/09, John Cheng wrote:
> From: John Cheng
> Subject: Re: [GENERAL] Postgresql On Windows
> To: pgsql-general@postgresql.org
> Da
MDB wrote:
Thank you,
I also found you could drop the "C:" (e.g. "/sql/test.sql") if it is on the c drive.
to be more precise, you can drop the C: if its the same as the current
default drive for whatever process is reading it. Windows, for legacy
reasons that date at least back to Digita
On Fri, Mar 27, 2009 at 10:32 AM, Will Rutherdale (rutherw)
wrote:
>
> Incidentally, in case people are interested in hearing the follow-up to
> my original message, my home-cooked benchmark with lots of processes
> doing tons of updates seemed to initially show MyISAM winning over
> Postgres.
>
>
I see. Perhaps earlier I alienated some people by talking about
transactions per second, which is not necessarily an appropriate unit.
Thanks for the tip.
-Will
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: 27 March 2009 16:08
To: Will Rutherdale (ruthe
On Fri, Mar 27, 2009 at 2:27 PM, Will Rutherdale (rutherw)
wrote:
> I see. Perhaps earlier I alienated some people by talking about
> transactions per second, which is not necessarily an appropriate unit.
Hard to say, tps is still important. A lot of loads need to change
one thing in a transact
I had given reply abt windows
From: Shoaib Mir
To: Dhaval Jaiswal
Cc: Kent Tong ; pgsql-general@postgresql.org
Sent: Friday, March 27, 2009 4:47:43 AM
Subject: Re: [GENERAL] how to specify the locale that psql uses
On Fri, Mar 27, 2009 at 9:35 AM, Dhaval
log_statement = none/ddl/mode/all
log_min_duration = -->> to log query consumes more than set value
--
Thanks & Regards
Dhaval Jaiswal
From: Raymond O'Donnell
To: ray
Cc: pgsql-general@postgresql.org
Sent: Friday, March 20, 2009 12:34:17 AM
Subje
Hi Mauro,
Not possible in PostgreSQL.
However, you can use dblink for creating query between multidatabase as
given below:
select empno from dblink('dbname=edb','SELECT empno from emp') as
emp(empno numeric)
union
select empno from dblink('dbname=enterprisedb','SELECT empno from emp')
as e
>> select a.relname, a.relowner, b.oid, b.rolname from pg_class a, pg_roles b
>> where relname like '' and a.relowner=b.oid and relkind = 'r';
>> \dt+
--
Thanks & Regards
Dhaval Jaiswal
From: Roderick A. Anderson
To: PostgreSQL
Sent: Friday, March 20, 2009
>> postgres=# \i C:/dj1.sql;
>> If there are space.
--
postgres=# \i 'C:/Program Files/PostgreSQL/8.3/bin/dj.sql';
Thanks & Regards
Dhaval Jaiswal
www.enterprisedb.com
From: Raymond O'Donnell
To: MDB
C
On Fri, Mar 27, 2009 at 9:44 AM, Dara Olson wrote:
> Happy spring.
>
> I am new to postgres/postgis and am trying to figure out the best way to
> approach documenting metadata within postgres. Has there been anything
> developed to add FGDC or Dublin Core standard metadata records into postgres
>
27 matches
Mail list logo
