You can try
If (IsNumeric(varToTest) And 0 = CDbl(varToTest)) Then IsNothing = True
Bret wrote:
This may not be the right group, if so, just let me know.
I have a table with a type [numeric].
When executing queries, I get the data which happens to
be (6.5) in this case, but my VB6 function w
This may not be the right group, if so, just let me know.
I have a table with a type [numeric].
When executing queries, I get the data which happens to
be (6.5) in this case, but my VB6 function which traps
for nulls (below) returns a null.
If I change it to type [real]. No problems
Function I
I'm still not buying the theory that the dump/restore method has
something to do with it. You might try the test yourself: run
pg_restore's output into a text file and compare with the text dump.
regards, tom lane
Haven't figured out exactly why yet, but I did find the
"Albe Laurenz" writes:
> The problem is that both _LARGE_FILES and _LARGE_FILE_API are #defined
> in this case, which makes #include fail.
> Does anyone have an idea how to best fix this problem in the
> source tree? I'm willing to implement and test.
I've committed changes for this in CVS, plea
Alvaro Herrera writes:
> Tom Lane wrote:
>> In most of the other cases the #include is done in an associated .y
>> file, but there is none in psql. Anyone have a thought which of
>> psql's .c files would be the most appropriate host?
> mainloop.c?
Yeah, that's about the same conclusion I had co
I have set up the replication using Bucardo. This is just an additional set
up
regards
On Tue, Nov 10, 2009 at 5:09 PM, silly wrote:
> How about using replication instead of incremental backups?
>
> On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson wrote:
> > On Tuesday 10 November 2009, akp g
On Tue, Nov 10, 2009 at 2:04 PM, Peter Eisentraut wrote:
> Well, a lot of hard work. ;-) Just like there are coding standards and
> best practices, there are standards and customs in writing and
> publishing.
Are these published anywhere?
--
Regards,
Richard Broersma Jr.
Visit the Los Angel
How about using replication instead of incremental backups?
On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson wrote:
> On Tuesday 10 November 2009, akp geek wrote:
>> So Is it always good to have the backup using PG_dump instead of PITR or
>> a combination of both
>>
>
> I like to do both. Ongoing P
On tis, 2009-11-10 at 07:00 -0800, David Fetter wrote:
> Well, there's the whole Docbook thing, which was pretty well thought
> out. Apart from that, I don't know. Peter?
Well, a lot of hard work. ;-) Just like there are coding standards and
best practices, there are standards and customs in wr
On Tuesday 10 November 2009, akp geek wrote:
> So Is it always good to have the backup using PG_dump instead of PITR or
> a combination of both
>
I like to do both. Ongoing PITR, daily base backups (by updating an rsync
copy), and weekly pg_dumps that in turn go to tape.
PITR gives a very rece
So Is it always good to have the backup using PG_dump instead of PITR or a
combination of both
Please advice
Regards
On Tue, Nov 10, 2009 at 11:24 AM, Scott Mead
wrote:
>
> On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark wrote:
>
>>
>> It's always worth having the dump, even if you also implement
I have tested the procedure in the URL and it worked fine. I have
accidentally deleted my PGDATA folder after the backup procedure is done. I
could able to restore it. But still have few questions
Thanks for the help
Regards
On Mon, Nov 9, 2009 at 11:01 PM, Jing Tan wrote:
> I wrote an article
Tom Lane wrote:
> In most of the other cases the #include is done in an associated .y
> file, but there is none in psql. Anyone have a thought which of
> psql's .c files would be the most appropriate host?
mainloop.c?
--
Alvaro Herrerahttp://www.CommandPrompt.co
Joshua Berry wrote:
> On Mon, Nov 2, 2009 at 8:35 AM, Jasen Betts wrote:
> |
> | for this case: convert to seconds and then do abs.
> |
> | ?select * from enviados e, recibidos r where abs(extract ( epoch from
> | ?(e.fecha - r.fecha) )) < 1
>
> Cheers for that. The query cost is pretty heavy, bu
On Mon, Nov 9, 2009 at 06:15, Jukka Inkeri wrote:
>
>>
>> The native psql is written for Windows, not for Cygwin. You really
>> shouldn't be using it there... If you are using Cygwin, you should be
>> using a Cygwin psql.exe.
>>
>>
>
> PG pages says: use native, not cygwin version anymore.
Yes, t
"Albe Laurenz" writes:
>> Why the "OBJECT_MODE" exported to 32 is not sufficient ?
> I dug around a little, and the problem is in psqlscan.c which is generated
> from psqlscan.l by flex.
> The problem is that both _LARGE_FILES and _LARGE_FILE_API are #defined
> in this case, which makes #include
On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark wrote:
>
> It's always worth having the dump, even if you also implement PITR.
> The dump allows you to restore just specific tables or to restore onto
> a different type of system. The PITR backup is a physical
> byte-for-byte copy which only works if
Hi;
also you can try this query which should work for any version
SELECT
a.userid, a.data, max(f.data), a.data - max(f.data)
FROM
(SELECT userid, data FROM foo EXCEPT SELECT userid, min(data) FROM
foo GROUP BY userid) a LEFT JOIN foo f ON (f.userid = a.userid AND
f.data < a.data) GROUP B
2009/11/10 Antonio Ruggiero :
> I am running PostgresSQL 8.3.8 on windows XP-64Bit. I am using psql
> client from the PostgreSQL installation and not the Cygwin client.
>
> My issue is that the command line argument "-c command" is not
> recognized. For example, if I run (from Cygwin)
>
> psql -h
> With 8.4's analytic capabilities you can do this:
> select * from (
> select userid, data - lag(data) over (partition by userid order by data)
> diff
> from foo) q
> where diff is not null;
Thank you! That worked perfectly!
--
Sent via pgsql-general mailing list (pgsql-general@postgres
I am running PostgresSQL 8.3.8 on windows XP-64Bit. I am using psql
client from the PostgreSQL installation and not the Cygwin client.
My issue is that the command line argument "-c command" is not
recognized. For example, if I run (from Cygwin)
psql -h localhost -p 5432 -d $database postgres -c
On Tue, Nov 10, 2009 at 06:23:16AM -0800, Richard Broersma wrote:
> On Mon, Nov 9, 2009 at 10:34 PM, David Fetter wrote:
>
> > You might be, but that's approximately what happened. Common editors
> > for this task are Emacs and Vim, each of which has varying levels of
> > support for SGML :)
>
With 8.4's analytic capabilities you can do this:
select * from (
select userid, data - lag(data) over (partition by userid order by data)
diff
from foo) q
where diff is not null;
On Tue, Nov 10, 2009 at 5:40 PM, A B wrote:
> Hello there!
>
> I have a tablefoo( userid integer, data
On Tue, Nov 10, 2009 at 6:40 AM, A B wrote:
> For example
> if the table contains:
>
> 4, 100
> 5, 200
> 5, 210
> 5, 231
>
>
> I want the values
>
> 5,10
> 5,21
> I guess that will work, but I'm curious, are there other ways?
I think this kind of operation is best suited for CTEs and Windowing.
On Tue, Nov 10, 2009 at 11:03 AM, Alban Hertroys
wrote:
> IMHO The simplest solution is to just write a dump to the same file every
> now and then and have the backup software take care of storing only the
> differences. It does have a few drawbacks; it means you'll have a file about
> as large as
Hello there!
I have a tablefoo( userid integer, data integer); with the
constraint unique(userid,data)
Now I wish to select one userid and calculate the differences between
the data -values (when they are sorted) .
For example
if the table contains:
4, 100
5, 200
5, 210
5, 231
I want the
On Mon, Nov 9, 2009 at 10:34 PM, David Fetter wrote:
> You might be, but that's approximately what happened. Common editors
> for this task are Emacs and Vim, each of which has varying levels of
> support for SGML :)
That is amazing. The layout and organization of the PostgreSQL manual
(to me)
On Mon, Nov 9, 2009 at 9:21 PM, Greg Smith wrote:
> On Mon, 9 Nov 2009, Richard Broersma wrote:
>
>> Out of curiosity, what are the favorite editor for authoring the
>> PostgreSQL document sgml files?
>
> http://developer.postgresql.org/pgdocs/postgres/docguide-authoring.html
I'll have to take
Hello all,
I need, after one specific table is created, with syncdb, to insert
in that new table some values from other table. Exactly I need to add
in a column of the new table all fields from other table. How can I do
this, I know that trigger can't fire after a create table event, what
else
On Tue, 2009-11-10 at 09:39 +, Thom Brown wrote:
> Is there a reason we require fixed-size WAL files?
Currently we reuse the files, which is much easier with fixed size
files.
It might have been interesting once to pass the size at log switch
through to the archiver as a parameter, though we
Peter Eisentraut wrote:
> On mån, 2009-11-09 at 19:49 -0300, Alvaro Herrera wrote:
> > hubert depesz lubaczewski wrote:
> >
> > > => pacman -Ql docbook-sgml
> > > docbook-sgml /usr/
> > > docbook-sgml /usr/share/
> > > docbook-sgml /usr/share/sgml/
> > > docbook-sgml /usr/share/sgml/docbook-sgml-4
David Fetter wrote:
>
> On Mon, Nov 09, 2009 at 06:09:19PM -0800, Richard Broersma wrote:
> > Out of curiosity, what are the favorite editor for authoring the
> > PostgreSQL document sgml files? (I would be shocked if the whole
> > thing was developed from scratch using a simple text editor.)
>
I CC: this to the hackers list as it seems to be an old problem that
was never fixed. See at the bottom.
Alexandra Roy wrote:
> This is a summary of what I have noticed concerning
> PostgreSQL 8.3.8 compilation on AIX 5.3 TL9.
>
> 1. To do a successful 64-bit build, specify and execute:
>
>
>
On 10 Nov 2009, at 3:48, akp geek wrote:
Dear all -
Is there way to create incremental backups in
postgres. I am currently using 8.4.1 on solaris.. I am new to
postgres. Can you please share your thoughts
Regards
IMHO The simplest solution is to just write a dump to t
On 9 Nov 2009, at 23:30, Baris Gerze wrote:
I have users table such as
create table users(
user_id bigserial,
user_name varchar(50),
user_surname varchar(100)
);
how can I write a function to return multiple rows? ( in plpgsql )
You can create set-returning functions (http://www.postg
Hi Laurenz, hi all,
This is a summary of what I have noticed concerning PostgreSQL 8.3.8
compilation on AIX 5.3 TL9.
1. To do a successful 64-bit build, specify and execute:
# export
OBJECT_MODE="64"
# export CFLAGS="-maix64"
# export LDFLAGS="-maix64 -Wl,-bbigtoc"
# ./co
Hello,
More on this ...
To be clear, just after receiving the S confirmation that PostgreSQL
can handle SSL connections, I have to switch my TCPSocket into SSL.
Immediatly, I receive some errors, depending my configuration:
0 - SSLv2: SSL (Secure Sockets Layer) version 2. ERROR =>
Hi all,
Is there a reason we require fixed-size WAL files?
Thanks
Thom
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Alexandra Roy wrote:
> I have always run "gmake distclean" before relaunching a build.
>
> Maybe the32-bit build failed because I have not set and exported the
> "OBJECT_MODE" environment variable.
> I will try to build PostgreSQL once again with "export
> OBJECT_MODE=32".
I will look at the 32
On Mon, Nov 09, 2009 at 07:49:12PM -0300, Alvaro Herrera wrote:
> hubert depesz lubaczewski wrote:
>
> > => pacman -Ql docbook-sgml
> > docbook-sgml /usr/
> > docbook-sgml /usr/share/
> > docbook-sgml /usr/share/sgml/
> > docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
> > docbook-sgml /usr/share/s
On mån, 2009-11-09 at 19:49 -0300, Alvaro Herrera wrote:
> hubert depesz lubaczewski wrote:
>
> > => pacman -Ql docbook-sgml
> > docbook-sgml /usr/
> > docbook-sgml /usr/share/
> > docbook-sgml /usr/share/sgml/
> > docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
> > docbook-sgml /usr/share/sgml/doc
On mån, 2009-11-09 at 23:13 +0100, hubert depesz lubaczewski wrote:
> configure:27984: checking for DocBook V4.2
> onsgmls:/etc/xml/catalog:2:78:E: name expected
> onsgmls:/etc/xml/catalog:2:18:E: cannot find "PUBLIC"; tried
> "/etc/xml/PUBLIC", "/usr/share/sgml/PUBLIC", "/usr/share/xml/PUBLIC"
Lo
42 matches
Mail list logo
