s. i.e. Let the database explicitly
have info about what each column can do.
I'd second that, even if it takes time ...
Emmanuel Charpentier
--
Emmanuel Charpentier
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http:
y the same as above, but
*keeping the old column id* and *propagating* changes as needed in defined
view and indices (maybe with a "cascade" option, deleting unupdtable
objects as needed ?).
Am I dreaming awake ? Or is this implementable ? An sufficiently "gener
Tom Lane wrote:
Emmanuel Charpentier <[EMAIL PROTECTED]> writes:
However, this does *not* work between a 7.3-generated dump and a 7.2
production server. The archiver complaints of an 'unknown archive format :
"0"' (I'm quoting this from the top of my head : my pro
Posted about 2 weeks to the "General" and "Questions" lists. Got no answers
and found no workaround (yet !).
Any ideas ?
Emmanuel Charpentier
PS : If possible, Please Cc: to [EMAIL PROTECTED] : I'm reading
the list through the news server, and nor very oft
Dann Corbit wrote:
[ ... ]
GDB works fine. Some of the other tools don't work right (e.g. sed is
broken).
Recent fixes exist, but I didn't check all of them. WorksForMe(TM), but my
projects are *much* simpler ...
Emmanuel Charpentier
---(end of
Jan Wieck wrote:
Emmanuel Charpentier wrote:
Mingw and mingw-ported tools ? That's a nice small and cozy unix-like
envoronment on tom of Windows. Add it emacs, and windoww becomes almost
tolerable ...
How good is the debugging support under mingW? Is it at least comparable
to usin
Mingw and mingw-ported tools ? That's a nice small and cozy unix-like
envoronment on tom of Windows. Add it emacs, and windoww becomes almost
tolerable ...
Emmanuel Charpentier
[ Back to lurking ... ]
Brian Bruns wrote:
Problem is, nobody builds packages on windows anyway. They jus
e 7.2 to 7.3
modifications ...]
The same could be said of the JDBC driver, btw, while it's doc is still in
the main doc tree.
This one is one of my pet peeves at the moment ...
Emmanuel Charpentier
---(end of broadcast)---
TIP 6
es, I have some Excel users
needing that) started complaining that "this table has no OID", which
really means that the ODBC driver complaints that ...
Is that a side effect of the above problem ?
Sincerely,
Emmanuel Charpentier
---(end of broadcast)
Christopher Kings-Lynne wrote:
[ ... ]
> What about this.
>
> 1. Implement pg_get_foreignkey_def() or whatever
> 2. Adjust pg_dump to dump foreign keys using an ALTER statement
> 3. Back port the above to rel 7_2_2
> 4. Release a 7.2.2 version and ask that people upgrade to that version and
> d
Hannu Krosing wrote:
> On Wed, 2002-08-14 at 04:23, Emmanuel Charpentier wrote:
>
>>Hannu Krosing wrote:
>>
>>>I'm trying to propose a scenario where
>>>
>>>1. The SELECT clause defining the view is preserved
>>>
>>>2. DROP
Hannu Krosing wrote:
> On Wed, 2002-08-14 at 04:08, Emmanuel Charpentier wrote:
>
>>Dear all,
>>
>
> ...
>
>
>>Of course, I am aware that view definitions aren't just stored, but that
>> a lot of rewriting is involved before storing th
efinition would entail re-processing of other
view definitions. But so is the case with the modification of a table ...
What do you think ?
--
Emmanuel Charpentier
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an app
one.
Any thoughs ?
And, BTW, where can I find the docs of the 7.0 system tables ? I know
where the 7.1 docs are ...
Sincerely yours,
Emmanuel Charpentier
cklog is ...
impressive. ]
These issues might seem small change to you die-hard plpgsql hackers. To
a lmot of people using Postgres for everyday office work through "nice"
interface, it's bread-and-butter, and these issues *should* be fixed
*before* release ...
[ crawling back under my rock ... ]
Emmanuel Charpentier
he catalog of all of the tables & fields OK
> > through the same login.
> >
> > I played with all of the options of the ODBC driver & postgres security &
> > could not find a solution. Also, searched the site for any similar
> problems
> > & found no posts.
> >
> > Can anyone verify this problem? Any ideas?
> >
> > Thanks for the help,
> >
> > Steve Shaffer ([EMAIL PROTECTED])
> >
--
Emmanuel Charpentier
?
And, BTW : what has happened to pgaccess ? Views doesn't show up, while psql
sees them.
--
Emmanuel Charpentier
of problem I would
*love* to have PostgreSQL to cope with, and *not* M$ Access ...
[ Back to lurking mode ... ]
E. Charpentier
--
Emmanuel Charpentier
n your Debian 2.2
> system.
Oliver Elphick seems awfully busy and once said that 7.1 required a
*lot* of packaging ... Better not bug him right now ...
--
Emmanuel Charpentier
ge tool, use Office 95 or 97,
but are tired of MS' endless "upgrade" tax and won't "upgrade" to Office
2000, except at gunpoint (i. e. disappearance of volume license
agreements for O95 or O97).
So I'm afraid these versions will have a lng life ...
Emmanuel Charpentier
--
Emmanuel Charpentier
Peter Eisentraut wrote:
>
> Emmanuel Charpentier writes:
>
> > 1) Updatable views.
>
> You can make rules updateable by attaching appropriate rules to them.
> The transparent implementation of updateable views would essentially do
> that. It's a planned featur
Horst Herb wrote:
>
> On Sunday 07 January 2001 21:31, Emmanuel Charpentier wrote:
[ ... ]
> Excuse me, but where has MS Access competence? It is a pretty useless data
> lottery with an admittedly very capable & easy user interface. The odds of
> data corruption can't
them as "native" tables.
Of course, the use of these bridges involve some (maybe quite serious)
performance loss. But then again, I'm less interested in performance
than in competence ...
What do you think ?
Emmanuel Charpentier
--
Emmanuel Charpentier
an packages as well, for similar reasons.
But I'm aware that those are harder to produce, and that Oliver Elphick
is almost alone on this task.
--
Emmanuel Charpentier
til" is
not null);
Cle
-
2
3
4
(3 rows) -- That's what I expected in the first place.
Could someone explain to me why not eliminating nulls destroys the
potential results of the query ? In other words, for any X not null, X
not in (some NULLs) is false.
Emmanuel Charpentier
Hiroshi Inoue wrote :
[ ... ]
> Column order isn't essential in rdbms.
A relation (a table) is a subset of the Cartesain cross-product of the
definition domains of the attributes (columns). Cartesian product being
a commutative operation, "order of columns" does not really exists. Period.
26 matches
Mail list logo
