Hi all,
I need to let a server access our postgreSQL database but I´m having
problems with the configuration. I´m getting the error message below,
psql: FATAL: no pg_hba.conf entry for host 10.24.17.22, user k175,
database k175, SSL off
I´ve added the section below to the pg_hba.conf
# TYPE
Hi all,
had some help the other day, but now I´m kinda stuck again. :/
I have a table (virksomhedsdata) with the following columns:
MI_STYLE character varying(254),
MI_PRINX integer NOT NULL DEFAULT
nextval('rk_ois.virksomhedsdata_MI_PRINX_seq'::regclass),
SP_GEOMETRY geometry,
I would like
Maybe I should clarify what I mean.
I have a db (postgresql 8.4.1 with a postGIS spatial extension) with about
200+ tables in it. Some of them is supposed to be updated using an
application what requres that some of the columns are in uppercase (a
leftover from Oracle I suppose) but the main
Hmm.. Haden´t thought about making a view. It should work because the
application that uses the data is read-only (yet!).
I´ll give that a try. Thanks!
Christian
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Uppercase-to-lowercase-trigger-tp5680384p5682880.html
Sent
Hi,
I´ve got some tables with column names in lowercase. Before updatering these
tables I want to add a trigger that can convert these lowercase to
uppercase, and when the tables are updates convert them back to lowercase..
I´ve looked at several examples without any luck. Could someone put me
Hi,
properbly a simple question (with a simple answer). Nevertheless I´ve been
struggeling with it for some time now. Hope you guys can point me in the
right direction!
I want to exclude access to our postgresql db using a configuration in the
pg_hba.conf file. I have a range of IP adress that
HI all,
below is the view i´ve tried to create on a table. The purpose was to do
some math on one of the columns (retning). The column is a double precision
number. The result is that the function is not recognized (ERROR: function
to_number(double precision, unknown) does not exist). I´m a bit
Hi all,
please foregive me for this rather trivial question, but I´ve worked in it
for quite som time and could use som help now. :)
I have a table where it want to create a idkey using our municipality number
+ the road number + the housenumber.
The municipality and housenumber is in a fixed