--- Tom Ince [EMAIL PROTECTED] wrote:
I am attempting to convert an database currently running on
Informix to
a free database on Linux (RedHat 6.1). I have a question.
I learned that MySQL, does not maintain foreign keys, which
affects me
because I need to use things like CHECK in
--- Doug Moore [EMAIL PROTECTED] wrote:
Hi,
As I understand it, in order to read in a file containing sql
commands
I should use the \i file syntax in psql.
So, from the psql prompt I type:
\i /root/phones
I get back /root/phones: permission denied
I am in psql as the user who
--- Andrew Sullivan [EMAIL PROTECTED] wrote:
1.I thought the SQL spec required varchar() not to pad. Is
it
just that, because of the way pg_dump saved the char() data
(as
blank-padded) that the varchar() field preserves the padded
data?
The pg_dump utility dumps out the data as is
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Here is an article saying open source databases will not make
major
inroads into large businesses during the next five years:
http://itmanagement.earthweb.com/datbus/article/0,,11969_796851,00.html
Those same weak arguments were used to discredit
This article mentions Postgres multiple times. It even mentions
GreatBridge:
http://dailynews.yahoo.com/h/zd/20010606/tc/linux_forklifts_in_the_data_warehouse_1.html
Brent
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail -
--- Hiroshi Inoue [EMAIL PROTECTED] wrote:
Allan Rafuse wrote:
I'm having trouble setting up a remote Apache PHP webserver
to connect to
our postgres machine using ODBC.
Are you using ~/.odbc.ini(user DSN) for odbc.ini ?
Current psqlodbc driver doesn't understand system DSN.
This article could be huge for those looking to sell Postgres to
a company. I'm printing out a copy for myself ;)
Open Source Code: A Corporate Building Block (ZDNet)
http://dailynews.yahoo.com/h/zd/20010514/tc/open_source_code_a_corporate_building_block_1.html
Brent
--- Ryan C. Bonham [EMAIL PROTECTED] wrote:
My question is what is the best way to import my data from MS
SQL. I
installed the ODBC Drivers and tried exporting using the MS
import/export
tool.. It successfully creates the tables, but fails to import
any data,
with a error stating that the
--- Sean Harding [EMAIL PROTECTED] wrote:
I have a table, 'mesg_headers', which holds headers from email
messages. Each message has a unique integer ID within the
system,
'mesgid'. mesgid is the primary key for mesg_headers, so it
has index
mesg_headers_pkey. This index is used if I do
--- Jonas Bengtsson [EMAIL PROTECTED] wrote:
Can't you do a dump with the oid's?
Yes, but I would never suggest it.
But when I want to know the primary key of the inserted row
I have to do an extra select query. If I use oid I just use
pg_getlastoid() in php.
And it is redundant data to
the ownership to postgres.postgres, su to postgres and it
says "permission denied" when I try to:
psql -e worldwide worldwide.pgdump
You must supply a username that has permissions to perform creates and
inserts on the database:
% psql -U postgres -e worldwide wordwide.pgdump
Brent
---
Brent R
that) and make sure to "" it because it's a quoted mixed
case name.
It might be even easier to just delete according to the oid.
select oid, * from pg_trigger;
delete from pg_trigger where oid = 49469 /* Numbers are easier */;
Brent
---
Brent R. Matzelle
Software Engineer
Informatio
y question) to
select * from tablename where anyfield like '%term%'??
That query should work fine.
Brent
---
Brent R. Matzelle
Software Engineer
Information Services
Main Line Health Systems
Tel: 610-240-4566
Pager: 610-640-8437
[EMAIL PROTECTED]
---(end of
I never install our version of postgresql7.0 on this Red Hat Linux
machine, but I need to connect to the database with ODBC.
Is there any way
I can tell if the ODBC driver has been installed?
Run this command:
% rpm -q postgresql-odbc
Brent
---(end of
3/15/2001 3:39:27 AM, Alexander Jerusalem [EMAIL PROTECTED]
wrote:
Thanks for your answer, Alex!
I've done an EXPLAIN and I saw that no index was used although my SQL
statement had a wild card only at the end as you pointed out ('blah%'). My
guess is that this is because of the locale
--- Jonas Lindholm [EMAIL PROTECTED] wrote:
Can a table grow larger than maximum file size ?
E.g. will PG create an additional file for the table ?
I'm running PG 7.0.3 on Linux where the maximum file size is
2GB
The new Linux 2.4 kernel has blown away that file size barrier.
The new
I use PoPy and think it's dandy. I also thought it *was* the
DB API 2.0--
am I mistaken here?
I noticed a couple posts asking for PoPy RPMs so I created some and posted
them below if anyone is interested.
http://www.linuxshare.com/popy/
Brent
---(end of
--- chris markiewicz [EMAIL PROTECTED] wrote:
Unknown Response Type
at org.postgresql.Connection.ExecSQL(Connection.java:420)
at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
at
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
does anyone
--- [EMAIL PROTECTED] wrote:
I tried at one point though I don't know the cygwin version.
I didn't work; said c compiler cannot produce
executeable
This happened to me as well. It occurs because you haven't
applied the source patch. You can read out and download it
here:
You can create an auto incrementing field with SERIAL. Take a
look at the FAQ
(http://www.postgresql.org/docs/faq-english.html#4.16.1).
Brent
--- Raymond Chui [EMAIL PROTECTED] wrote:
If I create a table like
create table tablename (
aNuminteger not null,
namevarchar(10)
);
Yes there is. You can find it in the TODO list under
Performance - Indexes
(http://www.postgresql.org/docs/todo.html). It isn't
slated for the 7.1 release however.
Brent
--- adb [EMAIL PROTECTED] wrote:
I've noticed that select max(the_primary_key) from
some_table
does a table scan. Is
There currently is no simple SQL command that accomplishes this.
It can be accomplished by creating an identical new table with
the bool data type change and then running a "INSERT INTO
new_table (SELECT * FROM old_table)". Then you can check your
results, drop the old table, and rename the new
22 matches
Mail list logo