Hi List;
I'm populating a time dimension. I need to get the number of days
since the start of the fiscal year and also the number of months since
the start of the fiscal year based on the current 'date' being
processed.
Example:
my current process date is 01/01/2007
start date of fiscal
[EMAIL PROTECTED] ("Roberts, Jon") writes:
> I am moving from Windows to Solaris and I need pgcrypto and dblink.
> Where are these? I don't see anything in the configure that suggests it
> is even an option.
They are part of the set of "contrib" functions.
You head to directory "contrib", and, i
[EMAIL PROTECTED] ("W S") writes:
> I was asked this question, and I wasn't sure if it is possible:
>
>
> do you know of a way to stop just one database (not delete/drop) on
> our PostgreSQL 8.1 server?
>
>
> And, while I know how to shut down postmaster, and/or put in rules to
> pg_hba.conf to lim
On Thu, Apr 10, 2008 at 3:00 PM, Marcelo de Moraes Serpa
<[EMAIL PROTECTED]> wrote:
> Thank you for the replies,
>
> Actually I did not change the port number. For some bizarre reason, the
> pgsql 8.1 debian package comes with port 5433 pre-configured and this was
> exactly was causing the problem,
On Thu, Apr 10, 2008 at 06:00:30PM -0300, Marcelo de Moraes Serpa wrote:
> Thank you for the replies,
>
> Actually I did not change the port number. For some bizarre reason, the
> pgsql 8.1 debian package comes with port 5433 pre-configured and this was
> exactly was causing the problem, of course
Thank you for the replies,
Actually I did not change the port number. For some bizarre reason, the
pgsql 8.1 debian package comes with port 5433 pre-configured and this was
exactly was causing the problem, of course, I wasn't noting that the port
was different, but they are so similar (that's what
> > I am moving from Windows to Solaris and I need pgcrypto and dblink.
> > Where are these? I don't see anything in the configure that
suggests
> it
> > is even an option.
>
> They're not handled by 'configure'. They are in the 'contrib'
> directory in the source tree, and you install them by
Did you purposely change the default port? Are you specifying the
change in pgadmin? If the pg_hba.conf file is the problem, pgadmin will
tell you with a message like:
FATAL: no pg_hba.conf entry for host "IPADDRESS", user "USER", database
"DATABASE", SSL ON/OFF
Are you getting a similar m
On Thu, Apr 10, 2008 at 1:26 PM, Marcelo de Moraes Serpa <
[EMAIL PROTECTED]> wrote:
> I can´t connect to my postgresql8.1 server running on Debian. The pgadmin
> client says it can't connect. I already edited the pg_hba.conf and
> postgresql.conf (listen_addresses = '*' and port) but the problem
On 4/10/08, Gong <[EMAIL PROTECTED]> wrote:
>
>
> In the java code below, I set the transaction isolation to serialization.
>
> public class IsolationTest {
>
> private static String select = "select * from tmp where url = 'aaa'";
>
> public static void main(String[] args) throws Exception{
On Thu, Apr 10, 2008 at 3:46 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
> I am moving from Windows to Solaris and I need pgcrypto and dblink.
> Where are these? I don't see anything in the configure that suggests it
> is even an option.
They're not handled by 'configure'. They are in the 'con
Roberts, Jon escribió:
I am moving from Windows to Solaris and I need pgcrypto and dblink.
Where are these? I don't see anything in the configure that suggests it
is even an option.
Jon
They are contribs, you have to install them after pgsql
smime.p7s
Description: S/MIME Cryptographic
I can´t connect to my postgresql8.1 server running on Debian. The pgadmin
client says it can't connect. I already edited the pg_hba.conf and
postgresql.conf (listen_addresses = '*' and port) but the problem remains,
pg_admin is running on a XP machine without Firewalls enabled, Debian is
also not
I am moving from Windows to Solaris and I need pgcrypto and dblink.
Where are these? I don't see anything in the configure that suggests it
is even an option.
Jon
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
On Apr 10, 2008, at 2:37 PM, Craig Ringer wrote:
I haven't checked whether pg_hba.conf rules are reloaded, but `pg_ctl
reload' can re-read some settings without a postmaster restart. So you
might be able to disallow access in pg_hba then reload.
I'd be curious to know if that works and if/how i
In the java code below, I set the transaction isolation to serialization.
public class IsolationTest {
private static String select = "select * from tmp where url = 'aaa'";
public static void main(String[] args) throws Exception{
//ConncetionFactory is a factory class for managi
On Thu, Apr 10, 2008 at 05:20:21PM +0100, William Temperley wrote:
> SELECT count(*) AS frequency, score,
> SELECT count(uid) FROM scoretable st2 WHERE st2.score <=
> st1.score) - count(*)) + (count(*)/2))::float/(select
> count(*) from scoretable))
>
> FROM scoretable st1
> GROUP BY score
> O
W S wrote:
> Greetings,
>
> I was asked this question, and I wasn't sure if it is possible:
>
>
> do you know of a way to stop just one database (not delete/drop) on
> our PostgreSQL 8.1 server?
One possible way:
You can update its pg_database record, setting datallowconn to 'f' to
disable new
What do you hope to get out of this that you wouldn't get out of locking
out access?
On Thu, 10 Apr 2008, W S wrote:
Greetings,
I was asked this question, and I wasn't sure if it is possible:
do you know of a way to stop just one database (not delete/drop) on
our PostgreSQL 8.1 server?
An
On Thu, Apr 10, 2008 at 11:25 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 10, 2008 at 5:45 AM, CMOS <[EMAIL PROTECTED]> wrote:
> > hi,
> > i would like to get services of postgresql from inside the process (to
> > use it as a library and linking to it), i.e not having a separate
Greetings,
I was asked this question, and I wasn't sure if it is possible:
do you know of a way to stop just one database (not delete/drop) on
our PostgreSQL 8.1 server?
And, while I know how to shut down postmaster, and/or put in rules to
pg_hba.conf to limit access to a certain database, is
Hello,
they're the 2 available ODBC drivers for PG, which one is better to use.
If they're equals, what are the circumstances to use one over the other.
Thanks
Bruno Lavoie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
On Thu, Apr 10, 2008 at 4:36 PM, Osvaldo Rosario Kussama
<[EMAIL PROTECTED]> wrote:
>
> Try:
>
> SELECT count(*) AS frequency, score,
> count((SELECT * FROM scoretable st2 WHERE st2.score <= st1.score)) AS
> runningtotal
> FROM scoretable st1
> GROUP BY score
> ORDER BY score
>
> Osvaldo
>
"Andrus" <[EMAIL PROTECTED]> writes:
> 1. SQL assumes that CHARACTER(n) column is always padded with spaces in
> right.
> So casting to text should preserve spaces.
No, it should not. In CHAR(n), trailing spaces are semantically
insignificant; 'foo' and 'foo ' are considered equal. In TEXT
they
On Apr 10, 2008, at 3:13 AM, Andrus wrote:
Albe,
select * from test where tc=' '::text;
Because the arguments to the operator "=" are of different type,
implicit type conversion takes place.
"character(1)" will by converted to "text", during this conversion
trailing blanks will be ignored, as
On Thu, Apr 10, 2008 at 11:13:33AM +0300, Andrus wrote:
> 1. SQL assumes that CHARACTER(n) column is always padded with spaces in
> right.
> So casting to text should preserve spaces.
> Why PostgreSQL cast to text violates SQL ?
It says it is padded with spaces, but it also says that these spaces
Stefan Schwarzer wrote:
I tried now for weeks to get postgres & postgis going on my machine, in
vain... Lots of frustration has been built up, lots of energy went into
it... But nothing goes... I mean, postgres is running, postgis is
installed, but it constantly craches, doesn't accept shp2pgsq
William Temperley escreveu:
Hi all
I'm trying to calculate the percentile rank for a record based on a
'score' column, e.g. a column of integers such as:
23,77,88,23,23,23,12,12,12,13,13,13
without using a stored procedure.
So,
select count(*) as frequency, score
from scoretable
group by score
On Thu, Apr 10, 2008 at 5:45 AM, CMOS <[EMAIL PROTECTED]> wrote:
> hi,
> i would like to get services of postgresql from inside the process (to
> use it as a library and linking to it), i.e not having a separate
> postgresql process and communicating with it. Is this possible?
No.
> if possibl
On Wednesday 09 April 2008 14:56, Greg Sabino Mullane wrote:
> > I see the following in the documentation for pg_trigger related
> > to tgenabled: "Controls in which session_replication_role modes the
> > trigger fires. O = trigger fires in "origin" and "local" modes,
> > D = trigger is disabled, R
On Apr 7, 11:14 am, [EMAIL PROTECTED] (Alan Hodgson) wrote:
> On Monday 07 April 2008, Dan99 <[EMAIL PROTECTED]> wrote:
>
> > Does TRUNCATE TABLE keep all necessary table
> > information such as indexes, constraints, triggers, rules, and
> > privileges?
>
> Yes. It does require an exclusive lock on
Albe,
>> select * from test where tc=' '::text;
>Because the arguments to the operator "=" are of different type,
>implicit type conversion takes place.
>"character(1)" will by converted to "text", during this conversion
>trailing blanks will be ignored, as befits the "character(n)" type.
Thank y
hi,
i would like to get services of postgresql from inside the process (to
use it as a library and linking to it), i.e not having a separate
postgresql process and communicating with it. Is this possible? if
possible what are the impact on licensing.
thank you
--
Sent via pgsql-general mailing l
Volkan YAZICI <[EMAIL PROTECTED]> writes:
> On Thu, 10 Apr 2008, "Roberts, Jon" <[EMAIL PROTECTED]> writes:
>> I don't see a pljava file in my share directory like I do on Windows.
>> Is pl/java not included when compiling from source?
> PL/java[1] is a separate PL project, not builtin to PostgreS
On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <[EMAIL PROTECTED]> wrote:
> Anyway I am a little surprised by this thing cause I thought that in a case
> like this the habgs should happen only at commit/rollback time.
>
I think that's because Postgres does not have deferred constraint checks.
Th
I tried now for weeks to get postgres & postgis going on my machine,
in vain... Lots of frustration has been built up, lots of energy went
into it... But nothing goes... I mean, postgres is running, postgis is
installed, but it constantly craches, doesn't accept shp2pgsql imports
etc...
S
laser <[EMAIL PROTECTED]> writes:
> when I do a:
> execute 'set search_path to bar; create table foo(f1 int);insert into
> table foo blah..blah;'
> in plpgsql, I found that the insert statement always report that "can't
> found table foo" or something
> like that.
Well, yeah. The whole stri
Hi all
I'm trying to calculate the percentile rank for a record based on a
'score' column, e.g. a column of integers such as:
23,77,88,23,23,23,12,12,12,13,13,13
without using a stored procedure.
So,
select count(*) as frequency, score
from scoretable
group by score
order by score
Yields:
frequ
Richard, I was convinced that it was not necessary to provide detailed
SQL to not introduce any noise in the information I was giving to the list.
Anyway you proved right at last, since trying to sample some sql to make
others able to reproduce the problem we were also able to identify the
cause
On Thu, 10 Apr 2008, "Roberts, Jon" <[EMAIL PROTECTED]> writes:
> I am migrating an 8.3 database from Windows to Solaris. We are using
> pl/java and I went through the installation process for this on Windows.
>
> I'm building Solaris from the source and when running ./configure, I
> don't see a
Roberts, Jon napsal(a):
I don't see a pljava file in my share directory like I do on Windows.
Is pl/java not included when compiling from source?
pl/java is not part of core like pl/pgPerl... You need to download it separately
from http://pgfoundry.org/projects/pljava/
Zden
On Thu, Apr 10, 2008 at 5:31 AM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
> I am migrating an 8.3 database from Windows to Solaris. We are using
> pl/java and I went through the installation process for this on Windows.
>
> I'm building Solaris from the source and when running ./configure, I
> don'
I am migrating an 8.3 database from Windows to Solaris. We are using
pl/java and I went through the installation process for this on Windows.
I'm building Solaris from the source and when running ./configure, I
don't see a switch to include pl/java. Java is in my path too so it
should allow me
thanks, it works
A. Kretschmer schrieb:
am Thu, dem 10.04.2008, um 13:32:04 +0200 mailte Thomas Markus folgendes:
hi list,
how can i set a variable, which content is only visible in current
transaction?
i know the way to create a temp table with
create temp table ... on commit drop
but
Kevin Martins wrote:
> Hello everybody,
> First off all I am new in postgres but allready got some questions. It's
> possible to wirte in a file from postgres?
First off, if you write to a mailing list you should first learn how to
write an e-mail. Really.
Core PostgreSQL does not have such a fu
am Thu, dem 10.04.2008, um 13:32:04 +0200 mailte Thomas Markus folgendes:
> hi list,
>
> how can i set a variable, which content is only visible in current
> transaction?
> i know the way to create a temp table with
>
> create temp table ... on commit drop
>
> but i dont like that way. somethi
hi list,
how can i set a variable, which content is only visible in current
transaction?
i know the way to create a temp table with
create temp table ... on commit drop
but i dont like that way. something like
|
set_config(setting_name, new_value, is_local)
is it possible?
regards
thomas
|
I am using Navicat to transfer data from one database to another.
But it soon gives me an error message like the following:
I think you'll probably have to ask the navicat people.
If you want to use pg_dump to transfer data from 8.1 to 8.2 though,
use the version of pg_dump that ships with 8
Michael Raven wrote:
Hello everybody.
I've got some kind of PostgreSQL copyright related question.
Our company is developing an commercial product for PostgreSQL administration.
We want to include some utilities (i.e. pg_dump.exe, pg_restore.exe etc)
from PostgreSQL for Windows installation pac
hi all,
when I do a:
execute 'set search_path to bar; create table foo(f1 int);insert into
table foo blah..blah;'
in plpgsql, I found that the insert statement always report that "can't
found table foo" or something
like that. I guess it's visibility rule in PostgreSQL, but I can't found
cl
In any case, it's obvious in your screenshot that you left the "server" and
"location" fields blank in the connection setup form. This is most likely
the cause of your problem.
*doesnt work either..OLE-DB error persists. thanks for the readmefile.
*
On Wed, Apr 9, 2008 at 8:04 PM, Craig Ringer <[E
51 matches
Mail list logo
