On Sat, 2003-11-29 at 04:37, cnliou wrote:
> "Jason Tesser" <[EMAIL PROTECTED]>
>
> > MySQL cannot even handle sub-queries yet.
>
> Ohh! Really?
> Allow me to pay my highest respect to the genius mySQL
> programmers!
> I completely have no clue on how to construct any single
> tiny database on
HI All,
I'm glad that this thread prompted some thoughtful response. I think
one of my main points I was trying to make, Jason hit the nail on the
head. The article to which I was referring uses a great example which I
have experienced many times before, but in order to grasp this, PHP et
a
I'm in agreement with Joshua in some aspects of his reply but not
others. I use Reiserfs on many production servers and have done so for
a couple of years. I have needed perform one repair only on the
filesystem, which was automated with the tools provided. Reiser is
still beta, in the same
On 25/11/2003 21:55 Jeremiah Jahn wrote:
[snip]
I have found that it is best to have a separate connection for BLOB's
and one for everything else. Mind you, this is with Java, but the
autocommit settings on the connection don't appear to be thread safe, so
in high traffic you can accidentally cut o
Further to this post, what might actually work is to convince O' Reilly
(since they have PostgreSQL book/s) to do some articles like they have
for PG, but making full use of the PG database. For instance, building
a simple data-warehouse using PG. Articles that show off an OSS
product/project
On 28/11/2003 17:10 Jason Tesser wrote:
[snip]
I completely disagree. I do a lot of programming with PHP and the
features
of Postgres come in handy. Let me give you an example of just some
basic things. Triggers! Why should I have to write insert and update
triggers in the logic (PHP) if I can
> "Permission to use, copy, modify, and distribute this software and its
> documentation for any purpose, WITHOUT FEE, and without a written
> agreement is hereby granted, provided that the above copyright notice
> and this paragraph and the following two paragraphs appear in all
> copies."
My pe
> > Java has its own issues and I am not sure it is as far supiour as you
> > are claming it is. But that is not for this dscussion.
>
> I'm not aware of any "issues" with Java (unless you mean Swing ;)).
I know for one thing - Java's lack of support for returning tuples is
hugely annoying.
Jon
Paul Thomas wrote:
>
>
>
> On 28/11/2003 17:10 Jason Tesser wrote:
> > [snip]
> >
> > MySQL cannot even handle
> > sub-queries yet. I also use Python for standalone interfaces to
> the data.
> >
> > Why should I not be able to use the same views and triggers etc
> in there
> > that I use for my
From: "Paul Thomas" <[EMAIL PROTECTED]>:
> Stored procedures can be a 2-edged sword. They can lead to business logic
> being scattered between the persistence layer and the business layer.
> Thats not good for maintaining the application 3 years down the line.
> Triggers can also cause maintenance
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Why not use the inet type, which can support both formats?
What will you do with local Unix connections?
regards, tom lane
---(end of broadcast)---
TIP 7: don't forget to increase
Hi all,
a few days ago, I upgraded from PostgreSQL 7.2.1 to 7.4, following
the instructions in the INSTALL file, including dump and restore.
All this worked fine without any error (message).
Since then, I found lots of the following in the postmaster output:
2003-11-29 15:19:54 [1359] ERROR: lar
I can create a function with a domain and
define it to return a domain.
The parameter is checked to see if it qualifies
in the constraint of the domain, however, the
return value is not.
Is this a bug? Is the author of the function
responsible for re-inforcing the constraint
at runtime?
This
I have a table which contains three
columns of domain X.
If I drop the domain X with cascade,
the table remains with no columns.
Is this the proper behaviour?
It seems to me that any action which
results in an invalid object should be
forbidden. On the other hand, with
alter table working well,
On Tue, 2003-11-25 at 02:13, Markus Wollny wrote:
> Hi!
>
> I haven't found anything in terms of startup- and check-scripts for
> pg_autovacuum yet; usually I like to have some sort of mechanism to
> check if some daemon is running and restart it if it isn't.
The Debian package of 7.4 starts pg_a
Jason Tesser wrote:
[snip]
A programmer that doesn't document stuff needs to find a new job :-)
This is more of an issue with management. Anyone who does database apps
for on any kind of a large scale will tell you that views, triggers, etc..
are essential. I am currently in teh process of writi
Shane D <[EMAIL PROTECTED]> writes:
>Could someone explain to me the usefulness of views? I understand
> how they are created. I understand a single query can be created as a
> view returning all records in a single column of a single table, or
> maybe even multiple columns across many table
elein writes:
> It seems to me that any action which
> results in an invalid object should be
> forbidden. On the other hand, with
> alter table working well, I am loathe
> to argue a table with no columns is
> an invalid argument.
While not allowed according to the SQL standard, we have decided
On Sat, 2003-11-29 at 20:46, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Why not use the inet type, which can support both formats?
>
> What will you do with local Unix connections?
Why not use 127.0.0.1 or the ipv6 equivalent.
--
Suchandra Thapa <[EMAIL PROTECTED]>
signa
elein <[EMAIL PROTECTED]> writes:
> I have a table which contains three
> columns of domain X.
> If I drop the domain X with cascade,
> the table remains with no columns.
> Is this the proper behaviour?
Yes, we agreed some time ago that that is the best thing to do.
regard
Doug McNaught wrote:
It's false. You can treat a view just like a table and add clauses to
your query that restrict it beyond what the view gives you. I think
that's what you're asking about...
Thanks for your reply.
I found an example in the postgresql reference manual in the "CREATE
VIEW
Shane D <[EMAIL PROTECTED]> writes:
>But what if the films table also had a field for the production
> company. This implies based on the view definition that it too, has
> the field (call it prod_co). Could I use the following query to
> select all Comedy films distributed by the 'Small Com
I upgraded to 7.4 a few days ago and am getting these
errors when importing dumps: "permission denied to set
session authority" and "permission denied for schema
public". Not all of the dump is imported successfully.
Are these errors due to new features in 7.4? Do I need
to add more permissions for
When grilled further on (Tue, 25 Nov 2003 11:19:32 -0500),
"Matthew T. O'Connor" <[EMAIL PROTECTED]> confessed:
> I know I heard from at least one person who said they were running it
> from there inittab with respawn, which seems like overkill.
Nah, it works great (it was me). I just had an un
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Brian Hirt wrote:
> here's a patch that j
Bruce,
for what it's worth, Matthew O'Connor submitted a patch which includes
my patch.
best regards,
Brian Hirt.
On Nov 29, 2003, at 10:14 PM, Bruce Momjian wrote:
[ Attachment, skipping... ]
---(end of broadcast)---
TIP 7: don't forget to in
On Sat, 2003-11-29 at 04:26, Randolf Richardson wrote:
...
> Keep in mind that (at least in Canada) contractual agreements are only
> valid when an aspect called "consideration" exists, which means that both
> parties benefit in some way (which must not be grossly unfair to one side).
>
>
27 matches
Mail list logo
