---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
***
Your mail has been scanned by InterScan MSS.
***
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's dataty
I want to make a table that has unique rows - no problem.
Create Table x (smarts Varchar Unique);
I have input data that has many duplicates and until now
I was creating a temp table allowing duplicates, and then
Insert into x (smarts) select distinct smarts from tmpx;
This is now failing when I
[EMAIL PROTECTED] wrote: Date: Fri, 15 Sep 2006 11:16:06 +0200From: [EMAIL PROTECTED]To: pgsql-sql@postgresql.orgSubject: [SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4hiI am upgrading from pgsql 7.4.1 to pgsql 8.1.4. However, some of the applicationqueries won't run on the ne
"TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> ERROR: could not write block 196261 of temporary file: No space left
> on device
> I can't tell if this was because I ran out of real disk space,
> or because of some disk space limit set in pg config files.
There is no "disk space limit in pg config
I got the following error during a psql session of a big transaction
filling a temporary table, then selecting distinct values from it
for insertion into a permanent table.
CREATE TABLE
CREATE TABLE
ERROR: could not write block 196261 of temporary file: No space left
on device
HINT: Perhaps ou
On 9/20/06, CN <[EMAIL PROTECTED]> wrote:
Hi!CREATE TABLE x1 (name TEXT, hobby TEXT, PRIMARY KEY(name,hobby));INSERT INTO x1 VALUES('John','music');INSERT INTO x1 VALUES('John','arts');INSERT INTO x1 VALUES('Bob','arts');INSERT INTO x1 VALUES('Bob','music');
INSERT INTO x1 VALUES('Rocky','copmputer
>Is that the one off gborg? It's broken because the equality function is
>marked volatile, and so the planner is afraid to try to use it for
>merging or hashing. (It's also not marked strict, which means you can
>trivially crash the backend by passing it a null ...)
Tom, you are a genius. I chan
On 9/18/06, Becky Hoff <[EMAIL PROTECTED]> wrote:
The sum(dr.loan_starting_balance
+
dr.loan_net_change) part of the calculation have a single date, the last day in
a date range chosen by the user
Sum(ds.pulled_loan_total) and sum(ds.renew_loan_amount) both
have a range of dates
In article <[EMAIL PROTECTED]>,
"CN" <[EMAIL PROTECTED]> writes:
> select * from x1;
> name | hobby
> ---+--
> John | music
> John | arts
> Bob | arts
> Bob | music
> Rocky | computer
> Steve | arts
> Steve | football
> Tom | computer
> Tom | music
> (9 rows)
Hi, Henry,
Henry Ortega wrote:
> This maybe more of a theoretical question, can you actually make a
> Trigger run
> after completion of the entire transaction?
[...]
> ... another 20-30 more inserts..
Which frontend do yu use? Maybe COPY is better than insert.
> The trigger actua
11 matches
Mail list logo
