Re: [HACKERS] Dreaming About Redesigning SQL

On Fri, 2003-10-17 at 22:52, Christopher Browne wrote: > Nobody seems to have been prepared to explain the MV model in adequate > theoretical terms as to allow the gentle readers to compare the theory > behind it with the other theories out there. I'm not convinced that there was a great deal of t

Re: [HACKERS] [COMMITTERS] pgsql-server/src/backend/catalog information_s ...

[EMAIL PROTECTED] (Peter Eisentraut - PostgreSQL) writes: > Log message: > Information schema fixes: Now that that's done, are we going to force initdb to ensure the changes take effect? regards, tom lane ---(end of broadcast)

Re: [HACKERS] *sigh*

Thomas Zehetbauer writes: > psql cannot \i a file which name contains a blank character. \i 'blah blah blah' -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] PostgreSQL on Novell Netware 6.5.

"Eduardo D Piovesam" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Hi,> > > It's been quite a while ago that I did NetWare programming (3.11 NLM,> > communication protocol for a dbms), and that I had some contact with> > Netware (4.1), but if Novell didn't change the archi

Re: [HACKERS] Error with views containing sub-queries with distinct

"Sean P. Thomas" <[EMAIL PROTECTED]> writes: > Last night I just upgraded to a nightly snapshot of 7.4 and noticed an > error on queries that had previously worked (in version 7.3.x and > previous 7.4's snapshots up to about a month old). Fixed, thanks for the test case.

[HACKERS] *sigh*

psql cannot \i a file which name contains a blank character. Why doesn't it take the rest of the command line as the name of the file?!? Why doesn't it use any of the standard command line parsing libraries which respect "quoting" and \e\s\c\a\p\i\n\g?!? psql \i even does autocomplete to the file n

Re: [HACKERS] Dreaming About Redesigning SQL

"Christopher Browne" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Quoth "Anthony W. Youngman" <[EMAIL PROTECTED]>: > > In article <[EMAIL PROTECTED]>, Gene Wirchenko > > <[EMAIL PROTECTED]> writes > >>[EMAIL PROTECTED] (Seun Osewa) wrote: > >> > >>[snip] > >> > >>>Sometimes I wonde

Re: [HACKERS] Is there a reason why no table OID in pg_tables

On Saturday 18 October 2003 16:32, Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > > Not a real problem, I just used pg_class, but is the lack of oid in > > pg_tables a design decision and if so why? > > Views don't have OIDs (or any other system columns). And if they did, it wouldn

Re: [HACKERS] Is there a reason why no table OID in pg_tables

Richard Huxton <[EMAIL PROTECTED]> writes: > Not a real problem, I just used pg_class, but is the lack of oid in pg_tables > a design decision and if so why? Views don't have OIDs (or any other system columns). We could export pg_class.oid as an ordinary column in pg_tables, but then it would be

[HACKERS] Is there a reason why no table OID in pg_tables

I was just trying to compare constraints in two versions of a database and the obvious (to me) join from pg_constraint to pg_tables wasn't possible. Not a real problem, I just used pg_class, but is the lack of oid in pg_tables a design decision and if so why? -- Richard Huxton Archonet Ltd

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

Dear Jean-Paul, > Please tell me if my experience can help you in any way, I'd be really > glad in participating your project. Thanks for your proposal, welcome in the team. In short, we plan to port Compiere to PostgreSQL and submit the changes back to Compiere team. There is no evidence so fa

Re: [HACKERS] Mapping Oracle types to PostgreSQL types

Le Friday Oct 17, 2003 at 10:10:26AM +0200, Jean-Michel POURE a écrit : > Dear friends, > > I would like to port Compiere CRM from Oracle to PostgreSQL (and release it > for free). Hi Jean-Michel, I did Red-Hat CCM Migration from Oracle to PostgreSQL a year ago when I was the dba of IdealX, a