I found some other things:
- why database encoding for new DB check 'createdb' script and not
CREATE DATABASE statement? (means client only encodings, like BIG5)?
Bug?
- ODBC -- here is some multibyte stuff too. Why ODBC code don't use
pg_wchar.h where is all defined? In
Grant [EMAIL PROTECTED] writes:
Possibly create a timeout for psql. pg_dump, pg_restore and other clients.
If they can not connect to a certain host within a certain period it will
quit with an error. I have psql's still running for 6 days from crontab
that could not connect to a bogus IP
I am pretty new to PostgreSQL so please bare with me :-)
When issuing the CREATEDB MyDb then creating some tables with CREATE
TABLE, I then go back and do a search for the file I have just created
(MyDb) but can't find the physical file.
Does one actually exist ??
Pete
We're trying to migrate from Oracle to Postgres and I've been having
problems converting the procedural language stuff. I've looked at the
web documentation and my functions/triggers seem like they should
work. What am I doing wrong? Any help you could give me would be
greatly appreciated. I
I got this cd from GreatBridge that has 7.0.3 on it, so I tried to do a
configure on my AIX 4.2.1.0.06 machine. I have egcs and gnu make installed
from the bull archives.
configure says that xlc is not installed, and gcc(egcs) cant create
executables.
I wrote a simple hello program and it
Transaction id is incremented even in sql queries like
select which does not change the state of database, is it not
unnecesary?.
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Hello, I'm pretty new to PostgreSQL, (I'm a (young) oracle DBA)
We need to work with Oracle (some heavy client of our society want Oracle
for security or maintenance), but we want to work with PostgreSQL too, cause
it's more performant, less administration, ... in few words : It's the
future
But
An interesting method would be to allow users to simply avoid locked
rows:
SELECT * FROM queue FOR UPDATE LIMIT 1 UNLOCKED;
Unlocked, return immediately, whatever could be used as a keyword to
avoid rows that are locked (skipping over them).
For update locks the row of course. Currently for
Tom Lane writes :
Oracle claims to be compliant with that
standard. If they don't accept the standard syntax for outer joins,
then their claim of compliance is faulty. But last I heard, they did.
Well, I can't find it into the documentation, and the postgres syntax does
not work so I think
Tom Lane wrote:
[...]
BTW, I think #ifdef would be a totally unworkable way to attack the
format-string problem. The code clutter of #ifdef'ing everyplace that
presently uses %u would be a nightmare; the impact on
internationalization files would be worse. And don't forget that %llu
would be
De : Tom Lane
Are you sure about that? Postgres supports ISO standard (ISO/IEC 9075,
SQL 1992) outer joins. Oracle claims to be compliant with that
standard. If they don't accept the standard syntax for outer joins,
then their claim of compliance is faulty. But last I heard, they did.
I
Nicolas Verger [EMAIL PROTECTED] writes:
But I have a big problem : PostgreSQL doesn't allow Oracle style outer join,
and Oracle doesn't allow Postgres style ...
Are you sure about that? Postgres supports ISO standard (ISO/IEC 9075,
SQL 1992) outer joins. Oracle claims to be compliant with
I want to make a field in a table contain numbers that increment each
time a record is updated. How would I go about doing this?
Example:
Table1
CustID balance
A12255.32
B20132.20
Table2
CustID transactions
A127
B2033
Every time something is
Hiroshi Inoue writes:
1) Because the current implementaion of LIKE isn't locale-aware,
we should be compatible with it for ever.
I'm not sure I intended to say that. The combination of the following
factors seems important:
a) compatibility is desirable
b) no requests to the contrary
Peter Moscatt [EMAIL PROTECTED] writes:
Thanks Tony... yes that helps explain why I am not seeing what I expected
to see.
Right. If I was developing an application, say with Python and I
needed to transport my created database and make it part of an installation
process (create a
Peter Eisentraut [EMAIL PROTECTED] writes:
I can observe something peculiar:
[7.0.2 works different from current]
Interesting. The psql that I exhibited my test with was in fact 7.0.2
[quick check ... yes, current sources act the same]. So it does seem
there's something Linux-specific here.
Anyone interested in a project that would allow a person to parrallelize
postgres
in like a beowulf or some other cluster? does one already exist?
This could certainly be a huge benefit for the linux world and postgres, as
most clusters are formed to either do AI, or more commonly, databasing.
Peter Moscatt [EMAIL PROTECTED] writes:
I am pretty new to PostgreSQL so please bare with me :-)
When issuing the CREATEDB MyDb then creating some tables with CREATE
TABLE, I then go back and do a search for the file I have just created
(MyDb) but can't find the physical file.
Does
Hi all,
For a few months now I've been thinking about whether or not a guide
('line-by-line') to the Postgres source tree would be of any value.
Such a guide would, most probably, trace an 'ultimate' query (ie,
one which requires the use of all source level functionality) through the
Tom Lane writes:
There is something wrong with your system, not with Postgres. Any
reasonable TCP stack will time out within circa 1 minute if no response.
Example (sss is a machine on my LAN that's not presently up):
$ time psql -h sss
psql: PQconnectPoll() -- connect() failed:
One idea to resolve this, by getting rid of the usesysid column in favour
of the oid column has fallen by the wayside (for some valid reasons), so
the problem remains. I think the simplest fix would be to assign a fixed
usesysid of 1. There still is the possibility of changing that with an
I have recently installed PostgreSQL onto my Linux system. I installed and
set it up under the account name of 'postgres' where I am able to create
and manage databases.
How do I set another account (namely my normal login 'pmoscatt') so that I
can create and manage databases instead of
On 17 Aug 2001 06:58:38 -0700, Joseph Castille [EMAIL PROTECTED] wrote:
I want to make a field in a table contain numbers that increment each
time a record is updated. How would I go about doing this?
Example:
Table1
CustID balance
A12255.32
B20132.20
Hi all. I'm not a good DB admin , thats why I'm posting to this list !
How can I figure out the size of a database or table ???
It was easier in older versions of postgresql to perform a `du -h` on
the directory that corresponded to the database name. However now they
are named by some type of
Thanks Tony... yes that helps explain why I am not seeing what I expected
to see.
Right. If I was developing an application, say with Python and I
needed to transport my created database and make it part of an installation
process (create a tar ball with all needed components), do I just
Projects that are as organized, professional, and value-adding as yours is
can surely stand on their own. I compare this to the recently released
OpenFTS. If we start including projects of this size we'd explode in size
and maintenance overhead.
Doesn't this discussion indicate
I am tempted to replace all attempts to build text data on your own (with
VARDATA, VARHDRSZ, etc.) with proper calls to textin/textout in all places
that can't claim to be truly internal (especially all contrib). The
background is that the internal format might change sometime when
Yes and no :-). The files were created but all postgres data files are now
idententified by numbers (oids I think), so you will not find a file or
directory anywhere in your filesystem named mydb, or mytable.
- Original Message -
From: Peter Moscatt [EMAIL PROTECTED]
To: [EMAIL
Tatsuo Ishii writes:
I wouldn't object it if there is a way to disable locale support.
export LC_ALL=C
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 5: Have you checked our extensive
maruthi maruthi [EMAIL PROTECTED] writes:
Transaction id is incremented even in sql queries like
select which does not change the state of database, is it not
unnecesary?.
No, it's not unnecessary. Every DB operation has to have a transaction
ID; what's more, we have to assign one long
Hi Pete,
Would it be appropriate to do a SQL dump of the created database via
pg_dump, then reload it during the installation vi psql or the COPY
command? If you include the whole data/ subdirectory, you'll also get
the WAL logfiles and everything, which you probably don't need.
Of course,
Hi all,
Just wondering if it'd be worthwhile creating a wrapper script people
can run which would automatically generate/update the
pg_hba.conf/pg_ident.conf files? Just to make it easier for the
end-user.
Called bin/pg_auth or something.
Regards and best wishes,
Justin Clift
--
My
Peter Moscatt [EMAIL PROTECTED] writes:
Right. If I was developing an application, say with Python and I
needed to transport my created database and make it part of an installation
process (create a tar ball with all needed components), do I just include
the /usr/local/pgsql/data
ipcclean(1) currently says:
| ipcclean cleans up shared memory and semaphore space from aborted backends
| by deleting all instances owned by user postgres. Only the DBA should
| execute this program as it can cause bizarre behavior (i.e., crashes) if
| run during multi-user execution. This
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
The text does seem to say that it's okay to add trailing blanks to the
pattern to produce a match, when the collating sequence is PAD SPACE
type (bpchar in our terms).
I can't find that.
The spec says without the appending of
Yes and no :-). The files were created but all postgres data files are now
idententified by numbers (oids I think), so you will not find a file or
directory anywhere in your filesystem named mydb, or mytable.
/contrib/oid2name in 7.1.X does the mapping.
- Original Message -
On Sun, 19 Aug 2001, Tom Lane wrote:
One thing that I find absolutely essential for dealing with any large
project is a full-text indexer (I use Glimpse, but I think there are
others out there). Being able to quickly look at every use of a
particular identifier goes a long way towards
At 11:20 AM 8/19/01 -0700, Vadim Mikheev wrote:
Well, ability to lock only unlocked rows in select for update is useful,
of course. But uniq features of user'locks are:
1. They don't interfere with normal locks hold by session/transaction.
2. Share lock is available.
3. User can lock *and unlock
Would your suggested implementation allow locking on an
arbitrary string?
Well, placing string in LOCKTAG is not good so we could
create auxilary hash table in shmem to keep such strings
and use string' address as part of LOCKTAG. New function
(LockRelationKey?) in lmgr.c would first
Peter's suggestion appears to be a natural step towards the goal of
being able to provide a defined interface that could be used for
extensions. The concern that the _external_ format might change seems
counter to the effort of providing a stable platform for extending
PostgreSQL. If there
Tom Lane writes:
How can A = B not imply A LIKE B?
Well, according to my reading of the spec, it apparently can. Space
padding can be weird that way. But see below why I think there are much
worse alternatives.
4) If the i-th substring specifier of PCV is neither an
Peter Eisentraut wrote:
Hiroshi Inoue writes:
1) Because the current implementaion of LIKE isn't locale-aware,
we should be compatible with it for ever.
I'm not sure I intended to say that. The combination of the following
factors seems important:
a) compatibility is desirable
Peter Eisentraut wrote:
Tatsuo Ishii writes:
I wouldn't object it if there is a way to disable locale support.
export LC_ALL=C
I would object even if there's such a way.
People in Japan have hardly noticed that the strange
behabior is due to the strange locale(LC_COLLATE).
regards,
This is from the jdbc list. Is there any way to get fully qualified
column names?
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Ben Carterette
Sent: August 16, 2001 11:02 AM
To: Rene Pijlman
Cc: [EMAIL PROTECTED]
Subject: Re: [JDBC] select on
Karel Zak wrote:
I found some other things:
- ODBC -- here is some multibyte stuff too. Why ODBC code don't use
pg_wchar.h where is all defined? In odbc/multibyte.h is again defined
all encoding identificators.
IMHO we can use for ODBC same solution as for libpq and compile it
Peter Eisentraut [EMAIL PROTECTED] writes:
AFAIR, with the 7.1 release the postmaster automatically recovers from
this situation. Can someone come up with a better description of what
ipcclean is useful for, if there still is such a thing?
I believe that ipcclean is no longer needed for
I found some other things:
- why database encoding for new DB check 'createdb' script and not
CREATE DATABASE statement? (means client only encodings, like BIG5)?
Bug?
Oh, that must be a bug. Do yo want to take care of it by yourself?
- ODBC -- here is some multibyte stuff too.
Tatsuo Ishii writes:
I wouldn't object it if there is a way to disable locale support.
export LC_ALL=C
It's not a solution. My point is people should not be troubled by the
useless feature (at least for Japanese) even if they set their locale
other than C.
--
Tatsuo Ishii
48 matches
Mail list logo