SELECT is returning bogus data.
migrate=# select version();
version
---
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3
(1 row)
migrate=# select userid from users where userid = '[EMAIL PROTECT
I have a table of strings categorized by string type and
unique id
e.g.
stringTypes table (sType, sDescription)
0 vanilla
1 ip address
2 mail address
stringValues table (sId, sType, sValue)
1 0 foobar
2 2 123 Main Street
3 1 123.123.123.123
3 1 123.13.123.123
I want to select ip addres
You probably have PostgreSQL compiled with the default blocksize, which is 8k.
OpenACS.org has a nice set of instructions explaining how to increase the size to
16k or 32k.
http://openacs.org/doc/openacs/html/simple-pg-install-2.html#ss2.2
Hope that helps.
Yves Martin wrote:
> Hello,
>
On Thu, Nov 23, 2000 at 11:40:52AM -0500, [EMAIL PROTECTED] wrote:
> On Thu, 23 Nov 2000, Tomasz Gralewski wrote:
>
> > I'd like to create a few tables in one SQL query, is that possible.
> > What tools I have to use, Perl, Tcl, or maybe is there block command
> > separator that I can write:
> >
> "Clayton" == clayton cottingham <[EMAIL PROTECTED]> writes:
Clayton> you could use a version of pgsql on your own machine and
Clayton> use the host switch to connect to an extrenal db
Clayton> of course your db isp will have to allow your ip to
Clayton> connect, not an eas
"pgsql-sql" <[EMAIL PROTECTED]> writes:
> migrate=# select userid from users where userid = '[EMAIL PROTECTED]';
>userid
> -
> [EMAIL PROTECTED]
> admin
> (2 rows)
That's a tad, um, startling :-(
However, you haven't given us nearly enough information to have a shot
Hi all!
I couldn't find a way to make my DB server work again.
I did this:
in postgres user killall -9 postmaster (I wanted to stop the server)
then rm /tmp/.s.PGSQL.5432
I tried to restart the server but I got this error:
[postgres@aux-209-217-53-170 postgres]$ postmaster -D /usr/local/pgsql/d
ipcclean
pg_ctl stop
Though finding out about ipcclean was not easy considering the output
given. There is no mention of it in any of the FAQs.
mrc
--
Mike Castle Life is like a clock: You can work constantly
[EMAIL PROTECTED] and be right all the time, or not work at all
www.
On Fri, Nov 24, 2000 at 12:34:29PM -0600, Mike Castle allegedly wrote:
> ipcclean
> pg_ctl stop
>
> Though finding out about ipcclean was not easy considering the output
> given. There is no mention of it in any of the FAQs.
>
> mrc
You could also use ipcrm manually to clean up the shm segment
Just a wild guess, but I would imagine
a corrupt (old) index on the userid field would
cause this kind of behavior.
You could test this by dropping the index and
then rebuilding it.
Troy
>
> "pgsql-sql" <[EMAIL PROTECTED]> writes:
> > migrate=# select userid from users where userid = '[EMAI
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> Just a wild guess, but I would imagine
> a corrupt (old) index on the userid field would
> cause this kind of behavior.
A corrupt index might be a contributing factor, but it doesn't seem like
it could be the only one. From what I know of the in
Hai,
How to set autocommit true/false from a java program. Please explain me.
Regards,
Ramesh
[EMAIL PROTECTED] writes:
>"pgsql-sql" <[EMAIL PROTECTED]> writes:
>> migrate=# select userid from users where userid = '[EMAIL PROTECTED]';
>>userid
>> -
>> [EMAIL PROTECTED]
>> admin
>> (2 rows)
>
>That's a tad, um, startling :-(
>
>However, you haven't given us nea
Is there any PostgreSQL developer working on the OpenACS (PG version of the
ArsDigita Community Sytem) project?
I have installed it and I am very much interested. There are a lot of small
bugs though, mostly related to Oracle->Postgres migration, and some which
are Postgres specific (queries that
Edmar Wiggers wrote:
>
> Is there any PostgreSQL developer working on the OpenACS (PG version of the
> ArsDigita Community Sytem) project?
>
> I have installed it and I am very much interested. There are a lot of small
> bugs though, mostly related to Oracle->Postgres migration, and some which
>
15 matches
Mail list logo
