: Re: [SQL] Schema partitioning
On Sep 1, 2011, at 14:13, Charlie wrote:
> Could I get feedback from the community on schema partitioning?
>
> I'm doing maintenance on my ddl and I'm noticing that my tables are all in 1
> schema, but they have prefixes on their names lik
On Sep 1, 2011, at 14:13, Charlie wrote:
> Could I get feedback from the community on schema partitioning?
>
> I'm doing maintenance on my ddl and I'm noticing that my tables are all in 1
> schema, but they have prefixes on their names like table_app1_sometable,
> table_app1_secondtable, ta
Could I get feedback from the community on schema partitioning?
I'm doing maintenance on my ddl and I'm noticing that my tables are all in 1
schema, but they have prefixes on their names like table_app1_sometable,
table_app1_secondtable, table_app2_anothertable,
table_priviledged_restrictedtab
[ sorry if it is a repost, i am not sure if i am subscribed in -general ]
Dear List,
There are many opensource applications that support postgresql
(eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces)
as a result of which you are forced to use/create a new database and loose
Hi,
chester c young wrote:
has anyone done any work on comparing schemas?
There are two different projects called 'pgdiff', you'll find them with
google.
I'm trying to automatically propagate changes in a master schema to
child schemas. All schema changes will originate at master. Curren
Hi
has anyone done any work on comparing schemas?
I'm trying to automatically propagate changes in a master schema to
child schemas. All schema changes will originate at master. Currently
child schemas are in the same database, but in the future might be in
different databases (clusters?).
tha
On 1/22/07, Marcin Stępnicki <[EMAIL PROTECTED]> wrote:
Dnia Mon, 22 Jan 2007 17:38:09 -0200, Ezequias Rodrigues da Rocha
napisał(a):
> Hi list,
>
> I would like to ask you if there is any schema that someone can send me.
I
> must make some Replication testes and would like to use a simple sche
Dnia Mon, 22 Jan 2007 17:38:09 -0200, Ezequias Rodrigues da Rocha
napisał(a):
> Hi list,
>
> I would like to ask you if there is any schema that someone can send me. I
> must make some Replication testes and would like to use a simple schema
> with two or three tables would be nice.
You can find
Hi list,
I would like to ask you if there is any schema that someone can send me. I
must make some Replication testes and would like to use a simple schema with
two or three tables would be nice.
My best regards...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Kyle,
Nice to hear from you guys again! Action Target was one of the pioneers
of production open source in manufacturing; nice to know that you're
still doing well with it.
--Josh
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
I just saw this very old post and thought I'd respond for the benefit
of the list:
Patrick,
> Could someone give me some advice or point me to an article that would help
> manage views? I have a view that I use in conjunction with other views,
> and since I have to drop the view and then rec
If it is for multiple columns' foreign key constraint.
Try this query:
SELECT DISTINCT n.nspname AS from_schema_name, c.relname AS
from_table_name, toSchemaName.nspname AS to_schema_name, toTable.relname
as to_table_name,
fk_col.attname
FROM pg_catalog.pg_class AS c
LEFT JOIN pg_namespace AS
Subject: Re: [SQL] schema inspection
O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :
> Hi,
>
> supposing to have a small DB:
>
> TABLE a (
> id SERIAL PRIMARY KEY
> );
>
> TABLE b (
> id SERIAL PRIMARY KEY,
> idA INTEGER NOT NULL REFERENCES a(id)
>
>Well thats it if you use only *single column* Foreign keys.
>In the general case the above will need extra work.
Are you sure? I have tested query with 3 table with multiple FK and
it works (see below) [as you can see
"C" table have two FK to A and B]
test=> SELECT
test-> (SELECT relname FRO
>
>SELECT c1.relname,c2.relname from pg_constraint cons,pg_class c1,
pg_class
>c2 where cons.conrelid=c1.oid and cons.confrelid = c2.oid;
>
>for column(s) names you will have to do extra homework.
Thanks! I have obtained my query! Here is:
SELECT
(SELECT relname FROM pg_catalog.pg_class WHE
O [EMAIL PROTECTED] έγραψε στις Mar 17, 2006 :
> >
> >SELECT c1.relname,c2.relname from pg_constraint cons,pg_class c1,
> pg_class
> >c2 where cons.conrelid=c1.oid and cons.confrelid = c2.oid;
> >
> >for column(s) names you will have to do extra homework.
>
> Thanks! I have obtained my query!
O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :
> > pg_catalog.pg_constraint is your (only?) friend.
>
> I have already examintated this table without results. Seem not to be
> a "human-readable" table :(
Right you will have to join against pg_class,
and make it readable.
SELECT c1.reln
> pg_catalog.pg_constraint is your (only?) friend.
I have already examintated this table without results. Seem not to be
a "human-readable" table :(
TIA
Roberto Colmegna
Tiscali ADSL 4 Mega Flat
Naviga senza limiti con l'unica Adsl a 4 Mega di velocità a soli 19,95
O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :
> Hi,
>
> supposing to have a small DB:
>
> TABLE a (
> id SERIAL PRIMARY KEY
> );
>
> TABLE b (
> id SERIAL PRIMARY KEY,
> idA INTEGER NOT NULL REFERENCES a(id)
> );
>
> How can I inspect pg_schema/information_schema to "detect" the
> rela
Hi,
supposing to have a small DB:
TABLE a (
id SERIAL PRIMARY KEY
);
TABLE b (
id SERIAL PRIMARY KEY,
idA INTEGER NOT NULL REFERENCES a(id)
);
How can I inspect pg_schema/information_schema to "detect" the
relation between "b" and "a" via "idB"?
TIA
Roberto Colmegna
Chris Gamache <[EMAIL PROTECTED]> writes:
> So, is the best-practice for the my_schema tables to reference the
> user-defined datatype in the "public" schema?
Not necessarily, but if you put it somewhere else you'll want to add
the somewhere else to your default search path (probably via ALTER
DAT
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> In practice I'm not sure that this is really a situation that we need to
> fret about, because using a datatype that isn't in your search path has
> got notational problems that are orders of magnitude worse than this
> one. The functions and operators tha
Chris Gamache <[EMAIL PROTECTED]> writes:
> Is it even possible to create an index that lives in a different
> schema from the table it is indexing?
It is not --- the index always lives in the same schema as its table.
However, I think that the real issue here is "where is the datatype?".
I'm assu
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Chris Gamache <[EMAIL PROTECTED]> writes:
> > I'm having a heck of a time, and it seems like in my thrashing about
> > to find a solution to this problem I have ruined the uniqueidentifier
> > datatype in the schema...
>
> > CREATE INDEX mt_uuid_idx
> >
Chris Gamache <[EMAIL PROTECTED]> writes:
> I'm having a heck of a time, and it seems like in my thrashing about
> to find a solution to this problem I have ruined the uniqueidentifier
> datatype in the schema...
> CREATE INDEX mt_uuid_idx
> ON my_schema.my_table USING btree (my_uuid);
> ERROR:
PostgreSQL 7.4.2 -- All vacuumed and analyzed.
I inserted the uniqueidentifier datatype into a new schema that I'm working on
by changing the search_path to "my_schema" in the contrib SQL. It effectively
created the datatype within the schema, all of its functions, operators, and
operator classes.
look here
http://sql-info.de/postgresql/schemas.html
On Sun, 16 Nov 2003 13:05:20 +0530
Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> hi
> where can i find infor about 'schema' in postgresql?
---(end of broadcast)---
TIP 2: you can get off all li
hi
where can i find infor about 'schema' in postgresql?
--
regards
kg
http://www.ootygolfclub.org
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Charlie Toohey <[EMAIL PROTECTED]> writes:
> Why can't my primary user (ttvuser) access tables (owned by owneruser) for
> which they've been granted access? I can describe the table, but can't
> read it.
> ttvdev=> select count(*) from owneruser.users;
> ERROR: owneruser: permission denied
You
Why can't my primary user (ttvuser) access tables (owned by owneruser) for
which they've been granted access? I can describe the table, but can't
read it.
===
Here's what I'm getting:
ttvdev=> \c - owneruser
Password:
You are now connected as new user owneruser.
ttvdev=> \d
30 matches
Mail list logo
