?
Version: postgres (PostgreSQL) 9.2.2
Thank you in advance,
Regards,
Johan
--
Johan Thomsen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nt from my smartphone
You can try DbVisualizer at www.dbvis.com, even the Freeware Version is good.
Johan Nel
Durban, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nd not other tables columns... using the below:
delete from pg_attribute where attrelid = regclass 'yourviewname' and attname =
'columnnametodrop'
Best to first do couple of selects until you have the selection correct:
select attrelid::regclass as whatever, * from pg_attrib
ifferent
thing from single vendor software, where support will continue as long as the
vendor finds it worthwhile to provide it.
Best Wishes,
Chris travers
Not to forget that Skype has used PostrgeSQL from the start... Probably a very
good case study to use that PG is mainstream enough.
Johan Nel
South Africa.
- Original Message -
> From: "Adarsh Sharma"
>
> This Link gives the capitals of all countries but I need the states
> and their capitals in all these countries too..
> But I think this is not possible because very few countries are
> divided into states and some into cantons, county etc
IGGER AS $$
BEGIN
IF NOT isset(NEW.modified) THEN
NEW.modified = NOW();
END IF;
RETURN NEW;
END;
$$ LANGUAGE 'plpgsql';
Does anyone know how to do this?
Thanks in advance!
/ Johan
--
View this message in context:
http://old.
nge the TYPE of a
column.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the data.
3. You have an application that have an option to insert the current
datetimestamp into your dumplog table and then read the exported table
after completion.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
_user.
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Yes I agree, that was why I initially said to do a couple of selects
before doint the update to ensure only the applicable columns get
updated.
>> Just first do some select statements to ensure you only
>> update what you really want to.
Regards,
Johan Nel
Pretoria, South Africa
a drop and
recreating of the queries without any side effects.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
direction will
either drown in their own information pollution or loose millions on
systems that are late, cost too much, and atrophy too quickly.”
Regards,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
something Timeout=60 or bigger.
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
know, exactly what I am using for
all my front-end applications.
Regards,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t almost impossible to have not more than
50% of a table's columns redundant.
If you need more info regarding this approach, feel free to contact me in
private.
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
w5~row9 | 3
row4 | row2 | 1 | row2~row4 | 4
row6 | row4 | 2 | row2~row4~row6 | 5
row8 | row6 | 3 | row2~row4~row6~row8 | 6
(6 rows)
Regards,
Johan Nel
Pretoria, South Africa.
Keresztury Balázs wrote:
hi,
I'm currently developing a
'\\'
I took the code directly from the help files for Npgsql. My question, how
do one use the E'\\' on a bytea column that is passed into a NpgsqlCommand
statement using NpgsqlParameter?
TIA,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-ge
are more than enough.
However the moment you start having to reference the spatial data to a
position on earth, you really cannot use anything else than PostGIS.
So in general, of you have spatial features all starting with a
reference point of (0,0) use the build-in support.
HTH,
Johan Nel
e", FileMode.Create,
FileAccess.Write);
BinaryWriter bw = new BinaryWriter(new BufferedStream(fs));
bw.Write(result);
bw.Flush();
fs.Close();
bw.Close();
conn.Close();
}
}
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pg
a "Expiry
flag/Inactive flag" on your user table to allow old records to be
viewed, but records can only be inserted/updated/deleted by current
active users. In this scenario, your user DELETE re-root your delete
statement to only deactivate the user from logging into the database.
t case:
You probably don't need to do anything except making sure that the
server and PG allows access from the IP address range used at the branch
office.
From the branch office you need to make your connection point to the IP
address of the PG server...
HTH,
Johan Nel
Pretoria, South A
again
END;
END LOOP;
END;
$$
LANGUAGE plpgsql;
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;
LOOP
IF rec.credit < 0 THEN
...
ELSE
...
END IF;
END LOOP;
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
only be used
in a stored procedure/function.
Johan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
OO is defined in programming languages, it is clear
that Cache follow a design nearer to programming language implementation.
So from my perspective, PG is not really a OO DB. We can however
through design make it to emulate OO, but it is not forced.
My 2cents worth.
Johan Nel
Pretoria
r the above, it does not need to be exactly the same, but are there a
group of functions available to at least return in a dynamic query the
number of columns, name of a column given the ordinal number of the
column, etc?
TIA,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general
into the central database.
Regards,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
IP address range that you want to
connect from, similar to:
host all all 10.0.0.1/8 md5
Remember to reload your configuration.
HTH,
Johan Nel
Pretoria, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
#x27;, 'id', 'parentid', '',
0, '~')
AS t(keyid text, parent_keyid text, level int, branch text);
HTH,
Johan Nel
Durban, South Africa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the server.
HTH,
Johan Nel
Pretoria, South Africa.
Martin Roach wrote:
Hi
I started the installation of postrgres got distracted and then started
again but forgot my password. I have received the info below:
Now what?
If you have access to shell account on the machine PostgreSQL is
running
t;>> That is until I can convince my new employer to realise the dark side
>>> of Microsoft SQL Server. :)
--
Johan van Zyl
[EMAIL PROTECTED] http://www.jvz.co.za
[EMAIL PROTECTED] http://www.acctual.co.za
[EMAIL PROTECTED] http://www.watzon.co.za
079 549 0034 Cell/Mobile
012 543 29
nitdb manually.
Is it even possible to install it with the Windows-installer in the
8.2.4 binary. It worked fine on Windows XP.
If it is possible, how should it be done? Does anyone have a
step-by-step guide?
I would appreciate any constructive help on this.
Thanks
/
Michael Fuhr schreef:
> On Thu, Sep 21, 2006 at 01:32:47AM -0700, Johan wrote:
> > Someone executed the query in psql for me and the problem seems to be
> > in a stored procedure triggered after update. This procedure complains
> > about the field.
>
> Were you able to
Michael Fuhr schreef:
> On Wed, Sep 20, 2006 at 02:29:16PM -0700, Johan wrote:
> > I encountered a strange problem while trying to solve a bug. I use a
> > postgresql 8.x database and a jdbc driver from
> > postgresql-8.1dev-400.jdbc3.jar. The following is happening
>
field1 from test;
results are returned normal, no problems at all, but when i do a
insert into test (field2, field1) values (1, 2);
It complains that field1 doesn't exists.
Has anyone encountered this same problem or does have anyone a pointer
for a bit more info on this problem?
Thanks,
I have posted this before without receiving replies
My code is as follows:
Public dbRemote As New Connection
Public rsData As New Recordset
dbRemote.Properties("Data Source").Value = "DSM"
dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
dbRem
user"
dbRemote.Properties("Password").Value = "password"
dbRemote.Open
rsData.Open "tblsuburb", dbRemote, , , adCmdTable
I am getting an error "relation tblsuburb does not exist"
Where am I going wrong?
Regards
Johan van der Merwe
Ballenden & Robb
dditions/deletions of fields in the tables.
ALTER TABLE ?
-- Johan
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
suffer
from the initial unresponsiveness...
-- Johan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
ting program runs only occasionally and will not be permanently
running subscribed. I'm not sure how to use LISTEN/NOTIFY for that.
-- Johan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
su
inding the
last modification timestamp. Yes, it may be the only alternative, but
a heavy one...
-- Johan
---(end of broadcast)---
TIP 6: explain analyze is your friend
ll me when the last update has been
COMMITted but until now I haven't been able to find out how. I must
have used the wrong search terms...
Can anyone tell me how to find the last update time of a database?
Thanks,
Johan
---(end of broadcast)-
If you feel the need to defragment your database files you need to set
them up differently. Using partitions on your hard disks and smart use
of tablespaces you can create a setup that needs no defragmenting.
Besides, on larger disks defragmentation isn't even necessary.On 12/1/05, David Saunders
Thanks for your help, I adjusted the function after a better reading of
the pl/Sql chapter - and feel I posted in haste.
Hopefully though it may prove useful to someone else.
Cheers
Johan Wehtje
Thomas F. O'Connell wrote:
On Oct 24, 2005, at 11:27 AM, Johan Wehtje wrote:
This is pro
.
In every case I always get the syntax error directly after "AS".
Can somebody point what is probably obvious.
Cheers
Johan Wehtje
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
between 8.0 and 8.1 in Postgres it is probably
worthwhile having a README that opens as soon as the installer is done
with information on upgrading from previous installations as well as
pointers to the change log.
Cheers
Johan Wehtje
Magnus Hagander wrote:
Magnus,
I have replied to general as
mp restore woes such as I am having.
Any suggestions you have would be appreciated
Tack på förhand
Johan Wehtje
Magnus Hagander wrote:
I don't know whether I should be posting to Hacker Win 32 or
General, but I wanted to ask if anyone else has experienced
troubles restoring a DB on windo
gis folder, but it only contains some perl scripts, the
postgis.sql file is nowhere to be found.
Is there an updated version of the installer with the missing bits of
postgis?
Cheers
Johan Wehtje
---(end of broadcast)---
TIP 9: In versions belo
oes make a difference.
Cheers
Johan Wehtje
Tony Caduto wrote:
as quick as Access to build a bunch of forms , pump data into
spreadsheets, charts, word processing applications. It is often little
things that make the difference - the speed with which drop down lists
can be created is a huge boon to
think we
already have a number of really excellent GUI DB managers, and to me
Rekall looks more like a Db Manager than Rich Client cum RAD tool for Db
centric applications.
Cheers
Johan Wehtje
John Dean wrote:
Hi Tom
At 03:32 18/10/2005, Tom Lane wrote:
Johan Wehtje <[EMAIL PROTEC
0 and beyond.
Cheers
Johan
Wim Bertels wrote:
Dear friends,
i've been using postgresql quiet some time now,
but i don't find any really good clients for "dummies" to this database.
When i look at pgadmin:
an anoying feature: it closes when u do something illegal, instead of
does
have support for transactions and Stored Procedures".
Given that from the 7 series onwards the relative speeds of MySql and
Postgresql is not something that has a clear and definitive answer, I
would suggest that the Connection Wizard text is misleading at best.
Johan Wehtje
John
its no-one.
Cheers
Johan Wehtje
Matthew Peter wrote:
Someone trying to stick microsoft yet another place
they don't belong.
--- Johan Wehtje <[EMAIL PROTECTED]> wrote:
Very much a description of the Business I am in.
For all the criticism leveled at it, I still think
that as a
pplications in this market are) or for
projects that become quite risky for developer and client alike.
Johan Wehtje
Alex Turner wrote:
Actualy to me, it seems like postgres is a perfect partner for MS
Access. Throw out Jet, and use Pgsql. It's infinately better than Jet,
so ope
Please...help me..
How to unsubcribe
thanks.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 1: if posting/re
he DB.
Johan Wehtje
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Please help me!!!
Howto insert images file from Visual basic 6 into postgreSQL database server
For information :
my database server : Fedora Core 2
my client : Win XP Pro SP #2 with visual basic 6.
thanks be4.
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile pho
of data sets (usually particular tables). I have used it
with Postgres 8.0 b2, b5, rc1 and final as well as worth 7.4.2.
You can also use it across a network (Import Access DB on Winbox1 to PG
DB on Linbox 2)
Cheers
Johan Wehtje
David Fetter wrote:
On Thu, Jan 27, 2005 at 02:50:11PM -0500
pment is very active at the
moment.
Cheers
Johan Wehtje
Geoffrey wrote:
Chris Smith wrote:
[EMAIL PROTECTED] wrote:
Does anyone know how to connect javascript to a postgresql
database
You can't connect javascript to any sort of database.
Actually you can, with server side javascript,
both licenses are similar , so from that point
of view the combination is a no-brainer.
Johan Wehtje
Wolfgang Keller wrote:
Hello,
for applications which require offline data collection/processing with PDAs
and synchronisation/replication with a centralised server database (running
on PostgreSQ
Thanks Neil,
I will just have to hassle EMS to upgrade :)
Cheers
Johan Wehtje
Neil Conway wrote:
On Tue, 2004-11-30 at 17:54 +1100, Johan Wehtje wrote:
I am getting the error "Column n.nsptablespace does not exist" in my
application when I connect using my Administrative tool.
I am getting the error "Column n.nsptablespace does not exist" in my
application when I connect using my Administrative tool. This only
happens with Version 8, but it does crash my application, does anyone
have any ideas ?
Cheers
Johan Wehtje
---(end of
has a (somewhat pricey) solution.
Cheers
Johan Wehtje
Gevik Babakhani wrote:
Checkout http://www.pgadmin.org
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *Nageshwar Rao
*Sent:* Monday, November 29, 2004
thesis project.
Johan Wehtje
Joshua D. Drake wrote:
[EMAIL PROTECTED] wrote:
Considering using the firefox SQL extension combined with XUL to
create a web
application to access a database in PostGreSQL, wondering if anyone has
attempted this, and how it turned out?
Hello,
I have played with
a bulk copy and
there was one error in line 45,000 the server would write a file with
the same name as the input file + an extension like err, with just that
row omitted . Also it would load 100 rows at a time - perform any logging.
Johan Wehtje
Victor Ciurus wrote:
And how does exactly PG8.0 he
MS SQL Server has a BULK INSERT command that can take a parameter "Start
Row" so that you can skip as many Rows as you want.
this is also available using the command line bcp utility. This would be
a nice feature for Postgresql to have , and I can't see it on any of the
to do lists, unless it is
relatively new product
called Data Architect, that appeared promising.
http://www.thekompany.com/home/
Cheers
Johan Wehtje
Eric wrote:
Heu...
I search for a graphical DATA MODEL designer in linux to developp my
database project (to draw) it on screen instead of paper and pencil...
Thanks for answers about
vant
examples, documentation or advice on how to solve this.
--
Johan Fredrik Øhman
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
vant
examples, documentation or advice on how to solve this.
--
Johan Fredrik Øhman
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
69 matches
Mail list logo
