Scott Frankel [EMAIL PROTECTED] writes:
I am attempting to install postgresql7.4.5 on OSX 10.3.5 and have
questions about readline.
FWIW, on my OSX machines I always pull down the source distribution of
readline and build/install it per defaults (configure; make; sudo make
install or nearly
Postgresql 7.4.5
The following VACUUMs were run within a couple of minutes of each other completing.
This table concerned is a table that has not been changed in a long time. (a month)
There were open transactions at the time the vacuum was run. These were created by
having PHP running with
Hi,
tonight my database got corruppted. before it worked fine.
since two days i do the following tasks every night
psql -c 'CLUSTER;' $DBNAME
psql -c 'VACUUM FULL ANALYZE;' $DBNAME
before these opertaions i stop all web access. The last months i only did a
VACUUM ANALYZE each night and didn't
Am Freitag, 1. Oktober 2004 09:49 schrieben Sie:
Hi,
tonight my database got corruppted. before it worked fine.
since two days i do the following tasks every night
psql -c 'CLUSTER;' $DBNAME
psql -c 'VACUUM FULL ANALYZE;' $DBNAME
before these opertaions i stop all web access. The last
Janning Vygen wrote:
Hi,
tonight my database got corruppted. before it worked fine.
since two days i do the following tasks every night
psql -c 'CLUSTER;' $DBNAME
psql -c 'VACUUM FULL ANALYZE;' $DBNAME
before these opertaions i stop all web access. The last months i only did a
VACUUM ANALYZE each
Howdy! I'd like to set up a database (mostly a bibliography), which
I'd like to connect to a webpage such that simple queries to the
database can be made by visitors of my homepage. I seem to remember
that FileMaker allows for this, but I'd prefer a UNIX-based solution
(under MacOS X).
Hi Richard,
i feared all db gurus are asleep at the moment.
Am Freitag, 1. Oktober 2004 10:56 schrieb Richard Huxton:
PS - your next mail mentions sig11 which usually implies hardware
problems, so don't forget to test the machine thoroughly once this is over.
You saved my life!! Nothing
Janning Vygen wrote:
Hi Richard,
i feared all db gurus are asleep at the moment.
They are, that's why you've got me :-)
Am Freitag, 1. Oktober 2004 10:56 schrieb Richard Huxton:
PS - your next mail mentions sig11 which usually implies hardware
problems, so don't forget to test the machine
Bernd Buldt wrote:
Howdy! I'd like to set up a database (mostly a bibliography), which
I'd like to connect to a webpage such that simple queries to the
database can be made by visitors of my homepage. I seem to remember
that FileMaker allows for this, but I'd prefer a UNIX-based solution
Hello all,
i have a view defined as a simple select of a table.
This table is inherited by a couple of others.
All entries belong to the child-tables.
I also have an unconditional update rule on the view.
If i do an update to the view, the update is rewritten
to update the father-table.
And now a
Hi,
I'm writing some simple triggers and functions for a postgres database, and I'm
wondering how to go about to debug a pl/pgSQL-script. Is there a way to echo
variable-content to screen, or to file? Or is there other, more advanced ways of
debugging such scripts?
regards Jonas:))
Hi,
http://www.postgresql.org/docs/7.4/static/plpgsql-errors-and-messages.html
Albert
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Fri, Oct 01, 2004 at 03:05:14PM +0200, Henriksen, Jonas F wrote:
I'm writing some simple triggers and functions for a postgres
database, and I'm wondering how to go about to debug a
pl/pgSQL-script. Is there a way to echo variable-content to screen, or
to file? Or is there other, more
Apache/PHP are already prebuilt on Mac OS X. All you need to do is
donwload the postgres tarball config and compile.
Small notte on the compile. When you compile postgres either turn off
readline support or download readline from GNU and compile the static
lib.
I don't remember off hand but I
Russell Smith [EMAIL PROTECTED] writes:
Should VACUUM report the rows as deleted or say they could not be deleted?
Why does it report the same information for three runs in a row?
I see no pending deletions in that vacuum output:
DETAIL: 0 dead row versions cannot be removed yet.
so I'm not
=?ISO-8859-1?Q?Sebastian_B=F6ck?= [EMAIL PROTECTED] writes:
Is this a known limitation with views, rules and
inherited tables i haven't heard of? Or is it a bug?
When you haven't shown us any details, it's impossible to tell.
Let's see the actual table, view, and rule definitions. (pg_dump -s
Additional note: configure warned of an old version of bison when I
attempted an install of postgresql7.4.5 the other day. Seems the
version
that comes with OSX 10.3.x is too old for postgres.
Only trick I encountered in installing bison from tarball was locating
the
install product in
[EMAIL PROTECTED] wrote:
Hi,
I'm looking for details, or tools about porting a full Ms Sql Server
2000 database to Postgres on Linux.
Is this possible? We have the whole nine yards, stored procedures,
triggers, and all.
Is there a way to automate this process?
Thanks
Totally automate - no.
Hi,
I want to do develop some C++ to interface with a remote postgresql
database via ODBC on a win32 platform (windows 2000) via unix
style. For example, I like using the mingw (minimum gnus for windows)
distribution, gnumake, xemacs, cygwin, and non-IDE building.
Will the iODBC driver manager
Scott Frankel [EMAIL PROTECTED] writes:
Additional note: configure warned of an old version of bison when I
attempted an install of postgresql7.4.5 the other day. Seems the
version
that comes with OSX 10.3.x is too old for postgres.
You only actually need Bison if you are building from
Randy Yates wrote on 27.09.2004 01:35:
Hi,
I want to do develop some C++ to interface with a remote postgresql
database via ODBC on a win32 platform (windows 2000) via unix
style. For example, I like using the mingw (minimum gnus for windows)
distribution, gnumake, xemacs, cygwin, and non-IDE
Hi,
I want to develop my project in postgresql database
but my project requirement is Distributed Database so
please guide me that postgresql can sport Distributed
Database system and Centralized Database System, if
yes then please inform me that which postgresql
version should i used and also
Hello,
Could someone help tell the commands of the following operation under postgreSQL
please?
. List all functions have been defined (e.g., defined through pg/sql) within a
database
. Display all process/connections (similar to show processlist under MySQL)
Thanks in advance,
Ly
Gentoo, in my opinion, makes a poor production platform. Others have had
success with it, but I would recommend 1 of the big 3 'stable' linux
platforms out there:
* RHES
* SUSE
* Debian
As far as hardware goes, IBM has some nice x86 intro servers that fit
into that price catagory.
-Barry
John
Hi,
not sure I quite understand, but could you not just concatenate all the fields and
test on that? like:
select test1, test2, test3 from testtable
where test1 || test2 || test3 = 'whateveryouwanttotest'
you might have to do some typecasting/conversion on data types other than strings...
Hi everybody,
I'm doing the following query:
select * from messages order by random() limit 1;
in the table messages I have more than 200 messages and a lot of times, the
message retrieved is the same. Anybody knows how I could do a more random
random?
Thank you very much
--
Arnau
* [EMAIL PROTECTED] [EMAIL PROTECTED] [2004-09-28 17:28:25 -0400]:
. List all functions have been defined (e.g., defined through
pg/sql) within a database
SELECT proname FROM pg_proc JOIN pg_language ON (pg_proc.prolang =
pg_language.oid) WHERE pg_language.lanname = 'plpgsql';
--
Steven
hi!
Everybody.
I have written a code to connec to postgre sql
databse.But i am geting some error.
import java.sql.*;
import java.util.*;
import java.lang.*;
public class LoginPage {
public static void main(String[] args)
{
Connection conn;
try
{
Use a SERIAL id on messages, then
Select * from messages
where id = int8( random() * currval({sequence_name}));
Arnau Rebassa wrote:
Hi everybody,
I'm doing the following query:
select * from messages order by random() limit 1;
in the table messages I have more than 200 messages and a lot of
Hello folks,
I am having a hard time installing PgSQL on WinXP - when installing from
source it tells me I have an incompatible time zone - PgSQL does not
support leap seconds (Europe - Bratislava, Budapest, Berlin, etc.), when
installing via installer dev2 and/or dev3 freezes.
ver says:
Are there also SRPMs? I'm interested on Fedora Core 2 ones. I have rebuilt
from SRPMs the Beta2 and it works OK - I only had to change the init
script - the version provided was 7.4.
Marian
---(end of broadcast)---
TIP 3: if posting/reading
On Mon, Sep 27, 2004 at 07:04:50PM -0400, Esteban Kemp wrote:
Esteban,
I'm building a Large DataMart with a big table and I want to improve
the performace using aggregates I mean a set of table that store
some specific aggregacion of the main table, like materialized
views, I know
HI,
I'm using pgadmin III 1.2.0 Post Beta 1 (Sept 17 2004). I used it to execute
a SQL script that creates tables and inserts data. At the end, I get a
message saying that everything went through correctly. However, when I try
to view the data in the pgadmin window, nothing shows up.
My
Im trying to connect locally to a database on a running postgres
cluster. If i connect with psql, everything is fine and i can transact.
I i try and connect in my own app, i get this error:
Could not connect to server: permission denied.
Is the server running locally and accepting
connections
* Alexander Cohen [EMAIL PROTECTED] [2004-10-01 14:42:07 -0400]:
Im trying to connect locally to a database on a running postgres
cluster. If i connect with psql, everything is fine and i can transact.
I i try and connect in my own app, i get this error:
Could not connect to server:
Arnau Rebassa [EMAIL PROTECTED] writes:
select * from messages order by random() limit 1;
in the table messages I have more than 200 messages and a lot of times, the
message retrieved is the same. Anybody knows how I could do a more random
random?
What OS is this? Postgres is just
Good to know ...
Scott
On Oct 1, 2004, at 9:08 AM, Doug McNaught wrote:
Scott Frankel [EMAIL PROTECTED] writes:
Additional note: configure warned of an old version of bison when I
attempted an install of postgresql7.4.5 the other day. Seems the
version
that comes with OSX 10.3.x is too old for
Alexander Cohen [EMAIL PROTECTED] writes:
Could not connect to server: permission denied.
Is the server running locally and accepting
connections on Unix domain socket /tmp/.s.PGSQL.5432
What exctly does this error message mean? What permissions is this
error talking about?
The permissions
On 1-Oct-04, at 3:06 PM, Tom Lane wrote:
Alexander Cohen [EMAIL PROTECTED] writes:
Could not connect to server: permission denied.
Is the server running locally and accepting
connections on Unix domain socket /tmp/.s.PGSQL.5432
What exctly does this error message mean? What permissions is this
Hi,
I upgraded recently DB and found that some columns with type timestamp
changed default values from now() to:
receipt_date | timestamp with time zone | not null default
'2004-09-29 09:58:03.010678+10'::timestamp with time zone
,where time is a time when psql -U postgres template1
Got this error on a pg_dumpall file dumped from a postgresql-7.4-0.3PGDG
database and imported into 7.4.5-3 database.
ERROR: zero-length delimited identifier at or near at character 37
From looking at the output, I think maybe this is the line that caused
the error.
CREATE SCHEMA MSV80
I would like to be able to initdb to get a clean database to test
backups. Reading the Debian version of the Postgresql README, I see
that I should use the --debian-conffile option with initdb. Problem
though. I have to run initdb as user postgres, but I need to be root to
edit the stuff in
I installed Postgres 8 beta 3 on an XP box, with Postgres running as a
service. TaskManager tells me that postgres and postmaster are both
running. Using pgAdmin III, I can connect to the server and create
users, databases, tables, etc.
But at the command line, on the same machine where the
On 30. sep 2004, at 21:35, Joe Lester wrote:
I'm just moved my Postgres client project from Mac 10.2.8 to 10.3.5.
It's an Objective-C program that links to libpq.a (the header file is
libpq-fe.h). However, when I try to compile now I get the following
linking error:
ld: Undefined symbols:
Hello all,
Is it possible that we setup the password in the pg_dump command line
instead of let users input it through prompt command. E.g.,
pg_dump test -c -d --host=localhost -U testUser1 --file='a.dmp'
--no-privileges
Thanks a lot!
Ly
---(end of
Alexander Cohen [EMAIL PROTECTED] writes:
What kind of permissions does /tmp need?
Generally it's 777 (ie, wide open), plus stickybit if your system
supports that (so people can't delete each others' temp files).
regards, tom lane
---(end of
Igor Kryltsov [EMAIL PROTECTED] writes:
I upgraded recently DB and found that some columns with type timestamp
changed default values from now() to:
receipt_date | timestamp with time zone | not null default
'2004-09-29 09:58:03.010678+10'::timestamp with time zone
Those were not
Steve Gollery [EMAIL PROTECTED] writes:
I installed Postgres 8 beta 3 on an XP box, with Postgres running as a
service. TaskManager tells me that postgres and postmaster are both
running. Using pgAdmin III, I can connect to the server and create
users, databases, tables, etc.
But at the
Tom,
False alarm -- I just realized that I was picking up the createdb from
an earlier failed attempt to install 7.4.5. Removing that got me to the
right command and all is well.
Thanks for the help.
Steve
Tom Lane wrote:
Steve Gollery [EMAIL PROTECTED] writes:
I installed Postgres 8 beta 3 on
Hi All,
I want to connect to PostgreSQL 7.4 from my Windows machine. What ODBC
version is needed? Is there any other important settings required? I am very
new to this database.
Thanks,
Astha
---(end of broadcast)---
TIP 2: you can get off all
On Sat, 2 Oct 2004 12:42 am, Tom Lane wrote:
Russell Smith [EMAIL PROTECTED] writes:
Should VACUUM report the rows as deleted or say they could not be deleted?
Why does it report the same information for three runs in a row?
I see no pending deletions in that vacuum output:
DETAIL: 0
I'm running some
very large table update operations (on 2 mil + records) and the queries are
taking 5 + hours to complete. Is there a way to turn off row-level
indexupdates or something else to make it run more
quickly?
Jon
52 matches
Mail list logo