On Fri, Jan 31, 2003 at 11:13:04 +0100,
Jaume Teixi <[EMAIL PROTECTED]> wrote:
> how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ?
If you are using psql, use the \copy command.
---(end of broadcast)---
TIP 2: you
On Mon, Jan 27, 2003 at 21:23:01 -0800,
Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> On Tue, 28 Jan 2003, Christopher Kings-Lynne wrote:
>
> > I just noticed you can do this:
> >
> > create table blah (
> > a not null references test on delete set null
> > )
> >
> > Should that be prevented
On Sun, Jan 26, 2003 at 00:01:04 -0500,
Rod Taylor <[EMAIL PROTECTED]> wrote:
> They work the same as table constraints with in-line declaration (no
> comma).
OK. But the documentation implies there is a comma, so it should probably
get chenged then.
This is from the create domain documentation
I am trying to create a domain with more than one check constraint and
I am getting an error that I don't think is correct according to the
documentation. I am not sure if this is a limitation of a partially
implemented feature or a bug that has so far been overlooked.
For example:
area=# create d
I have a specific proposal for allowing for building cube values from
float8 values with building strings (which will typically lose information).
I want to add the following 4 overloaded functions:
cube(float8)
cube(1) returns '(1),(1)'::cube
cube(float8,float8)
cube(1,2) returns '(1),(2)'::
On Fri, Jan 17, 2003 at 13:39:11 -0500,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
> So it would be possible to say for example:
>
> select min(column1),lookup_min(column1,column2) from tab
>
> to do the equivalent of:
>
> select column1,column2 where column1=(select min(column1) from tab) limit
On Sat, Nov 30, 2002 at 18:23:56 -0500,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
> It seems like this should be an important optimization given the number of
> applications that request max(foo) in a broken attempt to implement sequences.
> Occasionally it's not even a broken attempt too.
This h
On Thu, Nov 21, 2002 at 17:30:10 +0100,
David Pradier <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm new on this list, my name is David Pradier, and i'm french.
>
> I'm currently trying the new postgresql 7.3rc1, and i've noticed that if
> i compared an integer to an empty string, i ran in an error.
On Sun, Nov 17, 2002 at 15:19:54 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > For 7.4 I would like to add a function for importing float8 values
> > into cube. But because the cube data type is variable length I am
> &
For 7.4 I would like to add a function for importing float8 values
into cube. But because the cube data type is variable length I am
not sure what a good approach would be.
Currently this can be poorly done using text as an intermediate type.
As far as I can tell functions can't take sets as argum
On Thu, Nov 14, 2002 at 17:00:30 +,
snpe <[EMAIL PROTECTED]> wrote:
> On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
> > On Thu, Nov 14, 2002 at 16:49:42 +,
> >
> > snpe <[EMAIL PROTECTED]> wrote:
> > > I want that 'create o
On Thu, Nov 14, 2002 at 16:49:42 +,
snpe <[EMAIL PROTECTED]> wrote:
>
> I want that 'create or replace view' work drop-create if view exists else only
> create
Why do you want this?
---(end of broadcast)---
TIP 5: Have you checked our extens
On Thu, Nov 14, 2002 at 13:41:18 +,
snpe <[EMAIL PROTECTED]> wrote:
> Hello,
> When I change view and change number of column PostgreSQL return error :
> 'cannot change number of column in view'
> Is it too hard set this command
> if view exits drop view
> and then change view
>
> It is li
On Thu, Nov 07, 2002 at 13:44:11 -0400,
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>
> I haven't noticed any 'drag' so far this release ... we had a long beta
> between 2 and 3, but 3->4 and 4->5 have been really short (so short that 4
> didn't exist) ...
I managed to be running beta 4 for a
On Sat, Nov 02, 2002 at 01:01:11 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> The example of a serial column (DEFAULT nextval('foo_seq')) seems
> compelling. You do not really want to grant general-purpose UPDATE
> rights on foo_seq to everyone you might allow to INSERT into your
> table.
If
On Fri, Nov 01, 2002 at 21:35:40 -0500,
Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> I think we open up more security problems by having the inserter doing
> things as the owner of the table.
With triggers it is a bit hard to decide. Since people other than the
table owner can create them, but
On Thu, Oct 31, 2002 at 12:58:21 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> But I think an EXTRA_DIGITS setting might be interesting. In
> particular, suppose we allowed EXTRA_DIGITS to be negative? Setting
> it to -1 or -2 would go a long way towards eliminating our problems
> with platfo
On Thu, Oct 31, 2002 at 11:15:31 -0500,
Rod Taylor <[EMAIL PROTECTED]> wrote:
>
> Yes, default expressions and check constraints could possibly. However,
> both revoke complex expressions (no sub-selects, etc) so there is little
> point.
I disagree. They can call functions which can do unexpec
On Thu, Oct 31, 2002 at 10:17:26 -0500,
Rod Taylor <[EMAIL PROTECTED]> wrote:
> Can't necessarily run them as the table owner, as it may give
> information to other users with the ability to ALTER that table.
You have to be the table owner to alter a table. So it should be OK
to have the default
Constraints also run as the user modifying a table instead of the table
owner.
Again I don't see a good reason to want to execute constraints as the
user modifying a table. But I do think there can be reasons to want to
execute them as the table owner.
To summarize, my suggestion for change is:
E
On Wed, Oct 30, 2002 at 14:03:21 -0600,
>
> While I am not sure about triggers, it certainly is possible to get
> a similar effect be having the referenced function run with the security
> of the definer.
I read some more on triggers and found that according to the documentation,
they appear to r
On Wed, Oct 30, 2002 at 08:27:37 -0600,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> Do default expressions execute with access of the user doing the insert
> or the owner of the table?
> What I was thinking was that the owner of a table may want to allow people
> to do insert
On Wed, Oct 30, 2002 at 19:27:57 +0100,
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
>
> The printf("%A") output is not system-specific.
Just out of curiosity, can you tell me a web page or keywords to use
in a search to see what that format does? I tried using google, but
searching for printf w
On Tue, Oct 29, 2002 at 23:19:05 +0100,
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
>
> There isn't a way right now, but it's planned to be able to dump
> floating-point numbers in some binary form (like printf("%A")) to be able
> to restore them exactly. Not sure how that would satisfy the nee
On Sat, Oct 26, 2002 at 01:04:55 -0400,
Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> The per db/user stuff is stored in the pg_database/pg_shadow tables per
> row, so they exist in permanent storage.
I have a question about this. This stuff is per user OR per db right?
When I see per db/user I
On Wed, Oct 23, 2002 at 18:04:01 +0200,
Hans-Jürgen Schönig <[EMAIL PROTECTED]> wrote:
>
> An example:
> I have a join across 10 tables + 2 subselects across 4 tables
> on the machine I use for testing:
>planner: 12 seconds
>executor: 1 second
>
> The application will stay the same for
On Tue, Oct 22, 2002 at 19:01:20 +0200,
Kaare Rasmussen <[EMAIL PROTECTED]> wrote:
> > Schema handling - ready? interfaces? client apps?
>
> What is the state of the Perl interface?
>
> Will it work when 7.3 is released
> Will it work, but no schema support
> Will it pop up later on CPAN
I am
On Tue, Oct 22, 2002 at 17:05:38 +0200,
Igor Georgiev <[EMAIL PROTECTED]> wrote:
> Is there any way to prevent superuser to acces the database ?
> I mean something like "GRANT / REVOKE CONNECT" MECHANISM
>
> I have no idea how to prevent root from access data in one of this ways :
> root @ l
On Sun, Oct 20, 2002 at 10:50:59 -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> When I try to grant usage on language c in 7.3b1 I get an error message
> saying I can't because the language isn't trusted. Is this different in b2?
> I can see using whether or not a l
On Sat, Oct 12, 2002 at 12:43:37 +0300,
Antti Haapala <[EMAIL PROTECTED]> wrote:
>
> > I cannot think of any reason why changing column order should be
> > implemented in Postgres. Seems like a waste of time/more code bloat for
> > something which is strictly asthetic.
>
> What about copy? AFAI
> > AFAICT, earthdistance is nowhere near passing yet :-(. It looks to
> > me like the regression test is depending on the cube-based features
> > that we decided to hold off for 7.4. Bruno, is that right?
>
> It shouldn't be. When I resubmitted the patch I intended to take out
> all of the cub
On Tue, Sep 24, 2002 at 23:57:29 -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > How do I run the regression tests for /contrib stuff?
>
> make
> make install
> make installcheck
>
> AFAICT, earthdistance is nowhere near passing yet :-(. It looks to
On Tue, Sep 24, 2002 at 16:10:19 -0400,
Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III wrote:
> > On Tue, Sep 24, 2002 at 15:02:20 -0500,
> > Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > >
> > > There is supposed to be a regression
On Tue, Sep 24, 2002 at 15:02:20 -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
>
> There is supposed to be a regression test. I may have forgotten to use
> -N or -r on the diff. If it is confirmed that the files needed for the
> regression test didn't make it into
On Tue, Sep 24, 2002 at 10:43:51 -0700,
Joe Conway <[EMAIL PROTECTED]> wrote:
> The Makefile for contrib/earthdistance indicates that there should be a
> regression test, but the files seem to be missing from CVS. The change to
> the
> Makefile was made here:
>
>
>http://developer.postgresql.
I am almost done. While working on the regression test I found a significant
bug in the original earth distance package, so this really does need to
get updated. While I was doing that I switched it to use the haversine
formula as that is more accurate for short distances than the formula
they use
+
+ Minor updates to this package were made by Bruno Wolff III <[EMAIL PROTECTED]>
+ in August of 2002.
+
+ These include changing the precision from single precision to double
+ precision and adding some new functions.
diff -c -r -N --exclude=CVS cube/cube
On Thu, Aug 29, 2002 at 10:53:12 -0300,
Paul Cowan <[EMAIL PROTECTED]> wrote:
> I do not know if this is the right list for this question but I am at
> the end of my rope. I have migrated a number of database into postgres
> and every thing seems to be working fine as far as the data is
> con
On Mon, Aug 19, 2002 at 22:35:26 -0700,
>
> Most computer virus problems are caused by buffer overrun. Someone
> decided it wasn't very important.
I disaggree with this. Most computer viruses that I see are rely on
poorly designed software and poorly trained users to propagate.
Buffer overruns
On Fri, Jul 26, 2002 at 10:48:53 -0300,
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>
> Something to maybe add to the TODO list, if someone has the
> time/inclination to work on it ...
>
> The problem with the current auth system, as I see it, is that you can't
> easily have seperate user li
On Thu, Jun 13, 2002 at 11:39:55 -0400,
Chris McCormick <[EMAIL PROTECTED]> wrote:
> Thanks for reading. A few disclaimers:
>
> MY PROBLEM - Because this site deals with, among other things, ancient
> art, acheaology, and anthropology, I need a way to handle dates as
> specific as a single d
301 - 341 of 341 matches
Mail list logo