2. The short answer is No. I've got the same issue. I come from a
different sql that had a CREATE VARAIBLE which was good for the session.
With PostGres, I've created a sessionsettings table and a bunch of
functions to get by variable and use the value. My perceived downside
is that this
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
Tom,
We made most of our text, varchar columns citext data types so that we
could do case insensitive searches. Is this going to negate most of the
index searches? It appeared to our DBA that it would be easier to use
citext data type then need to use ILIKE instead?
Michael Gould
Intermodal
Tim,
It is my understanding that since the extention citext is available that
this gives you what your asking for and at least at this point isn't
going to be part of the core.
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
Original Message
Subject: Re:
I would like to see 2 features which I've found useful in other SQL
engines.
1. The ability to create global variables. The syntax is usually
something like
CREATE VARIABLE 'foo' integer;
There could be 1-n of these create.
2.
The ability for the system to automatically called a stored
There seems to be CREATE everything in Postgres but it would be really
nice to have a CREATE VARIABLE which would allow us to create global
variables. I know there are other techniques but this would be the
easiest when doing a init routine when a user logs in to the
application.
Best Regards
In some languges you can use set l_localid = @@identity which returns
the value of the identity column defined in the table. How can I do
this in Postgres 9.1
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
I am trying to convert stored procedures from SQL Anywhere to Postgres.
I am getting error
ERROR: syntax error at or near return
LINE 2: return integer AS
^
** Error **
ERROR: syntax error at or near return
SQL state: 42601
Character: 81
when I run this. I'm not
Thanks for all of the help. I will be doing some testing in VM's this
week before loading on my other server.
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
Original Message
Subject: Re: [GENERAL] what Linux to run
From: r d rd0...@gmail.com
Date: Mon, March
Our application runs on Windows, however we have been told that we can
pick any OS to run our server on. I'm thinking Linux because from
everything I've read, it appears to be a better on performance and there
are other features like tablespaces which we could take advantage of.
On our hosted
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
Andrew,
That is acutally what the second run was supposed to be. I copied the
original on instead of the second instance, but the results were the
same.
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
Original Message
Subject: Re: [GENERAL] problem trying
We are using it on a rather beefy server with no problems with a Win32
client/server app. There are additonal things you can do to tune the
database. I've not seen any stability problems. Remember it's been
several years since version 8 came out and the current version is 9.1.2.
Michael Gould
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
I am creating a rule which will copy a record when it is changed to a
audittable. My question is that the first column is a UUID data type
with a defined as auditaccessorid uuid DEFAULT
isscontrib.uuid_generate_v4() NOT NULL,
Right now I've got that set to NULL to allow the parser to compile.
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
text/html; charset="utf-8": Unrecognized
inline: top.letterhead
We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One of
the features that is really nice in ASA is the ability to add the attribute
hidden to a Create procedure, Create function and Create trigger. Essentially
what this does is encrypt the code so that if anyone or any
] Securing stored procedures and triggers
There's not bulletproof way, in my opinion.
If they copy the whole DB structure *and* the object binaries they'll
have the very same functionalities!
Il Wednesday 31 October 2007 16:13:23 Douglas McNaught ha scritto:
mgould [EMAIL PROTECTED] writes:
We
All,
I'm in the process of moving to PostGres from iAnywhere's SQL Anywhere v 10.
One of the neat features from ASA 10 is the ability to create proxy tables
These tables can be local or remote. The purpose of a proxy table is that once
create it can be used just like any other table or
26 matches
Mail list logo