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
#
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 si
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,
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 sh
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 in
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 appl
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 f
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 wo
