On Wed, Apr 11, 2001 at 10:25:24AM +0200, Marcin Wasilewski wrote:
> hello everybody,
> Can you help me?
>
> I have POSTGRESQL 7.0.3,
> I try to create simple view by typing.
>
> create view "xx" as select "aa.yy", "bb.yy" from "yy" order by "bb.yy"
>
> the problem is that parameter order is no
OK, I've decided to get PostgreSQL running on Windows by using the 7.1
RC2 build that is now available through the Cygwin setup. I was
finally able to build, install, and run it.
Now, I'm going to need to run pgAccess under native Windows and
connect to the PostgreSQL server, but the pgAccess do
I have significant experience using Access with Microsoft SQL Server,
and the situation is similar. Even when the server has something like
an Auto-increment or Identity column type, using it will be
problematic. The best thing you can to is to make your own
auto-increment system.
For each regu
On Fri, Apr 13, 2001 at 02:28:29PM +0530, Masood Rezvi wrote:
> We are a firm of web developers in Lucknow, India. We are new
> to PGSQL but have this database on the webserver (Apache
> running on Linux Red Hat). We need help on learning PGSQL
> information on tutorials and also to know whether i
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> A view creates a virtual table; there is no implicit ordering in a table,
> so it follows that you should not be able to impose one in a view.
This is indeed the pure-SQL attitude, but it may be worth pointing out
that Postgres 7.1 does allow ORDER B
Jeff Eckermann <[EMAIL PROTECTED]> writes:
> Based on past posts I have read, this error is usually associated with
> running out of memory for the query result. Problem is, I am only
> expecting about 30 lines of moderate length to be returned
Have you verified that by doing
select
Tom Lane wrote:
>"Oliver Elphick" <[EMAIL PROTECTED]> writes:
>> A view creates a virtual table; there is no implicit ordering in a table,
>> so it follows that you should not be able to impose one in a view.
>
>This is indeed the pure-SQL attitude, but it may be worth pointing out
>th
Hi All,
Is there a way to store photographs in postgres? I'm creating an employee
master kind of thing, so i would like to store photos of my company
employees also. If there is, is there a file size limitation or something?
Regards,
Raman.
---(end of broadcast)---
Bruce Momjian wrote:
> > On Fri, 13 Apr 2001, Karl DeBisschop wrote: > As for postgresql
> > having an anit-Christian bias? I think Lamar and > Bruce, among
> > others, could not be accused of an anti-Christian bias.
> >
> > Thanks, Karl.
> >
> > As a matter of fact, I am an ordained Baptist mini
Jan Wieck wrote:
> I'm not able to find any applicable disclaimers in my copy of
> the Bible. A quick look into the Koran didn't show up
> anything either.
FWIW, the 1611 King James text is in the Public Domain, as is the source
Hebrew and Greek from which it is translated. T
Raymond Chui writes:
> I am wonder are those files under $PGDATA/data/base/dbname/
> directory cooked files?
> Can I copy or ftp them to other machine running PostgreSQL without
> export/import (pg_dump)?
No.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---
Hi,
I have one machine running 7.1RC2, that I now want to upgrade to 7.1final.
I guess I don't need a dump restore then?
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTECTED]
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
--
On Sat, 14 Apr 2001, Jan Wieck wrote:
> Is it allowed to borrow the Cristian rules even if I don't
> believe in God and don't pray? Do they fall under the GPCL
> (General Public Christian License) or are they distributed
> under a BSDish style license? What if I link myse
Hello,
First of all: I' m using postgresql v7.0.2 on debian 2.2. (and I have two
completely different questions)
i) What is the most effective representation of
type "set" in postgres?
As I remember there is no attribute type to
represent definitely sets. (Please, correct me
if I'm
I'm sure my problem relates more to my ignorance than the srpm set but here
goes:
I am trying to build on a Mandrake 7.2 system (rpm v3.0.5)
The source install (rpm -i postgresql-7.1-1.src.rpm) seemed to do everything
it was supposed to. I followed the directions in the README.rpm-dist file
as
Len Morgan wrote:
> Am I missing something? I am assuming that since Mandrake RPMs were done
> before, they are not the same as the RedHat RPMs and I will have to rebuild
> from source. I tried the build from the RPM directory (as stated above) and
> from the SPECS directory as stated in the "Ma
"Gyozo Papp" <[EMAIL PROTECTED]> writes:
> How can I solve this ? Maybe an upgrade to v7.1 blows the whole thing out?
Possibly. It's hard to tell what your problem is with such an
incomplete, fuzzily-described example. But there have been a number
of bugs fixed in that general area.
Wonderful job on getting 7.1 released. I've just installed it in place of a
7.1beta4 database, with the great advantage of not even having to migrate
the database.
It seems that 7.1 is able to handle large objects in its dump/restore
natively now and no longer requires the use of the contrib pro
On Sat, 14 Apr 2001, David Wall wrote:
> It seems that 7.1 is able to handle large objects in its dump/restore
> natively now and no longer requires the use of the contrib program to dump
> them. Large objects are represented by OIDs in the table schema, and I'm
> trying to make sure that I under
I might not be able to change the standard but:
How specific is BCE?
1973 Before the Current Era my birth year,
but _only_ under that very pro-christian
assumption that BC = BCE !
the last item in the Example column is January 8, 99 BC.
The corresponding Description item reads "Year 99 before t
On Sat, 14 Apr 2001, Stefan Waidele jun. wrote:
> How specific is BCE?
> 1973 Before the Current Era my birth year,
> but _only_ under that very pro-christian
> assumption that BC = BCE !
This brings up another question nto related to religion but just time
keeping in PostgreSQL: can PostgreSQL
To all,
Ok, this is ridiculous.
>> On page 29 of the PostgreSQL User's Guide, distributed with version 7.0.3,
>> in table 3-8 Postgres Date Input, the last item in the Example column is
>> January 8, 99 BC. The corresponding Description item reads "Year 99 before
>> the Common Era". Th
22 matches
Mail list logo
