Re: [SQL] curly braces to group outer joins in queries from

2003-11-11 Thread Palle Girgensohn
Only, I set up postgreql to connect using JDBC... :( So, the bug is that OO expects an ODBC connection, and I use JDBC... Seems logical. I'll go ask the ODBC guys. Thanks for you help, /Palle --On tisdag, november 11, 2003 11.28.57 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Palle

Re: [SQL] curly braces to group outer joins in queries from

2003-11-11 Thread Palle Girgensohn
aStr; } Thanks for the prompt reply, as usual! Regards, Palle --On tisdag, november 11, 2003 09.39.52 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Palle Girgensohn <[EMAIL PROTECTED]> writes: I just tried using openoffice to create a SQL query, but it failed when I tried using left outer

[SQL] curly braces to group outer joins in queries from OpenOffice.org?

2003-11-11 Thread Palle Girgensohn
Hi! I just tried using openoffice to create a SQL query, but it failed when I tried using left outer joins. The contructed query from OO contains curly braces to group things. I've never seen this construct before. Is it OO doing bad things, or does postgresql not understand it? It's on pg-7.3.

Re: [SQL] CREATE OR REPLACE VIEW

2000-11-30 Thread Palle Girgensohn
As a work around, you might get off telling php to ignore the errors, using error_reporting(); CREATE OR REPLACE cannot be found in the postgres docs, so I guess it is not there? /Palle Ricardo Dias Marques wrote: > > Hi all, > > Is CREATE OR REPLACE VIEW available in any way, in PostgreSQL 7

Re: [SQL] need asap: bg_BG locale for FreeBSD

2000-09-11 Thread Palle Girgensohn
Oleg Bartunov wrote: > > Hi, > > I'm going to Bulgaria this week to setup FreeBSD server running > postgres and would like to know if somebody has an experience > with postgres and bulgarian locale. Actually, I need > bg_BG locale for FreeBSD. interesting that searching for > subject in internet

Re: [SQL] pg_attribute_relid_attnam_index problem after log disk filled up

2000-08-28 Thread Palle Girgensohn
Tom Lane wrote: > > Palle Girgensohn <[EMAIL PROTECTED]> writes: > > What's this? What to do? Shall I bother? > > > pp=> vacuum; > > NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF > > INDEX' TUPLES (3094) IS NOT THE SAME AS HEAP&

[SQL] pg_attribute_relid_attnam_index problem after log disk filled up

2000-08-28 Thread Palle Girgensohn
Hi! What's this? What to do? Shall I bother? pp=> vacuum; NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (3094) IS NOT THE SAME AS HEAP' (3093) The database is rather large, and the time to run vacuum is too short, so it feels like something is stopping the vacuum too e