Casey Duncan <[EMAIL PROTECTED]> writes:
> On May 11, 2006, at 4:42 AM, Simon Riggs wrote:
>> As your database is defined, this SQL statement will return
>> approximately 4 trillion rows, by my calculation. As you say, it
>> returns no rows at all when the database is empty.
> *slaps forehead* I
Dario Basso Cardoso <[EMAIL PROTECTED]> writes:
> I receive two (2) rows if i union with other table i receive one (1) row!!!
You do know that UNION is defined to eliminate duplicate output rows?
(UNION ALL doesn't eliminate duplicates, and might be what you want.)
If that's not what you're seein
Richard Yen <[EMAIL PROTECTED]> writes:
> Here's the machine where postgres is faulting:
> postgreSQL version: 7.4.6
Well, the very first recommendation you're going to get is to run
something newer. 7.4 is up to 7.4.12 (.13 next week) and we don't
make those patch releases just to fill spare tim
Hi,
I have PostgreSQL 8.0.3 for Windows XP and i have in attach the database
with problem.
The problem occour with this SQL
select proextra.data as data, 0 as codigo, proextra.motivo as nome, 'X'
as tipo, proextra.qtd, 0 as valor_u, 0 as cod_v from proextra where
proextra.data>=to_date('28/
Hi all,
I'm experiencing signal 11 (segmentation fault) failures on the
master node of a 3-node Slony-I cluster. In the past week, we've
averaged a little more than one segfault per day (11 times in the
past 10, including today). Any ideas what's going on?
Would anyone know how to track
"Thomas Reiss" <[EMAIL PROTECTED]> writes:
> The following bug has been logged online:
> Description:PID file not created if $PGDATA is different from
> Datadir
Yes it is, but it's in the data_directory. In general the postmaster
need not (and probably should not) have write permission wh
On May 11, 2006, at 4:42 AM, Simon Riggs wrote:
On Wed, 2006-05-10 at 09:34 -0700, Casey Duncan wrote:
The script actually fails before the function is even defined anyhow,
on this statement:
INSERT INTO ss
(ss_id, name, ll_id, shared_ss_id, time_added,
shared_creator_id)
SELECT ne
The following bug has been logged online:
Bug reference: 2432
Logged by: Thomas Reiss
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Linux Debian sarge
Description:PID file not created if $PGDATA is different from
Datadir
Details:
Hello
On Wed, 2006-05-10 at 09:34 -0700, Casey Duncan wrote:
> The script actually fails before the function is even defined anyhow,
> on this statement:
>
> INSERT INTO ss
> (ss_id, name, ll_id, shared_ss_id, time_added,
> shared_creator_id)
> SELECT nextval('ss_id_seq'), s.name, lts.ll_id
