On 6/21/07, danmcb <[EMAIL PROTECTED]> wrote:
Hi
I have two tables, say A and B, that have a many-to-many
relationship, implemented in the usual way with a join table A_B.
How can I economically find all the rows in table A whose id's are not
in A_B at all (i.e. they have zero instances of B a
On 6/21/07, brian <[EMAIL PROTECTED]> wrote:
I have a lookup table with a bunch of disciplines:
# SELECT id, name FROM discipline;
id |name
+-
1 | writing
2 | visual arts
3 | music
4 | dance
5 | film and television
6 | theatre
7 | media arts
On 7/8/07, Crystal <[EMAIL PROTECTED]> wrote:
Hi All,
Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website address may be very long
On 7/20/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Jul 20, 2007, at 17:54 , Vincenzo Romano wrote:
> In an inner join involving a 16M+ rows table and a 100+ rows table
> performances got drastically improved by 100+ times by replacing a
> UNIQUE-NOT NULL index with a PRIMARY KEY on th
ette I may have committed in
posting to two lists simultaneously.
- Josh Tolley
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messa
On 8/2/07, Gavin M. Roy <[EMAIL PROTECTED]> wrote:
> Are you contemplating providing access to data that's currently not stored
> in the pg_ catalog tables? I currently monitor the statio data,
> transactions per second, and active/idle backends. Things that I think
> would be useful would be ave
On 8/3/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> Can anyone shed some light on this. I just would like to know if queries
> for raw data (not aggregregates) is expected to take a long time.
> Running times between 30 - 2 hours for large dataset pulls.
>
> Involves lots of joins on very large tab
On 8/6/07, Rodrigo Faccioli <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm a new user's postgreSQL and I have a question: Is possible add function
> of intelligent System like Neural Networks or Fuzzy Logic within postgre
> SGDB?
>
> For example: I have a database and I want to execute a select instructi
On 8/14/07, Kirk Wythers <[EMAIL PROTECTED]> wrote:
>
> I need some help with rewriting a query. I have a fairly complicated query
> (for me anyway) that dumps daily climate data, filling in missing data with
> monthly averages (one line per day).
>
> I want to output monthly averages (one line per
On 8/15/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> Trevor Talbot wrote:
> > On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
> >
> >> Let me fine tune my question here. What I mean to say is the way we can
> >> write stored procedures in C, perl etc in Postgres specifying the langu
On 8/15/07, Rohit <[EMAIL PROTECTED]> wrote:
> I have few queries regarding the use of Stored Procedures, Functions
> and Triggers in an RDBMS.
>
> (1) When to use Stored Procedure? Writing an INSERT query in a Stored
> Procedure is better or firing it from the application level?
>
> (2) Can a Trig
On 8/18/07, Julio Cesar Sánchez González
<[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> It's natural what master table in the partitioning table contain data
> (http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html) ?
> or to be empty.
I'm no partitioning expert, but I would say most of
On 8/18/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> Interesting. Does PG have to initiate the Perl interpreter every
> time you call a Perl-written SP?
IIRC PostgreSQL should only load the perl interpreter once per session.
- Josh
---(end of broadcast)--
On 8/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a question about whether I can safely declare a function IMMUTABLE.
> Citing the documentation under "Function Volatility Categories" in the
> section on "Extending SQL":
>
> It is
On 8/31/07, Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote:
> Phoenix Kiula írta:
> > I am getting this message when I start the DB:
> >
> >
> > psql: FATAL: could not access status of transaction 0
> > DETAIL: Could not write to file "pg_subtrans/01F8" at offset 221184:
> > No space left on device
On 8/31/07, Alban Hertroys <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've recently been busy improving a query that yields a fixed number of
> random records matching certain conditions. I have tried all the usual
> approaches, and although they do work, they're all limited in some way
> and don't tr
On 9/1/07, john_sm <[EMAIL PROTECTED]> wrote:
>
> Hey Guys, can you suggest any Open Source Application Server for SOA
> deployments. Also, wondering, if our needs are somewhat lightweight, is
> there some lightweight open source Application Server you could Suggest.
What language are your applic
On 10/1/07, S Sharma <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> The default table space defined in db conf file is used for all database
> tables as well as indexes. So putting the indexes on another table space
> requires manually dropping and re-creating indexes.
> It would be nice to have a featur
On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two questions on the above:
>
> 1. I found in some postings recommended to use triggers instead of
> rules. Is this documented somewhere?
A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/e
On 10/4/07, Ted Byers <[EMAIL PROTECTED]> wrote:
> --- Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> >
> > On Oct 4, 2007, at 9:30 , Ted Byers wrote:
> >
> > > I do not know if PostgreSQL, or any other RDBMS,
> > > includes the ability to call on software such as
> > "R"
> >
> > See PL/R:
> >
>
On 10/6/07, Goboxe <[EMAIL PROTECTED]> wrote:
> Josh,
>
> Thanks for sharing a very good info on partitioning.
>
Don't thank me -- this comes from Robert Treat. I'm just the messenger :)
-Josh/eggyknap
---(end of broadcast)---
TIP 2: Don't 'kill -9
On 10/24/07, Bob Pawley <[EMAIL PROTECTED]> wrote:
> Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into
> a PostgreSQL Database??
>
> Bob Pawley
I know nothing of AutoCad, but your message has been sitting for a
while without response, so I'll throw out the suggestion th
On 11/4/07, Reg Me Please <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I'd like to know whether the indexes on a table are updated or not during
> a "COPY ... FROM" request.
>
> That is, should I drop all indexes during a "COPY ... FROM" in order to gain
> the maximum speed to load data?
>
> Thanks.
A
People tend to like the idea of PL/R, because R draws some awfully
nice (and frequently useful) eye candy, and it sounds cool to be able
to make such things from inside PostgreSQL. In my (probably very
limted) experience those people often find that it's harder than it
looks to make these plots wor
On Mon, Mar 17, 2008 at 2:27 AM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hi Sam,
>
> Thankyou for the suggestions. They make perfect sense to me. I
> appreciate your time and input. The lack of optimiser usage was
> something that I had not considered, and I thank you for making me
> awa
While developing PL/LOLCODE, I've found something wrong with returning
strings from LOLCODE functions using 8.3.0 or greater. Using 8.4beta
from a few days ago, for instance, a function that should return "test
string" returns
"\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F\x7F" in
pgsql
On Mon, May 12, 2008 at 4:53 PM, D Galen <[EMAIL PROTECTED]> wrote:
> If this isn't the right place to post this, please advise.
>
> I've spent a week trying to get PostgreSQL 8.3 to install correctly on
> WIN2K. Server will load & I see the server processes loaded but none of
> them have any ope
On Thu, Jun 19, 2008 at 8:17 AM, Bill Moran
<[EMAIL PROTECTED]> wrote:
> In response to "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
>
>> Hello,
>>
>> i have the problem that postgres ist starting and stopping several (up
>> to 4) processes per minute, so that the error log in windows is
>> running fu
28 matches
Mail list logo
