chemas
within the same database.
2. Each schema is fully controlled by a role who is responsible for the
development of that application.
Best Regards,
CN
--
http://www.fastmail.com - The professional email service
ot;public".
Sure I can issue command "SET SEARCH_PATH TO s1" before command "CREATE
table". However, the problem with such arrangement is that role "r1" can
create in schema "s1" those commands like "SET ROLE r2" or "SET
SEARCH_PATH TO s2&
wants to downgrade
itself to role "user3", then it simply sends these commands:
SET SESSION AUTHORIZATION user3;
SET SEARCH_PATH TO schema3,pg_category;
Does my points make sense?
Is it eligible for feature request?
Best Regards,
CN
--
http://www.fastmail.com - Accessible with you
e product and services in place rather than just an idea.
Best Regards,
CN
--
http://www.fastmail.com - Email service worth paying for. Try it for free
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ake to have my
awesome or yet another awful "idea" be delivered to those targeted
PostgreSQL endorsers?
Thank you in advance!
Best Regards,
CN
--
http://www.fastmail.com - Or how I learned to stop worrying and
love email again
--
Sent via pgsql-general ma
q C
functions with which I will link my C client application as a single
executable file. The benefits from the embedded feature will make the
client lighter, easier to manage, and run faster.
Regards,
CN
--
http://www.fastmail.fm - One of many happy users:
http://www.fastmail.fm/docs/quotes.h
es it make sense, and is it
possible, to enhance NOTIFY that process "name/value" pair? Like this:
NOTIFY "MyName=MyValue";
With the capability of name/value pair, the listener will not have to
check notification details by reading tables.
Thank you!
CN
--
ht
On Fri, 28 Sep 2007 21:32:43 -0400, "Carlos Moreno"
<[EMAIL PROTECTED]> said:
> CN wrote:
> > Hi!
> > "initdb" use SQL_ASCII as the default characterset encoding when it is
> > not given option "-E" and when it can not correctly derive one f
support "-E" switch for "createdb". As
a result, I have to abandon that service all together. Was "initdb"
using UNICODE as the default characterset, everthing would be perfect.
Regards,
CN
--
http://www.fastmail.fm - Same, same, but different�
DATE
CASCADE ON DELETE CASCADE
Secondly, triggers along with complicate functions must be created and
attached to "master" and "detail" tables.
Does my wish make sense or violate any standard?
Best Regards,
CN
-
db2=# \d detail
Ta
ast becasue (a) I think the backend will call it only once in a SQL
statement rather than once for every returned rows from table t2, and
(b) this function, if ever exists, has race issue.
Regards,
CN
--
http://www.fastmail.fm - One of many happy users:
http://www.fastmail.fm/docs/quotes.h
ot; differently from that being
part of multi-byte characters depending on which client encoding is
used.
Regards,
CN
--
http://www.fastmail.fm - And now for something completely different�
---(end of broadcast)---
TIP 4: Have you sea
tes might look like ASCII.
Are you suggesting me to implement the middleware that will translate
Big5 input to UTF8 and then escape the latter before sending it to
PostgreSQL?
SET CLIENT_ENCODING TO UTF8;
[BIG5 string from user] --> [middleware] --> [UTF8] --> [escaped UTF8]
--> Postgr
h this, AFAICS.
What I still don't realize is that as mentioned in my first posting,
"A\134B" gets stored in TEXT with value "A\B" but the Big5 string
escaped in the same manner yeids different result - the latter string is
stored in escaped form and becomes longer
ages the following string differently:
INSERT INTO x VALUES ('A\134B');
and
SELECT * FROM x;
outputs
A\B
Its size stored in the column is 3 octets. This second case is exactly
what I need. I guess strings like "C:\dir" is properly processed too
though I did not test it.
W
. It happens because MyFunc() raises exception as the data of
this table with CHECK constraint is being restored before the data of
the table(s) referenced by MyFunc().
Is it a wise request for one more option to be added to pg_restore to
disable CHECK constraint?
Best Regards,
CN
--
http://www.fa
Thank you for the reply!
> > Triggers are still fired although option --disable-triggers is applied
> > to pg_restore. The fired triggers abort pg_restore because of the
> > foreign keys violations.
[snip]
> > pg_restore -l db1 >list
> > createdb -E UNICODE db1
> > pg_restore -F c -L list -v -d db
riggers db1 >log-data
2>&1
Any idea will be much appreciated.
Regards,
CN
--
http://www.fastmail.fm - Email service worth paying for. Try it for free
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your d
uncontrolled restore order of tables data.
Option --disable-triggers appears to be not disabling CHECK in such
case. Probably my requirement is exordinary, but is it possible to
"enhance" pg_restore so that it also ignores CHECK constraint?
Thanks!
CN
---(end of
Hi!
My 8.0beta2 database was initialized with option "-E UNICODE". Psql sets
client encoding to Big5:
database1=# \encoding big5
I get this error when inserting Big5 character 0xf9d8:
WARNING: ignoring unconvertible BIG5 character 0xf9d8
Any idea?
R
lass.oid and indisprimary
and attrelid=pg_class.oid and attnum ANY (indkey)
Helps will be much appreciated!
Regards,
CN
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ched messages from [EMAIL PROTECTED]
CN
Return-Path: <[EMAIL PROTECTED]>
Received: from nic.funet.fi (nic.funet.fi [128.214.248.6])
by mail.sinyih.com.tw (8.9.1/8.9.1) with ESMTP id RAA19559
for <[EMAIL PROTECTED]>; Sun, 14 Mar 1999 17:57:56 +0800
Received: from vger.ru
How do I correctly save and display Traditional Chinese characters in PostgreSQL 6.3.2
using Delphi 3 as client?
Best Regards,
CN liu
(mailto:[EMAIL PROTECTED])
23 matches
Mail list logo
