Maybe it was moved for PostGres v7 (I'm still using 6.5.3 because it works
and I'm too lazy to upgrade. :-) but in older versions the PG_VERSION file
was in the data directory (ie, /usr/local/pgsql/data/ ) Try checking what
you are using for a data dir ("locate pg_database" should tell you wh
Greetings.
Monday, September 18, 2000, 10:38:37 PM, you wrote:
>> óÅÎ 18 15:53:06 arbat logger: FATAL 1: File '/var/lib/pgsql/PG_VERSION' does not
>exist or no read permission.
>>
>> Well, '/var/lib/pgsql/PG_VERSION' does exist, it has read permission
>> for user 'postgres' (I made it world re
Colleagues.
Could you please tell me how I can prevent a user from creating tables
in a database belonging to another user?
I login as user1, create a database, then logout, connect to the
database as user2 and create tables in it. Is this behavior by design?
And how can I prevent this from happ
Danny wrote:
> - Hello
> - I had previous experience with Access and MySQL.
>
> -Situation
>
> - I am trying to create the equvilant of the following which is a mysql
> command.
>
> - Queston
> - But I cannot figure out how to do this is postgresql
>
> "mysql -u root -p mydb < mydb.dump"
>
I thi
- Hello
- I had previous experience with Access and MySQL.
-Situation
- I am trying to create the equvilant of the following which is a mysql
command.
- Queston
- But I cannot figure out how to do this is postgresql
"mysql -u root -p mydb < mydb.dump"
- I was trying to create a test databa
> I was just about to give postgres 7.0.2 a try on my development machine,
> but after installing it, I find that I can't connect to my 6.5.2
> production servers. The following error message is reported by both psql
> and pgaccess, upon trying to connect:
>
> ERROR: MultiByte strings (MB) must
I was just about to give postgres 7.0.2 a try on my development machine,
but after installing it, I find that I can't connect to my 6.5.2
production servers. The following error message is reported by both psql
and pgaccess, upon trying to connect:
ERROR: MultiByte strings (MB) must be enabled
I did it. I reverse engineered Oracle with ERWin, set the server to Watcom,
converting domain data types. Then forward engineered it, then some small
sed script to convert e.g. NUMBER(8) to int8 etc.
Works fine with postgresql, especially the referential integrity is
absolutely compatible. Delete
Hi,
my query is about using the function SPI_modifytuple for a varchar
field.
I have (for example) a table with a field my_field of type
varchar(100). And I need to create a trigger that adds the phrase
"hello, world" to any value, that user inserts (or updates) in field
my_field. Using SPI_getva
Marko Kreen writes:
> I want to do simple and/or/xor/test operations on integers
> but PostgreSQL seems not to support this. I found in conrib
> area the 'bit' package, which supports 'SQL-compliant bitstrings'
> but this is too weird for me and anyway it crashes too.
These were the remainders
I've inherited a Web based application that was developed using
VisualBASIC, IIS, and SQL Server 6.5 ... which for some reason or other
decided to stop working. (Before I got it.) I'm pretty sure the issue is
with SQL Server and authentication but my attempts to fix it have not been
successful.
Hi,
I've been poking through the archive and PostgreSQL sites
looking for tools that would allow me to migrate from an Oracle DB. I'm
getting the impression that there aren't any. Are there any projects
underway to work on a tool like this (or a general Other DB -> PostgreSQL
framework)?
On Mon, 18 Sep 2000, Alexey V. Borzov wrote:
> Greetings.
>
> The problem is: from time to time, PostgreSQL seems to crash.
> Inspection of the logs revealed the following:
>
> óÅÎ 18 15:53:06 arbat logger: FATAL 1: File '/var/lib/pgsql/PG_VERSION' does not
>exist or no read permission.
>
>
On Fri, 15 Sep 2000, Andreas Tille wrote:
> On Thu, 14 Sep 2000, chris markiewicz wrote:
>
> > could this be a servlet/thread issue? i cannot tell from the code snippet,
> Solved. I really stupidly forgot an rs.next() :-(((.
>
> > but remember that variables in a servlet with class scope are
Greetings.
The problem is: from time to time, PostgreSQL seems to crash.
Inspection of the logs revealed the following:
óÅÎ 18 15:53:06 arbat logger: FATAL 1: File '/var/lib/pgsql/PG_VERSION' does not
exist or no read permission.
Well, '/var/lib/pgsql/PG_VERSION' does exist, it has read permi
suppose i have two tables whose primary keys i want to be generated from
the same sequence and a third table where i want to establish a foreign
key based on a primary key from either of the two initial tables whose
id's are from the same sequence.
e.g.,
t1t2
----
idid
t3
--
On Sun, Sep 17, 2000 at 12:50:26PM -0700, Stephan Szabo wrote:
>
> If you always SELECT ... FOR UPDATE (in all transactions that access it),
> then the second one will not see the DB state before the transaction is
> started, because the row is locked and the second transaction won't be
> able to
On Fri, 15 Sep 2000, Tim Kientzle wrote:
> The Statement variable here CANNOT be a class
> variable unless you're taking other steps to
> synchronize access. Otherwise, you risk having
> two different threads trying to manipulate the
> same statement object at the same time.
OK, I followed your
Hi, long time listener first time caller.
Does anybody have any definative info on the geometric data types?
for example is there an easy way of returning the x,y co-ords seperatly for the
box type
ie select x1,y1,x2,y2 from .
at the moment it looks like I'm going to have to parse out t
I want to do simple and/or/xor/test operations on integers
but PostgreSQL seems not to support this. I found in conrib
area the 'bit' package, which supports 'SQL-compliant bitstrings'
but this is too weird for me and anyway it crashes too.
So, my question 'How can I do this?' Is there any plan
20 matches
Mail list logo
