Re: [BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-14 Thread Stuart Bishop
On Thu, Nov 15, 2012 at 1:42 PM, Craig Ringer wrote: >> The pgstattuple upgrade from unpackaged script expects the pgstatindex >> function to exist, but it does not on particularly old databases (My >> pgstattuple originally installed with 8.3 or 8.4?). pg_relpages(text) was missing too. > That

Re: [BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-14 Thread Craig Ringer
On 11/15/2012 02:19 PM, stu...@stuartbishop.net wrote: > The following bug has been logged on the website: > > Bug reference: 7661 > Logged by: Stuart Bishop > Email address: stu...@stuartbishop.net > PostgreSQL version: 9.1.6 > Operating system: Ubuntu 12.04 > Description:

[BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-14 Thread stuart
The following bug has been logged on the website: Bug reference: 7661 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.6 Operating system: Ubuntu 12.04 Description: The pgstattuple upgrade from unpackaged script expects the pgsta

Re: [BUGS] Re: BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long

2012-11-14 Thread Craig Ringer
On 11/15/2012 02:11 AM, limkimhuot wrote: > Dear all, > > Today is my fourth day I have been trying to install PostgreSQL > (postgresql-9.2.1-1-windows-x64) in my window 7 x64, yet it fails all the > time. > > I don't know much about VB script or I am very new in VB. > > Is it correct if I place co

Re: [BUGS] BUG #7657: Create Table doesn't create columns

2012-11-14 Thread Tom Lane
"Matthew Kuss" writes: > Depesz - > I'm fairly sure it's not a problem with something I'm doing wrong because > I've used the same code before. It has to be something wrong on the DB side. > But just to entertain you I did as you requested: > RigMinder_NewDBTest02=# \d test > Table "public.

Re: [BUGS] BUG #7658: the result of pg_get_viewdef can NOT execute directly

2012-11-14 Thread Tom Lane
zoulx1...@163.com writes: > postgres=# create table t1(a int, b int); > CREATE TABLE > postgres=# create table t2(c int, d int); > CREATE TABLE > postgres=# create view v as select * from t1 t where a in (select a from t2 > t); > CREATE VIEW > postgres=# select pg_get_viewdef('v'); >

[BUGS] Re: BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long

2012-11-14 Thread limkimhuot
Dear all, Today is my fourth day I have been trying to install PostgreSQL (postgresql-9.2.1-1-windows-x64) in my window 7 x64, yet it fails all the time. I don't know much about VB script or I am very new in VB. Is it correct if I place code of the new environment variable like this: SYSTEMDRIV

Re: [BUGS] BUG #7657: Create Table doesn't create columns

2012-11-14 Thread Matthew Kuss
Depesz - I'm fairly sure it's not a problem with something I'm doing wrong because I've used the same code before. It has to be something wrong on the DB side. But just to entertain you I did as you requested: RigMinder_NewDBTest02=# \d test Table "public.test" Column | Type | Modifiers --

[BUGS] BUG #7658: the result of pg_get_viewdef can NOT execute directly

2012-11-14 Thread zoulx1982
The following bug has been logged on the website: Bug reference: 7658 Logged by: ZouLixian Email address: zoulx1...@163.com PostgreSQL version: 9.2.0 Operating system: Linux Description: postgres=# postgres=# select version();

Re: [BUGS] BUG #7657: Create Table doesn't create columns

2012-11-14 Thread hubert depesz lubaczewski
On Wed, Nov 14, 2012 at 10:00:08AM -0600, Matthew Kuss wrote: > Depesz - > > I'm fairly sure it's not a problem with something I'm doing wrong > because I've used the same code before. It has to be something wrong > on the DB side. But just to entertain you I did as you requested: > > RigMinder_N