Hello list,
what about uniqueness of inherited primary keys ?
eg you have :
create table objects (
id int4,
date_created timestamp(0),
primary key (id)
);
create table persons (
firstname varchar(100),
lastname varchar(100)
) inherits (objects);
now ...
insert into objects (id) values
Alas, it's one of the biggest shortcomings of email. My apologies for
grasping the wrong end of the stick.
All of your points are valid, but there is always room for a larger
user community, especially in one that is almost entirely voluntary.
It's OK to be aloof and niche, Debian has done
I was
thinking more along the lines of a company that said "Hey, we've got a
core app on MySQL which is running like a bag of bolts, can you come
and troubleshoot it for us." A company quite rightly would get a
little edgy with someone saying sorry guys, it's new DB time. You'd
want to go and
On Sun, Dec 28, 2003 at 12:57:10PM -0500, Casey Allen Shobe wrote:
> Martijn van Oosterhout (Sunday 28 December 2003 04:56)
> > Interesting, I found them in psql's manpage under ADVANCED FEATURES -
> > VARIABLES. Let's see if I can find it on the web... Here's a web version of
> > the manpage.
>
>
Quoting Gaetano Mendola <[EMAIL PROTECTED]>:
> Chris Travers wrote:
> > Regarding the importance of PostgreSQL on Windows.
> >
> > For example, I am developing a hotel reservation management application
> > using Python and PostgreSQL (http://sourceforge.net/projects/openres).
> This
> > will on
Quoting Tony <[EMAIL PROTECTED]>:
> Sadly a company will believe anything that a consultant they trust tells
> them. Otherwise there'd be little point in hiring a consultant to give
> them advice would there?
There are different levels of trust and in addition sometimes consultants are
used fo
Quoting Shridhar Daithankar <[EMAIL PROTECTED]>:
> On Sunday 28 December 2003 11:15, D. Dante Lorenso wrote:
> > The only SQL customizations that MySQL has that I really miss in
> PostgreSQL
> > are the commands:
> >
> > SHOW DATABASES;
>
> \l
>
> > SHOW TABLES;
>
> \dt
>
> > DESC
Chris Travers (Sunday 28 December 2003 01:24)
> With 7.4, PostgreSQL implements the standard information_schema so that one
> can essentially get all this information in a standard way with will
> presumably not be brokent too much in future versions. Prior to this
> release, you have to dig the i
Martijn van Oosterhout (Sunday 28 December 2003 04:56)
> Interesting, I found them in psql's manpage under ADVANCED FEATURES -
> VARIABLES. Let's see if I can find it on the web... Here's a web version of
> the manpage.
Ahh, I have seen those...but they're specific to psql, and if memory serves me
I've asked this before and I'll apologize now if there was a response but how
does http://gborg.postgresql.org NOT fill this.
Quoting Chris Travers <[EMAIL PROTECTED]>:
> Hi all;
>
> The problem with trying to maintain an image of unity is that PostgreSQL is
> moving in a direction of being sort
Tony (Sunday 28 December 2003 10:30)
> The native windows port is certainly useful for me when I was
> developing for MySQL applications, I always ran a copy on my Windows
> laptop which started as a service, and was most useful. I used to Rapid
> Devel and prototype all of my DB apps this way
"Carmen Wai" <[EMAIL PROTECTED]> writes:
> Do any one know the max length of a SQL statement?
There is no specific limit; it'll depend on available memory and
complexity of the statement. I've run tests with multi-megabyte
string literals, tens of thousands of WHERE clauses, etc.
MySQL's "crashm
On 28/12/2003 14:44 Tony wrote:
[snip]
This really rattled some peoples cages and I ended up defending PG
against some really ill thought out attacks. Like:
MySQL User: But can PG deal with really complicated joins.
Me: In many cases the extra functionality of PG avoids the problems
where real
Sadly a company will
believe anything that a consultant they trust tells them. Otherwise
there'd be little point in hiring a consultant to give them advice
would there?
It seems rather illogical that you'd refuse to work with a company that
had been given potentially sub-standard advice, bas
The native
windows port is certainly useful for me when I was developing for
MySQL applications, I always ran a copy on my Windows laptop which
started as a service, and was most useful. I used to Rapid Devel and
prototype all of my DB apps this way.
Whilst I can (and do) run PG on my
la
The confusing license
terms and conditions was one of the main reasons I appeared on this
list some weeks ago, when I was considering a commercial venture using
a JDBC client application, and couldn't untangle who needed licenses,
how many and what for exactly. After a breif foray on #postgres
Christian Kienle writes:
> Here are two pictures of the PostgreSQL booth on the Linux World Expo &
> Conference in Frankfurt 2003.
There are more photos here:
http://developer.postgresql.org/~petere/past-events/lwe2003-pictures/
---(end of broadcast)---
In 7.2, how would you change ownership of a database and all its tables
and sequences?
Right now everything is owned by postgres and I want to change ownership
to a regualar user.
--
[ Russ Schneider (a.k.a. Sugapablo) ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.n
On 28/12/2003 01:57 Chris Travers wrote:
Regarding the importance of PostgreSQL on Windows.
For example, I am developing a hotel reservation management application
using Python and PostgreSQL (http://sourceforge.net/projects/openres).
This
will only run on Linux and UNIX, so in order to get this t
Hello:
Do any one know the max length of a SQL statement?
Thanks!
Carmen
_
No masks required! Use MSN Messenger to chat with friends and family.
http://go.msnserver.com/HK/25382.asp
---(end of broadcast)
On 28/12/2003 08:47 John Sidney-Woollett wrote:
I have found pgAdmin III to be an absolute godsend - this product is
brilliant. With it, I can see all databases, schemas, objects, and grants
quickly and clearly. This one tool turned postgres into an absolute joy
to
use (in much the same way that TO
Hi Dante;
From: "D. Dante Lorenso" <[EMAIL PROTECTED]>
> I started with MySQL and it WAS easier to use. It was easier because
> the manual essentially reads:
>
>-- we didn't implement anything complicated that's why
>-- we are fast.
>
> The only SQL customizations that MySQL has that I re
On Sun, Dec 28, 2003 at 04:29:56AM -0500, Casey Allen Shobe wrote:
> Martijn van Oosterhout (Sunday 28 December 2003 02:57)
> > Yes, they do vary, there is no stardard. As you point out, DB2 and MySQL
> > use different commands, as does probably every other database. There is no
> > command that is
23 matches
Mail list logo
