--- 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
--- "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
--- 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
--- 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
--- 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
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.
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
--- [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
--- 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
> > 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
> 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.
--- 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
> 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
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
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:
>
>
--- 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
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
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
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
--- 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
--- 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
--- "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
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
__
--- 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 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
26 matches
Mail list logo
