Re: [BUGS] can't startup PG-8.0.3

2005-06-26 Thread Tom Lane
Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > Please note different values in "Latest checkpoint location" and "Prior > checkpoint location" - is this mean > that DB shutted down abnormally and some uncommited data exists? No; indeed, if they were the same *then* I would worry.

[BUGS] problem with unexpected error

2005-06-26 Thread satish reddy
Hi, I'm using postgreSQL with vb.net is working fine. But some times i got the error is "ERROR: no error information is available". I'm using 8.1 version and odbc 9.x version. Please give me some solution to avoid this error   Thanks in advance   Satish Yahoo! Sports Rekindle the Rivalries.

Re: [BUGS] can't startup PG-8.0.3

2005-06-26 Thread Ruslan A Dautkhanov
Tom Lane wrote: Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: I have experience with PostgreSQL 7.x, and I can't figure out why this happen. PG didn't say anything meaningful, that can point me why he did not start. That's fairly unusual --- I can't think of any place

Re: [BUGS] can't startup PG-8.0.3

2005-06-26 Thread Ruslan A Dautkhanov
Hello ! Tom Lane wrote: I have a command su - pgsql -c '/usr/local/pgsql/bin/postmaster -d 5 -D /usr/local/pgsql/data' Shouldn't there be an & or something in there? Seems like that will leave the su command blocked waiting for the postmaster to exit, which of course i

Re: [BUGS] Works as SELECT but not as a VIEW

2005-06-26 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > So the SELECT can manage this bot not the VIEW? The spec constrains tables (and views) not to have duplicate column names, but it does not say that about SELECT output lists. regards, tom lane ---(end of

Re: [BUGS] Works as SELECT but not as a VIEW

2005-06-26 Thread Robert Creager
When grilled further on (Sun, 26 Jun 2005 15:18:47 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > This doesn't seem right: > [ snip embarrassing mistake ] > > Why doesn't it seem right? You're asking it to generate a view with > two columns both

Re: [BUGS] Works as SELECT but not as a VIEW

2005-06-26 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > This doesn't seem right: > CREATE VIEW inci AS > SELECT date, inci_id, protocol, a.ip_addr, b.ip_addr, spt, dpt > FROM (SELECT addr_id, ip_addr FROM addrs) AS a > JOIN incident ON incident.source_addr_id =3D a.addr_id=20 > JOIN (SELECT ad

[BUGS] Works as SELECT but not as a VIEW

2005-06-26 Thread Robert Creager
This doesn't seem right: CREATE VIEW inci AS SELECT date, inci_id, protocol, a.ip_addr, b.ip_addr, spt, dpt FROM (SELECT addr_id, ip_addr FROM addrs) AS a JOIN incident ON incident.source_addr_id = a.addr_id JOIN (SELECT addr_id, ip_addr FROM addrs) AS b ON incident.de

Re: [BUGS] BUG #1727: Corrupt Zip file?

2005-06-26 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1727 > Logged by: Robert Zahm > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: Windows 2000 > Description:Corrupt Zip file? > Details: > > I an unable to unzip the .zip f