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 make
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
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
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 adamr...@mac.com writes:
Always test your performance assumptions. The plpgsql function is
faster than the sql function, a lot
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
,
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 from the
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:
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 Spng Arthursson wrote:
Hi!
I would like to know if it's possible to give a priority order of
how
to sort
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
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 with a database
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:28 AM, Russ Schneider wrote
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:
In article [EMAIL
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 companies and organizations
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 modify
to see how it compares to this.
Adam Ruth
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
. 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 Ruth
---(end of broadcast
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
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'm trying to copy data into a
22 matches
Mail list logo