[EMAIL PROTECTED] wrote:
> I have a int4 coloumn, and I want to change the last bit the the
> number in this column to 0. How can I do it?
Last bit = least significant bit (LSB)?
update mytable set thecolumn = thecolumn & ~1 where ...
---(end of broadcast)---
CSN wrote:
> For this to work, make sure that:
> . the cube source directory is in the postgres contrib
> directory
> . the user running "make install" has postgres
> administrative authority
> . this user's environment defines the PGLIB and PGDATA
> variables and has
> postgres binaries in the P
On Mon, 12 Jul 2004 20:31:15 +0200, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
> Hi
>
> We have again experienced data-corruption using 7.4.2 on an XFS Filesystem
> on top of a software-raid (md) raid-1.
>
> After a server crash last night (It was a rather strange crash - The machine
> was still p
CSN <[EMAIL PROTECTED]> writes:
> I looked through the docs and contrib, but didn't see
> anything related to storing and using latitude and
> longitude values.
I think you want to look at the PostGis project:
http://postgis.refractions.net
regards, tom lane
-
Ah, that should work.
The README for contrib/cube states:
To install the type, run
make
make install
For this to work, make sure that:
. the cube source directory is in the postgres contrib
directory
. the user running "make install" has postgres
administrative authority
. this
FYI, I have seen the SW linux raid not detect failed drives and cause
filesystem corruption on many occasions. I would reccomend staying
away from it. Maybe what you describe is a problem with PG but, i
doubt it.
On Jul 12, 2004, at 12:31 PM, Florian G. Pflug wrote:
Hi
We have again experienc
I inherited some C code that works as a series of libraries using
libpq. One of the libraries has an input to it of a PGresult pointer,
but not of a PGconnect pointer. Within the library, the code tries to
determine the host name of the connection by doing the following
trick:
strcpy (host,PQhost
Didn't /contrib/earthdistance help?
---
CSN wrote:
> I looked through the docs and contrib, but didn't see
> anything related to storing and using latitude and
> longitude values. I have data in the form of 12° 34'
> N, 12°
I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values. I have data in the form of 12° 34'
N, 12° 34' W.
Would any of the geometric data types work well for
this type of data? Or just convert them to decimals?
Are there any functio
Hi
We have again experienced data-corruption using 7.4.2 on an XFS Filesystem
on top of a software-raid (md) raid-1.
After a server crash last night (It was a rather strange crash - The machine
was still pingable, but no login was possible, and postgres and apache
didn't respond to requests any m
On Mon, Jul 12, 2004 at 03:03:14PM +0200, Holger Marzen wrote:
> But "select * from v_laufwerke" gives "FEHLER: Relation >>v_laufwerke<<
> existiert nicht" (ERROR: Relation v_laufwerke doesn't exist). Dropping
> fails as well although it seems to be there:
>
> login=# \dv
>List of re
I had tomatoes on my eyes. I wrote laufverke but meant laufwerke.
Sorry.
-- Forwarded message --
Date: Mon, 12 Jul 2004 15:03:14 +0200 (CEST)
From: Holger Marzen <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: cannot access or delete view
Hi all,
I installed PostgreSQL 7.4.2 from
Hi all,
I installed PostgreSQL 7.4.2 from backports.org and all went fine. Then
I did as user postgres:
create view v_laufverke
as
select
distinct
bg.mandant as v_mandant,
bg.benutzer as v_benutzer,
l.laufwerk as v_laufwerk,
l.pfad as v_pfad,
l.benutzer as v_login_benutzer,
l.kennwort
> > ...i have little experience in linux and i work on windows.
>
>
> I don't know the current state of the Windows port (PG 7.5)
> but as I understood it currently won't run as service at all.
> For getting a service you need to go with cygwin ...
Current snapshots have full service integrati
Hallo Hans,
[EMAIL PROTECTED] wrote:
...i have little experience in linux and i work on windows.
I don't know the current state of the Windows port (PG 7.5) but as I
understood it currently won't run as service at all.
For getting a service you need to go with cygwin ...
I didn't test it, but a
Ramesh Yeligar wrote:
Hi,
We have been using pgsql for our retail business, now, due hard drive
crash, the databse corrupted and we are unable to start pgsql
database. Pl help me if you know any commands or tools to recover this
database.
What do you have in hand?
like the PGDATA folder pg_xlog
Hi Tom,
Thanks for your input. So if I understand you correctly, it is implied
that the behavior with PostgreSQL 7.3.4 is likely to be incorrect (or it
was a bug, I guess?)
One more question, in your reply, you mentioned that "char" type
considers trailing spaces to be insignificant. Should thi
mike wrote:
> All the date-time types seem to only be for specific time dates and
> not for a running total.
You probably want the interval type.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(sen
mike wrote:
I cannot seem to find a field type in postgres that is equivalent to
h:mm without enforcing a 24 hour day limit. This seems to preclude pg
from use - am I correct?
You want to use "interval" data type and then do some formatting on the
output to get 123 hours 30 minutes.
See:
http://w
[EMAIL PROTECTED] (Praveen) wrote in message news:<[EMAIL PROTECTED]>...
> Can anybody tell from where i can download the latest Postgress Windows version?
>
http://www.hagander.net/pgsql/win32snap/
---(end of broadcast)---
TIP 3: if posting/readi
Hi I am trying to setup a timesheet app. However I have come up against
an unexpected problem (possibly fatal)
I cannot seem to find a field type in postgres that is equivalent to
h:mm without enforcing a 24 hour day limit. This seems to preclude pg
from use - am I correct?
All the date-time type
21 matches
Mail list logo
