et is
the following:
psql: FATAL: could not get token from SSPI security context
DETAIL: The function requested is not supported
(80090302)
Is anyone else experiencing problems with SSPI on Windows 7?
Cheers,
Adam Ruth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Good point, I should have specified 8.3.7.
Just one more reason to anxiously anticipate upgrading to 8.4.
On 30/05/2009, at 2:56 AM, Tom Lane wrote:
Adam Ruth writes:
Always test your performance assumptions. The plpgsql function is
faster than the sql function, a lot faster on smaller
Always test your performance assumptions. The plpgsql function is
faster than the sql function, a lot faster on smaller arrays.
unnest - 10 element array - 100,000 times: 6701.746 ms
unnest - 100 element array - 100,000 times: 11847.933 ms
unnest - 1000 element array - 100,000 times: 59472.691
I needed to do this just the other day, here's what I did:
create or replace function explode(_a anyarray) returns setof
anyelement as $$
begin
for i in array_lower(_a,1) .. array_upper(_a,1) loop
return next _a[i];
end loop;
return;
end;
$$ language plp
I've actually done this before. I had a web app with about 400 users
each with their own schema. It actually worked very well, except for
one thing. There got to be so many tables that a pg_dump would fail
because it would run out of file locks. We got around it by creating a
primary table
es. (#14)".
Thanks,
Adam Ruth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
One option is sc.exe command.
sc create postgresql binPath= "^"c:\scholarpack\postgres\bin
\pg_ctl.exe^" runservice -w -N ^"P4^" -D ^"c:\scholarpack\data^"" -
start auto
On 03/05/2009, at 9:32 PM, ga...@schoolteachers.co.uk wrote:
Anyone know how to install Postgresql as a windows service fr
Cygwin comes with rsync on Windows.
On 02/05/2009, at 4:06 AM, John R Pierce wrote:
Joshua D. Drake wrote:
Well that's just it. Out of the box it doesn't actually work.
PostgreSQL
only gives you the facilities to roll your own PITR solution. You can
look at PITR Tools:
https://projects.comm
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Amen to that. I have to use Oracle at work, but I use PostgreSQL for
all my side stuff. Man do I ever miss psql when I'm in SQL*Plus...
On Aug 18, 2004, at 12:29 PM, Andrew Rawnsley wrote:
If you use it enough, I think it is inevitable that something,
sometime, somewhere will really honk you
o
On May 20, 2004, at 12:19 PM, Stephan Szabo wrote:
On Thu, 20 May 2004, Adam Ruth wrote:
On May 20, 2004, at 11:20 AM, Stephan Szabo wrote:
On Tue, 11 May 2004, [ISO-8859-1] Victor SpÄng Arthursson wrote:
Hi!
I would like to know if it's possible to give a priority order of
how
to sor
On Apr 29, 2004, at 9:22 AM, Yannick LOUVET wrote:
hello,
i want to call a function (function1() for example )in an other
function.
simple,i guess :
PERFORM function1() ;
You will want to use EXECUTE instead (assuming var_function is a text
variable):
EXECUTE var_function;
You may need to
drop columns, all indexes need to be recreated. Again, not a problem in PSQL. You'll find times similar to Oracle and MS SQL (I've never directly compared them, but they feel about the same).
Regards,
Adam Ruth
On Feb 11, 2004, at 1:58 PM, Chris Fossenier wrote:
I currently have a client
That would depend on the client you're using. psql can do it either
directly (using \o) or by piping its output: psql -c "select * from
mytable;" mydb > out.txt
If you're using a programming library, I think you're on your own.
Adam Ruth
On Feb 8, 2004, at 10
dth.
Also, the same request goes for your response.
Thanks,
Adam Ruth
On Jan 21, 2004, at 11:28 AM, Gavin M. Roy wrote:
My problem is the threat from SCO is not from the bleachers so to
speak, but direct in writing :(
http://www.gavinroy.com/~gavinr/sco_threat.gif
Gavin
Harald Fuchs wrote:
Excellent response!
On Jan 21, 2004, at 3:50 PM, Gavin M. Roy wrote:
Here is a copy of the letter which I've sent out today:
http://www.gavinroy.com/~gavinr/SCO%20Response.pdf
We'll see their response and act accordingly. Thanks for all the
feedback everyone.
Gavin
Alex Satrapa wrote:
Gavi
On Jan 6, 2004, at 3:27 PM, Oliver Elphick wrote:
On Tue, 2004-01-06 at 22:06, Adam Ruth wrote:
1. Modifying the applications to use schemas instead of connecting to
specific databases. Getting the authors to use schemas so I do it
once.
One thing I'd suggest would be to modif
the rest of the
application wouldn't need to change. That's what I did when I did
something similar.
Adam Ruth
On Jan 6, 2004, at 12:39 PM, Roderick A. Anderson wrote:
I'm looking for some input on a configuration I'm implementing. The
long
term goal is to providing hosting for
ested it myself
yet to see how it compares to this.
Adam Ruth
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
27;s no way to get the
size of the column from the catalog. It does seem that the large
object functions do split the data into 2k chunks, but it would
probably be a simple thing to check the source to determine if this is
always true. But it could always change in a future version.
Adam
where loid = xxx order
by pageno;
Hope this help,
Adam Ruth
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
where loid = xxx order
by pageno;
Hope this help,
Adam Ruth
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
You can call currval on the sequence that provided the value for the primary key. It's guaranteed to be the last value retrieved from that sequence *for your session*.
insert into table1 (f1, f2) values ('a', 'b');
select currval('table1_seq');
Use the name of your sequence. If the primary key
on box, with
512 MB of RAM. The PostgreSQL machine was a Gateway ALR 1x600 Pentium III,
with 512 MB of RAM.
--
Adam Ruth
InterCation, Inc.
www.intercation.com
"Ned Lilly" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi Fabrice,
>
>
I've gotten that message before when users couldn't read the directory the
file is in.
--
Adam Ruth
InterCation, Inc.
www.intercation.com
"Felix Slager" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> LS,
>
> i'
25 matches
Mail list logo