x27;s listening on the proper port. When I try
to connect with PG admin from remotely it says there is no entry for my IP
address in pg_hba.conf. The problem with this is that there IS an entry for
my IP.
Did you start postmaster with -i option?
Oliver
--
VECERNIK Datenerfassungssysteme
A
Hi,
I've got SuSE 7.3 with PostgreSQL 7.1.3 server an a system where
LANG=de_DE@euro. I tried to import some data with:
\copy im from '/usr/share/data/pricelist.csv' using delimiters '|'
and got following message:
\.
ERROR: copy: line 1, Bad numeric input format '1018,11'
PQendcopy: resettin
> Chris Ruprecht wrote:
>
> Hi all,
>
> can somebody explain to me, or point to an explanation of, the way,
> PostGreSQL names databases?I have files like 18732 and 7503034 - and
> they are big but I have no idea which data lives in what file:
>
> /home/pgsql/data/base/18720/
> -rw---1
Reiner Dassing wrote:
>
> Hello Tom!
>
> By accident I gave in psql the command \@ and \db.
> In both cases a core dump was produced.
>
> This is just a note for your TODO List.
>
> Basis:
> PostgreSQL V7.1.1 on Tru64 V 5.1
But not on:
version
Tom Lane wrote:
>
> Oliver Vecernik <[EMAIL PROTECTED]> writes:
> > Using of OIDs as foreign keys is recommended in the docs.
>
> Er ... where? It shouldn't be.
Sorry, it was not in the official docs, but in Bruce's book in the
chapter about OIDs:
| Object
Hi,
Using of OIDs as foreign keys is recommended in the docs. It is a unique
number for every object of the PostgreSQL server. I can dump OIDs with
-o option.
But what happens if I have to upgrade my server? For example for the new
7.1 release an initdb is required. OIDs start from 16384 or some
[EMAIL PROTECTED] wrote:
>
> Greetings All.
>
> I have a record on my database with a last name of 'DeFelice'.
>
> I want to be able to retrieve that record whether a user enters 'DeFelice',
>'Defelice', 'defelice', or 'DEFELICE'. Is there a way I can do that? Is that what
>the "ilike" func
Hi,
I've got a table with two columns: one for distance in km (float4) and
one for the time (interval). I'd like to calculate the speed.
My problem is how to convert the intervals to decimal hours to be able
to a simple:
SELECT *, distance/time as speed from table;
Any clues? Are there any doc
Anuradha Ratnaweera wrote:
>
> On Mon, 30 Apr 2001, Oliver Vecernik wrote:
>
> > Anuradha Ratnaweera wrote:
> > >
> > > Is there a way to disable write ahead logging (WAL) in 7.1?
> >
> > Why do you want to do this?
> >
>
> Because I h
Anuradha Ratnaweera wrote:
>
> Is there a way to disable write ahead logging (WAL) in 7.1?
Why do you want to do this?
Oliver
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Christian Marschalek wrote:
>
> I installed the PostgreSQL ODBC dll, but everytime I'm trying to connect
> to my database server (witch is another machine in my network) I get the
> error "Couldn't connect to server, couldn't connect to remote socket"
>
> Now I wonder how I have to configure the
Hi,
I recently started using postgresql. I'm running version 7.0.3 on a SuSE
7.1 Linux box. I'm trying to test the examples in the user's guide. But
I can not create a function with language 'plpgsql'.
It seems there has some installation be done to achieve that. But how?
Can anybody point me to
12 matches
Mail list logo