Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
OK, that makes more sense now. But why isn't table2 also in the rule
query's rtable?
It is, but you errored out before getting to it.
The fog has finally started lifting, I think.
Why wouldn't we force checkAsUser to the rule owner in the cop
Hi all,
I'm founding little messy the RPM condition for redhat:
Inside the RH9.0 coesist the 7.4.0-0.3 and 7.4.0-0.5 versions
looking on other RH directory version I found that actually
7.4.0-0.2
7.4.0-0.3
7.4.0-0.4
7.4.0-0.5
are existing.
Inside the SRPMS directory is present only the 7.4.0-0.2
ve
A E wrote:
I guess the question I have then is how do I return data from a
select statement using the record datatype? This is only a test
function I was trying to get info from, but my application is based
on passing the table name to the function dynamically. How do I do
this? The documentation i
Joe Conway <[EMAIL PROTECTED]> writes:
> OK, that makes more sense now. But why isn't table2 also in the rule
> query's rtable?
It is, but you errored out before getting to it.
regards, tom lane
---(end of broadcast)---
TIP
Tom Lane wrote:
This is exactly what I'm talking about. The rtable for a query
generated by a rule is the concatenation of the original query's rtable
and the rule query's rtable. Therefore the RTE for table1 appears
twice, once in the original INSERT query and once in the generated
UPDATE query
Joe Conway <[EMAIL PROTECTED]> writes:
> Sorry if I'm being thick, but what of this?
This is exactly what I'm talking about. The rtable for a query
generated by a rule is the concatenation of the original query's rtable
and the rule query's rtable. Therefore the RTE for table1 appears
twice, onc
I guess the question I have then is how do I return data from a select statement using the record datatype? This is only a test function I was trying to get info from, but my application is based on passing the table name to the function dynamically. How do I do this? The documentation is sketchy
Tom Lane wrote:
Reverting the change will bring back the bug for which it was created.
It does seem though that we have an inadequate model of how to perform
permission checks. In particular, the "write" flag bit in RTEs is
context dependent: it can mean insert, update, or delete permission
depend
A E <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION tester(varchar) RETURNS SETOF record as'
> DECLARE
> ft record;
> begin
> FOR ft IN SELECT * FROM visaapplicants LOOP
> RETURN NEXT ft;
> END LOOP;
> return null;
> end;'
> LANGUAGE 'plpgsql' VOLATILE;
>
> select * from te
Hi,
I was wondering if a solution was ever found to the error: "wrong record type supplied in RETURN NEXT" when executing a function that returns the Record datatype? I have seen a couple of previous post from Tom Lane and others, but no real resolution.
I am attempting to execute this code and
How do you connect to postgres if it is running on a different machine. I
am looking for a telnet command in place of postmaster -D data
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregi
[ please respect moving of thread to pg-hackers ]
Joe Conway <[EMAIL PROTECTED]> writes:
> ISTM that we want the relations in the un-rewritten query checked based
> on the basis of the user referencing the rule and for the modes used in
> the un-rewritten query -- suggesting the change need be rev
[EMAIL PROTECTED] wrote:
Hi Manfred,
I'm using unixware 7 but couldn't compile your source with native cc, I
had to compile it with gcc.
here are the results:
Thanks. The test app compares the time needed for three different short
loops: a loop with six empty function calls, a loop with six f
its must be in run time, server should has text with linux new line,
and if clinet is windows, postgres would convert \n to \n\r
but when clinet is also linux postgresa can do nothing about it
:)
any idea ?
On Sat, 27 Dec 2003, [iso-8859-1] Jürgen Cappel wrote:
> Hi Ivan,
>
> maybe your're lo
Hi Manfred,
I'm using unixware 7 but couldn't compile your source with native cc, I
had to compile it with gcc.
here are the results:
Script started on Sat Dec 27 17:50:49 2003
/tmp 17:50:50: ./a.out
MOVETEST called by non-superuser, running with normal priority.
zerotest: -1073736628 tick
Michael Meskes wrote:
> In manage-ag.sgml our docs says:
>
> [...]
> risk. To allow it, you must compile PostgreSQL with
> the C preprocessor macro ALLOW_ABSOLUTE_DBPATHS
> defined. One way to do this is to run the compilation step like
> this:
>
> gmake CPPFLAGS=-DALLOW_ABSOLUTE_
Hi Ivan,
maybe your're looking for something like this:
http://rcamera.org/cgi-bin/man2html.cgi?1+unix2dos
HTH,
Jürgen Cappel
ivan <[EMAIL PROTECTED]> schrieb am 27.12.2003, 14:19:10:
>
>
> is there same easy way to turn on translation bettwen client and server
> from linux new-line style (0x
is there same easy way to turn on translation bettwen client and server
from linux new-line style (0x0A) to windows style (0x0A0D?)
(something like conversions) ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
18 matches
Mail list logo
