On Wed, Mar 02, 2005 at 02:16:29PM -0500,
Tom Lane [EMAIL PROTECTED] wrote
a message of 8 lines which said:
It is of course very inconvenient to duplicate my LDAP database into
pg_ident.conf. Is there a better way?
Perhaps you can find a PAM plugin that talks to LDAP, and configure
Stephane Bortzmeyer wrote:
All the user accounts, including mine, are in a LDAP database. Thanks
to NSS (Name Service Switch) all applications have access to the LDAP
accounts (getpwuid(3) and getpwnam(3) use LDAP). But not PostgreSQL.
I did similar setups and both gentoo and debian/sarge, and
Stephane Bortzmeyer [EMAIL PROTECTED] writes:
The real issue is Why PostgreSQL does not use getpwuid when
getsockopt with SO_PEERCREED returns a numeric UID?
Oh? I read in hba.c
if (getsockopt(sock, SOL_SOCKET, SO_PEERCRED, peercred, so_len) != 0 ||
so_len != sizeof(peercred))
On Thu, Mar 03, 2005 at 10:04:32AM +0100,
Florian G. Pflug [EMAIL PROTECTED] wrote
a message of 114 lines which said:
Might it be that the postgres user is not allowed to read
/etc/ldap.conf - or however your nss_ldap config file is called?
myriam:~ % ls -ld /etc/*ldap*
drwxr-xr-x 2 root
On Thu, Mar 03, 2005 at 04:03:25AM -0500,
Tom Lane [EMAIL PROTECTED] wrote
a message of 21 lines which said:
pass = getpwuid(peercred.uid);
so it sure looks like we *are* using getpwuid.
You're right but I do not understand why it fails only with
PostgreSQL.
On Thu, 3 Mar 2005, Stephane Bortzmeyer wrote:
On Thu, Mar 03, 2005 at 10:04:32AM +0100,
Florian G. Pflug [EMAIL PROTECTED] wrote
a message of 114 lines which said:
Might it be that the postgres user is not allowed to read
/etc/ldap.conf - or however your nss_ldap config file is called?
myriam:~ %
Is there a way to make a postgresql 8 database dump work with 7.4? I.E I
want to do a dump from 8.0 on one machine and put it into a database
running on 7.4 on another?
Thanks
Jake
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
All you said are wright. But it 's not so difficult for postgresql to hold
on a bit attribute attached to each table the information, whether there
is done an insertion/deletion/update to a clustered table or not.
And i guess, postgresql would already implement this simply alternative.
Easy,
Jake Stride wrote:
Is there a way to make a postgresql 8 database dump work with 7.4? I.E I
want to do a dump from 8.0 on one machine and put it into a database
running on 7.4 on another?
Haven't tried this yet, but apart from turning off dollar-quoting for
functions, it should just work. If
On Thu, March 3, 2005 12:00, Marco Colombo said:
On Thu, 3 Mar 2005, Stephane Bortzmeyer wrote:
On Thu, Mar 03, 2005 at 10:04:32AM +0100,
Florian G. Pflug [EMAIL PROTECTED] wrote
a message of 114 lines which said:
Might it be that the postgres user is not allowed to read
/etc/ldap.conf - or
I am trying to develop an application to access postgresql DB using QT
developer however when running the developer it cannot find the DB driver?
How can I make the driver available to QT?
Any Ideas would be helpful
Philip
---(end of broadcast)---
On Thu, Mar 03, 2005 at 12:00:51PM +0100,
Marco Colombo [EMAIL PROTECTED] wrote
a message of 39 lines which said:
Does Debian include and activate SELinux?
Not at all.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Hi,
i wonder if the attribute IMMUTABLE has any effect on functions.
Maybe its not implemented yet?
I tried the following:
CREATE TABLE foo (bar int4);
CREATE FUNCTION foo(int4)
RETURNS int4
AS '
INSERT INTO foo (bar) VALUES ($1);
SELECT $1;
' LANGUAGE 'sql' IMMUTABLE;
...now without any
Lookup the docs, but IMMUTABLE and other such tags are hints to the
optimiser. If a function is immutable then the optimiser can optimise
away any invocations. If your function isn't actually immutable you've
just caused a problem.
They don't affect the actual function at all...
On Thu, Mar 03,
Richard Huxton wrote:
Jake Stride wrote:
Is there a way to make a postgresql 8 database dump work with 7.4?
I.E I want to do a dump from 8.0 on one machine and put it into a
database running on 7.4 on another?
Haven't tried this yet, but apart from turning off dollar-quoting for
functions, it
Jake Stride wrote:
That helps a bit, but I still have the following issue:
ERROR: function pg_catalog.pg_get_serial_sequence(unknown, unknown)
does not exist
Any ideas how to get around this?
Hmm - before 8.0 there wasn't an easy way to figure out the name of a
sequence attached to a column.
Stephane Bortzmeyer [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] wrote
so it sure looks like we *are* using getpwuid.
You're right but I do not understand why it fails only with
PostgreSQL.
Perhaps one of the pile of random libraries we include is supplying a
broken version of
Thomas Schoen [EMAIL PROTECTED] writes:
In my expectations the 2nd function call should not have added a new row
to table foo, beacause it was called with the same parameter and is
immutable.
IMMUTABLE is a promise from you to the database (a promise which you
broke, in this case) ... not
This caught my eye the other day, but didn't take the time to examine it. I
find that I am now very interested in it. Could you please elaborate on your
method and how this works?
TIA
On Sunday 27 February 2005 05:37 pm, Jay Guerette saith:
If I disable INSERT and UPDATE triggers inside a
Frank Finner [EMAIL PROTECTED] writes:
error from Perl function: trusted Perl functions disabled - please
upgrade Perl Safe module to version 2.09 or later at (eval 4) line 1.
What do you get from
perl -e 'require Safe; print $Safe::VERSION\n'
regards, tom lane
Hi Tom,
I found an error right between my ears,
means, I had looked at the client__s version of Safe, not thinking
about the fact that I was connected to the database on a server which
actually had Safe installed only with version 2.07. I upgraded Safe now
from CPAN on my server and everything
Hello,
I am getting a strange "aggregates not allowed in
where clause" error when I try to execute the below query:
SELECT
n.note, pr.property_id AS
PropertyID FROM property.note
n INNER JOIN property.rating_note
rn ON rn.note_id = n.note_id INNER
JOIN property.propertyrating pr ON
Richard Huxton dev@archonet.com writes:
This *will* break if the target table (1st param) is in a different schema
than
public, or if you have non-default sequence names.
Including if you've renamed a serial column since creating it, or if your
serial column has an extremely long name.
In
Hi,
Simple question:
If I change a hostname (Linux FC2) do I need to do any changes to
Postgresql configurations ?
Thanks,
Mark
__
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
L. Fletcher [EMAIL PROTECTED] writes:
I am getting a strange aggregates not allowed in where clause error =
when I try to execute the below query:
SELECT n.note, pr.property_id AS PropertyID
FROM property.note n
INNER JOIN property.rating_note rn ON rn.note_id =3D
Hi,
another simple question:
what's the correct command line syntax to change specific run-time parameters,
e.g. 'client_min_messages'.
I understand you can define/change them in the .conf file ...
an example, or a pointer to RTFM would be great =)
thanks,
richard
---(end
On Thu, 3 Mar 2005 11:07:53 -0800 (PST), Mark [EMAIL PROTECTED] wrote:
Hi,
Simple question:
If I change a hostname (Linux FC2) do I need to do any changes to
Postgresql configurations ?
Only if the IP address associated with it is changing. Although
remote clients might need to have their
Hi All,
A question about joins i have 17 tables in my postgres-DB how does
one perform a join on these many tables!!! :(
Thanks,
H
On Tue, 1 Mar 2005 08:42:57 -0600, James Thompson [EMAIL PROTECTED] wrote:
On Tuesday 01 March 2005 08:07 am, Hrishikesh Deshmukh wrote:
Hi All,
I want to
Tom,
Do you feel this is a safe method for disabling triggers in the rare cases
where one finds that it is prudent to do that? Do you think that the column,
reltriggers, is permanent fixture in pg_class? What is your advice on this?
TIA
On Monday 28 February 2005 03:22 pm, Tom Lane saith:
Am Donnerstag, den 03.03.2005, 14:35 -0500 schrieb Hrishikesh Deshmukh:
Hi All,
A question about joins i have 17 tables in my postgres-DB how does
one perform a join on these many tables!!! :(
you just use 16 times the word JOIN ?
HTH
Tino
---(end of
When a table inherit another, why it doesn't
inherit their keys nor fkeys?... How do I change it?
On Mar 3, 2005, at 4:36 PM, Tino Wildenhain wrote:
Am Donnerstag, den 03.03.2005, 14:35 -0500 schrieb Hrishikesh Deshmukh:
Hi All,
A question about joins i have 17 tables in my postgres-DB how does
one perform a join on these many tables!!! :(
What are you trying to do? You have 17 total tables
On Thu, 03 Mar 2005 07:59:14 +, Mario Splivalo wrote:
Can I use XPath queries in any form to retrive data from XML documents and
'transfer' them to table-like sets?
Basically, yes - if you look at the README for contrib/xml2 in the
PostgreSQL source distribution (v8.0.1) there is an
On Thu, 2005-03-03 at 15:53, Cristian Prieto wrote:
When a table inherit another, why it doesn't inherit their keys nor
fkeys?... How do I change it?
There are basic architectural problems that need to be overcome before
that would happen. The only way to change it right now is to check out
Thanks!
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Cristian Prieto [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, March 03, 2005 4:18 PM
Subject: Re: [GENERAL] Table inherits...
On Thu, 2005-03-03 at 15:53, Cristian Prieto wrote:
When a table
Hi,
I want to do a 17 table join! :( But a general idea will help.
Thanks,
H
On Thu, 3 Mar 2005 16:56:13 -0500, Sean Davis [EMAIL PROTECTED] wrote:
On Mar 3, 2005, at 4:36 PM, Tino Wildenhain wrote:
Am Donnerstag, den 03.03.2005, 14:35 -0500 schrieb Hrishikesh Deshmukh:
Hi All,
A
Is there a canonical form that db schema designers use
to save changes to the data in their databases?
For example, given a table with rows of data, if I UPDATE
a field in a row, the previous value is lost. If I wanted to
track the changes to my data over time, it occurs to me that
I could,
1)
On Thu, 2005-03-03 at 18:00 -0500, Hrishikesh Deshmukh wrote:
Hi,
I want to do a 17 table join! :( But a general idea will help.
Thanks,
H
Try here to start:
http://www.postgresql.org/docs/current/static/tutorial-join.html
SELECT *
FROM weather LEFT OUTER JOIN cities ON
Terry Lee Tucker wrote:
Tom,
Do you feel this is a safe method for disabling triggers in the rare cases
where one finds that it is prudent to do that? Do you think that the column,
reltriggers, is permanent fixture in pg_class? What is your advice on this?
I'd be quite interested in this as
39 matches
Mail list logo