At 01:10 +0200 on 06/10/1999, Howie wrote:
> for now, refint ( $PGSQL_SRC_ROOT/contrib/spi/ ) is what one should be
> using for foreign keys. requires two triggers, one on the parent and one
> on the child. works nicely.
Does it? I was under the impression that it supported cascading deletes
5 Oct 99,-kor Bruce Momjian wrote:
> > Hello everyone,
> >
> > I would just like to know if the Foreign key constraint feature should be a one
> > of a near release... Any idea?
>
> Planned for 6.6, due in a few months.
And the INNER, OUTER JOIN statements?
Bye:
Andrew Csehi
Hi,
I sent out the forwarded message below last Sunday, and have received no
responses.
Now I realize that this list operates on a volunteer basis and that
everyone is busy, so I am in no way demanding or expecting an answer,
but I would really like to know if there is something wrong with the
m
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> 5 Oct 99,-kor Bruce Momjian wrote:
>
> > > Hello everyone,
> > >
> > > I would just like to know if the Foreign key constraint feature should be a one
> > > of a near release... Any idea?
> >
> > Planned for 6.6, due in a few months.
>
At 15:30 +0200 on 06/10/1999, Frank Mandarino wrote:
> main=> create index ven_code_idx on vendor using btree (ven_code char_ops);
> CREATE
I didn't have time to check this, but the problem may be caused by the
incorrect ops you are using. For char(N) it should be bpchar_ops, not
char_ops.
Her
Yeah, darwin is the database I want to backup, but it complains about
template1 not existing.. I can psql into both darwin and template1 - but I
can pg_dump neither.
nm
On Wed, 6 Oct 1999, Mike Mascari wrote:
> > [nikm@db01 /tmp]# pg_dump -o darwin > q
> > pg_dump: couldn't find the template1
On Wed, 6 Oct 1999, Mike Mascari wrote:
> You show yourself attempting to dump a database
> called "darwin", while connecting to and displaying
> tables in the "template1" database. If the data you
> wish to dump is in template1, you should issue the
> command:
But, as his message indicated, the
On Wed, 6 Oct 1999, Herouth Maoz wrote:
> At 01:10 +0200 on 06/10/1999, Howie wrote:
>
>
> > for now, refint ( $PGSQL_SRC_ROOT/contrib/spi/ ) is what one should be
> > using for foreign keys. requires two triggers, one on the parent and one
> > on the child. works nicely.
>
> Does it? I was
> It would be very nice you could add to the above the features that
> MySQL has that postgreSQL is missing. PostgreSQL does have some
> features that MySQL lacks, but MySQL does support a lot of ODBC and
> ANSI SQL things that postgreSQL doesn't support. We have also put a
> lot of effort in MyS
On a related note I'd like to mention that seemingly a lot got lost in
6.5.2. I tried to upgrade from 6.5.0 to 6.5.2 via the two patches which
did not apply cleanly by the way, complaining about reverse patches on
some Alpha and Linux PPC file (neither of which I have) and then all the
template fi
> On a related note I'd like to mention that seemingly a lot got lost in
> 6.5.2. I tried to upgrade from 6.5.0 to 6.5.2 via the two patches which
> did not apply cleanly by the way, complaining about reverse patches on
> some Alpha and Linux PPC file (neither of which I have) and then all the
> t
Wow, where do I start with this?
> Bruce> I am talking about the database comparison chart. We said in the past,
> Bruce> "Hey, you don't mention a major feature that every DBMS should have, and
> Bruce> that is transaction/rollback, and they said, "We don't know how to test
> Bruce> for that."
--- Michael Plump <[EMAIL PROTECTED]> wrote:
> On Wed, 6 Oct 1999, Mike Mascari wrote:
>
> > You show yourself attempting to dump a database
> > called "darwin", while connecting to and
> displaying
> > tables in the "template1" database. If the data
> you
> > wish to dump is in template1, you sh
Hello,
Anybody know any easy way to ALTER the column type of a column in an
existing table without dumping it?
Something akin to : ALTER TABLE tableOne CHANGE fieldOne
VARCHAR(100).
I have a limited varchar field that I want to change to TEXT.
I am using 6.4.
Thanks in adva
14 matches
Mail list logo
