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 wel
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 (weat
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) cop
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
Thanks!
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
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 inherit another, why it d
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
t
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 exa
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
When a table inherit another, why it doesn't
inherit their keys nor fkeys?... How do I change it?
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 broadca
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:
>
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
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
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
"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_
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
http://birthday.yahoo.co
Richard Huxton 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 practice it wo
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 prop
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 wo
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
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 tra
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) ...
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
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
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 s
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, 2
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 tr
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 th
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, 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
>>> /et
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 you
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,
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,
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:~
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, 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 ro
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 this
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(peercre
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 configu
39 matches
Mail list logo
