Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-15 Thread Emmanuel Charpentier
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://www.postgresql.org/docs/faqs

[HACKERS] May I have som syntactic sugar, please ?

2003-02-10 Thread Emmanuel Charpentier
(maybe with a cascade option, deleting unupdtable objects as needed ?). Am I dreaming awake ? Or is this implementable ? An sufficiently generally useful ? Comments ? Emmanuel Charpentier -- Emmanuel Charpentier ---(end of broadcast)--- TIP 6

Re: [HACKERS] [Fwd: Backporting parts of databases from a 7.3 server

2003-02-04 Thread Emmanuel Charpentier
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 production server is not reachable

[HACKERS] [Fwd: Backporting parts of databases from a 7.3 server to 7.2 : How?]

2003-02-03 Thread Emmanuel Charpentier
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 often ... Original Message

Re: [HACKERS] [mail] Re: Win32 port patches submitted

2003-01-21 Thread Emmanuel Charpentier
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 just all

Re: [HACKERS] [mail] Re: Win32 port patches submitted

2003-01-21 Thread Emmanuel Charpentier
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 using gdb

Re: [HACKERS] [mail] Re: Win32 port patches submitted

2003-01-21 Thread Emmanuel Charpentier
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 broadcast

Re: [HACKERS] Survey results from the PostgreSQL portal page

2003-01-20 Thread Emmanuel Charpentier
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: Have you

Re: [HACKERS] default to WITHOUT OIDS? Possible related problem

2003-01-19 Thread Emmanuel Charpentier
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)--- TIP 5: Have you

Re: [HACKERS] Open 7.3 issues

2002-08-15 Thread Emmanuel Charpentier
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 do a

[HACKERS] Possible enhancement : replace view ?

2002-08-13 Thread Emmanuel Charpentier
-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 appropriate subscribe-nomail

Re: [HACKERS] Possible enhancement : replace view ?

2002-08-13 Thread Emmanuel Charpentier
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 the actual execution plan.Modifying a view definition would entail

Re: [HACKERS] Possible enhancement : replace view ?

2002-08-13 Thread Emmanuel Charpentier
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 of undrlying table/column will _not_ drop the view, but just mark it dirty 3. Using

[HACKERS] Current ODBC driver(s) problems with 7.1

2001-03-01 Thread Emmanuel Charpentier
, where can I find the docs of the 7.0 system tables ? I know where the 7.1 docs are ... Sincerely yours, Emmanuel Charpentier

Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Emmanuel Charpentier
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

[HACKERS] ODBC protocol changes in 7.1 ? And to pgaccess ?

2001-02-07 Thread Emmanuel Charpentier
pgaccess ? Views doesn't show up, while psql sees them. -- Emmanuel Charpentier

Re: [HACKERS] Re: MySQL and BerkleyDB (fwd)

2001-01-23 Thread Emmanuel Charpentier
problems, with data sources ranging from SAS datasets under MVS/XA to Excel files to Oracle databases to younameit ... That's the kind of problem I would *love* to have PostgreSQL to cope with, and *not* M$ Access ... [ Back to lurking mode ... ] E. Char

Re: [HACKERS] copy from stdin; bug?

2001-01-18 Thread Emmanuel Charpentier
awfully busy and once said that 7.1 required a *lot* of packaging ... Better not bug him right now ... -- Emmanuel Charpentier

Re: [HACKERS] A post-7.1 wish-list.

2001-01-10 Thread Emmanuel Charpentier
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 possibly be higher with any

Re: [HACKERS] A post-7.1 wish-list.

2001-01-10 Thread 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 feature but I don't know of anyone who has made

[HACKERS] A post-7.1 wish-list.

2001-01-07 Thread Emmanuel Charpentier
ative" 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

Re: [HACKERS] Re: Beta2 ... ?

2001-01-06 Thread Emmanuel Charpentier
to produce, and that Oliver Elphick is almost alone on this task. -- Emmanuel Charpentier

[HACKERS] NULLS and : Discrepancies ?

2000-12-29 Thread Emmanuel Charpentier,,,
quot;CleUtil" 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. /NewbieMode LurkingMode Emmanuel Charpentier

Re: [HACKERS] Tuple data

2000-12-18 Thread Emmanuel Charpentier,,,
Hiroshi Inoue wrote : [ ... ] Column order isn't essential in rdbms. Nitpicking 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.