Hello
I was listening Your discusion. I have practical problem for which I write my
own locking system:
Personal rekords:
Name
zip
adress
Users A,B reads data from record:
John Smith
124312
Xstreet 27
Now A change zip and write all
B change adress and write
so zip is unchanged.
In pgsql I
On Thu, Jun 15, 2000 at 03:58:40PM -0400, Ron Peterson wrote:
PostgreSQL's TODO list (http://www.postgresql.org/docs/todo.html) makes
reference to implementing SQL3 recursive queries. Where does this task
fall in the overall priority of things? I hate to just whine without
I want to
Tyler Robert Wood wrote:
Hi,
I am attempting to copy the contents of a table to a file, like this:
foodserver= COPY company TO '/home/peter/copytest.out';
But I keep getting this error:
ERROR: COPY command, running in backend with effective uid 100, could not
open file
Is it possible to select data from mulitple databases with a single sql
statement? Does postgresSQL allow the DB link to other database as Oracle?
Or any way to work around?
Howard
On Fri, 16 Jun 2000 (Yesterday), Tyler Robert Wood wrote:
TRW
TRW Hi,
TRW I am attempting to copy the contents of a table to a file, like this:
TRW
TRW foodserver= COPY company TO '/home/peter/copytest.out';
TRW
TRW
TRW But I keep getting this error:
TRW
TRW ERROR: COPY
"Pawe³ Dubin" wrote:
Hello
I was listening Your discusion. I have practical problem for which I write my
own locking system:
Now A change zip and write all
B change adress and write
so zip is unchanged.
In pgsql I can solve it by SELECT FOR UPDATE but if user A goes for caffe
during
I usually prefer the following trick for preventing long locking
times. On every
table I define a timestamp field which is updated every time the record is
written to the database. If a user edits a record (without
locking) and commit his changes
the timestamp is returned from the client
The backend died while I was dropping an index on a table. Now I cannot
access my data! Help!
My table looks like
create table user_usage (email varchar(100),date date);
I created the index:
CREATE INDEX user_usage_email_idx on user_usage(email);
When I dropped the index, the backend died.
[EMAIL PROTECTED] wrote:
The backend died while I was dropping an index on a table. Now I cannot
access my data! Help!
My table looks like
create table user_usage (email varchar(100),date date);
I created the index:
CREATE INDEX user_usage_email_idx on user_usage(email);
When I
On Sat, 17 Jun 2000, Vipin Samtani wrote:
I am trying to designate foreign keys after tables "distributors" and
"addresses" have already been created with primary keys "distributor"
and "address" respectively. I am attempting to use ALTER TABLE to
accomplish this. I found this statement in
International addresses can be very strange. To send a package to
someone in Anguilla, you address it like this:
John Doe
344 444
The Valley, Anguilla
where 344 444 is the guy's phone number.
In Laos, an address is like this:
John Doe
Near
What happens if someone else updates the
record *just* after the record is
reread for update and timestamp compared?
SELECT FOR UPDATE means no one else can update the row, doesn't it?
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at
Mike Mascari [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
How do I fix this? This is on 6.5.
1. Change to the location of the datafiles, which, for a
database, called "mydatabase" will look something like:
2. Create an empty file of the name of the index:
3. Delete the file using
13 matches
Mail list logo