Date: Wed, 15 Apr 2009 21:23:04 -0700
From: Steve Midgley
To: Erik Jones
Subject: Re: How to count from a second table in an aggregate query?
Message-ID: <49e6b2a8.5040...@misuse.org>
Erik Jones wrote:
>
> On Apr 15, 2009, at 1:15 PM, Steve Midgley wrote:
>
>>
Erik Jones wrote:
On Apr 15, 2009, at 1:15 PM, Steve Midgley wrote:
I want to generate an analysis report that counts the values in two
separate tables. I've been able to accomplish what I want with two
separate queries that I then merge together in Excel. Essentially
what I need
Hi,
I'm trying to figure out how to do something which I'd guess is easy for
a sql whiz but has me stumped. I would greatly appreciate any help on
this - it's a form of SQL query that I've never figured out, but have
wanted to use many times over the years..
I want to generate an analysis re
Date: Mon, 13 Apr 2009 17:09:49 -0400
From: Glenn Maynard
To: pgsql-sql@postgresql.org
Subject: Re: changing multiple pk's in one update
Message-ID:
(JMdict? I was playing with importing that into a DB a while back,
but the attributes in that XML are such a pain--and then my email died
while
pgsql-sql-ow...@postgresql.org wrote:
Date: Tue, 7 Apr 2009 22:34:38 -0400
From: Glenn Maynard
To: pgsql-sql@postgresql.org
Subject: Nested selects
Message-ID:
I'm deriving high scores from two tables: one containing data for each
time a user played (rounds), and one containing a list of stage
At 09:20 AM 3/26/2009, pgsql-sql-ow...@postgresql.org wrote:
Message-Id: <587e5df3-5859-48de-93f9-f7b05c37e...@rvt.dds.nl>
From: ries van Twisk
To: DM
In-Reply-To:
Subject: Re: Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 15:07:21 -0500
References:
X-Archive-Number:
At 02:20 AM 3/25/2009, pgsql-sql-ow...@postgresql.org wrote:
To: Zdravko Balorda
cc: pgsql-sql@postgresql.org
Subject: Re: Alter Table/Indexing
In-reply-to: <49c89fea.8060...@siix.com>
References: <49c89fea.8060...@siix.com>
Comments: In-reply-to Zdravko Balorda
message dated "Tue, 24 M
At 05:20 PM 3/16/2009, pgsql-sql-ow...@postgresql.org wrote:
In-Reply-To: <1992170861895942...@unknownmsgid>
References: <1992170861895942...@unknownmsgid>
Date: Mon, 16 Mar 2009 22:45:54 +0100
Message-ID:
<162867790903161445i78127316s1c0deb3bec0e1...@mail.gmail.com>
Subject: Re: Exclude fields
At 06:20 AM 3/13/2009, pgsql-sql-ow...@postgresql.org wrote:
Message-ID: <457532.70947...@web45913.mail.sp1.yahoo.com>
Date: Thu, 12 Mar 2009 10:28:19 -0700 (PDT)
From: Duffer Do
Subject: select count of all overlapping geometries and return 0 if
none.
To: pgsql-sql@postgresql.org
X-Archive-Nu
At 08:20 AM 2/25/2009, pgsql-sql-ow...@postgresql.org wrote:
To: pgsql-sql@postgresql.org
From: Mark Stosberg
Subject: Best practices for geo-spatial city name searches?
Date: Tue, 24 Feb 2009 11:19:56 -0500
Message-ID: <20090224111956.5b7a4...@summersault.com>
X-Archive-Number: 200902/94
X-S
At 01:20 PM 1/24/2009, pgsql-sql-ow...@postgresql.org wrote:
From: Marek Florianczyk
Organization: TP SA
To: pgsql-sql@postgresql.org
Subject: problem using twice custom comparision operator
Date: Fri, 23 Jan 2009 21:42:44 +0100
Message-Id: <200901232142.44102.fra...@adm.tp.pl>
Hi all,
I wante
At 09:20 AM 1/14/2009, pgsql-sql-ow...@postgresql.org wrote:
Date: Wed, 14 Jan 2009 12:05:29 +0100
From: Ivan Sergio Borgonovo
To: pgsql-sql@postgresql.org
Subject: Re: some howto/theory book/tutorial on practical problem
solving in SQL
Message-ID: <20090114120529.0ab11...@dawn.webthatworks.it
At 10:20 AM 1/4/2009, pgsql-sql-ow...@postgresql.org wrote:
Message-ID:
<618950b80901031757l15109658kdae1cdb0814d3...@mail.gmail.com>
Date: Sat, 3 Jan 2009 17:57:32 -0800
From: "John Zhang"
To: postgis-us...@postgis.refractions.net
Subject: How to excute dynamically a generated SQL command?
X-A
At 05:20 AM 1/1/2009, pgsql-sql-ow...@postgresql.org wrote:
To: pgsql-sql@postgresql.org
Subject: Question on Escape-string
X-Archive-Number: 200812/132
X-Sequence-Number: 32082
Dear all,
I am using pl/pgsql to develop a function to implement some logic to
load BLOB data, like .tif file, to po
At 11:20 AM 12/6/2008, [EMAIL PROTECTED] wrote:
Message-ID: <[EMAIL PROTECTED]>
From: "Oliveiros Cristina" <[EMAIL PROTECTED]>
To: "Bryce Nesbitt" <[EMAIL PROTECTED]>,
"sql pgsql"
References: <[EMAIL PROTECTED]>
Subject: Re: Best way to "and" from a one-to-many joined table?
Date: Fri, 5
At 11:20 PM 11/24/2008, [EMAIL PROTECTED] wrote:
Message-Id: <[EMAIL PROTECTED]>
From: ries van Twisk <[EMAIL PROTECTED]>
To: Tk421 <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
Subject: Re: Sequence and nextval problem
Date: Mon, 24 Nov 2008 16:21:40 -0500
References: <[EMAIL PROTECTED]>
At 11:28 AM 10/23/2008, Joe wrote:
Steve Midgley wrote:
# (invoiceid, txid)
(A, 1)
(A, 3)
(B, 1)
(B, 2)
(C, 5)
(D, 6)
(D, 7)
(E, 8)
(F, 8)
For journalling, I need to group/cluster this together. Is there a
SQL
query that can generate this output:
# (journal: invoiceids, txids)
[A,B
At 10:20 PM 10/22/2008, you wrote:
Message-ID:
<[EMAIL PROTECTED]>
Date: Wed, 22 Oct 2008 12:14:49 +0700
From: "David Garamond" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: grouping/clustering query
X-Archive-Number: 200810/89
X-Sequence-Number: 31731
Dear all,
I have an invoices
At 05:20 PM 10/8/2008, [EMAIL PROTECTED] wrote:
Date: Wed, 8 Oct 2008 11:25:10 +0200
From: Louis-David Mitterrand <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Re: many-to-many relationship
Message-ID: <[EMAIL PROTECTED]>
Mail-Followup-To: pgsql-sql@postgresql.org
References: <[EMAIL
At 06:20 AM 10/7/2008, [EMAIL PROTECTED] wrote:
Date: Mon, 6 Oct 2008 15:08:02 +0200
From: Louis-David Mitterrand <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: many-to-many relationship
Message-ID: <[EMAIL PROTECTED]>
X-Archive-Number: 200810/13
X-Sequence-Number: 31655
Hi,
Say you
At 09:50 PM 9/29/2008, Richard Broersma wrote:
On Mon, Sep 29, 2008 at 7:48 PM, Steve Midgley <[EMAIL PROTECTED]>
wrote:
> In my specific case it turns out I only had duplicates, but there
could have
> been n-plicates, so your code is still correct for my use-case
(though I
At 05:38 PM 9/26/2008, Oliveiros Cristina wrote:
In-Reply-To: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
Howdy, Steve.
SELECT id
FROM dummy a
NATURAL JOIN (
SELECT fkey_id,name
FROM dummy
GROUP BY fkey_id,name
HAVING COUNT(*) > 1 A
aps a natural join like in Oliveiros' sql would do the
job?
Thanks for any advice on either of these solutions. I'm going to learn
a lot here if someone can pound it into my head.
Thanks,
Steve
It seems to be returning any records that have sequential id's
regardless
At 11:
Hi,
I've been kicking this around today and I can't think of a way to solve
my problem in "pure SQL" (i.e. I can only do it with a
looping/cursor-type solution and some variables).
Given a table with this DDL/data script:
drop table if exists dummy;
create table dummy (
id integer primary
At 08:20 AM 9/18/2008, [EMAIL PROTECTED] wrote:
Message-ID:
<[EMAIL PROTECTED]>
Date: Wed, 17 Sep 2008 09:20:44 -0700
From: "Richard Broersma" <[EMAIL PROTECTED]>
To: "Scott Marlowe" <[EMAIL PROTECTED]>
Subject: Re: surrogate vs natural primary keys
In-Reply-To:
<[EMAIL PROTECTED]>
References:
To: pgsql-sql@postgresql.org
From: Seb <[EMAIL PROTECTED]>
Subject: Re: surrogate vs natural primary keys
Date: Mon, 15 Sep 2008 17:56:31 -0500
Organization: Church of Emacs
Lines: 20
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
X-Archive-Numbe
At 12:20 PM 8/15/2008, [EMAIL PROTECTED] wrote:
Date: Fri, 15 Aug 2008 13:46:14 -0400
From: "Edward W. Rouse" <[EMAIL PROTECTED]>
To:
Subject: Re: Join question
Message-ID: <[EMAIL PROTECTED]>
I did try that, but I can't get both the values from table a with no
entries
in table b and the value
At 10:05 AM 8/7/2008, [EMAIL PROTECTED] wrote:
Date: Thu, 7 Aug 2008 09:14:49 -0700
From: [EMAIL PROTECTED]
To: pgsql-sql@postgresql.org
Subject: DELETE with JOIN
Message-ID: <[EMAIL PROTECTED]>
I want to delete with a join condition. Google shows this is a common
problem, but the only solution
At 03:51 PM 7/31/2008, Tom Lane wrote:
Steve Midgley <[EMAIL PROTECTED]> writes:
> At 07:29 AM 7/16/2008, Tom Lane wrote:
>> I think what is happening is that ORDER BY knows that and gets rid
of
>> the duplicate entries while DISTINCT ON fails to do so.
> Of course rem
At 09:20 AM 7/22/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 22 Jul 2008 13:27:24 +0200
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Re: index for group by
Message-ID: <[EMAIL PROTECTED]>
am Tue, dem 22.07.2008, um 13:18:30 +0200 mailte Patrick Scharrenberg
fol
At 07:29 AM 7/16/2008, Tom Lane wrote:
Steve Midgley <[EMAIL PROTECTED]> writes:
Interesting. You realize of course that sorting by the same
expression
twice is completely redundant? I haven't dug through the code yet but
Thanks Tom. Yeah, I was a little embarrassed to throw this
Hi,
I'm a little baffled. I'm trying to generate a SQL statement that
issues a DISTINCT ON using the same values as my ORDER BY statement.
I'm using a somewhat complex CASE statement in my ORDER BY clause. I'm
on Pg 8.2. Here is some SQL to get you started at seeing my problem:
-
At 11:59 AM 7/12/2008, [EMAIL PROTECTED] wrote:
Date: Sat, 12 Jul 2008 10:20:37 +0100
From: Simon Riggs <[EMAIL PROTECTED]>
To: Dave Page <[EMAIL PROTECTED]>
Cc: Lewis Cunningham <[EMAIL PROTECTED]>, Scott Marlowe
<[EMAIL PROTECTED]>, samantha mahindrakar
<[EMAIL PROTECTED]>, pgsql-sql@postgre
At 04:31 PM 7/11/2008, [EMAIL PROTECTED] wrote:
Date: Fri, 11 Jul 2008 23:31:03 +
From: Milan Oparnica <[EMAIL PROTECTED]>
To:
Subject: PERSISTANT PREPARE (another point of view)
Message-ID: <[EMAIL PROTECTED]>
[snip]
What could we gain by introducing a kind of global prepared statement
are
At 02:20 AM 6/25/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 24 Jun 2008 17:33:11 +0300
From: "Pascal Tufenkji" <[EMAIL PROTECTED]>
To:
Subject: ANSI Standard
Message-ID: <[EMAIL PROTECTED]>
Hi,
How do I know if a function (or a certain sql syntax) in Postgres is a
SQL
ANSI Standard, hence it
At 12:20 PM 6/12/2008, [EMAIL PROTECTED] wrote:
Date: Thu, 12 Jun 2008 08:47:44 -0400
From: PostgreSQL Admin <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Tsearch
Message-ID: <[EMAIL PROTECTED]>
this is a small sample of the data:
short_desc
|
At 10:52 AM 6/10/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 10 Jun 2008 05:05:24 -0700
From: Bryan Emrys <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Conceptual Design Question
Message-ID: <[EMAIL PROTECTED]>
Hello Everyone,
In a text-heavy database, I'm trying to make an initial de
At 11:20 PM 6/5/2008, [EMAIL PROTECTED] wrote:
Date: Thu, 5 Jun 2008 10:14:04 -0400
From: "Edward W. Rouse" <[EMAIL PROTECTED]>
To:
Subject: design resource
Message-ID: <[EMAIL PROTECTED]>
I was wondering if there were any resources that have some table
designs for common problems. Since that
At 09:20 PM 5/27/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 27 May 2008 09:29:56 -0700
From: "Richard Broersma" <[EMAIL PROTECTED]>
To: "Sebastian Rychter" <[EMAIL PROTECTED]>
Cc: pgsql-sql@postgresql.org
Subject: Re: Extremely Low performance with ODBC
Message-ID:
<[EMAIL PROTECTED]>
On Mon, M
At 09:20 PM 5/27/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 27 May 2008 09:29:56 -0700
From: "Richard Broersma" <[EMAIL PROTECTED]>
To: "Sebastian Rychter" <[EMAIL PROTECTED]>
Cc: pgsql-sql@postgresql.org
Subject: Re: Extremely Low performance with ODBC
Message-ID:
<[EMAIL PROTECTED]>
On Mon, M
At 12:20 PM 5/21/2008, [EMAIL PROTECTED] wrote:
Date: Wed, 21 May 2008 06:39:11 -0500
From: Karl Denninger <[EMAIL PROTECTED]>
To: Gurjeet Singh <[EMAIL PROTECTED]>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL question
Message-ID: <[EMAIL PROTECTED]>
> Also, if you don't have it already, yo
At 07:20 AM 4/15/2008, you wrote:
Date: Mon, 14 Apr 2008 09:41:41 -0400
From: Emi Lu <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: export CSV file through Java JDBC
Message-ID: <[EMAIL PROTECTED]>
Good morning,
Running the following command from command line is ok, but cannot
expor
At 06:47 AM 3/19/2008, D'Arcy J.M. Cain wrote:
But your suggestion was to base this key on the serial primary key so
where is your index collision protection? You are going to get
collisions on both the serial key and, to a lesser extent, your
generated one. Besides, has anyone ever demonstrated
At 12:36 PM 3/18/2008, D'Arcy J.M. Cain wrote:
On Tue, 18 Mar 2008 12:23:35 -0700
Steve Midgley <[EMAIL PROTECTED]> wrote:
> 1) Create a second field (as someone recommend on this list) that
is an
> MD5 of your primary key. Use that as your "accessor" index from the
At 11:58 AM 3/18/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 18 Mar 2008 13:40:42 -0500
From: "Campbell, Lance" <[EMAIL PROTECTED]>
To: "Vivek Khera" <[EMAIL PROTECTED]>,
Subject: Re: Create on insert a unique random number
Message-ID:
<[EMAIL PROTECTED]>
Thanks for all of your input.
At 02:49 PM 3/10/2008, A. R. Van Hook wrote:
The following code seems to work but it leads to the following
question(s):
Is there a sequence for each scid,item or is there one sequence that
must be reset
when changing scid?
$cmd = "select setval('schItem_item_seq', (select max(item)+1 from
At 09:20 AM 3/10/2008, [EMAIL PROTECTED] wrote:
Date: Mon, 10 Mar 2008 00:14:12 +
From: "Jamie Tufnell" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Re: Insert problem
Message-ID:
<[EMAIL PROTECTED]>
[snip]
> table defination
>
> create sequence schItem_item_seq
> create table
At 03:20 AM 3/5/2008, [EMAIL PROTECTED] wrote:
Date: Wed, 5 Mar 2008 01:51:19 +0300
From: "Yura Gal" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: using copy from in function
Message-ID:
<[EMAIL PROTECTED]>
I'm trying to automate import data using CORY FROM. For this purpose I
wrot
At 09:20 AM 2/12/2008, [EMAIL PROTECTED] wrote:
Date: Mon, 11 Feb 2008 11:56:33 -0500
From: Tom Lane <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: Usage of UUID with 8.3 (Windows)
Message-ID: <[EMAIL PROTECTED]>
[EMAIL PROTECTED] writes:
> Now, what do I hav
At 06:54 PM 2/6/2008, Medi Montaseri wrote:
Thanks Steve...
And finally you mentioned that bank accounts are tricky...can you
expand on this please. After all I am under the impression that "bank
accounts" are a corner stone of this whole book keeping...I
mean...bank accounts have debits and
At 05:09 PM 2/6/2008, [EMAIL PROTECTED] wrote:
Date: Wed, 6 Feb 2008 17:08:54 -0800
From: "Medi Montaseri" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: accounting schema
Message-ID:
<[EMAIL PROTECTED]>
Hi,
I am learning my way into Accounting and was wondering how Accounting
appl
Hi,
I see this documentation item but can't figure out how to use it:
http://www.postgresql.org/docs/8.2/interactive/infoschema-columns.html
The view columns contains information about all table columns (or view
columns) in the database.
However, if I execute "select columns;" I get a not fo
Hi,
A while ago on a different SQL platform, I had the idea to use negative
numbers as id's for certain system records that I didn't prefer to have
interspersed with other records in a table. (For example, we had
"template" records which we used to spawn new records, and rather than
store the
At 07:50 PM 1/29/2008, [EMAIL PROTECTED] wrote:
Date: Mon, 28 Jan 2008 20:16:35 -0800
From: Bryce Nesbitt <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Proposed archival read only trigger on rows - prevent history
modification
[snip]
I'm considering building a protective mechanism,
At 07:24 PM 1/22/2008, you wrote:
Hi all,
I have created a little test database to help illustrate my situation.
CREATE TABLE categories (
id integer NOT NULL,
name character varying(255) NOT NULL,
description character varying(255),
vocabulary_id integer,
derived boolean
)
Date: Sun, 20 Jan 2008 20:01:08 -0800
From: Ryan Wallace <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: improvements to query with hierarchical elements
Message-ID: <[EMAIL PROTECTED]>
Greetings,
I have a complex query which I am trying to figure out the most
efficient
way of perfo
";" at character 59
Char 59 by the way is the first accurance of semi-colon as in 䕱
which is being caught by PG parser.
Medi
On Jan 14, 2008 12:18 PM, Steve Midgley
<<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]> wrote:
On Jan 13, 2008 8:51 PM, Steve Midgley
<<m
On Jan 13, 2008 8:51 PM, Steve Midgley
<<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]> wrote:
At 02:22 PM 1/13/2008,
<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
wrote:
>Date: Sat, 12 Jan 2008 14:21:00 -0800
>From: "Medi Montaseri" <<mailto:[EM
At 02:22 PM 1/13/2008, [EMAIL PROTECTED] wrote:
Date: Sat, 12 Jan 2008 14:21:00 -0800
From: "Medi Montaseri" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: UTF8 encoding and non-text data types
Message-ID:
<[EMAIL PROTECTED]>
I understand PG supports UTF-8 encoding and I have sucess
At 07:20 AM 1/9/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 8 Jan 2008 17:41:18 +
From: "Jamie Tufnell" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Re: How to keep at-most N rows per group? periodic DELETEs or
constraints or..?
Message-ID:
<[EMAIL PROTECTED]>
On 1/8/08, codeWa
I think what you want is related to this post on how to create a FIFO
queue in Postgres:
http://people.planetpostgresql.org/greg/index.php?/archives/89-Implementing-a-queue-in-SQL-Postgres-version.html
The major difference is that you want a FIFO queue per user_id, so the
triggering code would
2007, Erik Jones wrote:
On Dec 18, 2007, at 10:53 AM, Steve Midgley wrote:
Hello again,
Reading a previous recent post and answers called "Describe Table"
got me thinking about a little piece of SQL I use in an application
to get a list of all the tables for a specific namespace:
select
Hello again,
Reading a previous recent post and answers called "Describe Table" got
me thinking about a little piece of SQL I use in an application to get
a list of all the tables for a specific namespace:
select pg_class.relname as table_name
from pg_class
join pg_namespace on pg_namespace.
Hi,
Rodrigo is exactly right in my opinion. To provide a little more info
on this calendar or day dimension idea..
You can create, for example, a time table dimension which stores every
day of every year as a unique record (for as far into the future as you
need). You can then associate vari
At 09:23 AM 12/7/2007, [EMAIL PROTECTED] wrote:
Date: Fri, 07 Dec 2007 14:22:26 +0100
From: "Stefan Scheidegger" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: INSERT INTO relational tables
Message-ID: <[EMAIL PROTECTED]>
Hi all
I'm new to SQL and I'm facing a problem I can't
find a
Hi,
(I posted this to the list on 10/25 but it didn't seem to get
distributed - apologies if it did and I'm actually double posting right
now..)
I've read on this list about some pretty powerful examples of using
expressions in order by clauses to sort according to very complex
rules. I kin
Hi,
Given a table (truncated some real fields for simplicity):
CREATE TABLE city
(
id serial NOT NULL,
muni_city_id integer,
post_code_city_id integer,
alias_city_id integer,
city_type character varying(15),
post_code_type character varying(15),
CONSTRAINT city_pkey PRIMARY KEY (id
Hi,
I'm not sure if you have access to a scripting language (like perl or
ruby) but my experience is that if you transform the source text file
into a secondary text file that postgres "copy" can read
natively/directly into the data formats you want, the copy command will
move everything into
Hi Peter,
I struggled to implement Michael's suggestion to use CACHE in this
regard when he made it but after your encouragement I've studied it
more and you and he are both totally right - CACHE is designed to do
exactly what I want. Here's the sample code so as to put this issue to
bed and
would
manifest, I'll post a warning on the RoR bug tracking site so that
people can at least understand that there's a potential bug here..
Thanks again,
Steve
At 08:42 PM 8/3/2007, Scott Marlowe wrote:
On 8/3/07, Steve Midgley <[EMAIL PROTECTED]> wrote:
> Hi Scott,
>
mands but they're only allowed to run against TABLES not
SEQUENCES - too bad - that would have been perfect.
I'm now starting to think that there's no way to solve this problem in
an "elegant manner" even in a stored procedure? Your method seems to be
as good as it
Hi,
I'm writing an import app in a third party language. It's going to use
"copy to" to move data from STDIN to a postgres (8.2) table. There are
some complexities though: it's going to copy the records to a
"versioned" table first, and then at a later time the records will be
copied by a dif
Hello,
I have a strange problem (or one that I've never had before anyway). I
am searching for a list of "id's" for a given table (these id values
are generated at run-time and held statically in an application-local
variable).
From that application, I want to retrieve all those rows, and I
Hi John,
It sounds like a disk-bound operation, so cpu is not maxed out. I'm not
clear on all the details of your operation but it sounds like you're
using Java to do row-by-row based inserts, selects and updates within a
transaction, from a file. This can be a very slow process if you have
m
Hi,
I think I had the exact same problem as you do a while back and I
solved it by removing the header row and the "CSV HEADER" clause of the
statement. For the large files I had, it was easier (for me) to remove
the header row than it was to escape out all the quotes (or regen the
file):
C
Hi Greg,
While not in a C++ framework, you might find that it's not too hard to
implement something similar in your system - It's called "Single Table
Inheritance." References to the Ruby on Rails implementation here:
http://wiki.rubyonrails.org/rails/pages/SingleTableInheritance
It's based
do appreciate any education or insight here. Are C code "patches" or
functions more of a risk to server stability/reliability than higher
level code? Or am I speaking gibberish?
Thanks,
Steve
At 01:01 AM 3/6/2007, Peter Eisentraut wrote:
Steve Midgley wrote:
> my ISP that m
your time. I'll certainly
repost to the list with whatever I uncover.
I really do appreciate the help you've provided.
Sincerely,
Steve
At 12:21 PM 3/5/2007, you wrote:
On Mon, 5 Mar 2007, Steve Midgley wrote:
Hi,
First off, can I say how much I love GiST? It's already solv
Hi,
First off, can I say how much I love GiST? It's already solved a few
problems for me that seemed impossible to solve in real-time queries.
Thanks to everyone who works on that project!
I'm developing a geographic index based on a set of zip code
boundaries. Points of interest (POI) will
Hi Rommel,
I thought I'd throw a little more input in, as an alternative to psql.
I use Ruby on Rails with Postgres, and for testing, it drops the
testing database, recreates it and loads the structures dumped from the
development database, before running tests - to ensure a clean test
every
Hi,
For what it's worth, WindowsXP (at least) seems to currently support
forward slashes at the OS level, so this Postgres behavior isn't as odd
as it might seem. If you enclose your paths with double quote (")
marks, Windows will even accept Unix style paths for some instructions
on the comm
81 matches
Mail list logo