Joseph Shraibman wrote:
> Bruce Momjian wrote:
> > I have events in the next few weeks in New York City, Copenhagen, Paris,
> > and Atlanta. Check the News section on the web site for more
> > information. I will also be in Amsterdam February 2-3, though I have no
> > public events scheduled ther
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually that same letter is available at sco's website. The one at SCO only
has a list with all the "infringing" header files attached.
On Wednesday 21 January 2004 10:30 pm, Alex Satrapa wrote:
> Gavin M. Roy wrote:
> > Feel free to link away :)
Bruce Momjian wrote:
I have events in the next few weeks in New York City, Copenhagen, Paris,
and Atlanta. Check the News section on the web site for more
information. I will also be in Amsterdam February 2-3, though I have no
public events scheduled there.
You mean the events section, don't you?
> Works for me in every branch back to 7.1 ... what version are you using?
7.4.1, but I figured out what I did wrong. The alias for the first
column turns out to be the same as the name of another column in the table.
--
Mike Nolan
---(end of broadcast)--
Mike Nolan <[EMAIL PROTECTED]> writes:
> Is the error message below a bug?
> select substr(memid,1,1) as memtp, substr(memid,2,4) as newx
> from memmast group by memtp, newx
> ERROR: column "memmast.memid" must appear in the GROUP BY clause or be used in
> an aggregate function
Works for me in
<[EMAIL PROTECTED]> writes:
> Does postgres support returning multiple sets from a function?
Not directly. You can fake it in some cases by returning several open
cursors and expecting the caller to fetch from those cursors. However,
if you can't write SQL queries that can be executed to return
Steve Atkins <[EMAIL PROTECTED]> writes:
> [ much snipped ]
> Vacuuming and analysing can be handled using the algorithms (and the code,
> come to that) from pg_autovacuum.
Autovacuum will undoubtedly migrate into the core. I'm not sure how
soon, or whether the end result will look much like the
I have events in the next few weeks in New York City, Copenhagen, Paris,
and Atlanta. Check the News section on the web site for more
information. I will also be in Amsterdam February 2-3, though I have no
public events scheduled there.
--
Bruce Momjian| http://candle
Reece Hart <[EMAIL PROTECTED]> writes:
> On Thu, 2004-01-22 at 16:13, Phil Campaigne wrote:
>> psql: relocation error: psql: undefined symbol: PQgetssl
> I vaguely remember seeing a similar message when I inadvertently
> mismatched versions of psql and libpq. I think that the problem was psql
> re
[EMAIL PROTECTED] wrote:
I know I can write plpgsql functions that return sets.
Does postgres support returning multiple sets from a function?
No.
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
I know I can write plpgsql functions that return sets.
Does postgres support returning multiple sets from a function?
Bill McMilleon
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-no
> Doesn't look like a bug to me. As far as I know only aggregation functions
> can occur in a select with group by for columns that are not in the group by
> clause.
I left out the 'count(*)' column, because the query fails with or without it.
The reason I think it may be an error is that if I
On Thu, Jan 22, 2004 at 01:04:29PM -0700, Rick Gigger wrote:
[PostgreSQL ill-suited to embedded use]
> How about the following comment from an earlier post:
>
> > Now, while I think that an embedded fork of PostgreSQL is completely
> > missing the point I do think that a low maintenance fork or
On Thu, 2004-01-22 at 16:13, Phil Campaigne wrote:
psql: relocation error: psql: undefined symbol: PQgetssl
Phil-
I vaguely remember seeing a similar message when I inadvertently mismatched versions of psql and libpq. I think that the problem was psql resolving to the wrong libpq, but this
Hi All,
I just installed postgresql 7.3.4 as an upgrade to 7.3.2 and all went
well untill I tried to log into a database that I successfully created.
Here are the steps in question:
bash-2.05b$ psql -h localhost -U postgres hardwoodthunder
Welcome to psql 7.3.2, the PostgreSQL interactive termi
In the following query the field 'memid' is varchar(8).
Is the error message below a bug?
select substr(memid,1,1) as memtp, substr(memid,2,4) as newx
from memmast group by memtp, newx
ERROR: column "memmast.memid" must appear in the GROUP BY clause or be used in
an aggregate function
--
Mike
> "Rick Gigger" <[EMAIL PROTECTED]> writes:
> >> All of this explains why an embedded PostgreSQL isn't a great idea. It
> >> being a true multi-user database means that even if you went though
> >> all the work needed to turn it into an embedded database you wouldn't
> >> get most of the advantages
"Rick Gigger" <[EMAIL PROTECTED]> writes:
>> All of this explains why an embedded PostgreSQL isn't a great idea. It
>> being a true multi-user database means that even if you went though
>> all the work needed to turn it into an embedded database you wouldn't
>> get most of the advantages.
> Is it
speaking as someone currently migrating enterprise stuff to postgres
point-in-time is definitely the biggest issue.
this is the main thing we are having to look reproducing using some form of
replication to an alternative server.
-Original Message-
From: Rick Gigger [mailto:[EMAIL
Guys,
Sent a message out last week asking for info, but wanted to send another
more direct one.
The company I work for has decided to cut ties with Progress Software
Corporation due to their draconian licensing policies (they're bleeding
us).
I'm looking at our available options and am seeking o
> On Behalf Of Cott Lang
> It seems to me that the lack of point-in-time recovery is a
> much bigger roadblock against big users. :(
Meaning incremental (hot)-backups?
Or as protection against DROP/TRUNCATE/DELETE ALL TABLE/SCHEMA/DATABASE?
With a WAL it should be doable in some 7.x version, al
Hi,
docs say (19.2.1):
When trust authentication is specified, PostgreSQL assumes that anyone who
can connect to the server is authorized to access the database as whatever
database user he specifies (including the database superuser). This method
should only be used when there is adequate op
On Wed, 2004-01-21 at 09:05, Brian Maguire wrote:
> In my opinion, it really is a critical feature to support and administer
> enterprise databases. All the major databases currently support this
> and it is a compelling enough reason drive big users from away from
> using postgres for their ente
On Thursday 22 January 2004 09:58, Mattias Kregert wrote:
> I ran into this problem a couple of days ago when I upgraded from 7.0.3 to
> 7.4.1. I used the 7.4.1 pg_dumpall, but it created a dump file which tried
> to load the old plpgsql.so. I had to fix the dump file manually before
> loading it i
I ran into this problem a couple of days ago when I upgraded from 7.0.3 to 7.4.1.
I used the 7.4.1 pg_dumpall, but it created a dump file which tried to load the old
plpgsql.so.
I had to fix the dump file manually before loading it into the new db. There were some
other annoyances too, like the 7
> Is there any way to end (commit/rollback) a transaction inside a stored
> function?
Currently not, but you can RAISE EXCEPTION to terminate the containing
transaction. This will essentially rollback the transaction when it hits
the COMMIT statement (or implied version).
Best Wishes,
Chris Tra
- Original Message -
From: "Marc G. Fournier" <[EMAIL PROTECTED]>
> We figure that SCO will either be bought out, or go bankrupt, before we
> have to worry about them :)
Especially since they don't reply to licensing inquiries. I know, I sent
them a letter asking what sort of licensing I
27 matches
Mail list logo
