am Wed, dem 22.11.2006, um 16:34:02 -0800 mailte snappingturtle folgendes:
> It appears that in my installation of Postgres that dollaw sign quoting
> is disabled. For example, the following command returns an error:
>
> CREATE or replace FUNCTION add_em(int, int) RETURNS integer AS $$
> S
Hello all
Let me introduce myself first. I am the ex-lead developer of SQLyog
(one of the most popular GUI for MySQL which is Windows only and runs
on Linux through WINE, more info at http://www.webyog.com).
===
New Project: wxWidgets based cross-platform GUI for Open Source databases
===
===
- Of the few multiple-db GUIs, 99% (or probably 100%) use JDBC/ODBC
layer to connect and work with the databases and JAVA or some other kind
of high level toolkit/language to develop the GUI. This results in
applications being bulky and slow and never able to provide the speed
that a low level C/C
2006/11/25, Ritesh Nadhani <[EMAIL PROTECTED]>:
Hello all
Let me introduce myself first. I am the ex-lead developer of SQLyog
(one of the most popular GUI for MySQL which is Windows only and runs
on Linux through WINE, more info at http://www.webyog.com).
===
New Project: wxWidgets based cro
Ben wrote:
Yes, it does. So of course it depends on how you use it to know what's
going to be more efficient. For instance, if the rows in this table
contain strings of more than a few bytes, and more than a couple tables
reference this table with a foreign key, then you will quickly start to
Tom,
If the real-world primary key is large (say up to 100 characters in length)
then
the disadvantage is that you are duplicating this referenced key in
several
other tables, each element taking up 100 characters. Space is wasted when
compared to int4 ID's. But not really sure if this is a pe
Hi Ritesh,
I'm in support of Tomi's comments (especially those about consulting), and
have a few more thoughts to add. To wit:
First, as an aside, as I didn't know anything about SQLyog, I read your
post first, then went to the URL cited. Throughout your post, it wasn't
clear what the subject wa
On Sat, Nov 25, 2006 at 12:14:11PM -0500, Tom Allison wrote:
> If the real-world primary key is large (say up to 100 characters in length)
> then the disadvantage is that you are duplicating this referenced key in
> several other tables, each element taking up 100 characters. Space is
> wasted
I use to use postgres quite a bit but have been working on a project for a
couple years that does not use it. I have finally convinced them to make
the switch after our current database hsqldb couldn't keep up with the
task.
So, for this project I will need postgres working on a debian server
(2.
[EMAIL PROTECTED] writes:
> 1)Do I run these old versions on my linux servers and the new version 8.1x
> for development? If I do this will I have to constantly battle
> compatibility issues when going from development to the production
> servers? Will it be a big headache? Will I be missing out
On Sat, Nov 25, 2006 at 04:23:10PM -0500, Tom Lane wrote:
> I'd advise you to be using a 2.6 kernel at this point, too. I don't
> know what the Centos guys have in mind as a schedule for releasing
> a 2.6-based distro, but again Fedora is at least as good a bet if you
> want a Red Hat based distro
Thanks for the reply.
> [EMAIL PROTECTED] writes:
>> 1)Do I run these old versions on my linux servers and the new version
>> 8.1x
>> for development? If I do this will I have to constantly battle
>> compatibility issues when going from development to the production
>> servers? Will it be a big
In all of postgres 8.1.4 (windows) databases I create there are a bunch of
cube and g_cube functions added to the db. If these are not needed, is there
a simple way to make sure that they are not added to new databases?
--
View this message in context:
http://www.nabble.com/Editing-contrib-modul
[EMAIL PROTECTED] wrote:
> 2)Is there a reliable way to install 8.1x on debian and centos using
> apt and yum?
For Debian, take a look at backports.org.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: H
On 25 Nov 2006 at 14:24, novnov wrote:
> In all of postgres 8.1.4 (windows) databases I create there are a
> bunch of cube and g_cube functions added to the db. If these are not
> needed, is there a simple way to make sure that they are not added to
> new databases?
As I was telling you on the p
Hi Ray - yes I read and checked in to your advice on the other list but I
posted here because the procedure looked a little complex and possibly risky
for a newbie like me. Rather than ask you for a simpler way to go, I figured
I'd post here and see what I came up with...and knew of course that yo
I hadn't checked and the page you pointed to here was different from the one
you pointed to on the other list
(http://www.postgresql.org/docs/techdocs.22). I've experimented a bit and
have been able to see what template0 consists of by creating a db based on
it. It lacks the ref to the lang plpgsq
Thanks for ur help guys.
--
View this message in context:
http://www.nabble.com/How-to-restore-a-dumbed-file-in-postgreSQL-tf2695735.html#a7535475
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of broadcast)---
TI
No, I realized afterwards that I had mistakenly installed a 7.x
version of PG. I had hoped that cancelling my post to Google groups
would eradicate it, but alas, posting to the net is like throwing
feathers to the wind.
Sorry for the distraction.
Miko
On 11/24/06, Bricklen Anderson <[EMAIL PRO
During schema duplication, I need to duplicate all user-defined triggers in
new schema in 8.1+
I created a query which returns trigger definitions which will be run
against new
schema.
Is this the best way or is it possible to get CREATE TRIGGER statements
without schema names or with new schema
Well.. you are correct!
After studying the contents of "/etc/init.d/postfresql", I put
"PGDATA=/home3/mylargedisk/data" in "/etc/sysconfig/pgsql/postgresql"
and it now works.
So what the . is this PGDATA!! It must be a trivial concept
cause nobody else is worried about how it works!! An
New Project: wxWidgets based cross-platform GUI for Open Source
databases
You might also want to investigate XUL (http://en.wikipedia.org/wiki/
XUL). In addition to having low level C/C++, you can provide the
ability to create interfaces with XML and JavaScript. Applications
can run stand
Hello
On 11/25/06, Thomas Kellerer <[EMAIL PROTECTED]> wrote:
> - Of the few multiple-db GUIs, 99% (or probably 100%) use JDBC/ODBC
> layer to connect and work with the databases and JAVA or some other kind
> of high level toolkit/language to develop the GUI. This results in
> applications being
Hello
On 11/25/06, Richard Troy <[EMAIL PROTECTED]> wrote:
Hi Ritesh,
I'm in support of Tomi's comments (especially those about consulting), and
have a few more thoughts to add. To wit:
First, as an aside, as I didn't know anything about SQLyog, I read your
post first, then went to the URL ci
Thanks for the info. I will take a look at it soon.
On 11/25/06, John DeSoi <[EMAIL PROTECTED]> wrote:
> New Project: wxWidgets based cross-platform GUI for Open Source
> databases
You might also want to investigate XUL (http://en.wikipedia.org/wiki/
XUL). In addition to having low level C/C++
25 matches
Mail list logo
