On Thu, Jul 27, 2006 at 07:30:01PM +, Steven Adams wrote:
> select ia.name, iac.internal
> from information_assets as ia
> left outer join information_asset_categories as iac on(ia.category_id =
> iac.id)
> and ia.id = 21
>
> This causes all rows in information_assets to be returned despite th
"Steven Adams" <[EMAIL PROTECTED]> writes:
> select ia.name, iac.internal
> from information_assets as ia
> left outer join information_asset_categories as iac on(ia.category_id =
> iac.id)
> and ia.id = 21
> This causes all rows in information_assets to be returned despite the "and"
> clause.
AF
Phil Frost <[EMAIL PROTECTED]> writes:
> Things were crusing along just fine as I can tell, and then all the
> postgresql processes terminated. This is all I see in the logs:
> LOG: received immediate shutdown request
Something sent the postmaster a SIGQUIT signal. You need to look into
what mi
On Thu, 27 Jul 2006, Steven Adams wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2553
> Logged by: Steven Adams
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.4
> Operating system: Red Hat Linux 3.2.3-42
> Description:Outer join
Hi,
I have tried several installs of postgresql-8.1.3-1
and postgresql-8.1.4-1, with psqlodbc-08_02_0002.zip and PgOleDb-1.0.0.20.zip.
After each uninstall I delete the entire contents of
the C:\Program Files\PostgreSQL directory.
I am using VB6 SP6b.
My ‘Connection’ string
The following bug has been logged online:
Bug reference: 2553
Logged by: Steven Adams
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Red Hat Linux 3.2.3-42
Description:Outer join bug
Details:
Every time I use an outer join as the last o
Things were crusing along just fine as I can tell, and then all the
postgresql processes terminated. This is all I see in the logs:
LOG: autovacuum: processing database "dew"
LOG: autovacuum: processing database "postgres"
LOG: autovacuum: processing database "template1"
LOG: autovacuum: proce
