On Saturday 16 June 2007, John Smith wrote:
> guys,
> love both tools but php @ 2.5 *billion* google results is far more
> popular than postgresql @ 25 million google results. *if* somebody's
> gotto adapt it's not php. php does what it does best in a way that
> stuffy academics don't get.
Mhhh -
On Saturday 07 July 2007, Lew wrote:
> So if your RDBMS sorts NULLs after all other values, then from
>
> >> select start_date from show_date
> >> order by
> >> case when start_date > CURRENT_DATE then start_date end desc,
> >> case when start_date <= CURRENT_DATE then start_date end asc;
>
>
Why do you create an extra type for that?
Just have your method return "movies"
i.e.
CREATE FUNCTION get_movies ()
RETURNS SETOF movies
...
...
HTH
Uwe
On Wednesday 12 September 2007, Cultural Sublimation wrote:
> Hi,
>
> I am not sure if this qualifies as a bug report or a feature request,
>
I haven't tried it with a view yet - so this may or may not work. But try
giving it a shot by declaring a view
create view vmovies as
select movie_id,movie_text from movies
and let your function return setof vmovies
Maybe that works - I think it should.
Uwe
On Wednesday 12 September 2007, C
On Monday 03 December 2007, Tom Allison wrote:
> is there much of a difference in performance between a XEON, dual
> core from intel and a dual core AMD 64 CPU?
>
> I need a bit of an upgrade and am not sure which, if any, have a
> significant advantage for postgres databases.
>
Personally I've ne
pg_dump -x -O -s [databasename] > outfile.sql
HTH
Uwe
On Sunday 09 December 2007, Ted Byers wrote:
> Is there a way to tell pg_dump to just dump the SQL
> statements required to create the tables, sequences,
> indeces, keys, &c.? I DON'T need to restore or
> recreate things like users,
Ok, something I've been toying around with for a while.
Here's the scenario:
Imagine a blogging app.
I have a table for blogs with a blog_id (primary key)
and a table blog_comments also with a comment_id as primary key and a foreign
key holding the blog_id the post belongs to.
The comments table
Thanks everyone.
This was exactly what I needed. I went with connectby as Dante recommended
and it works like a charm.
UC
--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax:+1 707
On Tuesday 26 February 2008, Kynn Jones wrote:
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?
> TIA!
>
> Kynn
pg_dump -t [table] [database] | psql -U [remoteuser] -h [remotehost]
[remotedatabase]
comes to mind...
You can an
On Friday 19 June 2009, Scott Marlowe wrote:
> On Fri, Jun 19, 2009 at 8:43 PM, Miguel
>
> Miranda wrote:
> > Well, i just didnt explain in detail, what i have is just the 16897
> > directory where i was storing the database, i tried just copying the
> > files but it didnt work,
> > should it be p
On Wednesday 29 July 2009, Tim Uckun wrote:
>
> What is the issue here? Some sort of a timezone problem? How do I tell
> it what time zone to use?
>
> Thanks.
cron runs programs in a very limited environment. Things like TZ etc. are
usually not set. To see what your cron sets, just run a shell
On Sunday 31 August 2008, Christophe wrote:
> On Aug 31, 2008, at 7:44 PM, Guy Rouillier wrote:
> > CTOs/CIOs like to sleep at night.
>
> If you buy Oracle, and there's a problem, the conversation with the
> CEO is that "Oracle broke." With PG, even if you have exactly the
> same level of support
or maybe not and I'm just not getting it.
So here's the scenario:
I have 3 tables
forum: with primary key "id"
forum_thread: again primary key "id" and a foreign key "forum_id" referencing
th primary key of the forum table
forum_post: again primary key "id" with a forign key "thread_id" referen
On Sunday 07 September 2008, Gregory Stark wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > I want to get a list looking like
> >
> > forum idthread_id post_id
> > 1 6 443
> > 2 9 123
> >
> I have been testing it a bit performance-wise, and the numbers are
> worrying. In my test, MySQL (using InnoDB) had a 40% lead in
> performance, but I'm unsure whether this is indicative for PostgreSQL
> performance in general or perhaps a misconfiguration on my part.
In my experience the "numbe
On Saturday 08 November 2008, Michelle Konzack wrote:
> Am 2008-11-08 19:07:35, schrieb Scott Marlowe:
> > No, your histrionics aside, it's the way this list works by default,
> > and for good reason. If you need it to work differently, there's a
> > setting which has been pointed out to you at t
On Saturday 29 November 2008, Andrus wrote:
> How to create automated backup script in Gentoo which in every night 3:00
> PM backups one database and sends backup
> with ftp using unique file name?
>
> In windows I can use scheduler and script
>
> set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%MyDb
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 March 2005 07:24 pm, Tope Akinniyi wrote:
> Hi,
>
> I am wondering at this display of extreme Linux mentality being displayed
> by the 'top bras' of the PostgreSQL community. And I ask, are we
> encouraging Windows use of PostgreSQL at a
ay 08 March 2005 09:02 pm, Edwin New wrote:
> I don't want to split hairs, but wasn't Firebird originally Interbase? If
> so, you'll find it was originally a *nix product before it was a Windows
> database (back in the Ashton-Tate days for those with long memories).
>
>
Don't see a problem pasting this one.
Neither to a local nor to a remote ssh (running psql certainly).
This is 7.4.7 on redhat and mandrake linux'es
I'd suspect it has nothing to do with psql. Can you paste that into a normal
ssh / terminal ?
On Thursday 14 April 2005 20:05, Joseph Shraibman w
have you enabled tcp in postgresql.conf ?
the parameter in question is pretty much on top of the file and should read
tcpip_socket = true
usually postgresql.conf is in /var/lib/pgsql/data/
on a RH system
UC
On Monday 18 April 2005 11:55, ElayaRaja S wrote:
> Hi,
> I am using Redhat linux 9. i
On Monday 18 April 2005 12:16, Leif B. Kristensen wrote:
> On Monday 18 April 2005 21:07, Gavin M. Roy wrote:
> > Thank you for posting to a better list for these questions. Check
> > your postgresql.conf file and make sure it's accepting TCP/IP
> > connections on the IP you're looking for. If yo
Well, you overlook one thing there. SUN has always has a really good I/O
performance - something far from negligible for a database application.
A lot of the PC systems lack that kind of I/O thruput.
Just compare a simple P4 with ATAPI drives to the same P4 with 320 SCSI drives
- the speed differ
Is this just me or did anyone actually think about adding a UPS to the machine
and monitor it with NUT ?
That way the machine would shut down properly, making the whole stale pid-file
issue irrelevant.
UC
On Wednesday 27 April 2005 13:41, Tom Lane wrote:
> Philip Hallstrom <[EMAIL PROTECTED]>
On Wednesday 27 April 2005 15:17, Doug McNaught wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > Is this just me or did anyone actually think about adding a UPS to
> > the machine and monitor it with NUT ? That way the machine would
> > shut down
Not quite correct. TCP needs to be turned on AND an according entry in
pg_hba.conf needs to be set up - otherwise the server will just decline to
talk to the client.
Also - if you're on XP you might want to check the "firewall" settings - which
if configured wrong could potentially block connec
in the where clause use something like (requires the earthdistance contrib to
be installed):
geo_distance(point([origin longitude],[origin latitude]),point([target
longitude column],[target latitude column])))::int <= 50
On Sunday 26 June 2005 04:40 pm, CSN wrote:
> If I have a table of items
point(''|| zc.longw
||'',''||zc.latn||''),point(z.longw, z.latn))::int <= ''||maxdistance ;
hope that helps
UC
On Monday 27 June 2005 02:08 am, you wrote:
> Uwe C. Schroeder wrote:
> >in the where clause use something like (re
I've solved this for my case in 7.4 by defining a view with the desired column
layout and the return setof the view. This certainly depends on what you're
trying to accomplish.
On Thursday 30 June 2005 09:21 am, Jason Tesser wrote:
> Can this return multiples? I thought when you dfined columns
First of all: Happy Independence Day.
I've got a quick question for those with tsearch2 experience.
I set tsearch2 up and it works great (although I'd like to search for phrases
too, but I guess that's not supported at this time).
Anyways, I noted that the search seems to be case sensitive for s
On Wednesday 05 October 2005 07:37, L van der Walt wrote:
> Berend Tober wrote:
> > L van der Walt wrote:
> >> I would like to secure Postgres completly.
> >>
> >> Some issues that I don't know you to fix:
> >> 1. User postgres can use psql (...) to do anything.
> >> 2. User root can su to postgr
On Saturday 08 October 2005 17:35, Chris Browne wrote:
> [EMAIL PROTECTED] writes:
> > On Sat, Oct 08, 2005 at 10:31:30AM -0500, Scott Marlowe wrote:
> >> What it comes down to is this. MySQL is dual licensed. You can use
> >> the GPL version, or the commercial version. In order to sell the
> >>
On Saturday 08 October 2005 21:07, Chris Browne wrote:
> [EMAIL PROTECTED] ("Uwe C. Schroeder") writes:
> > Didn't MySQL AB acquire SAPdb (which was Adabas D before)? AFAIK
> > (and you're welcome to correct me since I might very well be wrong)
> > SAPdb s
how about using 2 tables with according unique/primary key constraints and a
view to actually access the data (mixing the 2 tables into one) ?
On Saturday 08 October 2005 22:36, Miles Keaton wrote:
> I'm stuck on a brain-teaser with CONSTRAINT:
>
> Imagine a table like "lineitems" in a bookstor
if not found then
raise exception 'error creating record';
end if;
end loop;
return NULL;
END;
On Thursday 10 November 2005 15:56, Bob Pawley wrote:
> Thank you - what is the correct command???
>
> Bob
>
> - Original Message -
> From: &qu
SELECT INTO
tries to create table
See: http://www.postgresql.org/docs/8.0/interactive/sql-selectinto.html
Why do you do the select into anyways? It does nothing.
If you try to update table pipe with the select result you have the wrong
command.
UC
On Thursday 10 November 2005 14:24,
one full row - NOT two or more rows.
On Thursday 10 November 2005 17:23, Bob Pawley wrote:
> By 'one record' do you mean one full row or one column of one row??
>
> Bob
>
> - Original Message -
> From: "Uwe C. Schroeder" <[EMAIL PROTECTED]>
On Wednesday 11 October 2006 10:42, A. Kretschmer wrote:
> am Wed, dem 11.10.2006, um 12:56:51 -0400 mailte Tom Lane folgendes:
> > Andreas Kretschmer <[EMAIL PROTECTED]> writes:
> > > Joe Kramer <[EMAIL PROTECTED]> schrieb:
> > >> I want to get:
> > >> item_id | last_update
> > >> ---
On Friday 13 October 2006 01:22, Martijn van Oosterhout wrote:
> > 1) I have a performance problem as I am trying to insert around 60
> > million rows to a table which is partitioned. So first I copied the
> > .csv file which contains data, with COPY command to a temp table
> > which was qu
do a "ps -ef | grep transact"
and look for "idle in transaction" postmaster processes.
If you're certain that nobody else is running that transaction (i.e. nobody on
the system or the process with the idle transaction has been sitting there
for a while and normally the application doesn't have l
For your immediate needs I'd recommend slony.
It's a quite reliable replication solution that works quite nicely.
It will sync the replica in nearly real-time and you won't have any
transactional problems either.
Uwe
On Friday 20 October 2006 21:22, Tobias Brox wrote:
> I would eventually like
On Sunday 22 October 2006 12:32, Volkan YAZICI wrote:
> On Oct 20 05:07, [EMAIL PROTECTED] wrote:
> > I'm concerned about whether the usual parameter escaping mechanism is
> > enough in a LIKE or regular expression search.
> >
> > I run a recent Postgres version and use the Python connector psycopg
why don't you just use < '00:00:00'::time
and avoid the issue?
IMHO there shouldn't even be a 24:00:00, because that would imply that there
is a 24:00:01 - which there is not.
It should go from 23:59 to 00:00
But then, I didn't write the spec for time in general, so maybe there is a
24:00 which
On Thursday 02 November 2006 00:16, Richard Huxton wrote:
> Uwe C. Schroeder wrote:
> > why don't you just use < '00:00:00'::time
> > and avoid the issue?
> >
> > IMHO there shouldn't even be a 24:00:00, because that would imply that
> > th
On Thursday 02 November 2006 00:59, Richard Huxton wrote:
> Uwe C. Schroeder wrote:
> >> Ah, times and dates are wonderful things though. For example, '23:59:60'
> >> is a valid time (and not equal to 24:00:00 or 00:00:00) every so often.
> >>
>
On Tuesday 07 November 2006 10:55, km wrote:
> > > Is it possible in a PLSQL function to call an external program/script
> > > residing at /usr/bin and return the result ?
> >
> > No, because plsql is a trusted language.
> > You can't run external commands from such a language.
>
> Is that a decid
On Friday 24 November 2006 12:56, ben short wrote:
> Hi,
>
> I have a postgresql server setup on a Solaris 10 box. I can connect to
> the db via psql from the local machine. What I have been trying to do
> it connect with pgAdmin from my workstation. I have setup the tunnel
> correctly, local port
On Monday 27 November 2006 02:38, Weerts, Jan wrote:
> Hi all!
>
> [EMAIL PROTECTED] wrote:
> > On Friday 24 November 2006 12:56, ben short wrote:
> >> I have a postgresql server setup on a Solaris 10 box. I can
> >> connect to the db via psql from the local machine. What I have
> >> been trying to
I think you're better off to use the official documentation.
http://www.postgresql.org/docs/
(chose the docs for the version you're running on the right side of that
page).
The docs you're currently referencing are for 7.0 - which is stone-age
postgresql.
On Wednesday 20 December 2006 11:57, B
Well, in very short terms: a "idle" transaction is not committed. This means,
when it's a writing transaction, that in the best case you have one or more
row locks blocking access to the updated/inserted rows and in the worst case
one or more table locks, which will block access to a table compl
Hi everyone,
this may be a very stupid question. I've always used the source rpms for new
versions. However now I'm faced with a ubuntu server and I never used a
non-rpm system.
Since there is no up-to-date postgresql package I grabbed the source for 8.1.8
and compiled/installed it.
So far so
Never mind.
Dumb me.
Uwe
On Tuesday 13 March 2007 22:17, Uwe C. Schroeder wrote:
> Hi everyone,
>
> this may be a very stupid question. I've always used the source rpms for
> new versions. However now I'm faced with a ubuntu server and I never used a
> non-rpm system.
Thanks Stuart.
I somehow overlooked it all the time. In the end I ran updatedb and locate :-)
Guess it's time to get some sleep.
Uwe
On Tuesday 13 March 2007 22:40, Stuart Cooper wrote:
> > this may be a very stupid question. I've always used the source rpms for
> > new versions. However now I'm
Yes it will. Everything INSIDE ONE transaction is visible to that exact
transaction. So in your scenario the val1 from the select will see what was
inserted - just any other transaction won't unless the current one is
committed.
Uwe
On Wednesday 09 May 2007, Harpreet Dhaliwal wrote:
> Hi,
>
usually contrib is installed along with postgresql.
Look for
/usr/lib/pgsql/contrib or /usr/lib/postgresql/contrib
and maybe it resides in
/usr/share/pgsql/contrib
or just type
locate contrib
Uwe
On Thursday 17 May 2007, ABHANG RANE wrote:
> Hi,
> I have installed postgresql 8.2 on redhat ent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
log in as root and edit the file
/var/lib/pgsql/data/postgresql.conf
Right on the top there is a line
#tcpip_socket=true
make sure this line has no # in front (comment)
and see that it has "true" as the value.
Second check out pg_hba.conf
At the en
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 October 2004 08:42 am, C G wrote:
> Dear All,
>
> I have a simple join query
>
> SELECT c1 FROM t1
> INNER JOIN
> t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
^
Your join doesn't alias anything
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There is no version of this library linked to a newer postgres version.
Symlinking libpq.so.3 to libpq.so.2 doesn't work with 7.4 anymore - at least
not here on my mandrake box.
I found no way to get this working except for compiling a libpq from a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here's a question for the SQL guru's out there, which I've been trying to
solve for the last couple of hours. There's got to be a solution to this, but
somehow I can't find it.
Tables:
table1 (
uid int PK,
uname varchar(64)
)
tabl
y has 3 fields)
so now I do:
table2 (
uid int FK to table1,
luid int FK to table1,
is_in_table3 boolean,
is_in_table4 boolean,
.
)
this just needs a simple select with a join against table1.
UC
On Saturday 06 November 2004 03:13 pm, Uwe C. Schroeder wrote:
> Here's a questio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for your answers Greg & Vincent.
Although I solved the problem by a change of schema - I'm happy that I have
something to digest I didn't know before. One never learns enough ...
U.C.
On Saturday 06 November 2004 03:13 pm, Uw
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
option 1) use a stored procedure to create the record. Within a transaction
the last value function will return the correct last value, not the one of a
concurrent insert.
option 2) if you know that this user uses the same connection for all his
qu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 07:04 am, Terry Lee Tucker wrote:
> Greetings,
>
> Here is a simple question:
>
> Is it ok to put a unique index on the oid for my tables? We are in the
> process of moving from Progress Software to PostgreSQL. In the Progr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 11 November 2004 10:23 am, Franco Bruno Borghesi wrote:
> I think the best way would be not to use a SERIAL field, but an INTEGER
> field and a sequence:
a "serial" is just a convenient shortcut to an int with an automatically
created seq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 27 November 2004 02:59 am, Konstantin Danilov wrote:
> Hello List!
> Do you know how many times can JOIN be used in a query? How many JOINs does
> PostgreSQL support in ONE query?
>
I think you will run out of memory before hitting the lim
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
a (maybe/probably) stupid idea just popped to my mind:
Problem:
I need to search a lot of locations based on distance (simple zipcode match
based on longitude and latitude). However I need to calculate the distance
between each of the nodes, s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 28 November 2004 10:43 pm, Michael Fuhr wrote:
> On Sun, Nov 28, 2004 at 06:41:50PM -0800, Uwe C. Schroeder wrote:
> > I need to search a lot of locations based on distance (simple zipcode
> > match based on longitude and lat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 28 November 2004 10:49 pm, Greg Stark wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > I could create a view for every node in the system which calculates the
> > distance in the result set, m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
check out slony. works great
On Tuesday 21 December 2004 08:56 pm, Jamie Deppeler wrote:
> Can anyone suggest good open source replicator system for pgsql
>
> Thanks
> JD
>
> ---(end of broadcast)---
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Although with your very little load a manual or cron based vacuum full once a
week will be more than enough.
I'm doing a biweekly vacuum full with one of my customer's machines (an
office application that uses pg as backend) and never had complaint
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Maybe it's to late for me to think correctly (actually I'm sure of that). I'm
going to ask anyways.
I have a table like
id int4
user_id int4
photo varchar
image_type char(1)
where image_type is either G or X
What I want to do is have ONE query that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You missed something obvious. Executing this query in psql you have no
problem, because there is no structure created from the result. A view
behaves like a table - try creating a table like
create table blah (
id int,
id int
);
and you'll hit the
How about reading the docs?
http://www.postgresql.org/docs/8.1/interactive/server-programming.html
is the chapter about stored procs
On Tuesday 29 November 2005 09:12, Brandon E Hofmann wrote:
> Does PostgreSQL include Stored Procedures supporting the CREATE PROCEDURE
> syntax. I notice pgAdmin
Hi everyone,
in 8.1 by default tables have no OID's anymore. Since OID's are 4 byte it's
probably a good idea to discourage the use of them (they produced a lot of
trouble in the past anyways, particularly with backup/restores etc)
Now there's the issue with stored procs. A usual construct wou
On Thursday 01 December 2005 10:24, Jaime Casanova wrote:
> On 12/1/05, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote:
> > Hi everyone,
> >
> > in 8.1 by default tables have no OID's anymore. Since OID's are 4 byte
> > it's probably a good idea to dis
the ctid seems to be the solution to my problem. I'm inserting the record in a
transaction so the ctid shouldn't change while the transaction isn't finished
(either rolled back or committed).
One question though. How would I get the ctid of the just inserted record. GET
DIAGNOSTICS only handles
Try
CREATE FUNCTION .
On Tuesday 27 December 2005 09:41, Ted Byers wrote:
> I am puzzled. Can ayone explain why I get an error from Postgres on this
> simple stored procedure?
>
> The following is from the pgAdmin III History window:
> -- Executing query:
> CREATE PROCEDURE addEntity (
> f
On Saturday 07 January 2006 13:50, Michael Trausch wrote:
> Mike wrote:
> > Hi,
> >
> > I am trying to make a website where scalability matters. In my quest to
> > make my website more scalable I broke down the following SQL statement:
> >
> > select * from customers limit 100
> >
> > to:
> >
> > s
I don't really know what you're trying to accomplish here, but dropping and
creating thousands of tables is never a good idea with any database system.
You can certainly do that, just don't expect any query to run at their best
performance. You'd need to at least do a vacuum before starting to qu
On Friday 27 January 2006 08:25, Aaron Colflesh wrote:
> Hello folks,
> I've run into a challenge that doesn't appear to have been discussed in
> the archives anywhere.
>
> I'm designing a database that users need to have the ability to
> customize some. They just need the ability to add extra fiel
I bet donations to support the project are appreciated.
Other than that, the postgreSQL license is BSD - which basically means you can
do whatever you want, you just can't sue anyone if it's not working.
This has been answered a thousand times, so checking mailing list archives and
the FAQ shou
Probably because the notice you see is a notice from the database engine, not
from the driver.
You can however turn off those notices in postgresql.conf
On Monday 06 February 2006 14:30, Tyler MacDonald wrote:
> I'm using the DBD::Pg driver and i've specifically turned "PrintWarn" off,
> yet I
Depending on your keys neither.
Rather let the DB handle the resultset. count(*) is quite slow.
How about something like
select blablabla from _complex_query order by _key_ (optional DESC or ASC)
OFFSET xxx LIMIT 15
where your offset would be a parameter from the php side and is basically the
I don't think you have duplicate databases - that would be the first time I
heard that postgreSQL supports that.
Are you sure you didn't create the database with a name that just doesn't
print?
I.e. a simple
createdb test
works.
do another
createdb "test "
(note the space)
works too, but when
On Wednesday 15 February 2006 18:49, Chris wrote:
> > And since MySQL already has got the upperhand in terms of marketing,
> > Oracle would buy MySQL to make it as the low-end alternative. Never mind
> > the lack/immature features in MySQL such as stored proc or trigger.
>
> Mysql 5 has stored pro
AFAIK NULL is not a value according to SQL spec, so it doesn't match in a "not
in" clause (or any other value comparing clause for that matter, i.e. blabla
>= 10 will not match rows where blabla is null). Therefor I'd say the result
of 30 is correct.
If you want to see null results too you shou
As long as the SQL standard is supported, support for the "ancient" syntax
shouldn't be removed - at least not without a very long period of transition.
Do you have any idea how many applications the removal of something simple
like the cast operator :: will break?
It's not difficult to write sta
There is the earthdistance package in the contrib directory. You may want to
look into that.
On Wednesday 08 March 2006 09:10, [EMAIL PROTECTED] wrote:
> I have the lat and long data. I have created the geom column based on the
> lat and long data as below.
>
>
> UPDATE property SET geom =Ge
On Thursday 30 March 2006 21:27, Tom Lane wrote:
> Chris <[EMAIL PROTECTED]> writes:
> > kurt _ wrote:
> >> My question: Is a text field just a varchar(Integer.MAX_VALUE)?
> >
> > varchar has a max of 255 characters,
>
> You must be using some other database ;-)
>
> The current Postgres code has a
Hope nobody minds a job offer.
We have developed an application for the insurance market that is based on:
wxPython for the GUI
twisted pb as network layer
certainly python :-)
reportlab/OpenOffice/pyUno for printing
zope/plone as alternative web interface.
the database backend is postgresql.
You can technically just copy & paste the postgresql data directory IF YOU
SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
same version of postgresql. Also: this is not a good way to do it and I'd
encourage you not to use this as general means of backup (it's ok if you
On Sunday 02 July 2006 01:42, Tino Wildenhain wrote:
> Uwe C. Schroeder wrote:
> > You can technically just copy & paste the postgresql data directory IF
> > YOU SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for
> > the same version of postgresql. Als
Well, you cast all those fields to be concatenated to text. Why should the db
make a varchar out of that? I seriously doubt that 7.x made a varchar of that
- but then, 7.2 is very very old.
So either cast your fields to varchar (i.e. c.refullname::varchar ||
d.enname::varchar) or cast the result
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I think that's been part of pgadmin 2
On Monday 08 December 2003 10:49 pm, Randy Harris wrote:
> I've been scouring the PostgreSQL web site and have found several
> references to a Database Migration Wizard. I was unable, however, to find
> any deta
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Although you certainly have a point that a lot of companies rely on
"certification" in the one or other way, you'd have to admit that probably
80% of "certified" people have no clue what they are talking about.
I met so many certified people where y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You've got to have some kind of "middleware". Apache, custom, whatever.
Basically this piece of middleware gets the session key.
Have the middleware (using a common login) retrieve the ser (and password)
drom the database table and authenticate the u
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Happened to me too sometime.
If you look at the messages generated by your import you should see errors
complaining about the missing plpgsql handler. If there is no handler the
procedures will not be imported. The import code usually has something
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually that same letter is available at sco's website. The one at SCO only
has a list with all the "infringing" header files attached.
On Wednesday 21 January 2004 10:30 pm, Alex Satrapa wrote:
> Gavin M. Roy wrote:
> > Feel free to link away :)
-BEGIN PGP SIGNED MESSAGE-
(BHash: SHA1
(B
(B
(BIf the test and productive machine are the same type (i.e. intel) and the
(Bpostgresql version is the same then I would try to do a filesystem copy.
(BJust make sure both machines have the postmaster shut down and then copy over
(Bthe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What is it you want ? the count of rows matching the criteria ?
If so a standard count(*) should do. If the resultset has no rows the count(*)
will return 0 as result.
On Sunday 29 February 2004 05:02 pm, Zak McGregor wrote:
> On Sun, 29 Feb 2004 1
1 - 100 of 119 matches
Mail list logo
