n;
execute 'set search_path = ' || v_searchpath;
end
$$ language plpgsql;
best regards,
Florian Pflug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
* by the scope of the object containing the
unqualified name. Nested namespaces thus simply become of matter of
syntax - i.e., whether you can write a.b.c, or need to write "a.b".c.
best regards,
Florian Pflug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the temporary database, but then obviously
have to do so every time you start new session because you start out
with an empty tempdb.
best regards,
Florian Pflug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
ess you're willing to tell your users to select
record_inspect.fieldinfo(some_record) as "some_record.fieldinfo"
alongside "some_record" if they want the record to be represented as other
than one large string.
best regards,
Florian Pflug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e
SELECT 'TRUNCATE' || quote_ident(schemaname) || '.' || quote_ident(tablename) ||
';' ...
Otherwise, table or schema names containing funny characters, upper case, or
spaces will cause trouble..
greetings, Florian Pflug
---(end of broadcast)---
TIP 6: explain analyze is your friend
n't really
know how these things work.
greetings, Florian Pflug
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
t in an interactive shell...
> Does Debian include and activate SELinux?
There are selinux-versions of debian, but in vanilla debian/sarge (and
debian/woody, and debian/sid), there is no selinux support - at least, I
never stumbled upon this, and I use quite a few debian machines).
greetings, Florian Pflug
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
update fail, but also select now gives "permission
denied" (The correct behaviour I believe).
greetings, Florian Pflug
---(end of broadcast)---
TIP 8: explain analyze is your friend
