unique indexes and pqlib

Vince Vielhaber <vev@michvhf.com> writes:

1) Is there any reason why I can't create a unique index on an int8?
It tells me this:
ERROR: Can't find a default operator class for type 20.

int8 is new and not very thoroughly supported yet. Probably there
just isn't support for making an index on it (Thomas?).

2) Are there any more changes expected in the code for libpq?

Ever? Yes. Before 6.4 release? Perhaps not, but I wouldn't swear to
it. We are at a bug-fixes-only stage of the release cycle, but I do not
promise there are no bugs in libpq.

Why do you care, exactly? You shouldn't need to worry whether a
library you use is changing internally, as long as the API is stable
(and I certainly hope we do not find bugs that force an API change
at this point...)

regards, tom lane

On 18-Oct-98 Tom Lane wrote:

Vince Vielhaber <vev@michvhf.com> writes:

2) Are there any more changes expected in the code for libpq?

Ever? Yes. Before 6.4 release? Perhaps not, but I wouldn't swear to
it. We are at a bug-fixes-only stage of the release cycle, but I do not
promise there are no bugs in libpq.

Why do you care, exactly? You shouldn't need to worry whether a
library you use is changing internally, as long as the API is stable
(and I certainly hope we do not find bugs that force an API change
at this point...)

I'm doing the libpq and psql ports for OS/2.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================

On 19-Oct-98 Tom Lane wrote:

Vince Vielhaber <vev@michvhf.com> writes:

Why do you care, exactly?

I'm doing the libpq and psql ports for OS/2.

Ah. In that case, pleased to meetcha. I guess you can either wait till
6.4 formal release (maybe another couple weeks?), or get involved now.
An advantage of getting involved now is that any porting patches you find
necessary could still be fed back into the 6.4 release. Do you care how
much your version diverges from 6.4 official?

I'll be getting involved now (even tho I've been here for a few months),
that should make things alot easier.

I've somehow unofficially acquired the position of head libpq basher,
so feel free to talk to me about any changes you need there.

regards, tom lane

Great! Around the time of 6.2 (I think), Marc submitted a couple of changes
for me, mostly minor. Unless major changes have occurred I'm hoping it'll
go smoothly and rather uneventful as 6.3 did.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================

1) Is there any reason why I can't create a unique index on an int8?
It tells me this:
ERROR: Can't find a default operator class for type 20.

int8 is new and not very thoroughly supported yet. Probably there
just isn't support for making an index on it (Thomas?).

I'll try to look at it. But I'm starting to get swamped with last-minute
big additions to the documentation, and will have only limited time for
other stuff.

btw, I haven't looked yet but I hope the odbc makefile stuff still can
build standalone. Hopefully we are converging on an acceptable set of
Makefiles; I'd made changes recently - which you'd noticed broke
installations which did not do major.minor version numbering on shared
libraries - in response to major breakage introduced for some other
reason which damaged installations _with_ major.minor version numbering.
Though despite appearances my response wasn't intended to rebreak the
other systems :/

- Tom

Vince Vielhaber <vev@michvhf.com> writes:

Great! Around the time of 6.2 (I think), Marc submitted a couple of changes
for me, mostly minor. Unless major changes have occurred I'm hoping it'll
go smoothly and rather uneventful as 6.3 did.

Well, actually, I've done some pretty major damage to the internals of
libpq since 6.3.2 ;-). The Windows guys report that porting it to
Windows wasn't hard, but unless OS/2 offers something very close to
Berkeley sockets and the select() system call, you might be in for
trouble. Let me know how it goes.

regards, tom lane

TwoBB seperate questions..

1) Is there any reason why I can't create a unique index on an int8?

It tells me this:
ERROR: Can't find a default operator class for type 20.

This will be fixed in 6.5, due to go into beta soon.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026