> 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
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
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
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
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
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
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
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.
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.
