[GENERAL] Getting the Type Definition in the information schema

2005-06-05 Thread Craig Bryden
Hi I am trying to figure out which view in the information schema or the system catalogs will give me the members/columns of a user defined data type. Any help with this would be great. Thanks Craig ---(end of broadcast)--- TIP 6: Have you searche

Re: [GENERAL] Getting the Type Definition in the information schema

2005-06-05 Thread Michael Glaesemann
On Jun 5, 2005, at 6:17 PM, Craig Bryden wrote: I am trying to figure out which view in the information schema or the system catalogs will give me the members/columns of a user defined data type. Any help with this would be great. I believe you're referring to the composite variety of user

[GENERAL] logout Postgres from MS Access (ODBC) ?

2005-06-05 Thread Zlatko Matić
Hi!In MS Access/PostgreSQL combination I have login form. After user writes all neccessary inputs and push the button, a startup procedure creates DSN-less connection string, receates all linked tables and change connection string in all pass-through queries. It works nice...But, how to achi

Re: [GENERAL] Limits of SQL

2005-06-05 Thread Joachim Zobel
Am Samstag, den 04.06.2005, 15:22 -0500 schrieb Bruno Wolff III: > On Sat, Jun 04, 2005 at 21:53:24 +0200, > Joachim Zobel <[EMAIL PROTECTED]> wrote: > > So WITH will allow recursion so I can walk the graph, right? Does this > > mean I can recursively join until a terminating condition is reached

Re: [GENERAL] postgresql books

2005-06-05 Thread sql
Christopher Browne <[EMAIL PROTECTED]> wrote: > Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: > > "Gevik babakhani" <[EMAIL PROTECTED]> wrote: > > > >> Beside the documentation, which pg book would you recommend? Which one is > >> your personal favorite pg book? > > > > I

Re: [GENERAL] postgresql books

2005-06-05 Thread sql
"Gevik babakhani" <[EMAIL PROTECTED]> wrote: > Beside the documentation, which pg book would you recommend? Which one is > your personal favorite pg book? I saw an O'Reilly book [1] this afternoon at a bookshop here in Paris .. 'had to fight the urge to get my credit card out ... :-) Anyone know

Re: [GENERAL] Determining when a row was inserted

2005-06-05 Thread Patrick TJ McPhee
In article <[EMAIL PROTECTED]>, Alex Turner <[EMAIL PROTECTED]> wrote: % I really wasn't suggesting it be put in the table structure at the DB level, % more a sidebar suggestion for people building schemas for companies. I can't % count the number of times I've been asked when something was inse

Re: [GENERAL] prevent user change password?

2005-06-05 Thread Richard Hayward
On Wed, 01 Jun 2005 11:39:22 -0400, [EMAIL PROTECTED] (Tom Lane) wrote: >> I have a database with a 'Guest' account, that will have limited >> access. I don't want any of my guests to change the Guest account >> password. > >Perhaps you should use something other than password authentication >for

Re: [GENERAL] Limits of SQL

2005-06-05 Thread Andreas Seltenreich
Joachim Zobel schrob: > Am Samstag, den 04.06.2005, 15:22 -0500 schrieb Bruno Wolff III: >> On Sat, Jun 04, 2005 at 21:53:24 +0200, >> Joachim Zobel <[EMAIL PROTECTED]> wrote: >> > So WITH will allow recursion so I can walk the graph, right? Does this >> > mean I can recursively join until a ter

Re: [GENERAL] prevent user change password?

2005-06-05 Thread Tom Lane
Richard Hayward <[EMAIL PROTECTED]> writes: > On Wed, 01 Jun 2005 11:39:22 -0400, [EMAIL PROTECTED] (Tom Lane) > wrote: >> Perhaps you should use something other than password authentication >> for the guest account. > I want anyone from anywhere to be able to connect to my_database (only > my_dat

[GENERAL] CPU-intensive autovacuuming

2005-06-05 Thread Phil Endecott
Dear Postgresql experts, I'm trying to work out why my system spends so much time autovacuuming. It looks like pg_autovacuum wakes up every few minutes and does a query on some system tables, and then spins doing no more queries but burning all available CPU cycles for a a couple of minutes, b

Re: [GENERAL] postgresql books

2005-06-05 Thread Joshua D. Drake
[EMAIL PROTECTED] wrote: Christopher Browne <[EMAIL PROTECTED]> wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: "Gevik babakhani" <[EMAIL PROTECTED]> wrote: Beside the documentation, which pg book would you recommend? Which one is your personal favorite pg bo

Re: [GENERAL] survey of the postgresql communiity

2005-06-05 Thread Michael Fuhr
On Wed, 25 May 2005 at 13:17:31 -0700, Si Chen wrote: > > My company (opensourcestrategies.com) is conducting a study of the > PostgreSQL community to promote better understanding of open source > software. Original message: http://archives.postgresql.org/pgsql-general/2005-05/msg01174.php I've

Re: [GENERAL] SELECT DISTINCT performance issue

2005-06-05 Thread K C Lau
At 13:06 05/06/05, Tom Lane wrote: K C Lau <[EMAIL PROTECTED]> writes: > esdt=> explain analyze select DISTINCT ON (PlayerID) PlayerID,AtDate from > Player > where PlayerID='0' order by PlayerID desc, AtDate desc; > Unique (cost=0.00..2507.66 rows=1 width=23) (actual time=0.000..187.000