Indeed.
Thanks for that! I keep getting bitten by that too hehe.
- Naz.
William Garrison wrote:
My guess is that integer division is to blame: 50 divided by 1500 =
0.03 which rounds to zero. You probably have to cast them to real
before doing the division.
Naz Gassiep wrote:
Is anyone able t
It was clear to me after 20 minutes of actually trying to use the OS that UAC
was a gimmick designed to supply plausible deniability for the fact that
Windows XP suffered so many problems with malware. They can simply ask "were
you using UAC?" every time someone complains that their box got inf
My guess is that integer division is to blame: 50 divided by 1500 = 0.03
which rounds to zero. You probably have to cast them to real before
doing the division.
Naz Gassiep wrote:
Is anyone able to tell me why in the last column of the returned result
set, the value calculated is always 0?
Is anyone able to tell me why in the last column of the returned result set,
the value calculated is always 0?
QUERY:
SELECT products.productid,
products.cost,
products.srp,
CASE WHEN products.srp > 0 THEN (products.srp - products.cost)
Hello,
My table 'orderitems' looks like this
create table orderitem (
id serial not null primary key,
item integer not null,
quantity numeric(6,2) not null,
unit varchar(10),
conference integer not null,
seller integer not null,
incharge integer not null,
orderdate date not null,
duedate date no
Hey Joshua,
I appreciate the insight. That's clear.
Thanks again,
Joshua D. Drake wrote:
Tom Lane wrote:
louis gonzales <[EMAIL PROTECTED]> writes:
As an example:
insertX which initiates the trigger reads the 'nextvalue' from the
sequence and begins to create the associcated table
Tom Lane wrote:
> louis gonzales <[EMAIL PROTECTED]> writes:
>> As an example:
>> insertX which initiates the trigger reads the 'nextvalue' from the
>> sequence and begins to create the associcated table
>> insertY happens almost at the same time, so that it gets the same
>> 'nextvalue' from the
:) , something that is analogous to a race condition. is this something
I shouldn't be concerned with?
I suppose if I knew for certain there was some kind of synchronous
behavior, then I wouldn't fear a potentially subsequent event completing
before the previous one doing so.
As a possible so
louis gonzales <[EMAIL PROTECTED]> writes:
> As an example:
> insertX which initiates the trigger reads the 'nextvalue' from the
> sequence and begins to create the associcated table
> insertY happens almost at the same time, so that it gets the same
> 'nextvalue' from the sequence
[ blink... ]
Randall Smith <[EMAIL PROTECTED]> writes:
> I'm at a loss as to how to remove the OF clause at the server. It it
> possible to do it with a rule?
No, because the syntax error will occur long before any rule has a
chance to get involved. You'd have to actually hack the C code
(see transformLocki
Hello List,
I want to write a statement-level trigger - one that happens once per
statement - such that, immediately after an insert into a table(which
gets a unique integer value as an ID from a defined sequence, being the
primary key on the table), a new table is created with foreign key
con
Erik Jones wrote:
This may be a dupe. I sent and had some issues with my mail client and
afterwards it was sitting all alone in my outbox, if you've already seen
this, sorry for the resend...
On Mar 14, 2007, at 2:08 PM, Randall Smith wrote:
Hi,
I'm attempting to process a query written in
"Alexi Gen" <[EMAIL PROTECTED]> writes:
> Since user01 is tagged to dba01 (who has the SUPERUSER option) - should'nt
> user01 also inherit this?
No, he has to actually SET ROLE to the superuser account to make himself
a superuser. SUPERUSER and the other non-GRANTable attributes of a role
don't
Hi,
I'm just wondering that does postgres have a time zone updater for the new
day time saving rule like java has?
(http://java.sun.com/javase/tzupdater_README.html). Or do I need to change
the time manually myself? If that is the case, if the time changes again
sometime in September then I wou
Erik Jones <[EMAIL PROTECTED]> writes:
> Basically I need a way for my script to know if it needs to
> abort because there were issues with the dump before it follows
> through with the drop db...
Well, just checking the exit status from pg_dump ought to give you at
least a go/no-go indicator.
Hi,
Please ignore my previous email.
Sorry,
Michael
_
From: Michael Su [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 15, 2007 6:43 PM
To: 'pgsql-general@postgresql.org'
Subject: About the new day-time saving rule
Hi,
I'm just wondering that does postgres have a time
How about using a try catch block?
isn't that more efficient that eval?
~Jas
On 3/15/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> Actually, if I rephrase my requirement, I need to catch an exception at
any
> point ,where ever it is raised, in th
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> Actually, if I rephrase my requirement, I need to catch an exception at any
> point ,where ever it is raised, in the perl code.
> E.g during an insert, there is a foreign key contraint violation, then i
> need to catch this specific error and do
Hi,
Actually, if I rephrase my requirement, I need to catch an exception at any
point ,where ever it is raised, in the perl code.
E.g during an insert, there is a foreign key contraint violation, then i
need to catch this specific error and do something with it.
Hope i make some sense here.
Thank
Dave Page wrote:
> Tom Lane wrote:
>> I have *no* interest in trying to get it to support an --output-version
>> switch...
>
> There speaks a man who has the luxury of not having to worry about
> multi-version admin tools :-(
I am afraid that I have to agree with Tom here. Pg_dump has plenty of
o
Alvaro Herrera wrote:
Dave Page escribió:
Paul Lambert wrote:
After install completes you can turn it back on... if you want -
personally I leave it off, it's an incredibly annoying "feature".
Doesn't the security center keep popping up to point out that it's
turned off?
You mean, like this
Porting it to Windows could be tricky though, given its use of symlinks
and wrapper scripts.
FWIW, as of Vista and Server Longhorn, Windows now supports Symlinks. I
don't know about wrapper scripts though.
--
Paul Lambert
Database Administrator
AutoLedgers
---(end
> --- Original Message ---
> From: Alvaro Herrera <[EMAIL PROTECTED]>
> To: Dave Page <[EMAIL PROTECTED]>
> Sent: 15/03/07, 22:32:50
> Subject: Re: [GENERAL] PgSql on Vista?
>
> Dave Page escribió:
> > Paul Lambert wrote:
> >
> > >After install completes you can turn it back on... if yo
On Thu, Mar 15, 2007 at 09:19:31PM +, Dave Page wrote:
> Even if we went through the insane pain (for me at least) of maintaining
> multiple branches of the Windows build of PostgreSQL, *and* custom
> builds of the utilities built against a single libpq, we still couldn't
> ship a single set
Dave Page escribió:
> Paul Lambert wrote:
>
> >After install completes you can turn it back on... if you want -
> >personally I leave it off, it's an incredibly annoying "feature".
>
> Doesn't the security center keep popping up to point out that it's
> turned off?
You mean, like this?
http:/
Hello, I'm currently working on an automated data archival script
that will dump an existing archive db, drop it, recreate it from a
template, and then fill it with any data ready to be archived from
our production db. My question here is: What is the format of the
warnings and/or errors
Martijn van Oosterhout wrote:
On Wed, Mar 14, 2007 at 08:09:24PM -0400, Kenneth Downs wrote:
What I have noticed is that once the innermost instance exits, none of
the outer instances execute any further, suggesting that the plperl
routine is not "re-entrant" (if I am using that term correct
Dave Page wrote:
Paul Lambert wrote:
After install completes you can turn it back on... if you want -
personally I leave it off, it's an incredibly annoying "feature".
Doesn't the security center keep popping up to point out that it's
turned off?
Regards Dave
Ahh, but there is an optio
Paul Lambert wrote:
After install completes you can turn it back on... if you want -
personally I leave it off, it's an incredibly annoying "feature".
Doesn't the security center keep popping up to point out that it's
turned off?
Regards Dave
---(end of broadcast)--
Alvaro Herrera wrote:
Dave Page wrote:
Tom Lane wrote:
I have *no* interest in trying to get it to support an --output-version
switch...
There speaks a man who has the luxury of not having to worry about
multi-version admin tools :-(
Is it more difficult for you to ship a pg_dump-8.0, pg_dum
Arkan wrote:
Hi all,
have anybody installed PgSQL on Windows Vista? I tried yesterday but I
fail... on XP and linux i've installed pgsql much times but on
vista... nothing to do! Version in 8.2.3 with the installer.
If I install with my user account (with administrative rights), the
installlat
Richard Huxton wrote:
William Garrison wrote:
I am writing scripts to create a database that I want to run in my
development, testing, and production environments. That means I need
to be able to do something like
IF
CREATE TABLESPACE foo LOCATION E'C:\database';
ELSE
CREATE TABLESPACE
Martijn van Oosterhout wrote:
On Thu, Mar 15, 2007 at 09:11:23PM +0100, Florian G. Pflug wrote:
You'd need a type for large integers first - otherwise your
ty_fraction will be quite limited. I think numeric could be
used for that, though I don't know if numeric guarantees that
at least the opera
On Mon, Mar 12, 2007 at 12:53:11 -0700,
Mike <[EMAIL PROTECTED]> wrote:
>
> How do I get access to the total of all clicks on per row basis so I
> can divide it? The only solution that comes to my mind is create a
> subquery that does a (select count(*) from... where... ) of the
> original group
On 3/15/07, Robert Treat <[EMAIL PROTECTED]> wrote:
Do you find this works well? I've used it from some older Oracle instances
connecting back into PostgreSQL and the results I had have been flakey at
best.
It really just depends on the data types in use... but I've never
really had anything I
On Mon, Mar 12, 2007 at 11:15:01 -0700,
Stefan Berglund <[EMAIL PROTECTED]> wrote:
>
> I have an app where the user makes multiple selections from a list. I
> can either construct a huge WHERE clause such as SELECT blah blah FROM
> foo WHERE (ID = 53016 OR ID = 27 OR ID = 292 OR ID = 512) or I
Dave Page wrote:
> Tom Lane wrote:
> >I have *no* interest in trying to get it to support an --output-version
> >switch...
>
> There speaks a man who has the luxury of not having to worry about
> multi-version admin tools :-(
Is it more difficult for you to ship a pg_dump-8.0, pg_dump-8.1, etc
a
Tom Lane wrote:
I have *no* interest in trying to get it to support an --output-version
switch...
There speaks a man who has the luxury of not having to worry about
multi-version admin tools :-(
/D
---(end of broadcast)---
TIP 4: Have you sear
http://www.postgresql.org/docs/8.2/static/datatype-geometric.html
Have you looked at these yet? If not, you asked your question
prematurely and should have read the docs. If so, in what respect do
they not work for you?
On 3/15/07, Robin Ericsson <[EMAIL PROTECTED]> wrote:
On 3/15/07, Webb S
On Thu, Mar 15, 2007 at 09:11:23PM +0100, Florian G. Pflug wrote:
> You'd need a type for large integers first - otherwise your
> ty_fraction will be quite limited. I think numeric could be
> used for that, though I don't know if numeric guarantees that
> at least the operators +,-,* and modulo ret
On Friday 09 March 2007 13:32, Jonah H. Harris wrote:
> To copy the data and table definitions, I'd use a database link (on
> the Oracle side) with hsodbc connecting to your PostgreSQL system via
> ODBC.
>
Do you find this works well? I've used it from some older Oracle instances
connecting back
Ezequias R. da Rocha wrote:
Hi,
We here in my job are having many trouble of compatibility with the
wx-widgets and it has been a quite difficult job.
Having so many installation dependencies we are almost give up.
Could someone list all dependencies to install pgAdmin (actually I just
need
Ron Johnson wrote:
CREATE TYPE ty_fraction AS
(
n SMALLINT,
d SMALLINT
);
You'd need a type for large integers first - otherwise your
ty_fraction will be quite limited. I think numeric could be
used for that, though I don't know if numeric guarantees that
at least th
Adam Groves wrote:
I have been ramming my head against the wall for the past two
evenings, trying to get PITR working and it's gotten to the point
where I need to ask someone for help.
I'm basically trying to follow the instructions in the manual in
chapter 23.3.
Which postgres version are you
Hi,
We here in my job are having many trouble of compatibility with the
wx-widgets and it has been a quite difficult job.
Having so many installation dependencies we are almost give up.
Could someone list all dependencies to install pgAdmin (actually I just
need to put pgAgent to run) on Red
Oops, I though Ken had written privately to me - here's my reply:
(From the Booost rational package - http://www.boost.org/libs/
rational/rational.html)
I'd try to link to an existing library that provides rationals, or
model my code closely after one.
Yes, it may be easy to create composite
John D. Burger wrote:
Stephane Bortzmeyer wrote:
But he can write one in PostgreSQL quite easily. Rational numbers are
always the first exercice in CS courses about Abstract Data Types :-)
It's a little tricky to get good performance for all the operations:
The addition and subtraction opera
On Mar 15, 2007, at 1:55 PM, Joshua D. Drake wrote:
Your other four points are mere rehashings of that one.
Yes. All of my points directly revolve around the reality that 8.2
is a
short cycle release and that 8.3 is a long cycle release. Further that
due to 8.2 being a short cycle releas
>
> Your other four points are mere rehashings of that one.
Yes. All of my points directly revolve around the reality that 8.2 is a
short cycle release and that 8.3 is a long cycle release. Further that
due to 8.2 being a short cycle release, it will not see as much
production action as 8.3 (and
If they have a support contract for, say, RHEL, why migrate to something
that support contract doesn't cover? Those had better be some very
important features or some very critical bug fixes, the latter of which
are very likely to get backported if they're versions covered by a
support contract.
On Wed, Mar 14, 2007 at 08:09:24PM -0400, Kenneth Downs wrote:
> What I have noticed is that once the innermost instance exits, none of
> the outer instances execute any further, suggesting that the plperl
> routine is not "re-entrant" (if I am using that term correctly).
Doesn't sound right, do
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> 1. More people will run 8.3 than 8.2. Why? Because 8.3 will be in the
> wild as current stable longer than 8.2.
Oh, gimme a break, Josh. A year or more from now that argument would be
relevant, but unless you are going to counsel your customers not
On 3/15/07, Webb Sprague <[EMAIL PROTECTED]> wrote:
... planning a simple coordinate system, where objects are described
> as x, y and z. Are there any contribs or extensions available that can
> help me with datatypes, calculation of length between two points, etc?
google postgis. It is for ge
Tony Caduto <[EMAIL PROTECTED]> writes:
> Alvaro Herrera wrote:
>> What's wrong with that? 8.2 will understand the GRANT ON SEQUENCE
>> without a problem.
>>
> Yes, but 8.1 and earlier wont!
You're missing the point entirely. The versioning contract for pg_dump
is that version M.N can dump from
... planning a simple coordinate system, where objects are described
as x, y and z. Are there any contribs or extensions available that can
help me with datatypes, calculation of length between two points, etc?
google postgis. It is for geographic stuff, so maybe overkill, but
maybe not. Ther
Hi,
I'm planning a simple coordinate system, where objects are described
as x, y and z. Are there any contribs or extensions available that can
help me with datatypes, calculation of length between two points, etc?
--
regards,
Robin
---(end of broadcast)---
On Thu, 2007-03-15 at 11:53, Tony Caduto wrote:
> Dave Page wrote:
> > This is a problem I've been thinking about on and off recently - and I
> > am starting to come to the conclusion that shipping each version of
> > the utilities is the only way things are likely to work unless someone
> > put
Dave Page wrote:
This is a problem I've been thinking about on and off recently - and I
am starting to come to the conclusion that shipping each version of
the utilities is the only way things are likely to work unless someone
puts some really significant effort into adding backwards
compatibi
Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> I can't really argue for 8.2 versus 8.3, but I can argue that as 8.3 is
>> literally around the corner, it may make sense to wait.
>
> Today is the ides of March ... while the most optimistic estimate I've
> heard for 8.3 release i
Tony Caduto wrote:
Alvaro Herrera wrote:
What's wrong with that? 8.2 will understand the GRANT ON SEQUENCE
without a problem.
Yes, but 8.1 and earlier wont!
If you dump a 8.1 database (with 8.2 pg_dump) and then use that dump to
restore to another 8.1 server, any permissions on sequenc
On Wed, 14 Mar 2007, Randall Smith wrote:
> Stephan Szabo wrote:
> > On Wed, 14 Mar 2007, Randall Smith wrote:
> >
> >> Scott Marlowe wrote:
> >>> This whole discussion is reminding me of one of my personal mantras, and
> >>> that is that relying on "artifacts" of behaviour is generally a bad
> >>
Alvaro Herrera wrote:
What's wrong with that? 8.2 will understand the GRANT ON SEQUENCE
without a problem.
Yes, but 8.1 and earlier wont!
If you dump a 8.1 database (with 8.2 pg_dump) and then use that dump to
restore to another 8.1 server, any permissions on sequences will fail
to res
Tony Caduto wrote:
> Tom Lane wrote:
> >We try to make pg_dump
> >cope with prior server releases, but since we lack a time machine we
> >can't go back and teach old versions about subsequent server changes...
> >
> Tom,
> How come version 8.2 of pg_dump uses GRANT ON SEQUENCE when dumping a
> 8
>Date: Wed, 14 Mar 2007 20:39:17 +0100
>From: Magnus Hagander <[EMAIL PROTECTED]>
>To: George Weaver <[EMAIL PROTECTED]>
>Cc: pgsql-general
>Subject: Re: DST problem on Windows Server
>Message-ID: <[EMAIL PROTECTED]>
>George Weaver wrote:
> A client has PostgreSQL 8.2.1 installed on a Windows 2000
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I setup a plperl handler in Postgres 8.1 running under Solaris. The
> machine has multiple versions of Perl installed, and plperl is not using
> the correct Perl binary. How do I set which Perl binary plperl should use?
You need to set the
Tom Lane wrote:
We try to make pg_dump
cope with prior server releases, but since we lack a time machine we
can't go back and teach old versions about subsequent server changes...
Tom,
How come version 8.2 of pg_dump uses GRANT ON SEQUENCE when dumping a
8.1 or older database?
Was it just a
> I also tend to run every other version. I've run 7.2, then 7.4, then
> 8.1. I've tested and played with 8.2 and speed wise, it wasn't a
> compelling enough upgrade to start the very long process of replacing
> 8.1 with. By the time 8.3 comes out, I'll be about ready to start
> evaluating our
Alan J Batsford <[EMAIL PROTECTED]> writes:
> When I search my system for anything postgres I find a boatload of 8.0.4
> source, and a boatload of 7.4.8 documentation.
"rpm -qa | grep postgres" would probably prove enlightening. It sounds
like you have postgresql-server at 8.1.4 and the other sub
On Thu, 2007-03-15 at 00:10, Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > Erik Jones wrote:
> >> I really hope you meant upgrades to 8.2.x. And, no, it's not worth
> >> waiting. Upgrade at the soonest available opportunity, expecially the
> >> 7.4.x servers.
>
> > I don't
>> There is zero question that 8.2 is faster than 7.4 *but* if 7.4 isn't
>> slow for them... Note, that I meant no reason for him to upgrade 7.4
>> *right now*. He could wait for 8.3. (I think he should get off 7.4 in
>> general)
>
> He could wait for 8.4 as well, as it will be probably faster an
On Wed, 2007-03-14 at 17:33, Randall Smith wrote:
> Scott Marlowe wrote:
> > This whole discussion is reminding me of one of my personal mantras, and
> > that is that relying on "artifacts" of behaviour is generally a bad
> > idea.
> >
> > For instance, many databases accept != for not equal, but
Hi,
Actually, if I rephrase my requirement, I need to catch an exception at any
point ,where ever it is raised, in the perl code.
E.g during an insert, there is a foreign key contraint violation, then i
need to catch this specific error and do something with it.
Hope i make some sense here.
Thank
Stephane Bortzmeyer wrote:
But he can write one in PostgreSQL quite easily. Rational numbers are
always the first exercice in CS courses about Abstract Data Types :-)
It's a little tricky to get good performance for all the operations:
The addition and subtraction operations are complex. They
am Wed, dem 14.03.2007, um 1:24:01 -0700 mailte Arkan folgendes:
> Hi all,
>
> have anybody installed PgSQL on Windows Vista? I tried yesterday but I
> fail... on XP and linux i've installed pgsql much times but on
> vista... nothing to do! Version in 8.2.3 with the installer.
>
> If I install
I would still recommend making it available as a web service rather
than giving direct access; besides the security/load issues, it lets
you change the representation of the data without necessarily
affecting customers (of course, you can do this also at the DB level
with views). The web service i
Unfortunately,
Everything that is a permission (CREATEROLE, etc) when creating a role
cannot be inherited. Only the GRANT stuff is inherited and I think only when
the WITH .. is given on the GRANT.
I may be wrong on the last part though.
David
On 3/15/07, Alexi Gen <[EMAIL PROTECTED]> wrote:
Stefan Berglund wrote:
foo WHERE (ID = 53016 OR ID = 27 OR ID = 292 OR ID = 512) or I could
alternatively pass the string of IDs ('53016,27,292,512') to a table
returning function which TABLE is then JOINed with the table I wish to
Stefan,
The user selections will be in some sort of list. C
filippo wrote:
> Hello,
>
> I have written a program perl/Tkprogram, based on postgres. For
> maintenance reasons in my program I use these commands:
>
> `dropdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`;
> `createdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`;
>
Zhang Qian wrote:
> Dear sirs,
>
> For some reason,I need a copy of pg8.1beta1,not other ones.But I can't find
> one on the web.Would you please send it to me?
> Waiting for your mail.
You can obtain it via CVS, using the tag REL8_1_0BETA1.
--
Alvaro Herrerahttp
Joshua D. Drake escribió:
> Tom Lane wrote:
> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> >> Erik Jones wrote:
> >>> I really hope you meant upgrades to 8.2.x. And, no, it's not worth
> >>> waiting. Upgrade at the soonest available opportunity, expecially the
> >>> 7.4.x servers.
> >
> >>
Hi all,
have anybody installed PgSQL on Windows Vista? I tried yesterday but I
fail... on XP and linux i've installed pgsql much times but on
vista... nothing to do! Version in 8.2.3 with the installer.
If I install with my user account (with administrative rights), the
installlation fails on se
Apparently I forgot one combination, which was the correct one. For
reference:
localhost:*:databasename:username:password
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
I have been ramming my head against the wall for the past two
evenings, trying to get PITR working and it's gotten to the point
where I need to ask someone for help.
I'm basically trying to follow the instructions in the manual in
chapter 23.3.
Here's how I'm starting out:
===
Co
On Wed, 14 Mar 2007 18:50:27 +, [EMAIL PROTECTED] (Ashley
Moran) wrote:
in <[EMAIL PROTECTED]>
>It's more complicated than that. What we need to do is something
>along the lines of:
>
>results = SELECT * FROM foo();
>DELETE FROM results WHERE (some condition involving results);
>some_valu
Postgres 8.1 on a windows machine.
I followed instructions and went to APPDIR to setup the file
pgpass.conf:
* * myuser mypass
I also tried: * * databasenamemyuser mypass
I also tried: *:*:myuser:mypass
When i start psql -U myuser, it always requests that I type the
password. Wh
Hello!!
I am working with hermes 2 postgresql and I obtain this mistake I am thinking
this mistake is because it not conect very well. Can someone help me?? thanks
very mach 2007-03-15 11:02:51 [Thread-6] hk.hku.cecid.piazza.commons.net.ConnectionException: Unable to connect to
incomin
I inherited an existing system with no documents on how it was originally
configuerd, so I'll provide as much as I can. OS is CentOS 4.3 Linux
Distribution.
When I search my system for anything postgres I find a boatload of 8.0.4
source, and a boatload of 7.4.8 documentation.
postgres --version
On Mon, 12 Mar 2007 10:41:21 -0400, [EMAIL PROTECTED] (Tom Lane) wrote:
in <[EMAIL PROTECTED]>
>Stefan Berglund <[EMAIL PROTECTED]> writes:
>> On Sat, 10 Mar 2007 00:37:08 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
>>> It looks pretty ugly to me too, but you haven't explained your problem
>>> cl
Hi,
I setup a plperl handler in Postgres 8.1 running under Solaris. The
machine has multiple versions of Perl installed, and plperl is not using
the correct Perl binary. How do I set which Perl binary plperl should use?
Thanks
-Dave
---(end of broadcast)--
I'm stuck on a query, I'm hoping someone can point me to the obvious
I need to limit the results of a query based on 2 criteria:
1- total rows grouped by column_a
2- total rows all
given:
books: id , author , subject , title
i need to
SELECT * FROM books WHERE
I have a SQL statement that uses group-by to generate reports as such:
GroupFieldClicks
---
Page 1 50
Page 2 20
Page 3 30
Now, as an added field, I also want it to tell me what percent of
total clicks each row represe
On Mar 8, 2:26 pm, [EMAIL PROTECTED] (Shane Ambler) wrote:
> Timasmithwrote:
> > Suppose I have a database table with 20 fields which are lookups to a
> > single table.
>
> > configtable(configtable_id, a_field, something_lookup_id,
> > another_lookup_id, ...)
> > lookup(lookup_id, value, descripti
Hello,
I have written a program perl/Tkprogram, based on postgres. For
maintenance reasons in my program I use these commands:
`dropdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`;
`createdb -U postgres -h $BACKUP_SERVER $BACKUP_DATABASE_NAME`;
`pg_dump -U postgres -h $D
Dear sirs,
For some reason,I need a copy of pg8.1beta1,not other ones.But I can't find one
on the web.Would you please send it to me?
Waiting for your mail.
Thank you for your time.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
[GENERAL] Role & User - Inheritance?
A ROLE dba01 has been given the option of SUPERSUSER.
A USER user01 is created and tagged to the above ROLE dba01.
When attempting to create a Tablespace (logged in as user01) it generates
the following message:
"permission denied to create tablespace (tblspc
On Thu, Mar 15, 2007 at 07:41:18AM +0100,
Peter Eisentraut <[EMAIL PROTECTED]> wrote
a message of 22 lines which said:
> His goal may be to store and compute rational numbers exactly. The
> answer is that there is no data type in PostgreSQL that supports
> this.
But he can write one in Postgr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/15/07 01:41, Peter Eisentraut wrote:
> Ron Johnson wrote:
>> On 03/14/07 18:55, Ken Johanson wrote:
>>> In SQL servers in general, or in PG, is there a native field type
>>> to store fractions? Or must one resort to char or separate
>>> numerator
I realize that direct access gives an outside user the opportunity to
overload the server. In fact, I am far less worried about malicious
DOS-type attacks than I am about plain old incompetence, such as having a
buggy script hammer our server with an infinite loop.
BTW, is there a way to configu
Hello All,
I have downloaded the PLpgSQl Debugger tarball edb-debugger-20061107-src.tar.gz
after issuing gmake
it gives me list of errors.
But not getting how to install it.
Can anybody tell me what are the steps to install it.
Thanks in advance
With Regards
Ashish..
* Kynn Jones ([EMAIL PROTECTED]) wrote:
> On 3/15/07, Stephen Frost <[EMAIL PROTECTED]> wrote:
> >* Kynn Jones ([EMAIL PROTECTED]) wrote:
>
> >One big question I have is, is this completely read-only?
>
> Sorry, I should have made this clear: the access we had in mind is
> strictly read-only, and
1 - 100 of 108 matches
Mail list logo
