Hello,
is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine
without Admin Rights?
Thanks for your Help,
Stefan Sturm
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Erik Jones wrote:
On Mar 24, 2008, at 2:18 PM, Josh Trutwin wrote:
On Mon, 24 Mar 2008 14:02:02 -0500
Erik Jones [EMAIL PROTECTED] wrote:
On Mar 24, 2008, at 1:09 PM, Martijn van Oosterhout wrote:
On Mon, Mar 24, 2008 at 12:47:43PM -0500, Josh Trutwin wrote:
My code to check if an
I have a table with 32 lakh record in it. Table size is nearly 700 MB,
and my machine had a 1 GB + 256 MB RAM, i had created the table space in
RAM, and then created this table in this RAM.
So now everything is in RAM, if i do a count(*) on this table it returns
327600 in 3 seconds, why
Stefan Sturm wrote:
Hello,
is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine
without Admin Rights?
Yes, but you cannot use the MSI installer, and you cannot install it as
a service (for auto-start). You can download the binaries-no-installer
and run the initdb and pg_ctl
Stumo wrote:
Each client retrieves an unprocessed record from the server, marks
that it's processing that record, does some processing (this will take
some time), and adds some extra data to the server based on the
processing. [snip]
However, if a client disconnects (which, because of the
Anyway, maybe I spoke too soon :-(.
ERROR: operator is not unique: integer || unknown
I did, of course, not follow the instructions and just blinding
applied them all, but from reading them it doesn't look like the issue
here. Does this error mean there are too many operators or
Hello
Stefan Sturm wrote:
Hello,
is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000
Maschine without Admin Rights?
Yes, but you cannot use the MSI installer, and you cannot install it
as a service (for auto-start). You can download the binaries-no-
installer and run the initdb
Stefan Sturm wrote:
Hello,
i copied the dll files to the system32 directory.
That's really NOT a good idea.
Win2k and up look in the executable directory for required DLLs. You
should never need to modify the system directories, and it's a really
bad idea to do so.
See:
Hello,
i copied the dll files to the system32 directory. But now I get
another error:
The Programm could not be initialized( 0xcc022 )
Any Hints?
Stefan Sturm
Stefan Sturm wrote:
Hello,
is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000
Maschine without Admin Rights?
On 2008-03-25 09:51, sathiya psql wrote:
Table size is nearly 700 MB,
and my machine had a 1 GB + 256 MB RAM, i had created the table space in
RAM, and then created this table in this RAM.
So now everything is in RAM, if i do a count(*) on this table it returns
327600 in 3 seconds, why
Hello,
If you can do that, you obviously have admin rights, so why not just
use the MSI installer?
When I try to run the Intaller, I get this Message: The
Systemadminitrator guidelines issued in order to prevent this
installation.
That said, this often happens if you have an incorrect
Hello,
I know that :-)It was just a try...
Greetings,
Stefan Sturm
Am 25.03.2008 um 11:28 schrieb Craig Ringer:
Stefan Sturm wrote:
Hello,
i copied the dll files to the system32 directory.
That's really NOT a good idea.
Win2k and up look in the executable directory for required DLLs.
If you can do that, you obviously have admin rights, so why not just use
the MSI installer?
That said, this often happens if you have an incorrect version of the
MSVC runtime on your system. See the README file in the download directory.
//Magnus
Stefan Sturm wrote:
Hello,
i copied the
Stefan Sturm wrote:
Hello,
If you can do that, you obviously have admin rights, so why not just
use the MSI installer?
When I try to run the Intaller, I get this Message: The
Systemadminitrator guidelines issued in order to prevent this
installation.
Oh. So it's not actually admin
Stefan Sturm wrote:
Hello,
If you can do that, you obviously have admin rights, so why not just
use the MSI installer?
When I try to run the Intaller, I get this Message: The
Systemadminitrator guidelines issued in order to prevent this
installation.
Have you upgraded the Windows
Please stop reposting your questions to multiple groups. Since all your
questions are about performance, please stick to the pgsql-performance
list. Posting to pgsql-sql is not really appropriate, and in
pgsql-admin you're totally off-topic.
--
Alvaro Herrera
ok
On Tue, Mar 25, 2008 at 5:33 PM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Please stop reposting your questions to multiple groups. Since all your
questions are about performance, please stick to the pgsql-performance
list. Posting to pgsql-sql is not really appropriate, and in
Hello Craig and Magnus,
thanks for your Help. I downloaded MSVCR80.DLL, but still the same
problems:
When I simply start init_db from within the bin folder I get the
Message, that he can't find libintl3.dll. The errormessage shows the
PATH, and this path contains the bin Folder...
When
Stefan Sturm wrote:
Hello Craig and Magnus,
thanks for your Help. I downloaded MSVCR80.DLL, but still the same
problems:
When I simply start init_db from within the bin folder I get the
Message, that he can't find libintl3.dll. The errormessage shows the
PATH, and this path contains the
Hi,
i have a 'insert into' statement and i would like to know if it fails or
not.
i was thinking to check the resturn value from this statement, but how to do
it ?
thx.
--
Alain
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C#
Alain Roger wrote:
Hi,
i have a 'insert into' statement and i would like to know if it fails or
not.
i was thinking to check the resturn value from this statement, but how to do
it ?
The answer depends entirely on how you're using the database.
ODBC?
JDBC?
Perl DBD?
Python with
Dropping the slony list.
On Mar 18, 2008, at 5:32 AM, Glyn Astill wrote:
We're setting up 3 servers replicating using slony. I was wondering
if it'd be possible for me to create a set of triggers that fire
whenever a user is created/dropped/modified on one of the servers
that goes and
On Mar 18, 2008, at 7:17 AM, Joris Dobbelsteen wrote:
Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
are very usefull but it would be great to have such a feature on the
mid-level too. I mean something CREATE SCHEMA LIKE that would copy
all
the template schema relations,
Decibel! wrote:
Dropping the slony list.
On Mar 18, 2008, at 5:32 AM, Glyn Astill wrote:
We're setting up 3 servers replicating using slony. I was wondering
if it'd be possible for me to create a set of triggers that fire
whenever a user is created/dropped/modified on one of the
I have some users that need select any table but they should not be
superusers. How can this be done?
I need a grant select on dbname to rolename.
Jon
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Roberts, Jon wrote:
I need a grant select on dbname to rolename.
This is a FAQ, though it doesn't actually seem to be in the PostgreSQL FAQ.
A Google search, either of the mailing list archives or of the web in
general, for:
postgresql grant all tables
should prove informative.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Mar 2008 09:54:20 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
I have some users that need select any table but they should not be
superusers. How can this be done?
I need a grant select on dbname to rolename.
You can't do it with
Anton Melser [EMAIL PROTECTED] writes:
Too many. You might have to remove the anynonarray || text and
text || anynonarray operators if you're going to continue to rely
on implicit casts to text.
Thanks for that. Any chance someone could give me more newbie instructions?
You'd have to do
On Tue, 25 Mar 2008 09:54:20 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
I have some users that need select any table but they should not
be
superusers. How can this be done?
I need a grant select on dbname to rolename.
You can't do it with a single command. It is easy enough to
Hello,
I want to sort strings containing a dot but by taking care of this dot
like any other character.
example :
Currently, I get this after the sort :
co.aaa
co.abb
co.cab
com
co.ment
com.enta
But I would like to get this :
co.aaa
co.abb
co.cab
co.ment
com
com.enta
How I can do this?
create table t (name varchar);
insert into t values ('co.aaa');
insert into t values ('co.abb');
insert into t values ('co.cab');
insert into t values ('com');
insert into t values ('co.ment');
insert into t values ('com.enta');
select name from t order by replace(name, '.', '');
Jon
under pl/pgsql language i would like to return a function value.
e.g :
0 is everything is completed
-1 if searched data already exist into table
-2 if insert into failed
...
later i would like to use this returned value in my PHP (this i know how to
do)
is it clearer ?
A.
On Tue, Mar 25, 2008 at
On Tue, 25 Mar 2008 16:38:04 +0100
Alain Roger [EMAIL PROTECTED] wrote:
under pl/pgsql language i would like to return a function value.
e.g :
0 is everything is completed
-1 if searched data already exist into table
-2 if insert into failed
...
later i would like to use this returned
Pierre LEBRECH [EMAIL PROTECTED] writes:
I want to sort strings containing a dot but by taking care of this dot
like any other character.
I suspect what you really want is C locale, and what you've got is
some other locale that uses dictionary sort rules. Try show lc_collate.
Alain Roger wrote:
under pl/pgsql language i would like to return a function value.
e.g :
0 is everything is completed
-1 if searched data already exist into table
-2 if insert into failed
...
Given the table:
CREATE TABLE testtable (
blah VARCHAR,
CONSTRAINT blah_is_unique
Thanks Jon, but it does not give me what I want.
But, this gave me an idea : I replaced the select statement by this one :
select name from t order by replace(name, '.', 'z');
And this time it works. With 'z', I get 'co' before 'com'. If I set an 'a',
then I get the 'com' before 'co'. Cool!
Hello,
I am running postgresql 8.2.5 on Solaris 10. When I try to shut
down postgres using
pg_ctrl -D datafile stop
it does not shutdown.Does anyone know why this is, or what files
pg_ctrl access to determine
the shutdown process. We have tried deleting a pgsql semaphore file
By the way, I have just inserted a duplicate. Then I have run the select
statement with distinct and I got an error.
select distinct name from t order by replace(name, '.', 'a');
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
How one can solve this?
Note : If I
By the way, I have just inserted a duplicate. Then I have run the
select statement with distinct and I got an error.
How one can solve this?
Does this work?
select distinct name
from ( select name from t order by replace(name, '.', 'a')) as t2
--
Sent via pgsql-general mailing list
Thanks Adam. No, It doesn't.
But I have found a solution which works :
select name from (select distinct name from t) as name order by replace(name,
'.', 'a');
name
--
co.aaa
co.abb
co.cab
co.ment
com
com.enta
(6 lines)
Thanks to all of you.
Adam Rich wrote :
By the way, I
select name from t group by name order by replace(name, '.', 'a');
I personally don't use distinct very often as group by is usually more
flexible and quicker to add aggregates to the query.
Jon
-Original Message-
From: Pierre LEBRECH [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March
On Mar 25, 2008, at 11:49 AM, LARC/J.L.Shipman/jshipman wrote:
Hello,
I am running postgresql 8.2.5 on Solaris 10. When I try to shut
down postgres using
pg_ctrl -D datafile stop
it does not shutdown.Does anyone know why this is, or what files
pg_ctrl access to determine
the
LARC/J.L.Shipman/jshipman napsal(a):
Hello,
I am running postgresql 8.2.5 on Solaris 10. When I try to shut
down postgres using
pg_ctrl -D datafile stop
it does not shutdown.Does anyone know why this is, or what files
pg_ctrl access to determine
the shutdown process. We have tried
You'd have to do something like
DELETE FROM pg_operator WHERE oprcode = 'anytextcat'::regproc;
since there isn't any higher-level command that will let you delete a
built-in operator.
I recommend practicing on a scratch database ;-)
Thanks for the tip, though alas that didn't
Anton Melser [EMAIL PROTECTED] writes:
You'd have to do something like
DELETE FROM pg_operator WHERE oprcode = 'anytextcat'::regproc;
since there isn't any higher-level command that will let you delete a
built-in operator.
I recommend practicing on a scratch database ;-)
Thanks for the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Mar 2008 10:16:19 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
On Tue, 25 Mar 2008 09:54:20 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
I have some users that need select any table but they should not
be
superusers. How can
On 25/03/2008, Tom Lane [EMAIL PROTECTED] wrote:
Anton Melser [EMAIL PROTECTED] writes:
You'd have to do something like
DELETE FROM pg_operator WHERE oprcode = 'anytextcat'::regproc;
since there isn't any higher-level command that will let you delete a
built-in operator.
I
Pierre LEBRECH wrote:
But I have found a solution which works :
select name from (select distinct name from t) as name order by replace(name,
'.', 'a');
Shouldn't you replace '.' with a character whose collating sequence is strictly
less than
'a'? This solution looks to me as though it
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
clusters, except that they are not aware of each other? Does this mean
that if I were to create copies of postgresql.exe beforehand and somehow
split traffic to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Mar 2008 14:16:37 -0400
Bill Wordsworth [EMAIL PROTECTED] wrote:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's
RAC clusters, except that they are
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
clusters, except that they are not aware of each other?
No, absolutely not. Each client request is handled by a
On Tue, 25 Mar 2008 09:54:20 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
I have some users that need select any table but they should
not
be
superusers. How can this be done?
I need a grant select on dbname to rolename.
You can't do it with a single command. It is
Thanks to everyone who's helped me before.
I'm trying to create the following mysql table in postgres:
CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP);
Thus far, I've
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Mar 2008 13:37:37 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
O.k. :) but that doesn't change my response. You can't do it with a
single command. You can script it.
It would be a nice enhancement to have a select any table
Edward Blake escribió:
Thanks to everyone who's helped me before.
I'm trying to create the following mysql table in postgres:
CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
On Tue, Mar 25, 2008 at 02:51:05PM -0400, Edward Blake wrote:
CREATE RULE timestamp_update AS ON UPDATE TO visit
Do this with a trigger instead of a rule. I think there's an example in the
docs of something very similar, but I haven't checked just now.
A
--
Sent via pgsql-general mailing
On 25/03/2008 14:54, Roberts, Jon wrote:
I have some users that need select any table but they should not be
superusers. How can this be done?
I need a grant select on dbname to rolename.
PgAdmin (www.pgadmin.org) has a handy Grant Wizard which will do this
for you in one go.
Ray.
You're looking for a trigger, not a rule.
On Tue, 25 Mar 2008, Edward Blake wrote:
Thanks to everyone who's helped me before.
I'm trying to create the following mysql table in postgres:
CREATE TABLE visit (
data1 varchar(30) NOT NULL,
data2 varchar(30) DEFAULT NULL,
data3
snip
| I've tried multiple iterations of how to accomplish this and keep getting
stuck. With the one above, postgres yells and says:
| ERROR: infinite recursion detected in rules for relation visit
|
| Any ideas?
/snip
Look at http://www.postgresql.org/docs/8.3/interactive/plpgsql-trigger.html
Our organization is looking for a hot-standby option for PostgreSQL that
uses the WAL (transaction) data to keep the standby current and also allows
the standby to be read-only accessible for reporting. We have implemented
WAL shipping through a set of scripts we developed and that works well to
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
clusters, except that they are not
Keaton Adams wrote:
Our organization is looking for a hot-standby option for PostgreSQL that
uses the WAL (transaction) data to keep the standby current and also allows
the standby to be read-only accessible for reporting. We have implemented
WAL shipping through a set of scripts we developed
Hi Andrej,
I am running on Linux, Red Hat 3.
I have hard time to use pg_dump command. Can you give me the syntax of
pgdump?
This is the error I got.
[EMAIL PROTECTED] backups]# ls
[EMAIL PROTECTED] backups]# pg_dumpall dbfile
pg_dumpall: could not connect to database template1: FATAL: role
Bill Wordsworth escribió:
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't
On Tue, Mar 25, 2008 at 1:17 PM, salman [EMAIL PROTECTED] wrote:
IIRC, it was mentioned previously in one posting that this a TODO for a
future version of postgres but not something that's expected soon.
Someone please correct me if I'm wrong.
This is what I saw on the TODO list:
Write-Ahead
But will that stand-by replication provide for a read-only slave?
On 3/25/08 2:26 PM, Richard Broersma [EMAIL PROTECTED] wrote:
On Tue, Mar 25, 2008 at 1:17 PM, salman [EMAIL PROTECTED] wrote:
IIRC, it was mentioned previously in one posting that this a TODO for a
future version of postgres
On Tue, 2008-03-25 at 14:11 -0600, Keaton Adams wrote:
“All queries reading from the physical replica execute in real-time,
and return current results. A Data Guard configuration consists of
one production (or primary) database and up to nine standby
databases. A standby database is
It is close, but has limitations that will be problematic for our
environment, such as:
Replicator will not replicate the schema. You must restore your schema to th
e slaves from the master before you begin replication.
Replicator can only replicate one database. If you have multiple databases
On 26/03/2008, Tri Quach [EMAIL PROTECTED] wrote:
Hi Andrej,
Hi Tri!
I am running on Linux, Red Hat 3.
I have hard time to use pg_dump command. Can you give me the syntax of
pgdump?
Not a syntax-problem; to use pg_dumpall you need to be
the postgres (superuser).
su - postgres
pg_dumpall
Bill Wordsworth wrote on 25.03.2008 21:04:
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's
Was there something wrong with the tzdata distributed in 8.2.7?
current_timestamp is still using EST, but the date command run from the
command line is correctly returning EDT
[local]:owl=# select version(), current_timestamp;
version
I'm just curious how would having the ability to grant privileges to a
schema be a foot gun?
On Tue, Mar 25, 2008 at 2:54 PM, Joshua D. Drake [EMAIL PROTECTED]
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Mar 2008 13:37:37 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
On Tue, 2008-03-25 at 14:11 -0600, Keaton Adams wrote:
“Oracle Active Data Guard enables a physical standby database to be
open for read-only access – for reporting, simple or complex queries –
while changes from the production database are being applied to it.
This means any operation that
On Tue, Mar 25, 2008 at 3:08 PM, Simon Riggs [EMAIL PROTECTED] wrote:
On Tue, 2008-03-25 at 14:11 -0600, Keaton Adams wrote:
Some funding would help that move forwards. If you or others would
consider that, it would help, even if just to provide the seed for
additional contributors.
That is
Hello, I was about to start on Forms Authentication with Postgres in .NET on
Mono.
I found this message from Kevin:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg23395.html
but didn't find any responses.
I was wondering whether anyone got this working, and has any documentation
that can help.
On Tue, Mar 25, 2008 at 1:11 PM, Keaton Adams [EMAIL PROTECTED] wrote:
Our organization is looking for a hot-standby option for PostgreSQL that
uses the WAL (transaction) data to keep the standby current and also allows
the standby to be read-only accessible for reporting. We have implemented
Joseph S [EMAIL PROTECTED] writes:
Was there something wrong with the tzdata distributed in 8.2.7?
current_timestamp is still using EST, but the date command run from the
command line is correctly returning EDT
Works for me ... what have you got TimeZone set to?
That is an interesting question. If our organization were to help fund the
development of such a feature, would that be something taken into
consideration by the development team?
-Keaton
On 3/25/08 4:32 PM, Richard Broersma [EMAIL PROTECTED] wrote:
On Tue, Mar 25, 2008 at 3:08 PM, Simon
Bill Wordsworth wrote:
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Bill Wordsworth wrote on 25.03.2008 19:16:
When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
clusters,
Similar case has been already happened.
For example, I have propsed to implement WITH RECURSIVE clause and the
work is supported by Sumitomo Electric Information Systems Co.,
Ltd. (http://www.sei-info.co.jp/) and SRA OSS, Inc. Japan
(http://www.sraoss.co.jp).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
paul rivers-2 wrote:
chuckee wrote:
1) how do I find out the size, in MB, of a particular table (called
'capture' in this case).
I tried entering the SQL query SELECT (pg_tablespace_size('capture'));
The result was the following:
ERROR: tablespace capture does not exist
You're
Hi,
I'm fairly new to DBMS's and PostGre SQL in particular. Most of
my experience is with MS Access. I've created MS Access to retrieve
data from PostGre by linking tables and have done so without error.
However, I am now in need of being able to update a PostGre table. The
source will
Hi,
How to use a database I have just created in a script that I am
executing in Pgadmin3 on Windows?
I can not use USE Northwind; or \connect Northwind;?
Cheers,
Anton
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 25/03/2008, Anton Andreev [EMAIL PROTECTED] wrote:
Hi,
Hi,
How to use a database I have just created in a script that I am
executing in Pgadmin3 on Windows?
I can not use USE Northwind; or \connect Northwind;?
Hard to say w/o knowing the script. Does it just create tables,
or does it
Barry,
Per the COPY documentation:
*COPY moves data between PostgreSQL tables and standard file-system files. COPY
TO copies the contents of a table to a file, while COPY FROM copies data
from a file to a table (appending the data to whatever is in the table
already). *
...So it's not
On Mon, Mar 24, 2008 at 07:08:13AM -0600, Pettis, Barry wrote:
I'm fairly new to DBMS's and PostGre SQL in particular. Most of
my experience is with MS Access. I've created MS Access to retrieve
data from PostGre by linking tables and have done so without error.
If you've linked the
___
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pettis, Barry
Sent: Monday, March 24, 2008 6:08 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Make MS Access UPDATE PostGre SQL Table
Note:
Generally, it is best to post in plain text,
chuckee wrote:
paul rivers-2 wrote:
chuckee wrote:
1) how do I find out the size, in MB, of a particular table (called
'capture' in this case).
I tried entering the SQL query SELECT (pg_tablespace_size('capture'));
The result was the following:
ERROR: tablespace capture does not exist
On 25/03/2008, chuckee [EMAIL PROTECTED] wrote:
Thanks but I still get the error 'ERROR: relation capture does not exist'
when trying these two alternative functions you mention above. There is
definitely a table called 'capture' in my database!
Are you sure you're connected to the right
Andrej Ricnik-Bay [EMAIL PROTECTED] writes:
On 25/03/2008, chuckee [EMAIL PROTECTED] wrote:
Thanks but I still get the error 'ERROR: relation capture does not exist'
when trying these two alternative functions you mention above. There is
definitely a table called 'capture' in my database!
On Mon, Mar 24, 2008 at 10:14 PM, J Ottery [EMAIL PROTECTED] wrote:
I am using a grid component (delphi) connected via Postgres ODBC , and
via Datasource - ADOTable - ADOConnection to a postgres database.
All works well.
Tried using the PostgreSQL Native Provider, built a working
Pettis, Barry wrote:
Hi,
I'm fairly new to DBMS's and PostGre SQL in particular. Most
of my experience is with MS Access. I've created MS Access to
retrieve data from PostGre by linking tables and have done so without
error. However, I am now in need of being able to update a
Anton Andreev wrote:
Hi,
How to use a database I have just created in a script that I am
executing in Pgadmin3 on Windows?
If you are in pgAdmin then you don't need the connect command. When you
select the db from the side list it connects you and lists the contents
of the db.
From the
I'm in the same boat, looking for master-slave replication for 1 master 2
'standby' read-only servers (one would get promoted to master in case of
failure).
I recently read about WAL here:
http://developer.postgresql.org/pgdocs/postgres/warm-standby.html
The standby server is not available for
Pettis, Barry wrote:
However, I am now in need of being able to update a PostGre table. The
source will be a .csv file.
I've seen a COPY command in PostGre that will allow you to
specify a .csv file as the source, but in looking at it it appears that
I'm using Access as
On Tue, 25 Mar 2008, Jonathan Bond-Caron wrote:
I know very little about postgreSQL internals but it would be great if:
- WAL files could be applied while the standby server is operational / allow
read-only queries
This is the part that requires modifying PostgreSQL, and that progress was
96 matches
Mail list logo