* Naomi Walker <[EMAIL PROTECTED]> [010706 17:57]:
> If PostgreSQL is run on a system that has a file size limit (2 gig?), where
> might cause us to hit the limit?
PostgreSQL is smart, and breaks the table files up at ~1GB per each,
so it's transparent to you.
You shouldn't have to worry about
At 01:30 PM 7/6/2001 -0700, you wrote:
>On Fri, 6 Jul 2001, Somazx Interesting wrote:
>
> >
> > I'm working with two different postgres installations - they're both
> > v7.1.2. On one I can drop a table and the related constraint info seems to
> > go away with the table, on the other the restraint
On Fri, 6 Jul 2001, Somazx Interesting wrote:
>
> I'm working with two different postgres installations - they're both
> v7.1.2. On one I can drop a table and the related constraint info seems to
> go away with the table, on the other the restraint trigger seems to remain
> in the system tabl
Somazx Interesting <[EMAIL PROTECTED]> writes:
> I'm working with two different postgres installations - they're both
> v7.1.2. On one I can drop a table and the related constraint info seems to
> go away with the table, on the other the restraint trigger seems to remain
> in the system tables
Ed Loehr <[EMAIL PROTECTED]> writes:
>> Btw., order by + union doesn't work prior to 7.1 anyway.
> Looks like order by + union was enabled at least in 7.0.3, fwiw...
Nonetheless, it had bugs crawling out of it everywhere ... try more
complex test cases, and pay attention to whether you actually
"Mihai Gheorghiu" <[EMAIL PROTECTED]> writes:
> Is there a function that returns the number of days between two dates?
Subtraction.
regression=# select '27 Feb 2001'::date - '5 Jan 2001'::date;
?column?
--
53
(1 row)
regards, tom lane
---
I'm working with two different postgres installations - they're both
v7.1.2. On one I can drop a table and the related constraint info seems to
go away with the table, on the other the restraint trigger seems to remain
in the system tables and then when I try to delete rows from tables once
r
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> In 7.2, VACUUM will not require an exclusive lock.
> Care to elaborate on that? How are you going to do it?
Uh, have you not been paying attention to pg-hackers for the
last two months?
I am assuming here that concurrent VACUUM will become the defau
> In 7.2, VACUUM will not require an exclusive lock.
Care to elaborate on that? How are you going to do it?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+
Peter Eisentraut wrote:
>
> Ed Loehr writes:
>
> > This query works in 7.0.3...
> >
> > SELECT p.*, e.id AS "employee_id", e.ref_name,
> >e.business_line_id, e.record_status_id AS "emp_record_status_id"
> > >FROM person p, employee e
> > WHERE e.person_id = p.id
> >
> > UNION ALL
> >
> >
Command: create rule
Description: define a new rule
Syntax:
CREATE RULE rule_name AS ON
{ SELECT | UPDATE | DELETE | INSERT }
TO object [WHERE qual]
DO [INSTEAD] [action|NOTHING|[actions]];
HTH
Omid
>From: "Jared H. Hudson" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTE
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Are you changing default VACUUM
Only to the extent of not being the default.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an ap
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> In 7.2, VACUUM will not require an exclusive lock.
>
> > Care to elaborate on that? How are you going to do it?
>
> Uh, have you not been paying attention to pg-hackers for the
> last two months?
>
> I am assuming here that concurrent VACUUM wil
I haven't gotten into it yet but you could try using the sendQuery method
and looping on the new data as it becomes available.
Josh
On Fri, 6 Jul 2001, Mithun Bhattacharya wrote:
> Just started on postgres a few days back and was having a few questions
> about the perl interface to it. Accordin
Is there a function that returns the number of days between two dates?
I found only age, which calculates the difference between two timestamps,
but the example shows the result as a timestamp.
Thanks,
Mihai Gheorghiu
---(end of broadcast)---
TIP 6
On Fri, Jul 06, 2001 at 06:15:47PM +0200, Peter Eisentraut wrote:
: Philip Molter writes:
:
: > I'm doing logging of PG information, and I'd like to rotate the logs.
: > What's the proper way to HUP the server once the logs have been
: > rotated?
:
: There isn't one. You're better off piping th
I would like to be able to define a table with 1 column containing user
names,
and the next column being a dynamically generating function that returns a
user's quota.
I think I see how to create the shared object, and the SQL function. But,
how
do I create a table that uses a function for a col
Ed Loehr writes:
> This query works in 7.0.3...
>
> SELECT p.*, e.id AS "employee_id", e.ref_name,
>e.business_line_id, e.record_status_id AS "emp_record_status_id"
> >FROM person p, employee e
> WHERE e.person_id = p.id
>
> UNION ALL
>
> SELECT p.*, NULL AS "employee_id", NULL AS "ref_na
Hi,
Extraction of large amount of data is not realistic especially with
CGI, then DBI/DBD::Pg always return all data received from a query
so if you don't want to tired your machine, the better way is to use
cursor in a transaction (or query) or the LIMIT+OFFSET keywords.
Regards
Gilles DAROLD
From: "Trewern, Ben" <[EMAIL PROTECTED]>
> If there is a transaction running when 'vacuumdb -a -z' is run (as a cron
> job) it stops running at that database till the transaction completes.
That
> is not so much of a problem until a new client tries to connect to the
> database. This new connect
Morgan Curley writes:
> Does anyone know if it is possible to connect to a differernt db from
> within a plsql function.
> I have multilple inter-related schemas and want to enforce some fk
> relationships.
Not possible
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~pete
21 matches
Mail list logo
