might be visible at the slave¹s last replayed transaction? I
didn¹t think the master was aware of the slave¹s state, and why locks
can¹t be coordinated between the master and slave.
On 9/22/14, 4:04 PM, "Adrian Klaver" wrote:
>On 09/22/2014 01:42 PM, Joel Avni wrote:
>> I notice
It 9.3.5 and I did the manual vacuum to try to see where the problem might
be.
On 9/22/14, 4:04 PM, "Adrian Klaver" wrote:
>On 09/22/2014 01:42 PM, Joel Avni wrote:
>> I noticed that tables on my master PostgreSQL server were growing, and
>> running vacuum full anal
.
Thank you,
Joel Avni
process is
averaging 80% of IO. If I stop the slave, then IO utilization on the master
drops to ~20%. Is there something that I am doing wrong? I have
wal_keep_segments at 2048, checkpoint_segments at 96.
Thank you,
Joel
On Tue, Jan 21, 2014 at 1:34 AM, Maciej Szopinski wrote:
> Hello,
>
> Does PostgreSQL provide any notation/method for putting a constraint on
> each element of a JSON array?
>
> An example to illustrate:
>
>
> [...]
> I know that this can be done by extracting products to a separate table
> with
would otherwise affect the quality of the ranking. You should set
up a test group of documents and make sure your mechanism ranks that group
properly on test queries.
Joel
On Tue, Sep 25, 2012 at 11:16 AM, W. Matthew Wilson wrote:
> I want to run a query like to_tsquery("A | B | C") an
check constraint "i_i_check"
# insert into i values (ARRAY[0,1,2,3,1024]);
ERROR: new row for relation "i" violates check constraint "i_i_check"
Joel
On Sat, Sep 8, 2012 at 8:31 AM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> test=# create or replace f
t where there is a conflict.
Would it be possible to somehow automatically scan through all functions
and getting a list of the functions which have this problem?
Thanks!
Best regards,
Joel Jacobson
y advice!
Best regards,
Joel Jacobson
Trustly Group AB (former Glue Finance AB)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
even if the actual table wasn't being replicated.
Does anyone know if this is a valid concern and whether or not the temp table
will be replicated (regardless of the use of file-based continuous archiving)?
Thanks in advance,
Joel
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
I'm trying the new 9.1b2 release and got a weird problem with the \s
command to show the latest history, for some reason it's trying to
write to /dev/tty instead of printing out to stdout:
Joel-Jacobsons-MacBook-Pro:~ joel$ uname -a
Darwin Joel-Jacobsons-MacBook-Pro.local 10.7.4 Dar
I think this should do what I want
select trunc(distance * 10.)/10., count(*)
from doc_ads
group by 1 order by 1
Thanks, Joel
--
- for hire: mac osx device driver ninja, kernel extensions and usb
What is the meaning of
group by 1 order by 2
e.g. what to the numbers 1 and 2 stand for?
What would change if I do the following?
group by 1 order by 1
On Apr 30, 2011, at 5:48 PM, Thomas Markus wrote:
> Hi,
>
> try something like this:
>
> select
>trunc(random(
Thank you Thomas!
Is there a way for the code below to determine the number of rows in the table
and use it?
Thanks, Joel
On Apr 30, 2011, at 5:48 PM, Thomas Markus wrote:
> Hi,
>
> try something like this:
>
> select
>trunc(random() * 10.)/10.
>
I have a column of 2 million float values from 0 to 1.
I would like to figure out how many values fit into buckets spaced by 0.10,
e.g. from 0 to 0.10, from 0.10 to 0.20, etc.
What is the best way to do this?
Thanks, Joel
Thanks for the help with that, Noah. Indeed the sizes do look like I'd expect
them to if I force deflation of the bytea value before inserting it into the
EXTENDED column.
On Apr 21, 2011, at 2:02 PM, Noah Misch wrote:
> On Mon, Apr 11, 2011 at 03:19:23PM -0700, Joel Stevens
Tom,
On Apr 26, 2011, at 5:00 PM, Tom Lane wrote:
> For another couple orders of magnitude, convert the sub-function to C code.
> (I don't think you need
> a whole data type, just a function that does the scalar product.)
That's a 30x speedup, from 12 minutes down to 38s. Thanks Tom!
_connections set to?
I have the default settings, e.g. work_mem = 1MB and max_connections = 100.
I'm looking to process 400 requests per second, though. What should I use for
the above?
Thanks, Joel
--
- for hir
untu 10.10, e.g.
Linux ... 2.6.35-28-virtual #50-Ubuntu SMP Fri Mar 18 19:16:26 UTC 2011 x86_64
GNU/Linux
Thanks, Joel
--
- for hire: mac osx device driver ninja, kernel extensions and u
d it speed things up to make the float array a custom data type backed by C
code?
Thanks in advance, Joel
[1] http://en.wikipedia.org/wiki/Kullback%E2%80%93Leibler_divergence
---
CREATE DOMAIN topics AS float[150];
CREATE DOMAIN doc_id AS varchar(64);
CREATE TABLE docs
(
id serial
On Apr 12, 2011, at 10:33 AM, Bill Moran wrote:
> In response to Joel Stevenson :
>
>> select pg_total_relation_size('obj1') as o1, pg_total_relation_size( (select
>> reltoastrelid from pg_class where relname = 'obj1' ) ) as otoast1,
&
rease if I do a normal vacuum at that point, but that's not germane to my
question AFAICT.
Can I use the relation size like this to determine whether or not compression
is happening for these toast columns? If not, is there a way that I can
confirm that it is or isn't active? The res
Hoping someone will be kind enough to share how to write a query that
uses 9.0's string_agg with a subselect, something like...
select
m.id,m.subject,m.from_address,m.date_sent,m.size,string_agg((select
address as to_address from recipient r inner join message_recipient mr
on r.id=mr.recipien
re defined, i.e. other classes
the given class depend on.
For instance, is it correct to assume constraints always can be
dropped, i.e. no other class (nor other constraints) can depend on
them?
--
Best regards,
Joel Jacobson
Glue Finance
--
Sent via pgsql-general mailing list (pgsql-general@pos
2011/1/3 Tom Lane :
> select refobjid ... where objid matches and deptype = 'i'
> then it'd be easy, but you only get one UNION ALL per recursive query.
Ah, I see! Thanks for explaining. Now I get it.
--
Best regards,
Joel Jacobson
Glue Finance
--
Sent via pgsql
It appears to me it's necessary to join the object type specific tables,
such as pg_rewrite, to build a complete tree?
If so, that's fine, I just wondered if I had missed something making it
possible to avoid it.
--
Best regards,
Joel Jacobson
Glue Finance
ewrite 192095 i
a <-- pg_type 192094 i
a <-- pg_rewrite 192099 n
a <-- pg_type 192094 i <-- pg_type 192093 i
(6 rows)
-- Same query for b:
tree
-----
b
b <-- pg_rewrite 192099 n
b <-- pg_rewrite 192099 i
b <-- pg_type 192098 i
b <-- pg_type 192098 i <-- pg_type 192097 i
(5 rows)
--
Best regards,
Joel Jacobson
Glue Finance
Hi,
I am trying to formulate a checklist for securing or securely configuring
the PostgreSQL DB. Wondering if you already have some thing in place or
perhaps a hardening document. Could you point me to some place where i could
find this.
Thanks,
Joel
tions always
return the same results in the same transaction, this is of course what you
usually want to happen, but in my case I want the ability to override this.
Thankful for any ideas.
--
Best regards,
Joel Jacobson
Glue Finance
E: j...@gluefinance.com
T: +46 70 360 38 01
Postal address:
s --on-- a postgres
list --- sorry,
it's been a long few days fighting software.
I meant to say I would check on the Fedora forum!
Joel.
--
+----+
| Joel K. Alpers
| Expressive Black and White Images
| http://w
Tom Lane wrote:
Joel Alpers writes:
New system: Fedora 11, PostgreSQL 8.4
Fedora 11 enables selinux by default ...
*** Error - Can't connect to database "photodb" - could not connect to server:
Permission denied
Is the server running on host &quo
s-- running on the server
machine, and --is-- listening on 5432.
I am sure I am leaving something out, so please write if you need more info.
Any thoughts?
Thanks!
Joel.
--
+---
larly
done in PL/SQL but it seemed more sensible to just do the whole thing
rather than using GROUP BY after enumeration.
- Joel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t random
for i in xrange(n):
m = random.randint(1,12)
d = random.randint(1,28)
b = random.choice(('red', 'blue'))
yield '2009-%d-%d' % (m, d), b
$$ LANGUAGE plpythonu;
DELETE FROM foo; INSERT INTO foo (SELECT * FROM make_random(100));]
I hope th
_random(n int) RETURNS SETOF foo AS $$
import random
for i in xrange(n):
m =3D random.randint(1,12)
d =3D random.randint(1,28)
b =3D random.choice(('red', 'blue'))
yield '2009-%d-%d' % (m, d), b
$$ LANGUAGE plpythonu;
DELETE FROM foo; INSERT IN
On Feb 16, 11:12 am, Paulie wrote:
> On Feb 16, 5:51 pm, joel garry wrote:
>
> > Check out Oracle XE and apex. No cost to you, and you can pay to
> > scale as appropriate.
>
> Before rushing to download Oracle XE, check out
>
> http://www.oracle.com/technology/pu
On Feb 15, 10:09 pm, pg wrote:
> I am involved with a SQL server project. The server would be used in a
> very heavy duty environment, with hundreds of thousands, if not
> millions of database enquiries per minutes.
>
> The server would run Linux or one of the BSD variant, with at least
> 32GB of
relies on
asynchronous replication and automatic failover.
- Joel
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Thanks for your response, Andrew.
On Tue, 8 May 2007, Andrew Sullivan wrote:
On Fri, May 04, 2007 at 08:54:10AM -0600, Joel Dice wrote:
My next question is this: what are the dangers of turning fsync off in the
context of a high-availablilty cluster using asynchronous replication?
My real
n the master of a cluster using asynchronous
replication, assuming we don't need to recover the data from the master
when it fails?
Thanks.
- Joel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
s?
Sorry if this has been discussed before - in which case please point me to
that discussion.
Thanks.
- Joel
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joinin
schema? That way it could cascade if the name was changed,
but I'm not sure what kind of ugliness might result if you tried to drop
the table and it still had a referencing record. Any opinions on that
or any other ways to approach this challenge?
Thanks in advance,
Joel
--
limited
connectivity, we are definitely more tolerant of the delayed performance
this synchronization strategy will cause than most users/companies would
be. The important thing for us is that the data integrity is maintained
and that everyone at each site can access and change the data.
Regard
most of all
how to correct it? Below is the buffer from a recent session with a \d
on Item and the only other thing I can offer is that several tables have
Item.id as a foreign key. Please advise and thanks in advance for the
help.
- Joel
postgres=# select * from item;
ERROR: too many trigg
keep the list
and me informed if you have oneThanks, Joel
Code excerpt from within on delete trigger function for foobar.
-- Disable triggers on table foobar
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
'foobar'::pg_catalog.regclass';
-- Perform update
UP
shed on this peculiarity would be
great. Once I get past this hurdle the function will, of course, go on
to do more and make better use of the temp table, but for now I just
need to figure out why it's failing. Is this an improper or ill-advised
use of a temp table?
Thanks much,
Joel
I've been using a product called HappyFish, which does reverse
engineering on Postgres and has proven to be a great DB development
tool. While it's not free, it is very low cost and you can easily get a
full-featured evaluation version to try out. I've been running it
through its paces with a pre
Greetings,
Could somebody shed any light on the error message below that came from
trying to call a simple pltcl test function? I am running Postgres 8.1
on WinXP and just recently added the pltcl language by copying Tcl84.dll
into my system directory (C:/Windows/System32) and successfully issui
Greetings,
I was wondering if it's possible to get any of the metadata from the NEW
and OLD constructs in a trigger or view rule? Specifically, I'd like to
get the column name or identifier anywhere the new record differs from
the old record (i.e. NEW.column_X <> OLD.column_X). Any advice would
I tried to post this the other day, but didn't get any responses and
never saw it show up in the digest. Here it is again if anyone can
offer any insight:
I'm trying to create a schema in which there will be simple a view for
each table that will have the same columns and can be acted on in the
Howdy,
I'm trying to create a schema in which there will be simple a view for
each table that will have the same columns and can be acted on in the
same way as the underlying table
An example of one table and its view would be:
CREATE TABLE test (id int, text_field varchar(100));
CREATE VIEW _te
I'd like to create a trigger function whose use can extend to multiple
tables by employing the special variables available (e.g., TG_RELNAME).
Below is a simple version of such a function that ought to prevent
insertion of greater than 4 total records in the table that calls it.
I'm not sure that I
Title: Determining caller of a function (due to a cascaded FK constraint?)
Greetings,
For reasons a little too complicated to get into off the bat, I am wondering what the most effective way is to determine by whom or how a particular action or function call was initiated. To shed more light
Kris Jurka wrote:
On Tue, 23 May 2006, Joel Alejandro Espinosa Carra wrote:
I searched at google and did not find any answer. I have an older
JDCB driver in my java web application, if I update the driver to the
7.4 build 216 version some of the querys like the next show no
results in the
TIS because the older one
throw an exception: "java.sql.SQLException: ERROR: SET AUTOCOMMIT TO
OFF is no longer supported.".
Thanks in advance.
Best regards.
ps. please tell me if it is the wrong mailing list for this issue.
--
Ing. Joel Alejandro Espinosa Carra
CINVESTAV CTS - Cent
what will work.
I can't have my clients losing faith in my ability to solve their
problems, so I get to track this down. :)
Thanks,
--Joel
On Feb 4, 2006, at 1:16 AM, Tom Lane wrote:
Joel Richard <[EMAIL PROTECTED]> writes:
... we occasionally get the following message in our a
lved. I've disabled the offensive code until I can more
closely investigate in a controlled environment. Give that we didn't
really need it, turning it off is an adequate solution for a
production server.
--Joel
On Feb 4, 2006, at 1:16 AM, Tom Lane wrote:
Joel Richard <[E
my question is this: What does this error indicate? I can't
seem to find much about it on the net and to be honest, I have become
rather illiterate in C over the past several years, so reading the
source is not really a viable option.
Any info would be appreciate
the data correctly.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
[EMAIL PROTECTED]
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,
insert the result, but is this the
best way of doing it? I need the trigger to be plperl since there is
some additional foo I am doing.
Thanks! --Joel
---(end of broadcast)---
TIP 8: explain analyze is your friend
t;
So, the only conclusion I can reach is this problem is some OS
dependant bug, which apparently has been fixed in 8.0.2beta.
--Joel
On Apr 7, 2005 9:04 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Joel Leyh <[EMAIL PROTECTED]> writes:
> > Same problem, same function causing t
Ah ok. I must have copied it incorectly. I am using 8.0.1 from the
latest binary build from NetBSD. The source I used was
postgresql-8.0.1.tar.bz2 stable release.
I will try the CVS release to see if it's fixed.
--Joel
On Apr 7, 2005 12:26 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
I have Pg installed on i386 NetBSD from the NetBSD package manager. I
then installed tsearch2 and used its default installation.
I then also got the source and built from it, with debugging enabled.
Again I installed tsearch2 but my results were the same.
Created a new database, added a table with
> % cd /var/data/pgsql
(B> still reports the absolute path
(B> --> /Volumes/data/pgsql
(B
(BIt looks to me like you are attempting to mount a few volumes under /var?
(B
(BI think that's going to wrinkle your handkerchief in Darwin.
(B
(B--
(BJoel Rees <[EMAIL PROTECTED]>
(Bdigitcom, inc
(From someone else who doesn't know what doesn't know, ... :-/)
(B
(B>sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster [...]
(B...
(B
(B> >> note that my cmd line refers to the conf file, which has the external
(B> >> PID id'd in it:
(B> >
(B> >> external_pid_file = '/
As long as the web page maintainers are going to the trouble of taking a
(Bsurvey, might I (at the risk of being tarred and feathered :-p) suggest
(Ba more thorough survey?
(B
(BSuggested questions:
(B
(B(1) If there were a USENET newsfeed, under comp.databases.postgresql.*,
(Bof one or more
Long and rambling question, here -- we have a customer with a database
(Bthat is outgrowing their original storage, and they want to upgrade
(Bstorage as cheaply and smoothly as possible.
(B
(BPresently, they have one 120G or so RAID 5 unit, and the entire system
(Band data are stored on that
ld be a bit slow, but that
might actually be an advantage.)
(And, BTW, Mike, thanks for trying.)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
s. What I see in news.groups
indicates to me they are just trying to see how many people they can get
to gag. Ignore them and pretty seen they get bored and go look for other
prey.
> ...
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Richard Huxton wrote
> Joel wrote:
> >
> > But we probably do need someone from the mail list to go co-proponent
> > with Mike.
> >
> > Unless, of course, the majority of the list would prefer to keep the
> > status quo.
>
> I must admit I'm n
robably do need someone from the mail list to go co-proponent
with Mike.
Unless, of course, the majority of the list would prefer to keep the
status quo.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: if posting/reading throug
ss for a day. There's no rush. And it really
isn't all on your back. If you insist on keeping it that way, the vote
will fail, and we'll be back where we were.
Are you needing a co-proponent?
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)--
ether Marc (all by himself?)
would be appropriate, particularly on the usenet side, perhaps it would
be good to set up a group of moderators? Ideally, they could be spread
around the globe and take shifts, to get good time coverage.
Oh, and thanks, Mike, for stirring up the hornets' nes
ould use
the primary key index on test when finding
referencing records in the test1 table.
Pierre, I seen the advice to use an additional
where condition in certain cases to induce an
index scan; how is this done?
my 1.2 pennies,
-Joel
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
> niutil -createprop . /users/pgsql passwd \*
> niutil -createprop . /users/pgsql home /Users/pgsql
> niutil -createprop . /users/pgsql shell /bin/tcsh
>
>
> gid and uid can be set to some non-conflicting number of your choice. I believe
> that numbers over 5000 do not
Sorry for the noise. We resolved it:
On Fri, 29 Oct 2004 12:36:54 +0900
Joel <[EMAIL PROTECTED]> wrote
> ...
>
> We get the following error:
>
> > Auth_PG_grp_group_field takes one argument, the name of the group-name field.
>
> on the directive
>
require group [EMAIL PROTECTED]
(And, yes, I'll also try an apache mailing list.)
Apologies in advance if the noise is not appreciated.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, 28 Oct 2004 01:01:20 -0400
Tom Lane <[EMAIL PROTECTED]> wrote
> Joel <[EMAIL PROTECTED]> writes:
> > Any thoughts on the urgency of the move?
>
> How large is your pg_log file? 7.1 was the last release that had the
> transaction ID wraparound limitati
On Tue, 26 Oct 2004 13:30:49 +0200
Ian Barwick <[EMAIL PROTECTED]> wrote
> On Tue, 26 Oct 2004 18:22:55 +0900, Joel <[EMAIL PROTECTED]> wrote:
> > I seem to remember reading a post on this, but searching marc does not
> > seem to bring it up immediately.
> >
>
the recent vulnerabilities.
War stories? Things to watch out for?
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ich might have
something to do with it.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
y dumbing
it down. It works, but then you have OS login enabled for the "postgres"
user.)
My JPY 2.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
dy done, or maybe
an option? (Not that it would in any way solve Wes's company's current
problem, ...)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
data models.) But PostGreSQL does have
tables, and you can use tables to model a family tree.
My JPY 2.
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Tue, 24 Aug 2004 01:34:46 +0200
(BIan Barwick <[EMAIL PROTECTED]> wrote
(B
(B> ...
(B> wild speculation in need of a Korean speaker, but:
(B>
(B> [EMAIL PROTECTED]:~/tmp> cat j.txt
(B> $Bec,e$;ec(B
(B> $ByyPl%$%9wd!"(B
(B> $Bx"(l%$(Bl$B%i(B
(B> $Bw{%1v.%/wd(B
(B>
Thank you ! that did it. - Joel
On Aug 1, 2004, at 11:15, Peter Eisentraut wrote:
Joel Rodrigues wrote:
The files do exist, for example:
/usr/include/libxml2/libxml/xpath.h
Try
make all CPPFLAGS=-I/usr/include/libxml2
--
Peter Eisentraut
http://developer.postgresql.org/~petere
such file or directory
pgxml_dom.c:12:25: libxml/tree.h: No such file or directory
pgxml_dom.c:13:30: libxml/xmlmemory.h: No such file or directory
... followed by several errors & warnings
Any ideas ? I never had any trouble compiling it on OS X 10.1.5
- Joel
The files do exist, for exam
world grammars, back to the cold,
cruel world of mechanical parsers. ;)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
t any hardware, but,
especially where reliability and performance are
required, it is wise to research your
hardware options thoroughly.
(where/when)
--
Joel <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 9
Hi,
In light of no responses to the make error question -
Has anyone succeeded in installing PostgreSQL 7.4 on Mac OS X
(10.1/10.2/10.3) ?
Until now PostgreSQL was always just a ./configure, make, make install
away.
- Joel
On Friday, December 12, 2003, at 10:02 , Joel Rodrigues wrote
Error 2
make[2]: *** [access-recursive] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
-
I found this, which may be relevant:
http://www.simdtech.org/apps/group_public/email/altivec/msg00663.html
I don't have much of a clue with regard to C programmi
hed
tar: Sorry, unable to determine archive format.
Cheers ! - Joel
On Monday, December 8, 2003, at 05:39 , Oleg Bartunov wrote:
On Mon, 8 Dec 2003, Joel Rodrigues wrote:
Hi,
I seem to recall once coming across & using functionality in PostgreSQL
that allowed for some flexibility in the spelling
hed
tar: Sorry, unable to determine archive format.
Cheers ! - Joel
On Monday, December 8, 2003, at 05:39 , Oleg Bartunov wrote:
On Mon, 8 Dec 2003, Joel Rodrigues wrote:
Hi,
I seem to recall once coming across & using functionality in PostgreSQL
that allowed for some flexibility in the spelling
On Wed, Aug 06, 2003 at 12:55:52PM -0400, Joel Burton wrote:
Reposting, with some clarification to my request. Thanks to the several
responses I received originally.
Yes, I know that a perfectly vaild PGSQL SQL file could contain only
ANSI SQL and therefore not be recognized as PG-related. In
ngs.
Two conditions I really want on the use of heuristics -- I want the date
itself to include some "fuzzy" flag, and I want some way to reconstruct
the original string. That way, if I want to design an application with
tools for getting operator attention, etc., there are hooks in
more than a
> hour. My database has 6 MB.
>
> I can backup my database directory on Windows (using ZIP) and put it on Linux?
Might want to try pg_dump (rather than dumpall), perhaps even using the
-t option to pick just one table. This could let us find out if you can
dump *anything* or n
On Wed, 10 Oct 2001, Ian Barwick wrote:
> I'm doing some work for a smallish company which conducts
> its business largely online. Currently they have a legacy
> mishmash of Oracle and MySQL databases which they wish
> to unify one one platform (RDBMS with client access via
> browser and custom s
d the same way:
DROP table foo;
DROP sequence foo_id_seq;
DROPDB dbname will *always* delete everything in a database, assuming
you have permissions to use it.
--
Joel Burton <[EMAIL PROTECTED]>
Director of Information Systems, Support Center of Washington
---(
igger get a hold of data
from an insert? Thanks in advance for your comments.
Joel Dudley
Unix Admin
DevelopOnline.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [
Buenas tardes, all.
I'm puzzled by my inability to use the following INSERT statement:
INSERT INTO RM_USER VALUES(RM_USER.ID, RM_USER.FIRST_NAME) VALUES(1, 'DUBYA')
it seems that postgres is unhappy about the explicit column naming
(e.g. 'RM_USER.ID' instead of just 'ID') because I end up with
1 - 100 of 184 matches
Mail list logo
