Steve,
I'm not as much of an expert on PostgreSQL as others, but at least I
have SOME answer.
The way to leverage the multi-disk capability is to use RAID, either
software or hardware, rather than trying to twist the PostgreSQL
structure and files to do so.
RAID (I forget what the acronym stan
Eduardo,
your problem is the way you are submitting the string. Since it's a
binary, it can contain any "character" value (from 0 to 255) and
PostgreSQL treats certain characters as special characters. The main
example you're running into is the quote character.
If you try to submit a string
If you specify an object's name without quoting it, e.g.:
ALTER TABLE MyTable ADD COLUMN MyNewCol INT4;
then it is read as all lower case. This means, that table "mytable"
will be altered, and the new column will be called "mynewcol".
To force mixed or upper case, you quote the names, e.g.:
Jeff,
you need to look under "\?" (psql commands), not "\h" (SQL commands).
Anyway, what you need is:
\c[onnect] [DBNAME|- [USER]]
connect to new database (currently "[...]")
Jeff Stout wrote:
I am fairly new to postgres, I need to know how to switch
databases once I'm in a psql se
http://www.fabforce.net/downloads.php
Jaime Casanova wrote:
Hello,
Db-designer is a nice tool, can work with importing Oracle databases,
and use it with PG and >MySQL.
Hope this helps
BR,
Miguel
Can someone suggest an E-R tool that will read a _PG_ database and
create an E-R diagram - crows feet
I would recommend one on the default port (5432). I have also
used, without problems (on RedHat 7.3) ports 5434, 5435, 5436, 5437,
15437.
What I would do (more experienced people, pls. correct me) is to check
your /etc/services file to see what ports are used for what (e.g.:
...
cfeng
Can anyone recommend an editor (windows OR linux) for writing plpgsql
code, that might be friendlier than a standard text editor?
Nice features I can think of might be:
- smart tabbing (1 tab = N spaces)
- code coloring (esp. quoted strings!)
- parens/brackets matching
Thanks,
Andrew
scott.marlowe wrote:
On Tue, 30 Mar 2004, Andrew Biagioni wrote:
Alex,
the answer is "no" to all of these. We are a tiny start-up (2 guys, and
we do our own cleaning); ambient temperature varies significantly but
is not related to the failure, and one machine starts beeping whe
sion/configuration (second machine); now we're out of
things to blame, except maybe unusually bad luck...
Thanks,
Andrew
Alex Satrapa wrote:
Andrew Biagioni wrote:
On three different machines running the same PostgreSQL version
(7.3.5) on Linux and almost identical databases,
Tom Lane wrote:
Andrew Biagioni <[EMAIL PROTECTED]> writes:
On three different machines running the same PostgreSQL version (7.3.5)
on Linux and almost identical databases, I have been plagued by
occasional, unexplainable (to me) reboots of the computer.
Postgres can *not* cause a
he
/usr/local/pgsql/ partition.
Thanks for any and all help!
Andrew Biagioni
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Iain wrote:
Yes, you are right but it wasn't the case this time, I have run the
explain plenty of
times with same results. I think that the reason was that I made a simple
VACUUM,
after a VACUUM FULL ANALYZE (1h!!) things are ok
I
In the v7.3 docs:
http://www.postgresql.org/docs/7.3/interactive/transaction-iso.html#XACT-READ-COMMITTED
Read Committed is the default isolation level
in PostgreSQL. When a transaction
runs on this isolation level, a SELECT
query sees only data committed before the query began; it never sees
Chris,
Thanks -- your answer is 90% of
what I need! As for the other 10%:
Chris wrote:
Our database ( (PostgreSQL) 7.3.5 ) uses Unicode encoding:
[...]
For some reason, If I try to use an extended character (ASCII code >
127) in a string, I get this peculiar res
Kent,
I suggest you read:
http://www.postgresql.org/docs/7.3/interactive/plpgsql-trigger.html
I found it very useful myself, and it should answer (almost?) all your
questions.
Note that you will need to add either pl/pgsql or pl/TCL to your
database to do triggers.
The docs. for both langu
Our database ( (PostgreSQL) 7.3.5
) uses Unicode encoding:
egreek=# \l
List of databases
Name | Owner |
Encoding
-+--+--
egreek | andrew |
UNICODE
For some reason, If I try to use
an extended character (ASCII code >
know enough to appreciate?
Inquiring minds want to know...
Thanks,
Andrew Biagioni
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ion between int4 and int8.
So finally, my question. Why is this behavior present? Is it actually a
feature that I don't know enough to appreciate?
Inquiring minds want to know...
Thanks,
Andrew Biagioni
---(end of broadcast)-
bases. You can get some primitive (but
>quite functional) cross database action with the contrib/dblink package.
>
>On Thu, 11 Sep 2003, Andrew Biagioni wrote:
>
>> I am thinking of separating my data into various DBs (maybe on the same
server,
>> probably not) -- mostly
I am thinking of separating my data into various DBs (maybe on the same server,
probably not) -- mostly for performance/stability/backup reasons -- but I have
a considerable amount of foreign keys, views, and queries that would need to
work across DBs if I were to split things the way I want to.
Yudha,
"ERROR: Query was cancelled." usually means that the query is taking too long,
and you exceeded the maximum time specified in your postgresql.conf file.
The parameter you want to change is:
statement_timeout = X
where X is in seconds; set X = 0 to turn off the timeout completely (quer
7/22/03 3:32:03 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
>On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote:
>> I am having a hard time selecting a Replication/Failover/HA solution for
>> PGSQL. What is troubling is the number of solutions available in various
>> states of deve
7/18/03 10:06:29 AM, "scott.marlowe" <[EMAIL PROTECTED]> wrote:
>On Thu, 17 Jul 2003, mlaks wrote:
>
>> Hi,
>>
>> I have about 15 different PC's running RedHat 7.3 Linux, each running the
>> same database backed application (I use Postgresql 7.2.1 for the database)
>> on each machine.
>
>Upg
unt it a vote in favor.
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Andrew Biagioni
Monica,
Come ha suggerito Gaetano Mendola, per quanto ho visto tutti gli utenti di
questa lista comunicano in inglese; e sicuramente, la maggior parte di quelli
che hanno le risposte sembrano non avere nomi italiani.
Se hai gia` trovato la risposta al tuo problema, benissimo.
Se no: se il
I recommend you look at chapter 5, "Data Types", of the PostgreSQL
User's Guide.
[EMAIL PROTECTED] wrote:
Hello ALL.
Where can I find (and set if need) all defined max length restrictions of PostgreSQL
server.
for example,
max lenght of VARCHAR,
or any variable-length array,
or max query len
You are not transparent, although you do seem to be somewhat sensitive.
I saw at least one posting from you that was answered by 2 different people.
If you got no answers to your questions, it may be that:
- nobody who knew the answer saw your posting (there are lots of
postings, and not many p
All the docs. are in:
http://www.postgresql.org/docs/
If you select "Interactive Documentation" you can do searches
(recommended for your specific question), otherwise you can go to
"Static Documentation" and look up the syntactic details of "SELECT".
Andrés Repossi wrote:
Hi,
I'm trying to
I didn't see a response to your question yet, so I'll throw in my 2
cents.
I had similar questions as yours; I found my answers in section 3.5 of
the Administrator's Guide (I looked at v.7.2.x, but it's also in
v7.3.1). They are all available at
http://www.us.postgresql.org/users-l
One of the options you can specify in postgresql.conf, is to write to log the
amount of time of each query. That should give you the precision you need,
although of course you need to look at a log file and not at a DB table...
If you try this approach, I recommend you specify printing out the
Be careful with your pg_hba.conf entries (read the comments in the file itself,
they are lengthy but useful). What you configured (below) will allow anyone
to connect to your database from any machine without validation, as long
as their IP address has the first two blocks equal to your machin
First of all your "su postgres" problem. You will note, that the first time
you executed "su postgres" you were root (and thus didn't need a password), the
second time you were a non-root user, zf2linux, and thus you DO need a
password.
The second problem is who postgreSQL thinks you are. Wha
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
As far as I can tell (yes, I tested thoroughly) if I create a normal
deadlock situation as follows,
Stephan Szabo wrote:
On Mon, 13 Jan 2003, Andrew Biagioni wrote:
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
It appears to me that the Deadlock Checker doesn't see (and thus
release) foreign-key-based locks (see below for details). Am I missing
something? Is there a configuration item I am unaware of?
As far as I can tell (yes, I tested thoroughly) if I create a normal
deadlock situation as follows, th
35 matches
Mail list logo
