[HACKERS] type OIDs

2000-09-15 Thread Michael Meskes
Can I safely assume that the OID of the standard data types remain the same for future releases? And of course that they are the same for every installation? I've been send a patch to speed up ecpg significantly by not looking up datatypes everytime. As it is written right now it works by har cod

Re: [HACKERS] current is broken

2000-09-15 Thread Philip Warner
At 04:41 15/09/00 -0500, Jan Wieck wrote: > >So if you find an ON SELECT rule on a relation, it is a VIEW. > Thanks for this, but I'm using 'pg_views' now since it means pg_dump does not have to interpret the meanings of the various columns. With time, I would like to remove as much internal

[HACKERS] fkey + primary key does not work in current

2000-09-15 Thread Tatsuo Ishii
It seems that foreign key does not work in current, if specified with primary key definition. Take a look at following example(works in 7.0.2.): test=# CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, PRIMARY KEY(ptest1, ptest2, ptest3) ); NOTICE: CREATE TABLE/PRIMARY KEY

[HACKERS] Cannot compile

2000-09-15 Thread Michael Meskes
I just did a cvsup to get up-to-date again after I hadn't found time to work on ecpg for some months and found out that I cannot even compile anymore: make[3]: Entering directory /home/postgres/pgsql/src/backend/parser' gcc -MM -I../../../src/include -O2 -Wall -Wmissing-prototypes -Wmissing-decl

Re: [HACKERS] type OIDs

2000-09-15 Thread Tom Lane
Michael Meskes <[EMAIL PROTECTED]> writes: > Can I safely assume that the OID of the standard data types remain the same > for future releases? And of course that they are the same for every > installation? They are fixed in any one version, and really are not very likely to change across version

Re: [HACKERS] Cannot compile

2000-09-15 Thread Tom Lane
Michael Meskes <[EMAIL PROTECTED]> writes: > What's going on? I'd suggest a full "make distclean" and reconfigure. Looks like you missed some build steps, which is maybe not too surprising considering that Peter has extensively revised the Makefile tree. regards, tom lan

Re: [HACKERS] fkey + primary key does not work in current

2000-09-15 Thread Stephan Szabo
On Fri, 15 Sep 2000, Tatsuo Ishii wrote: > It seems that foreign key does not work in current, if specified with > primary key definition. Take a look at following example(works in > 7.0.2.): > > test=# CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, >PRIMARY KEY(ptest1

[HACKERS] Expired records ?

2000-09-15 Thread Eje Gustafsson
Hello Stephan, I think this listserver hates me. none of my messages seem to go through. Anyone read this ?? I need to get access to records that is marked expired in the database any idea how or if it's possible ? Please respond even if it's just to say that you don't know so I KNOW that my

Re: [HACKERS] new relkind for view

2000-09-15 Thread Mark Hollomon
On Tue, Sep 12, 2000 at 09:42:41AM +0200, Zeugswetter Andreas SB wrote: > > add the functionality for "with check option" clause of create view > I'm not familiar with this. What does it do? -- Mark Hollomon [EMAIL PROTECTED]

[HACKERS] Winner Notification - Linux Magazine Editor's Choice Awards (fwd)

2000-09-15 Thread Vince Vielhaber
Does anyone have the Sept issue of Linux Magazine? According to a notification we just received, PostgreSQL got 4th place in the editor's choice awards. I wanna know what was in first, second and third! Anyone know? Vince. -- ==

Re: [HACKERS] Expired records ?

2000-09-15 Thread John McKown
Your message got though. I don't know the answer to your question, but I'll bet that it is NO. On Fri, 15 Sep 2000, Eje Gustafsson wrote: > Hello Stephan, > > I think this listserver hates me. none of my messages seem to go through. > Anyone read this ?? > > I need to get access to records th

Re: [HACKERS] Winner Notification - Linux Magazine Editor's Choice Awards (fwd)

2000-09-15 Thread Len Morgan
1st - MySQL 2nd - Oracle 8i 3rd - Informix Dynamic Server.2000 -Original Message- From: Vince Vielhaber <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, September 15, 2000 1:31 PM Subject: [HACKERS] Winner Notification - Linux Magazine Editor's Choice Awards (f

Re: [HACKERS] Winner Notification - Linux Magazine Editor's ChoiceAwards (fwd)

2000-09-15 Thread The Hermit Hacker
*rofl* now that wasn't rigged or nothing ... I could see us second to MySQL, or third to Oracle/Informix, depending on how it was evaluated, but fourth to all three? On Fri, 15 Sep 2000, Len Morgan wrote: > 1st - MySQL > 2nd - Oracle 8i > 3rd - Informix Dynamic Server.2000 > > > -Original

[HACKERS] LIKE is still short some MULTIBYTE code

2000-09-15 Thread Tom Lane
I finished revising the LIKE operators back into an index-optimizable form. But I notice there is some non-multibyte-aware code that needs to be fixed, specifically the pattern analysis routines in src/backend/utils/adt/selfuncs.c: like_fixed_prefix regex_fixed_prefix like

Re: [HACKERS] LIKE is still short some MULTIBYTE code

2000-09-15 Thread Joseph Shraibman
Hasn't the [HACKERS] / [GENERAL] crossover thing been resolved yet? I'm not subscribed to hackers. Tom Lane wrote: > > I finished revising the LIKE operators back into an index-optimizable > form. But I notice there is some non-multibyte-aware code that needs > to be fixed, specifically the pa

Re: [HACKERS] Winner Notification - Linux Magazine Editor's Choice Awards(fwd))

2000-09-15 Thread Jan Wieck
The Hermit Hacker wrote: > > *rofl* now that wasn't rigged or nothing ... I could see us second to > MySQL, or third to Oracle/Informix, depending on how it was evaluated, but > fourth to all three? Hey, look at the headline: Linux Magazine's Editor's Choice Awards by The Edi

Re: [HACKERS] Winner Notification - Linux Magazine Editor's ChoiceAwards (fwd))

2000-09-15 Thread The Hermit Hacker
On Fri, 15 Sep 2000, Jan Wieck wrote: > The Hermit Hacker wrote: > > > > *rofl* now that wasn't rigged or nothing ... I could see us second to > > MySQL, or third to Oracle/Informix, depending on how it was evaluated, but > > fourth to all three? > > Hey, look at the headline: > > L

Re: [HACKERS] LIKE is still short some MULTIBYTE code

2000-09-15 Thread Tatsuo Ishii
> I finished revising the LIKE operators back into an index-optimizable > form. But I notice there is some non-multibyte-aware code that needs > to be fixed, specifically the pattern analysis routines in > src/backend/utils/adt/selfuncs.c: > like_fixed_prefix > regex_fixed_prefix >

[HACKERS] postgressql QNX version

2000-09-15 Thread Maurizio
Hi,   I am tring to use the qnx version of postgresql 7.0.0   I have qnx 4.25 and TCP/IP   I have compiled postgres using gcc I used this commands gmake all gmake install   then I have started postgres with -D and -i options.   Every time I execute the command createdb I have SIGSEGV error.