Jim Michaels, 15.07.2009 01:47:
most programmer's text editors can't handle more than 2000 characters
per line.
and I want to be able to edit my dumps.
I don't know what you are using, but the following editors can certainly handle
more than 2000 characters:
OpenSource and free:
http://www.p
I'm not exactly sure what was wrong. But I tried making a change on another
database on the same server and it was ok. So I thought deleting the problem
database and restoring it again would do the trick and it did. So problem
solved I guess. Although I'm still not sure what happened . . .
Jim Michaels wrote:
I am having problems with pg_restore. pg_restore
--file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
--username=postgres
this just hangs.
I am restoring from 8.3.7 to 8.4 - what did I do wrong?
Well, I don't see a database name, was that just an ac
On Tue, Jul 14, 2009 at 7:47 PM, Jim Michaels wrote:
> could somebody rewrite pg_dumpall and pg_dump so that it makes editable
> dumps?
> most programmer's text editors can't handle more than 2000 characters per
> line.
> and I want to be able to edit my dumps.
You're going to have better luck fin
I am having problems with pg_restore. pg_restore
--file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
--username=postgres
this just hangs.
I am restoring from 8.3.7 to 8.4 - what did I do wrong?
could somebody rewrite pg_dumpall and pg_dump so that it makes editable dumps
Michael Gould wrote:
> I have created the following in my postgres.conf file
>
> custom_variable_classes = 'iss'
>
> In a SQL session I've tried
>
> Set iss.one = '1'
> set iss.two = '2'
>
> Select * from iss;
>
> How do I access the values from the custom class in sql code?
show iss.one;
se
Hi,
Debugging PL/Python isn't as easy as with PL/pgSQL, as it appears I
can't see line numbers where errors occur. For example:
ERROR: plpython: function "evaluate_something" failed
DETAIL: : sequence index must be integer,
not 'str'
The location of this type of exception is difficult to
On Tue, Jul 14, 2009 at 10:00:04AM +, Jasen Betts wrote:
> On 2009-07-13, Michael Gould wrote:
> > I would like to know what the formal method of requesting new features are
> > for Postgres and how are decisions made which features are included in a
> > future release or not.
>
> Formal?
>
I have created the following in my postgres.conf file
custom_variable_classes = 'iss'
In a SQL session I've tried
Set iss.one = '1'
set iss.two = '2'
Select * from iss;
How do I access the values from the custom class in sql code?
Best Regards
Michael Gould
--
Michael Gould, Managing Partne
On Tuesday 14 July 2009 14:16:33 you wrote:
> This is great,
> thank you
>
> I have to say, if this is a free-of-charge
> add on to postgres that works and utilizes the hardware on each server
> to perform
> the join,
>
> -- why would anybody need to use mapreduce/hadoop/etc?
> for database-like se
On Tue, Jul 14, 2009 at 12:38 PM, V S P wrote:
> Hi,
> thank you for the links
>
>
> I read through the presentation
>
> and they did not solve the issue for me -- which presenting a e table from
> multiple
> shards as one single table (at least for reads) for ODBC clients.
>
>
> I also do not thin
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> The reason why I think the data will not fit into one database,
> is because I just do not have money for servers (everything is coming
> out of my small pocket) so I just want to deploy inexpensive computers
> but add them as I get more data
On Tue, Jul 14, 2009 at 1:16 AM, V S P wrote:
> Hello
>
> I am researching how to store the data for easy 'user-driven'
> reporting (where I do not need to develop application for
> every user request).
>
> The data will typically be number ranges and text strings with
> unique Id for each row
>
On Tuesday 14 July 2009 13:35:23 you wrote:
> yes -- thank you
>
> that's in the direction of what I am looking for
>
>
> ODBC connectivity and joins across databases!
>
>
> It looks like it cannot support
> a single image table across databases
It's effectively a single image across nodes - in
On Tuesday 14 July 2009 12:38:27 V S P wrote:
> Hi,
> thank you for the links
>
>
> I read through the presentation
>
> and they did not solve the issue for me -- which presenting a e
> table from multiple
> shards as one single table (at least for reads) for ODBC clients.
>
>
> I also do not think
Hi,
thank you for the links
I read through the presentation
and they did not solve the issue for me -- which presenting a e
table from multiple
shards as one single table (at least for reads) for ODBC clients.
I also do not think that skypetools do that
they have implemented essentially an AP
On Tue, Jul 14, 2009 at 10:04:12AM -0400, Clark Slater wrote:
> SELECT DISTINCT ON (part_number) * FROM (
> SELECT part_number, priority FROM ...
> UNION ALL
> SELECT part_number, priority FROM ...
> UNION ALL
> SELECT part_number, priority FROM ...
> ) AS filter_duplicates ORDER BY priority,part_n
On Tue, Jul 14, 2009 at 10:04:12AM -0400, Clark Slater wrote:
> Hello-
>
> I am trying to use DISTINCT ON to filter out *potential* duplicate values
> from a set of sub queries. There are certain cases where there can be
> repetitive part numbers that are priced differently. I'm trying to start
"Clark Slater" writes:
> I am trying to use DISTINCT ON to filter out *potential* duplicate values
> from a set of sub queries. There are certain cases where there can be
> repetitive part numbers that are priced differently. I'm trying to start
> with the full list, ordered by priority, and the
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Clark Slater
> Sent: Tuesday, July 14, 2009 10:04 AM
> Subject: [GENERAL] filter duplicates by priority
Maybe I'm missing something, but why not something like (incoming
pseudo-SQL):
Select par
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> It's perfectly valid (from the DBI's point of view) for prepare() to
> return a prepared statement handle for an invalid statement.
>
On Mon, Jul 13, 2009 at 3:29 PM, Sam Mason wrote:
> On Mon, Jul 13, 2009 at 06:57:43PM +, Nelson Correia wrote:
> > Running pg_dump from another machine needs much space on the DB
> > host? Or it just outputs the data as it goes?
>
> pg_dump should use very little space on the server, it just
On Tuesday 14 July 2009 15:52:29 Alvaro Herrera wrote:
> Andres Freund wrote:
> > On Tuesday 14 July 2009 11:36:57 Jasen Betts wrote:
> > > if you do an ascii dump and the dump starts out "SET CLIENT ENCODING
> > > 'UTF8'" or similar but you still get errors.
> >
> > Do you mean that a dump from SQ
I guess I'll ask on the slony-i mailing list also. thanks for your hlep.
LW . . . Lawrence
> To: lawrence...@hotmail.com
> CC: mmonc...@gmail.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] cache lookup failed for function 72629
> Date: Tue, 14 Jul 2009 10:18:10 -0400
> From: t...
This sounds like a problem I have observed, which I was able to fix by
restarting
the Slony daemon.
- Dean
2009/7/14 Lawrence Wong :
> I had been using Slony-I together with another database on a server on a
> different machine. I had been testing my replication constantly dropping
> and creat
Lawrence Wong writes:
> I had been using Slony-I together with another database on a server on a
> different machine. I had been testing my replication constantly dropping and
> creating my Slony-I tables. This is not out of the ordinary though. I had
> been doing this for many days now.
>
> Propose a DTrace probe immediately after the "goto begin" at line 740 of
> xlog.c, so we can start tracing from the first backend following
> checkpoint, and turn off tracing when all backends have completed a
> transaction.
>
That's greek to me. But I'm happy to test things if you send me
pa
Hello-
I am trying to use DISTINCT ON to filter out *potential* duplicate values
from a set of sub queries. There are certain cases where there can be
repetitive part numbers that are priced differently. I'm trying to start
with the full list, ordered by priority, and then remove any repeats tha
Andres Freund wrote:
> On Tuesday 14 July 2009 11:36:57 Jasen Betts wrote:
> > if you do an ascii dump and the dump starts out "SET CLIENT ENCODING
> > 'UTF8'" or similar but you still get errors.
> Do you mean that a dump from SQL_ASCII can yield non-utf8 data? right. But
> According to the OP h
Michael Gould wrote:
> In some SQL engines the engine doesn't need to define both Ascending and
> Descending indexes on the same column. Does Postgres need to have indexes
> defined for both Ascending and Descending sorts? We use quite a few of
> these types of sorts.
A single btree index can be
In some SQL engines the engine doesn't need to define both Ascending and
Descending indexes on the same column. Does Postgres need to have indexes
defined for both Ascending and Descending sorts? We use quite a few of
these types of sorts.
Best Regards
--
Michael Gould, Managing Partner
I
I had been using Slony-I together with another database on a server on a
different machine. I had been testing my replication constantly dropping and
creating my Slony-I tables. This is not out of the ordinary though. I had
been doing this for many days now.
The query, I had been doing is
On Tue, Jul 14, 2009 at 9:12 AM, Lawrence Wong wrote:
> I'm sorry. What does 're-applying the function source' mean? and how would
> I do it?
>
> For the 'change to the table' I was talking about, I just tried to do a
> regular update on the table using pgAdmin III.
>
> LW . . . Lawrence
>
well,
On Mon, Jul 13, 2009 at 8:54 PM, Andreas wrote:
> Hi,
> I need to do some reporting for projects that have some columns that stay
> the same for every project and then every project brings along some project
> specific stuff.
> Now I've got a big view for everyone of those about 100 projects (and
>
I'm sorry. What does 're-applying the function source' mean? and how would I
do it?
For the 'change to the table' I was talking about, I just tried to do a regular
update on the table using pgAdmin III.
LW . . . Lawrence
> Date: Tue, 14 Jul 2009 09:01:38 -0400
> Subject: Re: [GENERAL] c
On Tue, Jul 14, 2009 at 8:23 AM, Lawrence Wong wrote:
> Hi,
>
> I had been using my database for a pretty long time now. It is postgres 8.3
> on Windows 2003 Server. Today I tried to make a change to one of my tables
> and I got this error message:
>
> 'An error has occured: ERROR: cache lookup f
Hi,
I had been using my database for a pretty long time now. It is postgres 8.3 on
Windows 2003 Server. Today I tried to make a change to one of my tables and I
got this error message:
'An error has occured: ERROR: cache lookup failed for function 72629'
I tried stopping the service and sta
Hi.
Is anyone aware of a connection pool or load balancer for PostgreSQL
that supports ident based authentication? Neither pgpool-ii nor
pgbouncer support this according to their docs, so I was wondering
what else is out there.
--
Stuart Bishop
http://www.stuartbishop.net/
--
Sent via pgsql-g
2009/7/13 Tom Lane :
> No, you're misinterpreting the message. What that code likely means
> is that something is trying to use SPI and finding plpgsql already
> connected. In other words, plpgsql forgets to do a SPI_push() before
> calling something that might try to use SPI re-entrantly. It sh
On Tue, Jul 14, 2009 at 03:02:14AM -0700, Nenad Milasinovic wrote:
>
> Hello,
>
> I am interested can PostgreSQL be used in commercial applications,
> and what is licensing policy. I know that PostgreSQL is released
> under BSD licence, but still i want to be sure are there any costs
> when distr
On Tuesday 14 July 2009 13:02:14 Nenad Milasinovic wrote:
> Hello,
>
> I am interested can PostgreSQL be used in commercial applications, and
> what is licensing policy. I know that PostgreSQL is released under BSD
> licence,
> but still i want to be sure are there any costs when distributing
> Pos
Hello,
We were also in search of having a table split across multiple databases but
then found out about skypetools and at the same time the following article;
http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/,
true that it's not done with PG, but the
Hello,
I am interested can PostgreSQL be used in commercial applications, and
what is licensing policy. I know that PostgreSQL is released under BSD
licence,
but still i want to be sure are there any costs when distributing PostgreSQL
in
closed, commercial applications (is there any restriction
On 2009-07-13, Michael Gould wrote:
> I would like to know what the formal method of requesting new features are
> for Postgres and how are decisions made which features are included in a
> future release or not.
Formal?
for open soure software in general, changes are are requested using
the bu
On Mon, Jul 13, 2009 at 11:16 PM, V S P wrote:
> Hello
>
> I am researching how to store the data for easy 'user-driven'
> reporting (where I do not need to develop application for
> every user request).
>
> The data will typically be number ranges and text strings with
> unique Id for each row
>
>
On Tuesday 14 July 2009 11:36:57 Jasen Betts wrote:
> On 2009-07-13, Andres Freund wrote:
> > On Sunday 12 July 2009 13:19:50 Phoenix Kiula wrote:
> >> Hi. I *always* get an error moving my current fully utf-8 database
> >> data into a new DB.
> >>
> >> My server has the version 8.3 with a five ye
On 2009-07-13, Andres Freund wrote:
> On Sunday 12 July 2009 13:19:50 Phoenix Kiula wrote:
>> Hi. I *always* get an error moving my current fully utf-8 database
>> data into a new DB.
>>
>> My server has the version 8.3 with a five year old DB. Everything, all
>> collation, LC_LOCALE etc are all u
On Mon, 2009-07-13 at 15:53 -0500, Dan Armbrust wrote:
> > So this thought leads to a couple of other things Dan could test.
> > First, see if turning off full_page_writes makes the hiccup go away.
> > If so, we know the problem is in this area (though still not exactly
> > which reason); if not w
48 matches
Mail list logo
