--- 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 CH
--- 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 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 th
--- 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
--- "Dr. Evil" <[EMAIL PROTECTED]> wrote:
>
> Again, if someone will point me to the place in the WAL code
> where it
> has the tuple and it wants to write it out, I'll make these
> mods
> myself.
I don't know this myself, but the pgsql-hackers list certainly
could lead you in the right directio
--- 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 di
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 - only
--- 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 sys
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
--- 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 i
--- 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 d
there a way (more likely a query question) to
> select * from tablename where 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
trigger name (first
>column in pg_trigger, will look like RI_ConstraintTrigger_ or
>something like 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 f
to 777
>and changing 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
--- Matthew <[EMAIL PROTECTED]> wrote:
> Pardon my ignorance on this topic, but if you compile using MS
> VC++ do you
> need cygwin at all? Does this allow you to run postgre
> without cygwin
> installed?
You can only compile psql.exe and libpq.dll with VC++. You
cannot build the postgresql se
3/17/2001 1:32:53 PM, "Moishe Groger" <[EMAIL PROTECTED]> wrote:
> I just finished compiling and installing the newest versions of cygwin,
> cygipc, and postgresql 7.1 beta 6. When I attempt to run "postmaster -D
> /usr/local/pgsql/data", however, I receive the following error message:
>
>
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
> 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 broa
--- 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 ne
> What's the difference between PoPy and the PygreSQL driver
> included in
> the PostgreSQL distribution? Just curious.
Several things actually. PyGreSQL is a C module and two Python
script files, while PoPy is built entirely as a C module which
should mean more speed. PoPy is Python DB API 2.
> > 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 broa
--- 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 a
--- [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:
http://people
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
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.
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)
26 matches
Mail list logo
