Neil Conway <[EMAIL PROTECTED]> writes:
> I don't know of an easy workaround. Why do you need numeric usernames?
There's always double-quoted identifiers:
create user "12345" with password ...
Considering that the SQL standard defines
as an , I'm not sure why Ed is expecting that he shou
On Tue, 12 Oct 2004, Ed Stoner wrote:
> I am unable to use the "CREATE USER" command with numeric user names
> (i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
> a problem somewhere with how I have things configured? Is there are
> workaround?
I believe you can create a
Ah, yes. You're right.
Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.
-tfo
On Oct 18, 2004, at 6:02 PM, Josh Close wrote:
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
<[EMAIL PROTECTED]> w
Google "slony"
Regards,
aaron.glenn
On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao
<[EMAIL PROTECTED]> wrote:
>
>
>
> Hi,
>
> We would like use Postgresql as our database. For high availability is it
> possible to cluster DB in Postgresql. Appreciate if you can let me know how
> this c
John Ossmann wrote:
I'm not sure where to find it exactly, but does anyone know how much
data a column of type "text" in a postgres DB can hold?
it's in the manual, in the Data Types section. the manual says "around 1GB".
btw, TEXT is one of those postgres-specific features that makes you
stick (s
On Wed, 2004-10-13 at 14:58, John Ossmann wrote:
> I'm not sure where to find it exactly, but does anyone know how much
> data a column of type "text" in a postgres DB can hold?
There is no limit on what "text" itself can contain. However, a field of
any data type can contain at most 1GB (compress
On Wed, 2004-10-13 at 06:31, Ed Stoner wrote:
> I am unable to use the "CREATE USER" command with numeric user names
> (i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
> a problem somewhere with how I have things configured? Is there are
> workaround?
A username is an i
I'm not sure where to find it exactly, but does anyone know how much
data a column of type "text" in a postgres DB can hold?
Thanks
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister Y
Hi,
It seems to me that
a bug was introduced in 8.0 version.
(I was previously
using 7.2.3 so I don't really know in which version the comportment
changed...).
I'm using Beta2 version on WIN32 platform.
hello, everyone
I know PgSQL dev team has no windows installer for the 8.0 version
except for the project in pgfoundry. I don't know how pgfoundry do it,
but I strongly sugguest the PgSQL team consider of using NSIS as the
installer tool. NSIS is an open source installer maker for windows, many
op
Thanks Martijn:
It worked. I was having issues with 7.4.2, run memory ans disk checks
and hardware seems ok, that's why I decided to upgrade to 7.4.5, but
unfortunately I'm still experiencing data corruption.
Ruben.
ruben20 wrote:
-- Forwarded Message ---
From: Martijn van Ooste
I'm a first-time user with PostgreSQL so please forgive my ignorance.
I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL
Essential Reference (New Riders). So far, so good. I think learning
PostgreSQL will not be as difficult as I thought it would be. I've also
been goog
Magnus, et al.,
This is, what initdb -d says:
D:\tmp\data>initdb -d
Running in debug mode.
VERSION=8.0.0beta3
PGDATA=d:/tmp/data
share_path=c:/msys/1.0/share/postgresql
PGPATH=c:/msys/1.0/bin
POSTGRES_SUPERUSERNAME=postgresql
POSTGRES_BKI=c:/msys/1.0/share/postgresql/postgres.bki
POSTGRES_DESCR
I am unable to use the "CREATE USER" command with numeric user names
(i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
a problem somewhere with how I have things configured? Is there are
workaround?
Any help would be greatly appreciated.
--
Ed
At 07:53 p.m. 11/10/2004, Marc G. Fournier wrote:
[snip]
As a result, for those using anoncvs, you will now be required to
re-checkout your source tree, as the paths stored by CVS in CVS/Root
throughout your tree will be wrong.
This was discussed beforehand on -hackers, but it appears that sever
Hello,
I'm using postgreSQL 8.0 beta1 and JDK 1.4.
I have following problem:
I have create test table that contains only unique column :
CREATE TABLE UNIQUE_COLUMN_TEST (
TEST_ID INTEGER,
CONSTRAINT TEST_ID_UQ UNIQUE (TEST_ID)
)
Within one transaction I have insert a few records int
Hi,
We would like use Postgresql as
our database. For high availability is it possible to cluster DB in Postgresql.
Appreciate if you can let me know how this can be achieved.
Else is there any other way to achieve High Availability
in POstgresql as this is mission critical system.
T
Michael Hannon wrote:
Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat
Enterprise server, version 3.0). We find ourselves in an awkward
position: we have a database of attributes relating to students that
uses as its primary key the ID number of the student. This is awkward
Hello.
For a project we are planning cost management. Each "user" should pay
for the cost he/she generates on the postgresql server.
The idea is that a query should be charged by the ammount of CPU time
used and/or the ammount of data read from disk.
The acctual time (in milliseconds) it took to
hi,Gaetano Mendola:
you wrote:
> Ann wrote:> I found the reason of this question and fixed the bug :))>
> Why then don't you share it ?
em ,because i make a stupid mistake in programming!! :((
I made use of transactions to ensure database consistency, and then, i called PQexec(
Please forgive me if I'm posting to the wrong mailing list. I am working
with Windows XP and the beta2-dev3 version of PostgreSQL. The issue I am
having is under a login name that has administrative rights to the machine
the program is running on (a program I wrote), database access is allowed
and
I try to detect potential memory management bugs of my program with valgrind.PostgreSQL is at version 8.0 beta2. Operating System is Red Hat Enterprise Linux 3.Valgrind is at version 2.2.0.
After Program terminated, Valgrind reports a memory lost error information as follows:
==13524== 208 bytes
Hmm..other open source projects that run on Windows servers... apache,
mysql, php, python, perl, etc etc etc... Porting it to Windows is a
great thing.. the more that open source gets its way into the use of all
markets, the more acceptable it becomes in the mainstream..and the less
control compan
On Mon, 2004-10-18 at 17:38 -0400, Eric wrote:
> The worst
> thing never made was porting an excellent product like PostgreSQL to a
> poor server OS like windows.
Isn't the purpose to promote PostgreSQL? not *nix-only flavors?
Hmm..other open source projects that run on Windows servers... apache,
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
<[EMAIL PROTECTED]> wrote:
> Are you looking for something different than vacuumdb?
>
> http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
>
> -tfo
I think so. As far as I can tell, you can either vacuum a whole db, or
individual t
On Monday October 18 2004 2:39, Jan Wieck wrote:
> On 10/18/2004 12:49 AM, Ed L. wrote:
> > I *think* I'm seeing "vacuum analyze" queries launched automatically on
> > an 8.0.0beta3 (unless I have a rogue autovac running that I haven't
> > spotted). Is this something new in 8.0 and to be expected?
"Roberts, Adam" <[EMAIL PROTECTED]> writes:
> The following is a link to the last post we had with this same problem:
> http://openacs.org/forums/message-view?message_id=185837
Given the comment about 500M pg_clog, I would venture that you aren't
doing adequate vacuuming and have therefore run int
Eric wrote:
It is possible to mainteners of this list to keep this list from
"/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Now, we are invade with users that aren't used to rea
It is possible to mainteners of this list to keep this list from
"/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Now, we are invade with users that aren't used to read the manua
We thought that this might be an AOLserver problem, however, through our
investigation and comments from posts to the OpenACS board, we believe
this is an error with PostgresSQL.
We are hoping that someone might have some ideas or any experience with
this. Thanks!!
Are you vacuuming? How of
On 10/18/2004 12:49 AM, Ed L. wrote:
I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
Are you running Slony by any chance?
Jan
--
#===
Are you looking for something different than vacuumdb?
http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
-tfo
On Oct 18, 2004, at 3:23 PM, Josh Close wrote:
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?
-Josh
---(end of
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?
-Josh
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Some time ago (May 2004), we were making changes to a Postgresql server
to allow a host to connect (pg_hba.conf). When we restarted the server,
and restarted the AOLserver process, there was only one table left. All
the ACS tables were gone.
As we were troubleshooting the problem, we found the la
On 10/15/2004 4:20 AM, Mark Gibson wrote:
Andrew Sullivan wrote:
On Wed, Oct 06, 2004 at 05:25:58PM +0100, Mark Gibson wrote:
I had to remove Slony's schema manually as I was having problems
with it. I was in the process of removing all Slony related stuff,
and all my slave tables when this problem
[EMAIL PROTECTED] ("Lada 'Ray' Lostak") writes:
> Imagine some online system, based on PgSql. There are 'many' parts which
> depends on each other. I will give small example, but instead of simple
> table imagine changing tenths various tables (editing). So, 'change table A'
> can be work for h
BiggerSQL is an advanced Cocoa based Postgresql Browser/Editor
for Mac OSX users.
BiggerSQL lives at http://homepage.mac.com/levanj/Cocoa
BiggerSQL is capable of displaying images, playing mp3s, displaying
movies and flash content. ie BiggerSQL is multimedia aware.
From this versions release notes:
Yes saying that PostgreSQL does not have any hot backup option ... testing a
RH-7.3 version in august 2004 when we are in v7.4.5 ... :o(
And it's one of the main computer science management newspaper in
France ... :o(
Le Lundi 18 Octobre 2004 18:58, Masse Jacques a écrit :
> in spite of the eff
On Thu, Oct 14, 2004 at 08:58:32PM +0200, [EMAIL PROTECTED] wrote:
> Hello
>
> Does PostgreSQL provide anything comparable with the functionality of
> MySQL Cluster?
>
> I appreciate all information.
No, in two ways:
1. There is not currently any in-transaction cross-machine
replication sy
in spite of the efforts of the french mailing list, an paper with some
"grossieres" erreurs...I apolgize
http://www.01net.com/article/253508.html
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.p
I used to do it this way :
Suppose you have a web form to edit data from a table... you add a field
in your table which contains a version identifier for that data, then you
UPDATE ... WHERE ... AND version_id = the old version id. The version_id
is passed around in a session variable or
Is a dump and reload required when going from beta1 to beta3?
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello there,
I am thinking how to solve another typical problem of online systems
with combination of thin client... Imagine simple case, 2 users are going to
edit 'same' datas. Both see on the 'screen' the same, after they started
edit them. First one changes datas and submit changes (sucessf
Hello ppl,
Imagine some online system, based on PgSql. There are 'many' parts which
depends on each other. I will give small example, but instead of simple
table imagine changing tenths various tables (editing). So, 'change table A'
can be work for hours.
There are tables tableA and table
On Sun, Oct 17, 2004 at 03:30:32 -0400,
Mike Mascari <[EMAIL PROTECTED]> wrote:
>
> I'm thinking that the WHERE clauses condition should read:
>
> WHERE l1.p_pkey is not null OR l2.p_key is not null;
That seems to make more sense. I was puzzling about that condition myself.
If both keys where
In the last exciting episode, [EMAIL PROTECTED] ("Ed L.") wrote:
> I *think* I'm seeing "vacuum analyze" queries launched automatically on an
> 8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
> Is this something new in 8.0 and to be expected?
>
> My settings:
>
> #vacu
Hello
I know it is possible to time isolated queries through the settting of the
\timing option in psql. This makes PgSQL report the time it took to
perform one operation.
I would like to know how one can get a time summary of many operations, if
it is at all possible.
Thank you.
Tim
On Oct 18, 2004, at 1:09 AM, Joel wrote:
There is no need to give either the postgres user or root a password,
much less a shell or a login directory, if you use sudo.
(And I have no idea why Apple would suggest using the system
preferences
user pane to add the postgres user unless they are intent
48 matches
Mail list logo
