On Thu, Jul 19, 2007 at 05:52:30AM -0700, Paul Codler wrote:
> Basic query optimization question- does Postgres process
>
>x IN (y1, y2)
> as fast as
>(x = y1 OR x = y2)
>
> in a function?
EXPLAIN indicates this.
Peter
---(end of broadcast)---
On Wed, Jul 11, 2007 at 09:50:25AM -0300, Fernando Madruga Pinheiro wrote:
> Hi. I'm having some strange round behaviour when using 4 decimals.
>
> If I use ROUND(1.8947, 2), it should return 1.90, but it does return 1.89.
I asked my math teacher a similar question back in 7th grade:
If you ro
On Tue, Jul 03, 2007 at 02:47:58PM +0200, Stefan Zweig wrote:
>
> i appreciate any help.
man psql:
It is also convenient to have a ~/.pgpass file to avoid
regularly having to type in passwords. See the documentation
for more information.
Peter
---(end of broa
On Tue, Mar 27, 2007 at 03:57:49PM -0400, Joseph S wrote:
> Does anyone know how this works and how I can get those files
> from the pg tarball?
My guess: strip -o
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
On Fri, Mar 17, 2006 at 03:05:17PM -0500, Andrew Stewart wrote:
> I have had postgres working perfectly up until recently. Now suddenly I
> get an error when trying to run postgres:
>
> % psql
> psql: FATAL: No pg_hba.conf entry for host localhost, user postgres,
> database postgres
>
> % pos
On Sat, Dec 03, 2005 at 09:48:42PM +0100, Andrew Toth wrote:
>
> MediaBin=# insert into media values ("000", 120, "1");
> ERROR: column "000" does not exist
>
> What the Hell could be wrong?
Your quotes. Use ' and that command will work.
Peter
---(end of broadcast
On Thu, Oct 27, 2005 at 03:30:43PM -0700, Shane wrote:
>
> Can anyone suggest how I can either get these into PG directly
> or massage the file so as to be compatable?
To my knowledge the only Unicode encoding used by Postgres is
utf-8.
Try 'recode' or 'iconv' on unix-like systems. A better text
On Wed, Oct 26, 2005 at 02:52:36PM +0200, Zlatko Matić wrote:
>
> Is there any way to check the version of PostgreSQL by a query?
> Maybe by querying catalog tables?
Easier: select version();
Peter
---(end of broadcast)---
TIP 2: Don't 'kill -9' t
On Mon, Oct 24, 2005 at 08:59:17PM -0400, phil campaigne wrote:
> Hi All,
> I'm trying ot install postgresql 8.0.4 on suse 9.0.
>
> I can run ./configure but when I try to run make, the program cannot
> find a usable c compiler.
> I tried
> ./configure CC=/usr/lib/gcc-lib/i586-suse-linux/3.3.3/cc
On Wed, Sep 28, 2005 at 10:11:45AM +0100, [EMAIL PROTECTED] wrote:
>
> vicbsd# gcc -I
Don't use gcc to compile C++. Use g++.
Peter
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/
On Mon, Sep 26, 2005 at 07:03:06PM +0200, ruben wrote:
>
> I guess I'm doing something wrong:
>
> -bash-2.05b$ ulimit
> unlimited
Please read manpages, in this case bash: ulimit -a
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the
On Thu, Jul 28, 2005 at 08:31:21PM +0100, Phil Endecott wrote:
>
> This is Linux 2.4.26 and an ext3 filesystem.
With the dir_index feature or without?
Peter
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wed, Apr 27, 2005 at 03:03:50PM -0400, Doug McNaught wrote:
>
> What I have done is to create a separate init.d script that
> removes the PID file, and arrange for it to run before the PG
> startup script.
An even better place (if you really want to do all this) would be
something that happens
On Sun, Apr 24, 2005 at 11:52:11AM -0400, Tom Lane wrote:
> Peter Wiersig <[EMAIL PROTECTED]> writes:
> > On Sat, Apr 23, 2005 at 08:19:31PM -0400, Tom Lane wrote:
> >> Peter Wiersig <[EMAIL PROTECTED]> writes:
> >>> vacuumdb -z miwabar
> >>> P
On Sat, Apr 23, 2005 at 08:19:31PM -0400, Tom Lane wrote:
> Peter Wiersig <[EMAIL PROTECTED]> writes:
> > vacuumdb -z miwabar
> > PANIC: open of /var/lib/pgsql/data/pg_clog/ failed:
> >Keine Berechtigung
> > server closed the con
Hi List,
I had a database with a 8 Mb pg_dump file with 1.7 Gb in PG_DATA.
I dropped the database and tried to recreate the db with this
step:
psql template1 < data.sql
All tables and all data was restored and to help accessing the db
I tried to vacuum analyze it, yielding this error message:
16 matches
Mail list logo
