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
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 hint
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 get
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
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.
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 of
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
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.
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 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
- 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
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 think:
psql -u
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
13 matches
Mail list logo
