Re: [BUGS] BUG #4303: insufficient privileges

2008-07-16 Thread Decibel!
Can you help me ? Thank you Alexandre -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy!

Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-28 Thread Decibel!
fuse to start if it's more than 5. Seriously, I doubt anything short of that will make a big difference, but certainly putting the actual verbage back in the FAQ can't hurt. -- Decibel!, aka Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) pgp8dtVDzCH7R.pgp Description: PGP signature

Re: [BUGS] BUG #3543: ARRAY(SELECT ...) contruct yields NULL without rows

2007-08-16 Thread Decibel!
GNU/Linux > Description:ARRAY(SELECT ...) contruct yields NULL without rows > Details: > > SELECT ARRAY(SELECT 1 WHERE 1 = 0) IS NULL; -- true And just what would you have it return? An array with no elements is by definition NULL. -- Decibel!, aka Jim Nasby[EMA

Re: [BUGS] BUG #3514: buggy install + no manual support (add)

2007-08-07 Thread Decibel!
stops ok, path isn't, > -u/-p switches doesn't help it regularly connects but throws an exception Neither of these issues sound like bugs. I recommend posting on pgsql-general and asking for help. -- Decibel!, aka Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) pgpRjJUStnEz3.pgp Description: PGP signature

Re: [BUGS] Oddities with ANYARRAY

2007-08-04 Thread Decibel!
On Thu, Aug 02, 2007 at 12:44:02AM +0100, Gregory Stark wrote: > > "Decibel!" <[EMAIL PROTECTED]> writes: > > > On Jul 31, 2007, at 11:55 PM, Gregory Stark wrote: > >> > >> And what type would the result be? > > > > ANYELEME

Re: [BUGS] BUG #3499: no owner privileges in information_schema.table_privileges

2007-08-04 Thread Decibel!
CT > test_owner | DELETE > test_owner | INSERT > test_owner | UPDATE > test_owner | REFERENCES > test_owner | TRIGGER > test_user | SELECT > (7 rows) > > -- drop test_*. > # drop table test_table; > # drop user test_user; > # drop user tes

Re: [BUGS] Oddities with ANYARRAY

2007-08-01 Thread Decibel!
On Jul 31, 2007, at 11:55 PM, Gregory Stark wrote: "Decibel!" <[EMAIL PROTECTED]> writes: David Fetter and I were just looking at something on IRC... decibel=# select most_common_vals[1] from pg_stats where tablename='pg_depend' and attname='classid'; ER

[BUGS] Oddities with ANYARRAY

2007-07-31 Thread Decibel!
David Fetter and I were just looking at something on IRC... decibel=# select most_common_vals[1] from pg_stats where tablename='pg_depend' and attname='classid'; ERROR: cannot subscript type anyarray because it is not an array decibel=# select most_common_freqs[1] from pg_s

Re: [BUGS] BUG #3488: exporting data

2007-07-30 Thread Decibel!
cs on data type formatting (section 9.8) -- Decibel!, aka Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [BUGS] Some errors in PostgreSQL installestion

2007-07-30 Thread Decibel!
in local on my personal PC. Did you try just going with the defaults to all the questions? That normally works for me. -- Decibel!, aka Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of

Re: [BUGS] BUG #3486: doc bug - Preventing transaction ID wraparound failures

2007-07-30 Thread Decibel!
someone's changing something they can just change it in one place. -- Decibel!, aka Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 1: if pos

Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-07-30 Thread Decibel!
20% chance that corruption would hit the same table on two different machines. So far you haven't said anything that sounds unusual about how you're using the database, and the hardware certainly seems pretty common- place, so I'm rather doubtful that it's software. But i