Hi!
I'm using PostgreSQL 6.5b1 and I have two questions:
1. Is it possible to search for an element in an array even though I
don't know at which position the element is.
2. If this is possible how can I have a fast access. Can I create an
index, so that the search isn't sequential any more?
Thank
i was recently importing a fairly large amount of data from a mysql to
postgres ( 6.4.2 ). to make a long story short, this involved some
renames ( alter table foo rename to bar ). two psql clients were running,
accessing the same database and, in some cases, querying on the same
table. when o
> > In 6.4.*, table renaming was not properly flushing the cache, I think.
> > Should work fine when 6.5 is released.
>
> i had figured the client was caching OIDs. _really_ looking forward to
> 6.5, keep up the great work!
Yes, we had a number of cache issues worked on recently. The original
On Mon, 31 May 1999, Bruce Momjian wrote:
> >
> > i was recently importing a fairly large amount of data from a mysql to
> > postgres ( 6.4.2 ). to make a long story short, this involved some
> > renames ( alter table foo rename to bar ). two psql clients were running,
> > accessing the same d
=
Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC
[EMAIL PROTECTED]// [EMAIL PROTECTED] // [EMAIL PROTECTED]
http://hub.org/~jeff // http://hub.org // http:/
Peter Keller wrote:
>
> Hi!
> I'm using PostgreSQL 6.5b1 and I have two questions:
> 1. Is it possible to search for an element in an array even though I
> don't know at which position the element is.
Sort of, but you need to load some extension operators available in the
contrib directory.
> 2
I tried the below script (again, going from 6.3->6.4.2 on RedHat 5.2
Linux).. Now I don't get the out of memory errors but it still chokes up
on the syntax.. The back end spits out things like:
ERROR: type name lookup of char16 failed
ERROR: ChangeAcl: class "accounts" not found
ERROR: Change
