OK, I see. I first used the Postgres admin tool in webmin (Linux/unix
web admin tool)
to create the first table. I guess that it quoted my "Project" table.
Anyhow, I dropped
the table from the same tool, and then went to DBVisualizer and
recreated all my tables
there, using uppercase for all tab
Ron Mayer wrote:
Did anyone get multi-column GIST indexes working using both
the gist_btree and postgis modules?
Not quite stable yet.
It seems to work fine for me on small test cases (shown
at the bottom), but seems to crash my database for large
ones. Any advice is welcome - including pointers
Ron Mayer <[EMAIL PROTECTED]> writes:
> On Mon, 28 Feb 2005, Tom Lane wrote:
>> You could shorten the intervals for which the lock is held by reducing
>> vacuum_mem, but this might be counterproductive overall.
> Does this work?
[ thinks about it... ] No, probably not; sorry for the misinforma
On Mon, Feb 28, 2005 at 07:49:54PM -0800, Yu Jie wrote:
> 1. What's the restriction of database file? How big it
> can be(for exmaple, 10TB?).
See "What is the maximum size for a row, a table, and a database?"
in the FAQ:
http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.4
> 2. Is t
Hi all,
In the document of PostgreSQL, I can't find any
restriction of database. I want to know something as
following:
1. What's the restriction of database file? How big it
can be(for exmaple, 10TB?).
2. Is there any restriction for the record and the
document? What kind of record and docume
On Mon, 28 Feb 2005, Tom Lane wrote:
>
> You could shorten the intervals for which the lock is held by reducing
> vacuum_mem, but this might be counterproductive overall.
Does this work?
I just tried:
setting vacuum_mem=1024
setting vacuum_cost_delay=10
ran a while loop that repea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Source code MD5 and SHA1 checksums for PostgreSQL 8.0.0
For instructions on how to use this file, please see:
http://www.gtsm.com/postgres_sigs.html
## Created with md5sum:
3fe6bb504a6457daa80bc32daf10122e postgresql-8.0.0.tar.bz2
57984b8b016501
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Source code MD5 and SHA1 checksums for PostgreSQL 8.0.1
For instructions on how to use this file, please see:
http://www.gtsm.com/postgres_sigs.html
## Created with md5sum:
075ac81c865b0af865459260bf1ca890 postgresql-8.0.1.tar.bz2
b8f8edce5b29bc
> Pgpool is a real cool project, I really hope it keeps evolving. I have a
> couple basic/fundamental questions that I hoping to get some clarification on.
>
> Question 1: If pgpool is used in conjuntion with slony or a another
> replication it can be used only for its loadbalancing and failove
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> BTW, the current code for upper/lower etc. seems to be broken. The
> exact problem you have are happening in Japanese encodings too(EUC_JP)
> too. PostgreSQL should not use wide-character method if LC_CTYPE is C.
Yeah, we came to that same conclusion a fe
Ron Mayer <[EMAIL PROTECTED]> writes:
> When you VACUUM a table with postgis indexes (perhaps GIST indexes
> in general?) it seems a lock is held on the table.
GIST isn't concurrent-safe.
> Any clever workarounds?
Fix GIST ;-)
You could shorten the intervals for which the lock is held by reduc
Wes <[EMAIL PROTECTED]> writes:
> Why is the vacuum time not going up linearly?
I'm betting that the database is suffering from substantial bloat,
requiring VACUUM to scan through lots of dead space that wasn't there
before. Check your FSM settings (the tail end of the output from a
full-database
On Mon, Feb 28, 2005 at 03:28:24PM -0800, Mohsen Pahlevanzadeh wrote:
> Dears,I need to create an pgsql user in C.
Perhaps you're looking for the libpq or ECPG documentation:
http://www.postgresql.org/docs/8.0/interactive/libpq.html
http://www.postgresql.org/docs/8.0/interactive/ecpg.html
> Ple
Apparently your hack does not kill #define USE_WIDE_UPPER_LOWER.
BTW, the current code for upper/lower etc. seems to be broken. The
exact problem you have are happening in Japanese encodings too(EUC_JP)
too. PostgreSQL should not use wide-character method if LC_CTYPE is C.
--
Tatsuo Ishii
> L.S.
Dears,I need to create an pgsql user in C.
Please guide me
Yours,Mohsen.
---(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
L.S.
I have a database created on:
db=# select version();
version
-
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)
The initdb was done using no-locale and unicode as
[snip]
I think most people agree that being SQL compliant is good. The question
is: is it worth the pain for existing users?
My guess is that it is worth it, if the users are given the discretion
of treading that water.. and to save them future pain by encouraging
them to migrate toward 'other-db
We've been doing a vacuum every night. With about 254 million rows, it was
taking abut 0.8 hours. Now a few months later with about 456 million rows
it is taking 4.8 hours. I did check the archives and didn't find anything
like this.
Why is the vacuum time not going up linearly? Since vacuum h
When you VACUUM a table with postgis indexes (perhaps GIST indexes
in general?) it seems a lock is held on the table. Setting
vacuum_cost_delay seems to make vacuum hold this lock much longer.
Is this true?
If so, I assume that's not desirable behavior, right? It makes
autovacuum harder to
On Mon, 2005-02-28 at 16:43, Mohsen Pahlevanzadeh wrote:
> Dears,I need to connect to the PostgreSQL without choosing database in C.
> Please guide me..
You have to choose a database. You can choose template1 which should
always be there. Connections in libpq are to specific databases.
Dears,I need to connect to the PostgreSQL without choosing database in C.
Please guide me..
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTEC
On Mon, Feb 28, 2005 at 01:46:16PM -0600, [EMAIL PROTECTED] wrote:
>
> Hello!
>
> Clay Shirky made a comment about MySQL that I thought the PostgreSQL
> community should be aware of:
>
>http://www.shirky.com/writings/situated_software.html
>
> It's the section (mostly toward the bottom) ent
"Ben Trewern" <[EMAIL PROTECTED]> writes:
> It seems that to_char(1, '000') gives a string " 001" with a space in front.
> Is this a bug?
No.
Possibly you want 'FM000'.
regards, tom lane
---(end of broadcast)---
TIP 1: sub
Bruce Momjian wrote:
Caleb wrote:
Hi,
I am using Windows as a development environment (and database design),
and it seems that Unicode is not supported on Win32.
Yes, the problem is that we only support UTF-8 and the Win32 collation
routines only support UTF-16. You can actually use UTF-8
Hi!
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
> Possibly a binary cast (WITHOUT FUNCTION) would solve your problem,
> though I doubt it will work well on bytea values containing \0.
Thanks, I've been a bit thick here, but I just found the solution to my problem
- and
Jeff Davis <[EMAIL PROTECTED]> writes:
> In this case you just have a syntax error in your function. You have
> tried to use a single-quoted string inside of a single-quoted string.
> Escape the single quotes by writing "''" instead of "'" inside the
> function definition.
BTW, if you were working
Hi!
-Original Message-
From: Ragnar Hafstað [mailto:[EMAIL PROTECTED]
>are you sure your problem is with pg_crypto ?
>what does this produce:
> select bytea2text('Tübingen'::bytea) as foo;
>?
Well I'm sure it's not WITH pgcrypto but with actually using pgcrypto in
conjunction with U
On Mon, 2005-02-28 at 10:13 -0700, Ken Johanson wrote:
> >I'm a little worried about PostgreSQL having the same problems as PHP.
> >In PHP, every time you want to download an application, you never see
> >"This application works on php 4+". Instead, you see "This application
> >works on php4+ with
On Mon, Feb 28, 2005 at 12:50:25PM +0100, Tommy Svensson wrote:
> - I've used Oracle, DB2, Mimer, and HSQLDB before, and my experience
> with these led me
> to beleive that SQL was case insensitive. In fact, I was so sure of it
> that a case problem
> just never occured to me.
Case isn't a pr
On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote:
> > I used a straight copy of the filesystem with running database
> > (over the net in my case) and immediately after that,
> > stop the db and rsync for the last changes. This took only
> > 10 minutes (compared to 1.5h for the full fil
Jay Guerette <[EMAIL PROTECTED]> writes:
> If I disable INSERT and UPDATE triggers inside a transaction; by
> setting and resetting reltriggers in pg_class; am I correct in
> thinking that this will disable triggers globally for that table for
> the duration of that transaction?
Not if you never c
In this case you just have a syntax error in your function. You have
tried to use a single-quoted string inside of a single-quoted string.
Escape the single quotes by writing "''" instead of "'" inside the
function definition.
For example:
CREATE FUNCTION month_idxable(date) returns date AS 'SELE
On Feb 28, 2005, at 7:11 AM, Konstantin Danilov wrote:
I need to compile postgres 8 for Windows to set up the locale support.
The distributive accessible from FTPs does not support it, and I
cannot sort Russian letters - that's why..
I have MS Visual Studio 6, but I've never worked with it. So, h
Hello!
Clay Shirky made a comment about MySQL that I thought the PostgreSQL
community should be aware of:
http://www.shirky.com/writings/situated_software.html
It's the section (mostly toward the bottom) entitled, "The Nature of
Programming, and the Curious Case of MySQL". The whole article
"Markus Wollny" <[EMAIL PROTECTED]> writes:
> ... I'am using the following function as workaround for a bytea-to-text-cast:
> create or replace function bytea2text(bytea) returns text as '
> begin
>return $1;
> end;
> ' language plpgsql;
That looks like your problem right there.
Possibly
On Sun, Feb 27, 2005 at 09:27:41PM +0100, Tino Wildenhain wrote:
> Hi,
>
> Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby:
> > On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> > > On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > > > Thanks!
> > > >
> > > > Is there
Hello all,
I am interested in setting up an index with a date_part as
part of it… From what I have been able to find I need to write a function
that will return the date_part that I want I have tried
CREATE FUNCTION month_idxable(date) returns date AS 'SELECT date_part('month', date)
f
On Mon, 2005-02-28 at 18:32 +0100, Markus Wollny wrote:
> To get straight to the point, here's my problem:
>
> mypgdb=# select bytea2text(decrypt(encrypt('Tübingen'::bytea,
> 'mypassphrase'::bytea,'bf'::text),'mypassphrase'::bytea,'bf'::text)) as foo;
>foo
> -
> T\303\274
Caleb wrote:
> Hi,
>
> I am using Windows as a development environment (and database design),
> and it seems that Unicode is not supported on Win32.
Yes, the problem is that we only support UTF-8 and the Win32 collation
routines only support UTF-16. You can actually use UTF-8 if you don't
care
On Sun, Feb 27, 2005 at 03:27:48PM -0800, Mohsen Pahlevanzadeh wrote:
> Dears,I need to read 1 field with select command from mysql. Then
> Write it to pgsql. Please guide me.
If you need to do this directly, look into dbi-link.
http://pgfoundry.org/projects/dbi-link/
There are conversion
Martijn van Oosterhout wrote:
> Incidently, if you disable the backslash quoting, how does one enter
> raw binary data including NUL (\0) characters?
The bytea type has its own internal quoting/escaping mechanism (which
overlaps with the lexer's mechanism in some ways), so entering binary
data i
On Mon, Feb 28, 2005 at 17:46:43 +0100,
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
>
> There are 5 vaccinations in a given vaccination schedule.
>
> Patient had 3 shots.
>
> I want the view to show me that shot 4 and 5 are missing
> without having to enter the cardinality of the vaccination in
Karsten Hilbert wrote:
> There are 5 vaccinations in a given vaccination schedule.
>
> Patient had 3 shots.
>
> I want the view to show me that shot 4 and 5 are missing
> without having to enter the cardinality of the vaccination in
> the original data.
That sounds like you are trying to abuse the
> OT: You have other database issues: http://www.gnumed.org/
>
>
> error
> insert into WebLog values(586,31,"2005-02-28","")
> Duplicate entry '2005-02-28' for key 2
>
Yes I do and no I don't. That database underlies a "Wiki"
written by one of our contributors. Nothing directly related
to GnuMed
Bruno Wolff III wrote:
On Mon, Feb 28, 2005 at 10:13:00 -0700,
Ken Johanson <[EMAIL PROTECTED]> wrote:
Besides, the version-deprecation / version requirements you mention
exists in every piece of software I've even seen. Sometime they're okay
with a really old version, sometime only the newest
Envbop wrote:
I have to move a pgsql database which is running on a linux box to a Windows
2003 server, so just started to find out about pgsql
Not sure what version of pgsql is running on the linux box. This a library
application written in php?.
Any recommendations on how to do this migration
On Mon, Feb 28, 2005 at 10:13:00 -0700,
Ken Johanson <[EMAIL PROTECTED]> wrote:
>
> Besides, the version-deprecation / version requirements you mention
> exists in every piece of software I've even seen. Sometime they're okay
> with a really old version, sometime only the newest will do. This
On 27 Feb 2005 at 15:47, Hrishikesh Deshmukh wrote:
> My sincere apologies if this is not the right list.
> I want to build a GUI for postgres DB, is there any toolkit available
> which allows to whip up a GUI real fast? General features for the GUi
> are like select a file to upload, login for DB
On Sun, 27 Feb 2005, Simon Riggs wrote:
> On Fri, 2005-02-25 at 16:48 -0800, Ron Mayer wrote:
> > Getting closer?
> For me, yes. [...]
> The not-warnings seem a little wordy for me, but they happen when and
> how I would hope for.
>
> So, for me, it looks like a polish of final wording and commi
Sebastien FLAESCH wrote:
Hi,
Parameterized queries (PREPARE/EXECUTE), is a great thing, but it would
even be better if the DECLARE CURSOR could use a PREPAREd statement, to
declare a "server-side" cursor with a parameterized query, to use the
benefits of DECLAREd cursors (no fetching of all the
> I've finally got around to writing the two nagios plugins which I am
> using to check our slony cluster (on our linux servers). I'm posting
> them in case anyone else wants them or to use them as a basis for
> something else. These are based on Christopher Browne's scripts that
> ship with slony.
Hi,
Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby:
> On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> > On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > > Thanks!
> > >
> > > Is there any documentation on how to upgrade to 8.0?
> > >
> > > Is it possible to upgra
Pgpool is a real cool project, I really hope it keeps evolving. I have a
couple basic/fundamental questions that I hoping to get some clarification on.
Question 1: If pgpool is used in conjuntion with slony or a another replication
it can be used only for its loadbalancing and failover. I am c
On Saturday 26 February 2005 09:41, Tatsuo Ishii wrote:
> Hi, I don't know here is an appropriate place but...
>
> In http://www.postgresql.org/community/lists/ there's "Regional
> Lists". It would be nice if Japan PostgreSQL community's regional list
> "pgsql-jp" is added to it. The list page is
>
Tommy Svensson presumably uttered the following on 02/27/05 18:50:
I have just installed Postgresql and tried it for the first time.
One very serious problem I ran into was when actually trying to use
created tables.
Creating a simple table without any foreign keys works OK, but after
creating t
Try putting quotes around the table name:
select * from "Table";
?
Do you see it in the table list?
\dt
Tommy Svensson wrote:
I have just installed Postgresql and tried it for the first time.
One very serious problem I ran into was when actually trying to use
created tables.
Creating a simple tabl
miguel angel rojas aquino wrote:
> hi everybody
>
> first, it is not that i'm migrating from postgresql to oracle, it's
> just that we have a payroll system (we are a software development
> company) that currently runs on postgresql, but the goal is that it
> runs on other databases too (for our i
On Sun, 2005-02-27 at 18:50 -0500, Tommy Svensson wrote:
> I have just installed Postgresql and tried it for the first time.
>
> One very serious problem I ran into was when actually trying to use
> created tables.
> Creating a simple table without any foreign keys works OK, but after
> creating
On Sun, 27 Feb 2005, Tommy Svensson wrote:
> I have just installed Postgresql and tried it for the first time.
>
> One very serious problem I ran into was when actually trying to use
> created tables.
> Creating a simple table without any foreign keys works OK, but after
> creating the
> table it
Am Sonntag, den 27.02.2005, 18:50 -0500 schrieb Tommy Svensson:
> I have just installed Postgresql and tried it for the first time.
>
> One very serious problem I ran into was when actually trying to use
> created tables.
> Creating a simple table without any foreign keys works OK, but after
> c
OT: You have other database issues: http://www.gnumed.org/
error
insert into WebLog values(586,31,"2005-02-28","")
Duplicate entry '2005-02-28' for key 2
On Sun, 27 Feb 2005 18:08:02 +0100, Karsten Hilbert
<[EMAIL PROTECTED]> wrote:
> > > is there a way return a column with the row number autom
Hi,
Parameterized queries (PREPARE/EXECUTE), is a great thing, but it
would even be better if the DECLARE CURSOR could use a PREPAREd
statement, to declare a "server-side" cursor with a parameterized
query, to use the benefits of DECLAREd cursors (no fetching of all the
result set on the client, us
On Sun, Feb 27, 2005 at 06:25:18PM -0700, Ken Johanson wrote:
> I feel somewhat confident (very actually) that a config option that
> disabled the backslash behavior globally(*) would be acceptable, BUT
> leave the current backslash behavior turned on by default so that
> current users are not i
Hello!
To get straight to the point, here's my problem:
mypgdb=# select bytea2text(decrypt(encrypt('Tübingen'::bytea,
'mypassphrase'::bytea,'bf'::text),'mypassphrase'::bytea,'bf'::text)) as foo;
foo
-
T\303\274bingen
(1 row)
I have compiled and installed pg_crypto and I
You will have to export from mysql and then insert into postgresql. If you
are using postgresql 8 or above, you can use dbi-link
(http://pgfoundry.org/projects/dbi-link/) to set up a view in your
postgresql for the table in mysql and select directly from it.
Sean
- Original Message -
Thanks for all the replys, I got quite a lot of them, and haven't had
time to read them all yet, but
one common comment I get is "You didn't supply enough information" , "be
more specific", etc.
You are of course right.
From the answers I got however, it seems to be a very high propability
that
Hello list
I need to compile postgres 8 for Windows to set up the locale support. The
distributive accessible from FTPs does not support it, and I cannot sort
Russian letters - that's why..
I have MS Visual Studio 6, but I've never worked with it. So, how can I do
everything?
-
> > > > is there a way return a column with the row number automatically
> > > > generated according the way the rows were processed by the query.
> > >
> > > No, but you can easily keep a counter in the client.
> >
> > How, then, do I do it if I "need" the "row number" in a view ?
>
> Keep the co
If you insert the results of your query into a table with a serial
column, the serial column will do what you want..
Plus add a huge overload... ?
Having some sort of line numbering in result query would be nice...
- Original Message -
From: "Mike Harding" <[EMAIL PROTECTED]>
To: "P
On Sun, 2005-02-27 at 15:47 -0500, Hrishikesh Deshmukh wrote:
>Hi All,
>
>My sincere apologies if this is not the right list.
>I want to build a GUI for postgres DB, is there any toolkit available
>which allows to whip up a GUI real fast? General features for the GUi
>are like select a file to uplo
I'm a little worried about PostgreSQL having the same problems as PHP.
In PHP, every time you want to download an application, you never see
"This application works on php 4+". Instead, you see "This application
works on php4+ with the following config options set ".
Sometimes these applications h
NTPT wrote:
> Having some sort of line numbering in result query would be nice...
The query result has line numbering. How else are you accessing the
individual rows?
Is the issue really that you want psql to number the lines on display?
That could be implemented.
--
Peter Eisentraut
http:
Ben Trewern wrote:
Is there any reason why :
SELECT char_length(to_char(1, '000'));
Gives a result
char_length
-
4
(1 row)
It seems that to_char(1, '000') gives a string " 001" with a space in front.
Is this a bug?
Regards,
Ben
Try formatting the result:
SELECT char_leng
Hi,
I am using Windows as a development environment (and database design),
and it seems that Unicode is not supported on Win32.
Is there word on when Unicode support will be implemented on the
Windows port of PostgreSQL?
I was used to using mySQL and it supported Unicode on Windows
properly.. B
Hi,
Parameterized queries (PREPARE/EXECUTE), is a great thing, but it
would even be better if the DECLARE CURSOR could use a PREPAREd
statement, to declare a "server-side" cursor with a parameterized
query, to use the benefits of DECLAREd cursors (no fetching of all the
result set on the client
Hi
I have to move a pgsql database which is running on a linux box to a Windows
2003 server, so just started to find out about pgsql
Not sure what version of pgsql is running on the linux box. This a library
application written in php?.
I have just installed php v5.0.0 and postgresql v 8.0.1 o
Did anyone get multi-column GIST indexes working using both
the gist_btree and postgis modules?
It seems to work fine for me on small test cases (shown
at the bottom), but seems to crash my database for large
ones. Any advice is welcome - including pointers to better
lists to ask questions like t
[EMAIL PROTECTED] (Rick Casey) writes:
> CREATE OR REPLACE FUNCTION logPedigreesDel() RETURNS TRIGGER AS '
> begin
> RAISE EXCEPTION ''OLD.famindid = '', OLD.famindid;
RAISE EXCEPTION ''OLD.famindid = %'', OLD.famindid;
^
> return OLD;
> end;
Yes, we compile our own kernel based on the "stardardised" stable release
available at the time. Everything we need is compiled in. This is what I
mean by standard Linus approved kernel release (as opposed to an AC/MM
modified release etc.)
- Original Message -
From: "Keith C. Perry" <
Is there any reason why :
SELECT char_length(to_char(1, '000'));
Gives a result
char_length
-
4
(1 row)
It seems that to_char(1, '000') gives a string " 001" with a space in front.
Is this a bug?
Regards,
Ben
---(end of broadcast)--
Hrishikesh Deshmukh wrote:
Hi All,
My sincere apologies if this is not the right list.
I want to build a GUI for postgres DB, is there any toolkit available
which allows to whip up a GUI real fast? General features for the GUi
are like select a file to upload, login for DB
A GUI for the web, MS
Hey, thanks to everyone who replied to my questions: problem solved!
I needed to: 1) do BEFORE DELETE to see the OLD variables, and 2) use a
placeholder in my format string in the RAISE EXCEPTION/NOTICE statement.
Open source newsgroups rock!
--rick
Rick Casey, Research Associate
Institute for Be
I prefer GTK, but your platform will be Windows or *NIXes?
(If you choose Linux I will be very glad to help you)
- Original Message -
From: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>
To:
Sent: Sunday, February 27, 2005 2:47 PM
Subject: [GENERAL] GUI
Hi All,
My sincere apologies if this i
Martijn van Oosterhout wrote:
On Sun, Feb 27, 2005 at 06:25:18PM -0700, Ken Johanson wrote:
I feel somewhat confident (very actually) that a config option that
disabled the backslash behavior globally(*) would be acceptable, BUT
leave the current backslash behavior turned on by d
On Sun, 2005-02-27 at 18:25 -0700, Ken Johanson wrote:
> >>Uh, yea, this is going to require quite a bit of discussion in the
> >>group, and I am concerned how it will affect other apps using
> >>PostgreSQL. (The mode isn't going to be useful if it breaks plug-in
> >>extensions and stuff.)
> >>
Hi All,
My sincere apologies if this is not the right list.
I want to build a GUI for postgres DB, is there any toolkit available
which allows to whip up a GUI real fast? General features for the GUi
are like select a file to upload, login for DB
Thanks in advance.
HD
---
It's a Win98 machine.
Bruno Wolff III <[EMAIL PROTECTED]> írta:
> On Fri, Feb 25, 2005 at 21:19:34 +0100,
> Berényi Gábor <[EMAIL PROTECTED]> wrote:
> >
> > I have a dotgeek.org free account, but they are about to leave
> > PostgreSQL for MySQL which is too bad. Can you suggest me a
> > fre
On Sun, Feb 27, 2005 at 21:48:00 +0100,
Berényi Gábor <[EMAIL PROTECTED]> wrote:
> It's a Win98 machine.
That makes it trickier. I think it is possible to get it to install on
W98, but the FAT file system isn't safe. There were some messages discussing
this within the last couple of months. For
If I disable INSERT and UPDATE triggers inside a transaction; by
setting and resetting reltriggers in pg_class; am I correct in
thinking that this will disable triggers globally for that table for
the duration of that transaction? So an INSERT or UPDATE to this
table, outside of the transaction and
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---
Ro
[ Previous version removed.]
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
--
Dears,I need to read 1 field with select command from mysql.Then Write it
to pgsql.
Please guide me.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMA
On Sun, Feb 27, 2005 at 06:50:50PM -0500, Tommy Svensson wrote:
> SELECT * FROM ;
> SELECT * FROM public.;
> SELECT * FROM .public.;
>
> All result in the message "The relation does not exist!" or "The
> relation public. does not exist!".
Could you copy and paste the *exact* commands and error
Uh, yea, this is going to require quite a bit of discussion in the
group, and I am concerned how it will affect other apps using
PostgreSQL. (The mode isn't going to be useful if it breaks plug-in
extensions and stuff.)
The hard part of this isn't turning off backslash quoting; the code
chan
95 matches
Mail list logo
