Description:
General Discussions about PostgreSQL
|
|
|
「ルパン三世より予告状」
|
| |
俺はルパ～ン三世！ よくここまで来れたな！ じゃあ手っ取り早く手順を説明するぜ！ ⇒ココにＵＲＬ ⇒パスワードを必ず5115で登録する ⇒全ての登録が完了し再度ログインする ⇒携帯番号を登録した全国の女性達の 電話番号一覧データーが地域別で表示される... more »
|
|
|
ADO TO ODBC
|
| |
hi freinds, I have an application software which has connection with MS Access through DAO.I want to use same software without any changing with my new databank Postgresql through Odbc. I dont think so,that i can change it,I must develope whole software with odbc for postgresql. can any body help me?... more »
|
|
|
Restoring a database
|
| |
I backup all my databases by using pg_dumpall - pg_dumpall > /tmp/postgres.backup.`hostname `. It should backup four DBs: analyze, postgres, template0 and template1 I guess this backs up the schemas as well. Now I want to restore one of the databases and schema from this backup dump file onto a different server. The databases is call "analyze".... more »
|
|
|
No select permission on a table but can query it
|
| |
I think that this is a strange question, but: I need to revoke the select permission on a table, but I also need to leave, with a function, a user do a query on column. A real case can be that a user "test" cannot have the permissions for do a "select * from articles", but for do a "select has_article('an_article')"... more »
|
|
|
Numbering rows
|
| |
Is there an easy way to assign a sequential number, possibly based on an arbitrary minimum (typically 0 or 1) to each row of an ordered result set, or do I have to work with explicit sequences? I need to do quite a lot of maths on successive rows, extracting numeric and timestamp differences hence rates of change. I've typically been... more »
|
|
|
slony and fill factor
|
| |
I was wondering if I can set fill factor without breaking slony replication. It's technically DDL, but it's not really altering the table in the way I'd expect to be an issue for slony. Anyone know before I set up a replication set and experiment on it?
|
|
|
UPDATE and Indexes and Performance
|
| |
Does PG (8.1) ever use existing indexes when executing an UPDATE? I've got some tables with millions of records and whenever I update a column that involves most or all the records the EXPLAIN command seems to indicate that it isn't using the pre-existing indexes. This result in a slow update, which is further slowed by the presence of indexes. So... more »
|
|
|
create parent after children
|
| |
Hello Guys, I need to create a postgres 7.3 (done that, its bundled with an app I have to extend). Now I need to create 2 tables one a table of events. usual mix of column types, with varchar as primary key. However when I get 3 events in with specific characteristics I need to create a summary event saying " 3 events of type X received).... more »
|
|
|
Opptimizing projections containing unused columns
|
| |
I have lot of autogenerated from projection queries in form SELECT source.c1, source.c2, t1.col1, t1.col2, ... FROM (SELECT c1, c2, c3, ..... , c20 FROM ... WHERE ... ) source LEFT JOIN t2 USING (somecolumn) Main SELECT uses only few columns (source.c1 and source.c2 in this sample) from source projection.... more »
|
|
|
