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 u
> 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
http://www.eudorama
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 Wa
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
Ron,
the Universal Postal Union [http://www.upu.int] keeps some record
about internationally used address formats. However, what they have is
also not a standard, but more of an inventory of national peculiarities
[http://www.upu.int/addressing/AN/AN.pdf]. In HL7, an international
health care s
[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);
>
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. No
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 the documentation
ALTER TABLE distributors ADD
> 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 cli
"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 caff
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> ER
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
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 '/
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 imple
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
15 matches
Mail list logo
