Hello all!
I'm working on a report (using jasperreports) for an application I've
written accessing PG 8.1.4. The view I'm doing the report on needs
to run as a the specific user requesting the report; however, the
report is connecting to the database using a general username for the
repo
On Sun, Nov 19, 2006 at 02:09:11AM -0500, Tom Lane wrote:
> Ron Peterson <[EMAIL PROTECTED]> writes:
> > How should I create a composite type value out of columns a and b in
> > table tt that I can insert into table atable?
>
> Hm, it works for me with an explicit cast:
>
> INSERT INTO
> atable
On Nov 19, 2006, at 11:10 AM, Mark Lubratt wrote:
I'm working on a report (using jasperreports) for an application
I've written accessing PG 8.1.4. The view I'm doing the report on
needs to run as a the specific user requesting the report; however,
the report is connecting to the database
Bingo! Thanks! I'm not sure how I missed that one...
Mark
On Nov 19, 2006, at 2:12 PM, John DeSoi wrote:
On Nov 19, 2006, at 11:10 AM, Mark Lubratt wrote:
I'm working on a report (using jasperreports) for an application
I've written accessing PG 8.1.4. The view I'm doing the report on
I am running Postgresql 8.1. I can't get the following create statement
to work. It failes on Column 39 which is my directory name.
CREATE TABLESPACE xx LOCATION "D:\tablespace\data\";
Rejean
pgsql-general@postgresql.org
---(end of broadcast)---
Rejean Proulx schrieb:
I am running Postgresql 8.1. I can't get the following create statement
to work. It failes on Column 39 which is my directory name.
CREATE TABLESPACE xx LOCATION "D:\tablespace\data\";
I'm pretty sure the " " are wrong. Strings are quotet with
' ' instead. You'
John Meyer wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> And while we're on it, setting that variable caused the PostgreSQL
> server to lock up Yast when I was restarting it that way.
File a bug with the Yast developers.
--
Alvaro Herrerahttp://www
Ran into a mystery that I can't seem to figure out
I want to authenticate using SSL for all external IP addresses that I have in my
subnet. I also want to be able to authenticate via non-SSL for localhost (not
unix socket).
I thought something like this would work:
host allal
Tom Allison wrote:
Ran into a mystery that I can't seem to figure out
I want to authenticate using SSL for all external IP addresses that I
have in my subnet. I also want to be able to authenticate via non-SSL
for localhost (not unix socket).
I thought something like this would work:
Tom Allison <[EMAIL PROTECTED]> writes:
> host allall127.0.0.1/32 md5
> hostsslallall192.168.0.1/24 md5
^^
That needs to be 192.168.0.0/24 ... as is, it won't match anything.
> But I have a localhost client that can't log in b
Tom Lane wrote:
Tom Allison <[EMAIL PROTECTED]> writes:
host allall127.0.0.1/32 md5
hostsslallall192.168.0.1/24 md5
^^
That needs to be 192.168.0.0/24 ... as is, it won't match anything.
But I have a localhost client that
11 matches
Mail list logo
