(this is after a reboot) and won't continue.
What do I have to do to convince the installer that I'm NOT running
another instance of the install program? Is something written in the
registry?
len morgan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
capture just that value. You might also want to make sure that you are
doing a real exit from your script and not just letting it fall through
len morgan
- Original Message -
From: [EMAIL PROTECTED]
To: Len Morgan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 27, 2001 10
with NULL in the text file. If the text file is
organized to be read by the COPY command, then use \N instead.
len morgan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
losing
anything.
len morgan
create table table1 (id int primary key, col1 int);
create table table2 (id int primary key references table1(id), col2 int);
and the 2 updates :
1) update table2 set id = 1001 where id = 1;
2) update table1 set id = 1001 where id = 1;
i can't execute them
to do the same thing.
len morgan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
I believe COPY is limited to reading ENTIRE records into a table not pieces
of them.
len morgan
-Original Message-
From: Jeff Boes [EMAIL PROTECTED]
To: Postgres-general [EMAIL PROTECTED]
Date: Friday, May 25, 2001 9:20 AM
Subject: [GENERAL] COPY with default values?
Let's say I have
You are correct and if you did your bulk insert with INSERT commands, it
will work just fine. The difference is the COPY command which AFAIK was/is
intended for backup and restore use.
len morgan
-Original Message-
From: Jeff Boes [EMAIL PROTECTED]
To: Postgres-general [EMAIL PROTECTED
Is it possible that there are spaces after the 'IDC16W' in the field? Try:
LIKE 'IDC16W%'
and see if that makes a difference.
len
A direct query gets appropriate rows of data:
dbname=# select * from partdef where shpname = 'IDC16W';
pn_id | class | num | mt | ver | loc_id | unit_id |
last_name BETWEEN 'A' AND 'Fz' ;
worked for me.
You could also use BETWEEN 'A' AND 'G' to avoid all of the s at the
end. Crude but effective.
len morgan
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
CREATE TABLE foo (test INT4) AS SELECT number FROM account;
I think you want something like:
SELECT number INTO TABLE foo FROM account ;
len morgan
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
forget an index when doing it "by
hand").
len morgan
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
load my finished RPMs when I'm done.
Len Morgan
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
and
not the table definitions, etc.
The last version I saw was 3.0 but that's been a couple of years.
len morgan
ly the one immediately
below this one).
How about:
select threadid, commentid, name detail from comments where
comentid '$commentid' and threadid='$threadid'
ORDER BY commentid DESC LIMIT 1 ;
The ORDER BY ... DESC will put the highest commentid first and the LIMIT 1
will only return one rec
any advice on how I can save these two tables I need so I can
get them to my customer I'd appreciate it.
Redhat 6.0 OS
len morgan
figure out if "nextscreen" is odd or even. 1
would odd, 0 even.
len morgan
From psql:
test = \o ouput-file-name
test = Enter your query here
test = \o
This will leave the results of your query in the file "output-file-name"
This IS covered in the documentation and from within psql with \h
len morgan
-Original Message-
From: [EMAIL PROTECT
me/postgres instead of PG_DATA?
Anyway, my 0.02 dollar's worth.
len morgan
-Original Message-
From: Joseph Shraibman [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, May 17, 2000 4:33 PM
Subject: [GENERAL] why so big?
I've just created a new database and I am wondering...
Why are all sequence files 8K? They're one freaking int.
How
to
have. I'd rather not roll out 6.4.2 and then have to go to 20 different
sites and upgrade them to 6.5 later unless that upgrade process will be
easier than it has been in the past.
Thanks
Len Morgan
20 matches
Mail list logo