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:
>
> >
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 lis
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
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 a
"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 we
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 br
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 broadcast)-
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: _poll
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
index updates or something else to make it run more
quickly?
Jon
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 ser
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"
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
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 per
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
"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
* 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:
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 on
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 backend
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
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 throug
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: 5.1.2600
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 time
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
{
Class.forNam
* [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 K
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
__
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...
r
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,
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 plea
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 build
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 fro
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 wo
[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.
T
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 /usr/lo
=?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
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
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 t
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 a
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
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:))
-
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 s
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
(un
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 thorough
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 les
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). Henc
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" eac
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. Th
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'
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
post
51 matches
Mail list logo
