Neil Conway <[EMAIL PROTECTED]> writes:
> A malicious user who can execute SELECT queries can already consume an
> arbitrary amount of memory -- say, by disabling GEQO and self-joining
> pg_class to itself 50 times. I'm not sure that letting users modify
> sort_mem/work_mem actually increases the r
On Thu, 2005-01-27 at 20:03 -0600, Jim C. Nasby wrote:
> Yes, there is a risk allowing ad-hoc settings; you can starve the
> machine for memory.
A malicious user who can execute SELECT queries can already consume an
arbitrary amount of memory -- say, by disabling GEQO and self-joining
pg_class to
On Thu, Jan 27, 2005 at 07:29:24PM -0600, j0rd1 adame wrote:
> Is there any way to save the result of a query in a variable, so that i could
> use that value in another query??
>
> something like set VARIABLENAME = select count(1) from table;
> and then
> select 56778/VARIABLENAME as final_resul
>
>
> With a Quad Opteron (4 memory slots per CPU), you could put 64GB of RAM
> onto a single machine using 4GB DIMMs in every slot.
We were talking about a similar solution today, but not quite as good as
this. You really got me thinking now. 64Gb.. hm that would solve many
issues. what do you th
Hi,
I just installed Postgresql 7.3.2 with Cygwin on my computer. When I try
to run "initdb -D /usr/postgresql/data" I get this message:
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in /usr/data/base/1... Signal 12
initdb: failed
can somebody help me out?
On Thu, 27 Jan 2005 20:05:19 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 27, 2005 at 05:52:41PM -0800, Lonni J Friedman wrote:
> > On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > > On Thu, Jan 27, 2005 at 02:57:22PM -0800, Lonni J Friedman wrote:
> >
Hi list:
Thank you all of you who friendly help me.
The bug was mine.
Im working in windows and the editor appended a txt
extension so that was the problem. Instead of
CreateTableWeather.sql, i've got
CreateTableWeather.sql.txt.
But by the way, i have a question (at some
extent)related:
By defaul
On Thu, Jan 27, 2005 at 05:52:41PM -0800, Lonni J Friedman wrote:
> On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > On Thu, Jan 27, 2005 at 02:57:22PM -0800, Lonni J Friedman wrote:
> > > Is there any way to increase sort_mem without having to perform a full
> > > re
On Thu, Jan 27, 2005 at 06:23:05PM -0700, Michael Fuhr wrote:
> On Thu, Jan 27, 2005 at 06:23:21PM -0600, Jim C. Nasby wrote:
> >
> > If you just want to change it for one connection, you can do 'set
> > sort_mem=newvalue;'. You might need to be an admin to do it, though.
>
> Ordinary users can s
On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 27, 2005 at 02:57:22PM -0800, Lonni J Friedman wrote:
> > Is there any way to increase sort_mem without having to perform a full
> > restart of the DB? Will just doing a 'kill -HUP $PID" work as long as
> > i
OK, but does that actually work to change sort_mem for all future connections?
On Thu, 27 Jan 2005 19:25:51 -0600, Jonel Rienton <[EMAIL PROTECTED]> wrote:
> I usually use pg_ctl reload instead of kill
>
> On Thu, 27 Jan 2005 14:57:22 -0800, Lonni J Friedman wrote
> > Is there any way to increas
On Thu, Jan 27, 2005 at 12:53:00AM -0800, sid tow wrote:
> I am updating a database using COPY commands. If
> the commmand breaks in between updating the database,
> is there any way to find the log of the previous
> updation or which part or row the loading broke.
Are you saying the COPY co
I usually use pg_ctl reload instead of kill
On Thu, 27 Jan 2005 14:57:22 -0800, Lonni J Friedman wrote
> Is there any way to increase sort_mem without having to perform a
> full restart of the DB? Will just doing a 'kill -HUP $PID" work as
> long as i've made the change in postgresql.conf first
Hi,
- Original Message -
From:
Rick
Schumeyer
To: 'PgSql General'
Sent: Thursday, January 27, 2005 4:14
PM
Subject: [GENERAL] convert mdb files to
pg?
Is there a way to import mdb files
from Access into pg?
I found a web page for mdbtools
but I c
On Thu, Jan 27, 2005 at 06:23:21PM -0600, Jim C. Nasby wrote:
>
> If you just want to change it for one connection, you can do 'set
> sort_mem=newvalue;'. You might need to be an admin to do it, though.
Ordinary users can set sort_mem/work_mem, at least in 8.0.0 and
earlier. Does setting that va
Hi:
Is there any way to save the result of a query in a variable, so that i could
use that value in another query??
something like set VARIABLENAME = select count(1) from table;
and then
select 56778/VARIABLENAME as final_result;
thanks
--
Jordi Adame V
jordi (.a.) jordi.net
http://www.lawaloca
Hi,
Some word from my test work.
I try first to just have a parser that can manage a string of unit.
like 'm s-1 kg2.5 A3.5/7.2'
The parser accept :
- any letters for the unit
- a + or - or nothing before the power
- a fractional power
- the unit separator is space ;-/
The system normalize the frac
On Thu, Jan 27, 2005 at 02:57:22PM -0800, Lonni J Friedman wrote:
> Is there any way to increase sort_mem without having to perform a full
> restart of the DB? Will just doing a 'kill -HUP $PID" work as long as
> i've made the change in postgresql.conf first?
>
> As a side question, are the optio
* Joshua D. Drake ([EMAIL PROTECTED]) wrote:
> Rick Schumeyer wrote:
> >Is there a way to import mdb files from Access into pg?
> >
> I would use ODBC to create linked tables from Pg and copy from the unlinked
> mdb tables.
I've tried doing thing and discovered that for large tables it can be
quit
Is there any way to increase sort_mem without having to perform a full
restart of the DB? Will just doing a 'kill -HUP $PID" work as long as
i've made the change in postgresql.conf first?
As a side question, are the options that will take effect with a kill
-HUP documented somewhere?
thanks!
--
On Thu, Jan 27, 2005 at 03:32:38PM -0200, Bruno Almeida do Lago wrote:
> Hello my friends,
>
> We are going to change some Oracle 8i and 9i databases to PostgreSQL
> 8 at my company.
>
> 1st: Is there somebody who knows how to do it (had the same
> experience)? What are the limitations of this p
Oleg Bartunov writes:
> On Thu, 27 Jan 2005, Max wrote:
>> The basic idea is: a user enters a search query and a maximum of 1000
>> results
>> is returned, sorted by date, newest first.
> I assume you already vacuum your db. Hmm, seems you need to rewrite your
> query.
That's not going to hel
On Thu, 27 Jan 2005, Max wrote:
Hi,
At 09:54 PM 1/27/2005, you wrote:
On Thu, 27 Jan 2005, Max wrote:
I'm setting up a simple search engine using Tsearch2.
The basic idea is: a user enters a search query and a maximum of 1000
results is returned, sorted by date, newest first.
At the moment the ta
EMS-Hitech ( http://www.sqlmanager.net ) has a product called PgDataPump
- I have used it to import a number of Access Databases to Postgres, it
is fast, quick to set up, and will even import indexes and
relationships. They also have an import utility for fine grained control
over the import o
Very dangerous. I only did it as a test to guestimate what kind of
performance I might get if I got a static ram hard drive to put the WAL
onto.
Dann Corbit wrote:
Isn't putting the WAL in memory dangerous in case of a power failure?
I would think that RI would be compromised.
-Original Mess
If you said PostgreSQL, you guessed right. The poll is at
http://sys-con.com/linux/readerschoice2004/vote.cfm. MySOL is on the
list, as are Sybase, Oracle, Ingres, and some others I don't remember
off-hand.
I'm not a subsscriber (I got an email from Sybase about this), so I
don't know who to conta
Hi,
At 09:54 PM 1/27/2005, you wrote:
On Thu, 27 Jan 2005, Max wrote:
I'm setting up a simple search engine using Tsearch2.
The basic idea is: a user enters a search query and a maximum of 1000
results is returned, sorted by date, newest first.
At the moment the table holding the searchable data
Hello,
there is no possibility change encoding after database is created. You
can only change dynamic encoding for clients,
example: czech environment use cp1250 for win clients and latin2 for
others clients generally. I init in initdb databse for latin2 encoding. If
some people goes from lati
Alonso García wrote:
Hi list:
Recently I installed postgresql 8.0, marvellous; and
I've been studying the tutorial. I got stuck in
chapter 2 "The SQL languaje". There, it says that in
order to read sql commands stored in a file you can
type:
mydb=> \i basics.sql
So I create a file named CreateT
On Thu, Jan 27, 2005 at 03:07:39PM -0600, Guy Rouillier wrote:
> Frank D. Engel, Jr. wrote:
> > I think it is an internal thing with gcc that the size of a pointer
> > and
> > sizeof(int) are always the same, regardless of machine word size...
> > with a 64-bit binary, sizeof(int) and sizeof(void
Hi list:
Recently I installed postgresql 8.0, marvellous; and
I've been studying the tutorial. I got stuck in
chapter 2 "The SQL languaje". There, it says that in
order to read sql commands stored in a file you can
type:
mydb=> \i basics.sql
So I create a file named CreateTable_weather.sql but
Frank D. Engel, Jr. wrote:
> I think it is an internal thing with gcc that the size of a pointer
> and
> sizeof(int) are always the same, regardless of machine word size...
> with a 64-bit binary, sizeof(int) and sizeof(void *) should both be 8,
> which still causes them to be equal.
On AMD64, gc
hi,
how to change encding of already created database wo win-1251 ?
tia
---(end of broadcast)---
TIP 8: explain analyze is your friend
Isn't putting the WAL in memory dangerous in case of a power failure?
I would think that RI would be compromised.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of William Yu
Sent: Thursday, January 27, 2005 12:41 PM
To: pgsql-general@postgresql.org
Subject:
>>
Rather than having the most selective item first, put the most
frequently used item first.
So (for instance) if your database is an organic chemistry database and
the columns were elements, then carbon might be a logical first choice,
hydrogen second, etc. for your index.
What you want in crea
On Thu, 27 Jan 2005, Max wrote:
Hi,
I'm setting up a simple search engine using Tsearch2.
The basic idea is: a user enters a search query and a maximum of 1000 results
is returned, sorted by date, newest first.
At the moment the table holding the searchable data has 1.1 million entries.
It works
David Potts wrote:
Postgress seems to include all this support for geometric types,
lseg,box, etc.
Is there any software for actual printing or displaying database which
has lsex, point types enumerated in it.
I did'nt mange to find any reference to this type of thing on the
current maillist.
"Frank D. Engel, Jr." <[EMAIL PROTECTED]> writes:
> I think it is an internal thing with gcc that the size of a pointer and
> sizeof(int) are always the same, regardless of machine word size...
> with a 64-bit binary, sizeof(int) and sizeof(void *) should both be 8,
> which still causes them to
On Thu, Jan 27, 2005 at 02:50:11PM -0500, Stephen Frost wrote:
> * David Fetter ([EMAIL PROTECTED]) wrote:
> > On Thu, Jan 27, 2005 at 02:14:32PM -0500, Rick Schumeyer wrote:
> > > Is there a way to import mdb files from Access into pg?
> > >
> > > I found a web page for mdbtools but I can't get i
On Thu, Jan 27, 2005 at 03:00:06PM -0500, Frank D. Engel, Jr. wrote:
> I think it is an internal thing with gcc that the size of a pointer and
> sizeof(int) are always the same, regardless of machine word size...
> with a 64-bit binary, sizeof(int) and sizeof(void *) should both be 8,
> which s
Bruno Almeida do Lago wrote:
OK! I've got to run now, but will search more about it tomorrow.
Could you give me more details / references?
You don't want to do it automatically. You want to do it by hand but it
isn't that hard.
Automatically? How?
About the link between the two databases, where
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Hmmm...the PostgreSQL binaries on my Solaris/sparc box are 32-bit
> and the FreeBSD box is a 32-bit i386, yet both are susceptible to
> the crash.
On looking at it, the problem is that the functions are defined in such
a way that you can pass any random i
Rick Schumeyer wrote:
-->
Is there a way to import mdb files from Access into pg?
I would use ODBC to create linked tables from Pg and copy from the unlinked
mdb tables.
Sincerely,
Joshua D. Drake
Command Prompt, Inc.
PostgreSQL Support
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I think it is an internal thing with gcc that the size of a pointer and
sizeof(int) are always the same, regardless of machine word size...
with a 64-bit binary, sizeof(int) and sizeof(void *) should both be 8,
which still causes them to be equal.
O
* David Fetter ([EMAIL PROTECTED]) wrote:
> On Thu, Jan 27, 2005 at 02:14:32PM -0500, Rick Schumeyer wrote:
> > Is there a way to import mdb files from Access into pg?
> >
> > I found a web page for mdbtools but I can't get it to compile.
>
> Here are a couple of ways to approach the problem:
>
Tim Vadnais <[EMAIL PROTECTED]> writes:
> bwks=# \d product
> ERROR: xlog flush request 0/215D32E4 is not satisfied --- flushed only to
> 0/15138F7C
> CONTEXT: writing block 4 of relation 17143/1682159
This looks to me like a corrupted-data problem: specifically, the LSN
field of that particular
On Thu, Jan 27, 2005 at 02:22:36PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
> >> It seems that contrib/intagg crashes my server :
>
> > I see the same thing with PostgreSQL 8.0.0 (REL8_0_STABLE) on Solaris 9
> > and
On Thu, Jan 27, 2005 at 02:14:32PM -0500, Rick Schumeyer wrote:
> Is there a way to import mdb files from Access into pg?
>
> I found a web page for mdbtools but I can't get it to compile.
Here are a couple of ways to approach the problem:
1. Use DBI and connect both to your mdb data source and
On Thu, Jan 27, 2005 at 12:09:47PM -0500, Eric E wrote:
>I'm trying to retrieve the SQL definition of a view from
> information_schema via:
> SELECT view_definition FROM information_schema.views WHERE
> table_name = 'viewname';
>It appears the definition returned is truncated at a fixed n
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
>> It seems that contrib/intagg crashes my server :
> I see the same thing with PostgreSQL 8.0.0 (REL8_0_STABLE) on Solaris 9
> and FreeBSD 4.11.
The intagg source code says
NOTE: This module requ
Is there a way to import mdb files from Access into pg?
I found a web page for mdbtools but I can’t get it to
compile.
Title: xlog flush request 0/215D32E4 is not satisfied
Can anyone help me with this problem; we are just about to go live (February 1), and all of a sudden our main database has an 'issue'. I'd like to save the database if possible, if not, then I'll rebuild it from scratch which I absolutely
OK! I've got to run now, but will search more about it tomorrow.
Could you give me more details / references?
> You don't want to do it automatically. You want to do it by hand but it
> isn't that hard.
Automatically? How?
About the link between the two databases, where can I find how to do it
Bruno Almeida do Lago wrote:
> Hello my friends,
>
>
> We are going to change some Oracle 8i and 9i databases to PostgreSQL
> 8 at my company.
>
>
> 1st: Is there somebody who knows how to do it (had the same
> experience)? What are the limitations of this process (eg:
> incompatible data type
Postgress seems to include all this support for geometric types,
lseg,box, etc.
Is there any software for actual printing or displaying database which
has lsex, point types enumerated in it.
I did'nt mange to find any reference to this type of thing on the
current maillist.
regards
David Pott
On Thu, 27 Jan 2005, Richard Huxton wrote:
[EMAIL PROTECTED] wrote:
[snip]
I need to create a shell script for cron.daily to run that will do pg_dump
for my database. I am using Redhat 9 and Postgresql v7.3.4. Currently when
I run the dump manually the command I use is
#pg_dump -u -C -D -f /tmp/ow
I'm sorry, I forgot to say I had the bug with 8rc3, then installed 8.0.0
and it is still crashing.
On Thu, 27 Jan 2005 10:52:37 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
[I've Cc'ed pgsql-bugs and set the Reply-To header to that list.]
On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
> Frank D. Engel, Jr. wrote [01/27/05 9:19 AM]:
> > On Jan 26, 2005, at 6:57 PM, PFC wrote:
> >
> >> Isn't there some free open source algebraic computation toolkit with
> >> equations and units somewhere ?
You mean like the traditional units program available on virtually all Unix
machines?
[I've Cc'ed pgsql-bugs and set the Reply-To header to that list.]
On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
>
> It seems that contrib/intagg crashes my server :
> -
> select int_agg_final_array(1);
> server c
On Thu, Jan 27, 2005 at 08:47:40 -0800,
[EMAIL PROTECTED] wrote:
>
> What should the command look like using ~/.pgpass ?
You might also consider using using ident as the authentication method if
it is supported by your os.
---(end of broadcast)--
Hello my friends,
We are going to change some Oracle 8i and 9i databases to
PostgreSQL 8 at my company.
1st: Is there somebody who knows how to do it
(had the same experience)? What are the limitations of this process (eg:
incompatible data types and objects).
2nd: Which t
[EMAIL PROTECTED] wrote:
I posted the message below on 1/15/05 and haven't received a reply yet.
Should I be asking this question on a different list?
This is probably the right list - your message may have been missed
though, there can be a lot of traffic.
I need to create a shell script for cron
On Thu, Jan 27, 2005 at 12:45:13 +0100,
Miguel Angel Tribaldos Hervas <[EMAIL PROTECTED]> wrote:
>
> I only need to know if a table has changed since the last check
> (create, update...), but I want to avoid a trigger + artificial records table.
> Is this information recorded somewhere, in a sys
On Thu, Jan 27, 2005 at 08:47:40AM -0800, [EMAIL PROTECTED] wrote:
> I need to create a shell script for cron.daily to run that will do pg_dump
> for my database. I am using Redhat 9 and Postgresql v7.3.4. Currently when
> I run the dump manually the command I use is
>
> #pg_dump -u -C -D -f /tm
Hi all,
I'm trying to retrieve the SQL definition of a view from
information_schema via:
SELECT view_definition FROM information_schema.views WHERE
table_name = 'viewname';
It appears the definition returned is truncated at a fixed number of
characters - for this view it's 7650.
Does anybod
On Thursday 27 January 2005 11:47 am, [EMAIL PROTECTED] saith:
>
> My other question... Is cron.daily is being run by root? If so would I need
> to put the .pgpass file in root's home directory?
>
--
I don't know about .pgpass, so I can't help you with that. Root does run
cron.daily. You can se
Frank D. Engel, Jr. wrote [01/27/05 9:19 AM]:
On Jan 26, 2005, at 6:57 PM, PFC wrote:
Isn't there some free open source algebraic computation toolkit with
equations and units somewhere ?
A very simple but effective system that I have used quite a lot for
"computation with units" is a Python modul
I posted the message below on 1/15/05 and haven't received a reply yet.
Should I be asking this question on a different list?
Thank you.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
- Forwarded by Ma
"TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> However, I am concerned that I must place the most selective column first in
> my index. I cannot tell, a priori, which column will be most selective. That
> depends on the nature of search, which can vary widely each time.
If you're always using > ope
I realize that using OR will not result in an index scan.
I will never be interested in a OR condition for the kinds
of searches I use. In my Select statements, I always name
every column of the multi-column index in same order that
they were named when creating the index. I always use
the >= co
It seems that contrib/intagg crashes my server :
-
select int_agg_final_array(1);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the
I realize that using OR will not result in an index scan.
I will never be interested in a OR condition for the kinds
of searches I use. In my Select statements, I always name
every column of the multi-column index in same order that
they were named when creating the index. I always use
the >= con
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yep:
http://www-fourier.ujf-grenoble.fr/~parisse/giac.html
Try things like:
convert(4_acre, _in^2)
(I'm in TI-89 mode, if that makes any difference I don't know).
On Jan 26, 2005, at 6:57 PM, PFC wrote:
Isn't there some free open source algebraic comput
Sandeep,
Using pl/perl at least, you could probably do this. My guess is that
pl/python (and perhaps pl/R) would offer similar functionality. At
least for pl/perl, I think you would need to use the untrusted version
and use a module like LWP. I haven't tried this, but I think it should
be po
Yep, I understand what you are saying.
I can live with a max of 255 occurrences, although it isnt desirable. My
main issue is the max position of the lexeme.
Take for example a document which is longer than 16384 words. Although words
beyond that point are seen, and enter the index they are mark
Sorry, but no way except patching sources of tsearch2
Tsearch2 (not GiST) has pointed limitations to save storage size mainly and to
reduce rank calculation time. Our (oleg and me) expirience in search engines
shows, that full positions info for long document hasn't a big importance to
rank
Hi,
I am using Postgres 7.3.4. I want to write a trigger for
insert, update, delete operation on say, user table. This trigger will
activate an URL. URL will be as:
http://sandeep/Trigger?userid=4&name=sandeep where, userid and password
will be parameters to send. They may taken from
Hi
I have been toying with the implementation of tsearch2 to index some large
text documents. I have run into problems where I am up against limits:
no more than 255 occurrences of a particular word are indexed.
word positions greater than 16384 are added as position 16384 and end up as
one occu
On Thu, 27 Jan 2005 18:47:44 +0530, Sandeep Gaikwad
<[EMAIL PROTECTED]> wrote:
> Hi,
> I am using postgres 7.3.4. I am new to postgres.
> I can give foreign key relationship between two tables of same
> database. Can I give foreign key relationship between tables of two databases
Hi,
I did a benchmarking on pgpool with replication mode enabled. The
result is reported at
http://pgpool.projects.postgresql.org/bench_24.html.
An interesting fact is pgpool outperform ordinary PostgreSQL at 128
concurrent connections despite of replication overhead. I would like
to hear from any
On Thu, 27 Jan 2005, Sandeep Gaikwad wrote:
> I can give foreign key relationship between two tables of same
> database. Can I give foreign key relationship between tables of two
> databases ? Plz, let me know if possible & send me how can I do that?
Unfortunately, that's not really current
Hi,
I am using postgres 7.3.4. I am new to postgres.
I can give foreign key relationship between two tables of same database. Can I give foreign key relationship between tables of two databases ? Plz, let me know if possible & send me how can I do that?
Thanks & Regards,
Sandeep.
--
Hi,
I'm setting up a simple search engine using Tsearch2.
The basic idea is: a user enters a search query and a maximum of 1000
results is returned, sorted by date, newest first.
At the moment the table holding the searchable data has 1.1 million entries.
It works great when the search only produ
TJ O'Donnell wrote:
More specifically, I have character data representing molecular structures.
I've written (rather slow) search functions. I can create any number of
columns that "fingerprint" each structure, e.g. # Carbon atoms, # N atoms,
# single bonds, etc. I expect my fingerprints will not
[EMAIL PROTECTED] wrote:
In another thread (Re: [GENERAL] Return value of 'serial' column on insert)
Bruno Wolff wrote
...
You can use the currval function to get the id. Normally the sequence
will have a name like table_column_seq. In 8.0, there is a function
you can use to get the sequence name,
In another thread (Re: [GENERAL] Return value of 'serial' column on insert)
Bruno Wolff wrote
...
> You can use the currval function to get the id. Normally the sequence
> will have a name like table_column_seq. In 8.0, there is a function
> you can use to get the sequence name, which is a bit mor
subscribe
end
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
I only need to know if a table has changed since the last check
(create, update...), but I want to avoid a trigger + artificial records table.
Is this information recorded somewhere, in a system table perhaps?
What about a hash value refered to any table?
Thanks.
>>Miguel Angel Tribaldos Hervas
Miguel Angel Tribaldos Hervas wrote:
Hi all!
Two related questions about a problem i'm trying to solve:
How can I know the last tuple affected by an insert/update operation per
table??
Is there exists any function in Postgres for retrieving some hash
value from a table??
You don't define what you m
On 27/01/2005 01:06 phil campaigne wrote:
Hi All,
I have a double type in java that I am trying to store in postgresql as
type numeric and it doesn't seem to like it. The error message is,
function double(numeric) does not exist
unable to identify a function that satisfies the given argument type
Hi all!
Two related questions about a problem i'm trying to solve:
How can I know the last tuple affected by an insert/update operation per
table??
Is there exists any function in Postgres for retrieving some hash
value from a table??
Thanks in advance.
--
Miguel Ángel Tribaldos
-
ision range you need), but does not allow
to be added with anything else than "amper". Any other interaction
with
other units (read data types) would be achieved by defining the needed
operators on the respective data types (read units).
You'd have to create a postgres datatype for every variatio
If you allow multiplication and division, you'd need to store not
only one type, but an expression like m.s^-2, etc. You'll end up with
something with Maple. Isn't there some free open source algebraic
computation toolkit with equations and units somewhere ?
Yes and no.
I am in the (slow) proce
Thanks, I was hoping there was some way to avoid it.
You have to write the subselect twice if you want to match up different
rows.
In some cases it might be worth making a copy in a temp table. For simple
subselects where there is an index on id, leaving it as is should work
fine.
---
On Thu, 27 Jan 2005 00:16:14 +, Vladimir S. Petukhov
<[EMAIL PROTECTED]> wrote:
> > > LC_COLLATE: ru_RU
> > > LC_CTYPE: ru_RU
> > >Name| Owner | Encoding
> > > ---+--+--
> > > testdb | postgres | UNICODE
hi,
I am updating a database using COPY commands. If
the commmand breaks in between updating the database,
is there any way to find the log of the previous
updation or which part or row the loading broke.
Regards
Sid
__
Do you Yahoo!?
Rea
96 matches
Mail list logo
