Il Wednesday 14 November 2007 05:50:36 Willem Buitendyk ha scritto:
> Will Postgresql ever implement an ignore on error feature when bulk
> loading data? Currently it is my understanding that any record that
> violates a unique constraint will cause the "copy from" command to halt
> execution inst
On Tue, 2007-11-13 at 00:07 -0500, Greg Smith wrote:
> On Mon, 12 Nov 2007, Mason Hale wrote:
>
> > After the wal segment file is copied by the restore_command script, is
> > it safe to delete it from my archive?
>
> While I believe you can toss them immediately,
This is almost never possible.
Tom Lane wrote:
> Martin Langhoff <[EMAIL PROTECTED]> writes:
>> I say they are worrying because Moodle code has many ocurrences of
>>/* bla.id is an INT8 */
>>SELECT x,y,z FROM bla WHERE id='1';
>> And we also often quote INT values for inserts/updates, I am not sure if
>> this is supporte
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> I tried something like that briefly and it failed. The trouble is, I
> think, that since the engine tries a require it fails on the op test
> before it even looks to see if the module is already loaded.
I think we have little choice but to report this
Martin Langhoff <[EMAIL PROTECTED]> writes:
> I say they are worrying because Moodle code has many ocurrences of
>/* bla.id is an INT8 */
>SELECT x,y,z FROM bla WHERE id='1';
> And we also often quote INT values for inserts/updates, I am not sure if
> this is supported either.
This is not
Will Postgresql ever implement an ignore on error feature when bulk
loading data? Currently it is my understanding that any record that
violates a unique constraint will cause the "copy from" command to halt
execution instead of skipping over the violation and logging it - as is
done in Oracle
Hi all -
I've spotted the cast-related "regressions" being discussed here
http://archives.postgresql.org/pgsql-general/2007-11/msg00505.php
... as a Moodle developer supporting Pg, the stricter cast rules in pg
8.3 are somewhat worrying. Is there a straightforward way to configure a
given DB or a
On Nov 13, 2007 3:35 PM, Steve Crawford <[EMAIL PROTECTED]> wrote:
> Given a table which includes tree-type information consisting of an id
> and a parent_id, is there an already existing function that will return
> the path to the top of the tree for a given record?
>
> The connectby function from
Greg Sabino Mullane wrote:
Ugh, in testing I see some nastiness here without any explicit
require. It looks like there's an implicit require if the text
contains certain chars.
Exactly.
Looks like it's going to be very hard, unless someone has some
brilliant insight I'm missing :-(
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Ugh, in testing I see some nastiness here without any explicit
> require. It looks like there's an implicit require if the text
> contains certain chars.
Exactly.
> Looks like it's going to be very hard, unless someone has some
> brillian
On Nov 9, 2007 12:53 PM, Waller, David <[EMAIL PROTECTED]> wrote:
> I have an application that I am porting from MySQL to PostgreSQL and I am
> working on the import Perl script that process the data.
>
> The data is web log data and each line has a variable amount of the fields
> (mostly because o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 13 Nov 2007 15:27:51 -0800
"Rick Grandy" <[EMAIL PROTECTED]> wrote:
> We are looking for a Postgresql Architect/Developer to do some
> mentoring, training, knowledge transfer and implementation for a
> large media outlet in Los Angeles. Trave
We are looking for a Postgresql Architect/Developer to do some mentoring,
training, knowledge transfer and implementation for a large media outlet in
Los Angeles. Travel is fully funded and the rates are great! Please reply
to [EMAIL PROTECTED] Thank you for your time!!!
Regards,
Ricky G
I was going through the docs for JDBC and came across connection
pooling within driver. At the same time it mentions that one should
use the Apache DBCP.
So now the question is which connection pool to use and why?
Regards
Dhaval Shah
---(end of broadcast)
On Tue, 2007-11-13 at 17:10 -0500, Morris Goldstein wrote:
> I suspect that the SELECT scan will tend to displace everything else
> in shared buffers, and I hope that the two forms of COPY do not. Is
> that correct?
>
In 7.4 that may be true, but in later versions it's not.
8.0+ use multiple LRU
Suppose I have a large table with no indexes, and I scan the entire
thing. What is the impact on the shared buffers? I'm interested in
three scenarios:
- Scan done in SQL using SELECT, (via JDBC if it matters).
- Scan done using SQL COPY.
- Scan done using psql COPY.
I suspect that the SELECT sca
Given a table which includes tree-type information consisting of an id
and a parent_id, is there an already existing function that will return
the path to the top of the tree for a given record?
The connectby function from the contrib tablefuncs does what I want for
a whole table, but I haven'
Beautiful, Scott. You nailed it. Thanks for the help!
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Monday, November 12, 2007 5:10 PM
To: Charles Mortell
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] update record with two-column primary key
OK, a follo
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
>> Yep, this is a fork without exec. And the child processes often aren't
>> even doing any database access -- the database connection's opened and
>> held, then a child is forked off, and the child 'helpfully' closes the
>> handle during
On Nov 13, 2007, at 1:18 PM, [EMAIL PROTECTED] wrote:
Yep, this is a fork without exec. And the child processes often aren't
even doing any database access -- the database connection's opened and
held, then a child is forked off, and the child 'helpfully' closes the
handle during the child's gl
On Tue, Nov 13, 2007 at 01:18:25PM -0500, [EMAIL PROTECTED] wrote:
> Yep, this is a fork without exec. And the child processes often aren't
> even doing any database access -- the database connection's opened and
> held, then a child is forked off, and the child 'helpfully' closes the
> handle duri
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Yep, this is a fork without exec. And the child processes often aren't
> even doing any database access -- the database connection's opened and
> held, then a child is forked off, and the child 'helpfully' closes the
> handle during the child'
On Tue, 2007-11-13 at 08:36 -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I have a table with 29384048 records in oracle and postgresql. The
> table has 47 columns (16 numeric and 27 varchar and the rest
> timestamp). The tablesize in postgresql is twice as much than the
> tablesize in oracle (for th
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
>> On Tue, Nov 13, 2007 at 12:02:31PM -0500, [EMAIL PROTECTED] wrote:
>>> How does Postgres handle sharing database handles across child
>>> processes?
>>> That is, if I have a process that opens a connection to the database
>>> and
>>> then fork
Il Tuesday 13 November 2007 17:36:30 SHARMILA JOTHIRAJAH ha scritto:
> Hi
> I have a table with 29384048 records in oracle and postgresql. The table
> has 47 columns (16 numeric and 27 varchar and the rest timestamp). The
> tablesize in postgresql is twice as much than the tablesize in oracle (fo
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> On Tue, Nov 13, 2007 at 12:02:31PM -0500, [EMAIL PROTECTED] wrote:
>> How does Postgres handle sharing database handles across child processes?
>> That is, if I have a process that opens a connection to the database and
>> then forks a few child
On Tue, Nov 13, 2007 at 12:02:31PM -0500, [EMAIL PROTECTED] wrote:
> How does Postgres handle sharing database handles across child processes?
> That is, if I have a process that opens a connection to the database and
> then forks a few child processes, what happens?
>
> Can the child processes sa
How does Postgres handle sharing database handles across child processes?
That is, if I have a process that opens a connection to the database and
then forks a few child processes, what happens?
Can the child processes safely use the handle?
If one child closes the handle, what happens to the h
Hi
I have a table with 29384048 records in oracle and postgresql. The table has
47 columns (16 numeric and 27 varchar and the rest timestamp). The tablesize in
postgresql is twice as much than the tablesize in oracle (for the same number
of rows and columns). There are no updates or deletes in
On Nov 12, 2007, at 11:07 PM, Greg Smith wrote:
On Mon, 12 Nov 2007, Mason Hale wrote:
After the wal segment file is copied by the restore_command
script, is it safe to delete it from my archive?
While I believe you can toss them immediately, you should
considering keeping those around for
On Nov 12, 2007, at 5:11 PM, Sarah Dougherty wrote:
For some context, I am trying to create a report that provides a
list of client charges and payments and a "running balance" after
each transaction. Because we often have multiple charges and/or
payments on the same day, we can't use the t
=?ISO-8859-1?Q?Christian_Schr=F6der?= <[EMAIL PROTECTED]> writes:
> What remains inscrutable to me is why this problem did not arise
> earlier. I cannot remember any changes that I have made to the system
> recently. Or maybe it has been a defective update of the glibc? I did
> not see in the bu
> my understanding was that the lack of threading on OSX made it
> especially poor for a DB server
What you're referring to must be that the kernel was essentially
single-threaded, with a single "kernel-funnel" lock. (Because the OS
certainly supported threads, and it was certainly possible to wri
On Nov 12, 2007, at 8:55 PM, Steve Manes wrote:
Steve Manes wrote:
What's the portupgrade process in FreeBSD??
(Fixed. The answer is to use pg_delete -f on the old package to
force the delete)
more elegantly,
portupgrade -Rrv -f -o databases/postgresql82-client postgresql-client
but y
In response to Ow Mun Heng <[EMAIL PROTECTED]>:
>
> On Thu, 2007-11-08 at 12:02 -0500, Bill Moran wrote:
> > Frequently, when people ask for help because they've exceed max_fsm*,
> > it's because they're not paying attention to their systems, and therefore
> > the problem has been occurring for a
On Tue, Nov 13, 2007 at 02:08:47PM +0100, Christian Schröder wrote:
> By the way, does the "--enable-thread-safety" switch have anything to do
> with the problem?
No, that only affects the client library, it doesn't affect the
server...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTE
Tom Lane wrote:
Hah, I've got it. (Should have searched Red Hat's bugzilla sooner.)
What you are hitting is a glibc bug, as explained here:
http://sources.redhat.com/ml/libc-hacker/2007-10/msg00010.html
If libpthread is loaded after first use of dcgettext, then subsequent
uses are at risk of han
> > > - out of line parameters
> > How to? Is there any function for this? I mean the C interface.
>
> PQexecParams.
>
> > > - escape the nulls, like \0
> > Do you mean this function?
> > #unsigned char *PQescapeBytea(const unsigned char *from,
> > # size_t from_length,
38 matches
Mail list logo
