At 09:39 AM 20-08-2001 -0700, Mikheev, Vadim wrote:
>> If it does then one of the things I'd use it for is to insert
>> unique data without having to lock the table or rollback on
>> failed insert (unique index still kept as a guarantee).
>
>(Classic example how could be used SAVEPOINTs -:))
I gu
> 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
> 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 t
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
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 compil
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 mu
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).
regard
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
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
> 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 ---
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 appendi
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 progr
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'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 t
> 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 find/pla
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 grand
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 u
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, you'
> 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 t
"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 on
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
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
> 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
"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 w
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: Co
> 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
> 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
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.
>
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.
ju
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 her
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 (cr
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 ha
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 ins
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
>wou
> 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 th
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 mo
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 that
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 th
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
> 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 o
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.
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 loggi
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
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
--
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 comp
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 k
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
---
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 I
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 odbc/multibyte
49 matches
Mail list logo
