> Andrew Snow wrote:
> >
> > > > > what is the relative safety of doing a vacuum verbose analyze
> > > on a 24Gb
> > > > > table while there are selects and updates/inserts happening on it?
> > > >
> > > > As far as I know, the table is locked completely during a Vacuum.
Any
> > > > transactions a
On Mon, 17 Apr 2000, Andrew Perrin - Demography wrote:
> Sure, VB works, as would perl with DBD::ODBC module. I've been using that
> technique for porting a database from access to postgres, and it should
> work equally well with excel-based ODBC connections. Disadvantage to the
> original post
I have completed the first draft of my book through chapter 14.
New chapters include:
Chapter 11, Performance: Indexes, CLUSTER, VACUUM, EXPLAIN
Chapter 12, Controlling Results: LIMIT, Cursors
Chapter 13, Table Management: Temporary tables, ALTER TABLE,
Sure, VB works, as would perl with DBD::ODBC module. I've been using that
technique for porting a database from access to postgres, and it should
work equally well with excel-based ODBC connections. Disadvantage to the
original poster is that it does require a Windows machine to read the
Excel f
I'm trying to use the trig functions mentioned in the postgresql manual.
Namely the cosine function listed as
cos(float8) float8cosine cos(0.4)
In both 6.5.3 and 7.0beta3 the function doesn't exist. I get. . .
obe-> \df cosine
result|function|arguments|description
--++
At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
>On Mon, 17 Apr 2000, Adam Ruth wrote:
>
>> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
>> > 6.5.3 tables are stored as single files, so better not go down that path
>> :).
>>
>> I'm using 6.5.2 and it will split a tabl
-> On 17-Apr-00 12:26:41, you wrote:
->
-> >I've been looking on the internet for 2 hours for information how to connect
-> >my SQL database to my website. I didn't find what I was looking for, this is
-> >my problem
-> >I have got a form on my site, that can be filled in by visitors.
On 17 Apr 2000, Hal Snyder wrote:
> "Chris Carbaugh" <[EMAIL PROTECTED]> writes:
>
> > If you really want to save the user some work/confusion, investigate
> > what you can do with VB under XL.
> >
> > I would think XL allows you to set some options when export as CSV,
> > with VB, you could wr
I'm a Linux user.
I've been using xlHTML and a home-made HTML2DBF rather than
ODBC with Perl's DBD::Proxy and DBD::ODBC because, to be
able to use ODBC, you need people to *name* the table they
create when using Excel. Well, they never do so.
Sometimes, they will name a table with 256 columns and
How do I create users for postgress on an NT workstation?
> I am trying to run postgress on an NT workstation.
>
> Do I have to run it in a bash prompt?
>
> This is the error I get if I try to run postgres.exe at nt cmd prompt:
> D:\cygnus\cygwin-b20>postgres
> FATAL 1: SetPgUserName: no entr
Hello J.Post,
On 17-Apr-00 12:26:41, you wrote:
>I've been looking on the internet for 2 hours for information how to connect
>my SQL database to my website. I didn't find what I was looking for, this is
>my problem
>I have got a form on my site, that can be filled in by visitors. I
"Chris Carbaugh" <[EMAIL PROTECTED]> writes:
> If you really want to save the user some work/confusion, investigate
> what you can do with VB under XL.
>
> I would think XL allows you to set some options when export as CSV,
> with VB, you could write your own Save function.
How messy to Save to
If you really want to save the user some work/confusion, investigate what
you can do with VB under XL.
I would think XL allows you to set some options when export as CSV, with VB,
you could write your own Save function.
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMA
> Log in as "postgres" (empty password) and create some users.
Do I need to do this at the bash prompt somehow? I don't know how.
Or do I log into my nt workstation and change users with the user manager?
I guess I am confused how postgress works with users.
Joseph
-Original Message
On Mon, Apr 17, 2000 at 06:12:37PM +0930, Stephen Davies wrote:
> G'day.
>
> I do a lot of work with the BASIS textual/multi-media RDBMS package and
> run into this question all the time.
>
> There is one pretty basic answer:
>
> If you leave BLOBS lying around in the file system - particularl
G'day.
I do a lot of work with the BASIS textual/multi-media RDBMS package and
run into this question all the time.
There is one pretty basic answer:
If you leave BLOBS lying around in the file system - particularly if
it is a Novell etc file system - people move them and the links get
broke
How do I start this? There are so many different ways to look at this
question. Do I save files inside the database, or do I simply use the database
as a tool to query information about a given file, it's properties, etc.
Instead of making general statements, let me pick specific examples. Let
17 matches
Mail list logo
