On Tue, 2015-08-25 at 15:41 +, Neil Tiffin ne...@neiltiffin.com
wrote:
I really like the standardization that PostgreSQL uses in auto
generating default names. The rule I use is to always use the auto
generated names unless the object is referenced routinely in code. In
most cases
On Mon, Jun 08, 2009 at 08:08:02PM +0100, Oliver Kohll - Mailing Lists wrote:
On 8 Jun 2009, at 17:23, Merlin Moncure mmonc...@gmail.com wrote:
Is there a way when creating a table to limit it to one row? That
is,
without using a stored procedure?
I searched the documentation, but didn't
On 8 Jun 2009, at 17:23, Merlin Moncure mmonc...@gmail.com wrote:
Is there a way when creating a table to limit it to one row? That
is,
without using a stored procedure?
I searched the documentation, but didn't find anything.
CREATE TABLE x (...);
CREATE UNIQUE INDEX x_only_one_row ON
Network
Debian GNU/Linux Consultant
- Forwarded message from [EMAIL PROTECTED] -
Date: Thu, 27 Mar 2008 05:56:10 -0300
Envelope-to: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Subject: [GENERAL] [pgsql-general] Daily digest v1.8030 (22 messages)
X-Mailing
[EMAIL PROTECTED] wrote:
Message Digest
Volume 1 : Issue 8030 : index Format
Messages in this Issue:
200803/1324: Re: casting from integer to boolean
200803/1325: Re: casting from integer to boolean
200803/1326: Re: casting from integer to boolean
200803/1327: Re: Survey:
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee [EMAIL PROTECTED] wrote:
I received eight of these unwanted digests last night and early this
morning, after never seeing them before. Is this a new configuration
change that I need to go personalize?
I was wondering the same thing, but
Brett Hoerner [EMAIL PROTECTED] writes:
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee [EMAIL PROTECTED] wrote:
I received eight of these unwanted digests last night and early this
morning, after never seeing them before. Is this a new configuration
change that I need to go personalize?
Tom Lane wrote:
Brett Hoerner [EMAIL PROTECTED] writes:
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee
[EMAIL PROTECTED] wrote:
I received eight of these unwanted digests last night and early
this morning, after never seeing them before. Is this a new
configuration change that I need to go
-general-owner+m130868
From: [EMAIL PROTECTED]
Newsgroups: pgsql.general
Subject: [pgsql-general] Daily digest v1.8030 (22 messages)
Date: Thu, 27 Mar 2008 05:56:10 -0300
Organization: Hub.Org Networking Services
Lines: 38
Sender: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
NNTP-Posting-Host
Message Digest
Volume 1 : Issue 8033 : index Format
Messages in this Issue:
200803/1382: Re: Using tables in other PostGreSQL database
200803/1383: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1384: Re: Timezones in 8.2.7
200803/1385: Re:
Message Digest
Volume 1 : Issue 8030 : index Format
Messages in this Issue:
200803/1324: Re: casting from integer to boolean
200803/1325: Re: casting from integer to boolean
200803/1326: Re: casting from integer to boolean
200803/1327: Re: Survey: renaming/removing script binaries
Message Digest
Volume 1 : Issue 8032 : index Format
Messages in this Issue:
200803/1364: very delayed autovacuum on certain tables
200803/1365: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1366: Re: Performance of update
200803/1367: Re: casting
Message Digest
Volume 1 : Issue 8031 : index Format
Messages in this Issue:
200803/1346: Re: RULES and QUALIFICATION for INSERT
200803/1347: Re: How to use database?
200803/1348: Re: RULES and QUALIFICATION for INSERT
200803/1349: Performance of update
200803/1350: Re: Performance of
Message Digest
Volume 1 : Issue 8034 : index Format
Messages in this Issue:
200803/1400: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1401: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1402: Re: Survey: renaming/removing
Message Digest
Volume 1 : Issue 8036 : index Format
Messages in this Issue:
200803/1440: Re: Need help on how to backup a table
200803/1441: Persistent user-defined functions
200803/1442: Merge Joins and Views
200803/1443: Re: Persistent user-defined functions
200803/1444: PL/pgSQL
Message Digest
Volume 1 : Issue 8035 : index Format
Messages in this Issue:
200803/1421: Re: Survey: renaming/removing script binaries
(createdb, createuser...)
200803/1422: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1423: Re: Using tables in other
Message Digest
Volume 1 : Issue 8037 : index Format
Messages in this Issue:
200803/1458: Delete after trigger fixing the key of row numbers
200803/1459: Re: SELECT DISTINCT ON and ORDER BY
200803/1460: Re: SELECT DISTINCT ON and ORDER BY
200803/1461: Re: SELECT DISTINCT ON and ORDER BY
On Sat, 2006-04-11 at 06:13 -0400, [EMAIL PROTECTED]
wrote:
Date: Fri, 3 Nov 2006 23:08:47 +0100
From: Alexander Staubo [EMAIL PROTECTED]
To: PgSQL General pgsql-general@postgresql.org
Subject: Per-row security
Message-ID: [EMAIL PROTECTED]
I am designing an application which requires
On Nov 6, 2006, at 21:00 , Marc Munro wrote:
A fairly cursory look at your proposed model suggests that it will
work,
but is likely to have serious performance problems. The issue is
not so
much the simple queries on single views, but the complex queries your
developers will almost
On Nov 6, 2006, at 21:00 , Marc Munro wrote:
For an alternative approach, you might want to check out Veil:
http://pgfoundry.org/projects/veil
Addendum: I took Veil to be undocumented since the source archive
only comes with Doxygen scripts; I thought the small here link on
the Veil home
Sylvain,
All of the things you want to do can be done using Veil:
http://veil.projects.postgresql.org/
Be warned though, it is not simple. If you want privileges at the
column level, or based on a where clause, you will have to use
techniques like Veil's secured views.
It's better to avoid this
Florian,
Reponses from, an ex-Oracle DBA, below.
On Mon, 2005-10-24 at 11:51 -0300, [EMAIL PROTECTED]
wrote:
Date: Mon, 24 Oct 2005 14:29:24 +0200
From: Florian Ledoux [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Subject: pg_dump, MVCC and consistency
Message-ID: [EMAIL PROTECTED]
Nikolay,
I think I must be missing your point. Even if updatable views existed,
I would still have created Veil. The real point of Veil is to control
each type of operation (insert, update, etc) on each record.
With updatable views, you could avoid a lot of the tedium of creating
the instead-of
Brew,
Yep we tried that. It did nothing. The same pg_hba.conf change worked
when we later tried it with the client disconnected.
__
Marc
Date: Fri, 16 Sep 2005 21:36:01 -0400 (EDT)
From: [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Subject: Re: pg_ctl reload breaks our client
How does one receive all mail to this list in a daily digest?
-Andrew
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
# [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
How does one receive all mail to this list in a daily digest?
Have you read the mailing list usage notes on the web site?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't
set pgsql-general digest
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
How does one receive all mail to this list in a daily digest?
Have you read the mailing list usage notes on the web site?
---(end of
# [EMAIL PROTECTED] / 2005-07-27 10:03:15 -0400:
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
How does one receive all mail to this list in a daily digest?
Have you read the mailing list usage notes on the web site?
set pgsql-general digest
Yes, that's
Yeah.. I'm with you.. I don't really know what all of this is about - I
like the way the Postgres mailing list works as it is Are any of the
changes being discussed here going to change the content or how we
receive the mailing lists?..
What exactly is the problem they thing exists anyways?..
29 matches
Mail list logo