I don't think there's an easy way to do this but I thought I better ask just in case.
I'm trying to come up with a way to search across a number of databases without
resorting to lots of horrible scripts. In one database I have a lot of news stories
from our news provider while in another data
Does ALTER TABLE ALTER SET STATISTICS 100; lock the
table? I just tried to do that while a query is running and the ALTER
is hanging.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
"Ben" <[EMAIL PROTECTED]> writes:
> On Sat, 31 Jan 2004 02:22:09 +, Lee Harr wrote:
>
>> In 7.4 anyhow, I bet you can do much of this with the
>> information_schema. This one would be ...
>>
>> SELECT count(*)
>> FROM information_schema.columns
>> WHERE table_name='mytable';
>
> Sound
Hi!
I started programming PostgreSQL database with libpq API (client
side). It looks very easy, but unexpected I found problem, which I
cannot solve myself.
If function PQexec fails, I can get error code using PQresultStatus.
But returned codes are very generally and do not specify what really
hap
On Sat, 31 Jan 2004, John Sidney-Woollett wrote:
> Hi
>
> I need to store accented characters in a postgres (7.4) database, and
> access the data (mostly) using the postgres JDBC driver (from a web app).
>
> Does anyone know if:
>
> 2) Can SQL_ASCII be used for accented characters.
Not with the
On 01/31/04 06:57 PM, John Sidney-Woollett sat at the `puter and typed:
> Apologies if I missed something, but why are you using the rowid in
> Oracle instead of your own primary key value (even if you are
> inserting 10's of millions of records a day). A number(38) provides
> a range of magnitude
I must say, I'm really appreciative with the responses from this list.
Thanks to all!
-Original Message-
From: elein [mailto:[EMAIL PROTECTED]
Sent: January 31, 2004 12:10 PM
To: Anony Mous
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Two joins on same foreign key
PostgreSQL General B
PostgreSQL General Bits Issue #56 has an article on Join Basics
which also has an example of multiple table joins.
http://cookie.varlena.com/varlena/GeneralBits/56.php
--elein
[EMAIL PROTECTED]
On Fri, Jan 30, 2004 at 03:03:35PM -0700, Anony Mous wrote:
> Hi,
>
>
>
> I??m fairly new to this
Louis LeBlanc <[EMAIL PROTECTED]> writes:
> [ large objects don't work real well in That Other Database ]
Fascinating. I'd have thought they'd use a less flaky design.
> I've been looking at the Postgres docs, and I've found the lo_*()
> routines, which appear to use OIDs to write to the object.
Apologies if I missed something, but why are you using the rowid in Oracle
instead of your own primary key value (even if you are inserting 10's of
millions of records a day). A number(38) provides a range of magnitude
1E-130 .. 10E125
Using a non rowid PK value would mean that you were not at the
If you know about these functions before
you create your databases, install them into
template1. Then all subsequently created databases
will have them.
If the databases already exist, you need to do what you did.
--elein
[EMAIL PROT
Nuno Morgadinho <[EMAIL PROTECTED]> writes:
> Ideally, I would want to make the example function return the
> information as a "set" and not through elog() so I can later access it
> and print it using PHP.
> I have a few ideas on how this can be accomplished but I haven't found
> any simple exampl
Hey folks. I'm new to the list, and not quite what you'd call a DB
Guru, so please be patient with me. I'm afraid the lead up here is a
bit verbose . . .
I am working on an application that uses very high volume DB
transactions - in the order of tens of millions per day . . .
Anyway, the curren
Hi
I need to store accented characters in a postgres (7.4) database, and
access the data (mostly) using the postgres JDBC driver (from a web app).
Does anyone know if:
1) Is there a performance loss using (multibyte) UNICODE vs (single byte)
SQL_ASCII/LATINxxx character encoding? (In terms of ex
On Jan 31, 2004, at 3:35 PM, Anony Mous wrote:
Actually, given that there may not always be a backup_employee field
(can be
null) I think I'm forced to use an outer join to return all team leader
records regardless if a matching backup_employee record exists.
yup. Actually, I hadn't seen the othe
On Mon, Jan 26, 2004 at 04:40:33PM -0500, Matthew Jones wrote:
> Is there a way, when a function is created (in language SQL for example),
> for it to be available globally, as the pg_catalog functions are. All of
> the ones I create are only available on the database they were created,
> and I can
Hello!
I need to execute a dynamic query and capture
your result in a integer variable.
I´m using the statement "EXECUTE string", but I
don´t obtain to capture the result of dynamic query.
See the example:
==
Hello all,
I'm messing around with the Server Programming Interface and the
particular example presented at:
http://www.postgresql.org/docs/current/interactive/spi-examples.html
Ideally, I would want to make the example function return the
information as a "set" and not through elog() so I can
Hi.
I'm trying the database privileges, I create diferent users in my
database server. Use A and user B in two diferents groups (GA and GB),
I create a database (DBA) with user A, and grant privileges to group
GA, i create a shema and grant privileges to GA and create same tables
too.
If i conect
Hi,
I am developing the DB code for what I hope will be
become a rather large/popular web application. The design
uses a unified object model, all object_ids coming from one
master sequence (suffice it to say it must be this way to meet
other design goals).
Being the worrier that I am, I am conce
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Marco Lazzeri
> Sent: Saturday, January 24, 2004 7:19 AM
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] If table A value IS NULL then table B
>
> > I think this post belongs on the SQL list, not the gener
PostgreSQL mavens, can I ask the database, in a normal database query command, or in
other words,
essentially using the same environment where I'd say...
SELECT count(*) FROM mytable [WHERE myconditions_obtain];
...to get # records in my table,
o How many fields mytable has as in:
SELEC
Is there a way, when a function is created (in language SQL for example),
for it to be available globally, as the pg_catalog functions are. All of
the ones I create are only available on the database they were created,
and I can't figure out a way to make it so they're available to all
without havi
23 matches
Mail list logo
