On Sat, Jul 16, 2005 at 05:39:59PM -0400, Garrett Kalleberg wrote:
>
> Now, the rec with id '1234' is in the table
> invoicelineiteminventorytypes, but I can't wrap my head around the
> fact that
>
> SELECT invoicelineitemtypeid FROM invoicelineitemtypes
>
> yields the rec with invoicelineit
Hi,
http://www.postgresql.org/docs/8.0/static/ddl-inherit.html
"A serious limitation of the inheritance feature is that indexes
(including unique constraints) and foreign key constraints only
apply to single tables, not to their inheritance children. This
is true on both the referencing and re
On Jul 17, 2005, at 5:35 AM, Michael Fuhr wrote:
See the inheritance documentation:
http://www.postgresql.org/docs/8.0/static/ddl-inherit.html
"A serious limitation of the inheritance feature is that indexes
(including unique constraints) and foreign key constraints only
apply to single tables
Hi,
Change it to a "BEFORE UPDATE" trigger, and set NEW.updated_date := now();
Otherwise each update produces another update produces another update
-Mark.
[EMAIL PROTECTED] wrote:
Can anybody help me creating a trigger on update trigger with update
statement as below.
This trigger fir
In article <[EMAIL PROTECTED]>, Andrus <[EMAIL PROTECTED]> wrote:
% > Then redesign this as a many to many relation. That way someone can
% > have access to one, two, three, four, or all departments.
%
% This means adding separate row for each department into permission table.
% If new department
Am Freitag, 15. Juli 2005 19:19 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > How can a function determine in which isolation level it runs?
>
> select current_setting('transaction_isolation');
Thank you for the hint.
I didn't find it myself because tab completion on SHOW doe
I am running PostgreSQL 8.0 on WinXP
When I try to connect
psql.exe" -h localhost -p 5432 template1 "postgres"
I have to wait
30 seconds before the Password: Prompt arrives
30 seconds after the password is entered.
Once I am connected access is fast. I figured the problem is Authentication.
a.
On Sun, Jul 17, 2005 at 12:38:48PM +0200, Sander Steffann wrote:
> >
> >"A serious limitation of the inheritance feature is that indexes
> >(including unique constraints) and foreign key constraints only
> >apply to single tables, not to their inheritance children. This
> >is true on both the refe
On UNIX this generally suggests a DNS configuration problem (can't
lookup 127.0.0.1 in DNS).
That's all I can help you with here...
Hope this helps,
On Fri, Jul 15, 2005 at 03:08:24PM +, Scott cox wrote:
> I am running PostgreSQL 8.0 on WinXP
> When I try to connect
>
> psql.exe" -h localh
"Scott cox" <[EMAIL PROTECTED]> writes:
> I am running PostgreSQL 8.0 on WinXP
> When I try to connect
> psql.exe" -h localhost -p 5432 template1 "postgres"
> I have to wait
> 30 seconds before the Password: Prompt arrives
> 30 seconds after the password is entered.
> Once I am connected access
> I'll report the results, for the record.
Okay, for the record, all went well. I re-initialise my PostgreSQL 7.4
database cluster using the following command:
initdb --locale=C --encoding UNICODE
Then, after defining the relevant groups and users, I used pg_restore to
restore my data from a dum
Hi,
>"A serious limitation of the inheritance feature is that indexes
>(including unique constraints) and foreign key constraints only
>apply to single tables, not to their inheritance children. This
>is true on both the referencing and referenced sides of a foreign
>key constraint."
I would r
On Sat, Jul 16, 2005 at 03:18:24PM -0700, Ron Mayer wrote:
> Jim C. Nasby wrote:
> >On Thu, Jul 14, 2005 at 11:29:23PM +0200, Martijn van Oosterhout wrote:
> >>On Thu, Jul 14, 2005 at 11:30:36AM -0500, Jim C. Nasby wrote:
> >>>On Wed, Jul 13, 2005 at 07:52:04PM -0400, Bruce Momjian wrote:
> >>>
> >
On Sun, Jul 17, 2005 at 10:33:58PM +0200, Sander Steffann wrote:
> I wish I knew enough about the internals of PostgreSQL to write one :-)
> Sander
Well, there are other TODO items that are much simpler, which would be a
great way to learn more about the internals. :) There's been talk of
creating
Dinesh Pandey wrote:
From where can I download?
"Postgres 8.x" + required packages and "installation instruction" of
Postgres for Fedora Core 2 OS.
Umm - did you try the website: http://www.postgresql.org/
Click "Downloads", click "FTP Browser", look in v8.03, linux, rpms,
fedora, fedor
15 matches
Mail list logo
