Hello,
Sorry for the poor subject. Not sure how to describe what I need
here. I have an application that logs to a single table in pgsql.
In order for me to get into our log management, I need to dump it out
to a file on a periodic basis to get new logs. I am not sure how to
tackle this. I tho
On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
> On 1/18/2010 4:08 PM, Terry wrote:
>>
>> Hello,
>>
>> Sorry for the poor subject. Not sure how to describe what I need
>> here. I have an application that logs to a single table in pgsql.
>> In order f
On Mon, Jan 18, 2010 at 5:07 PM, Terry wrote:
> On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
>> On 1/18/2010 4:08 PM, Terry wrote:
>>>
>>> Hello,
>>>
>>> Sorry for the poor subject. Not sure how to describe what I need
>>> here. I ha
On Tue, Jan 19, 2010 at 12:06 AM, Johan Nel wrote:
> Terry wrote:
>>
>> Hello,
>>
>> Sorry for the poor subject. Not sure how to describe what I need
>> here. I have an application that logs to a single table in pgsql.
>> In order for me to get into ou
Hello,
I have an application that is doing something stupid in that it is
tacking on its own order clause at the end of the statement I am
providing.
For example, I am putting this statement in:
select
ev_id,type,ev_time,category,error,ev_text,userid,ex_long,client_ex_long,ex_text
from clients_e
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe wrote:
> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
>> Hello,
>>
>> I have an application that is doing something stupid in that it is
>> tacking on its own order clause at the end of the statement I am
>> p
On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
> wrote:
>> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
>>> Hello,
>>>
>>> I have an application that is doing something stupid in that it is
>>> t
On Fri, Feb 26, 2010 at 3:16 PM, Scott Marlowe wrote:
> On Fri, Feb 26, 2010 at 1:46 PM, Terry wrote:
>> On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
>>> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
>>> wrote:
>>>> On Wed, Feb 24, 2010 at 8:50 PM, T
Hello,
I am looking for a way to copy all the data from one table to another
on a regular basis, every 5 minutes let's say.
INSERT INTO table2 SELECT * FROM table1;
The above will copy all the data as is and insert it into the other
table. What happens if I rerun it again? Will it just append
On Sun, Feb 28, 2010 at 6:29 PM, John R Pierce wrote:
> Szymon Guz wrote:
>>
>> Different doesn't mean that the id should be greater or lower, rather
>> should be different. I'd rather do something like:
>
> indeed, my code assumed that records were only INSERT'd into table1 and
> never UPDATE or
On Sun, Feb 28, 2010 at 6:29 PM, John R Pierce wrote:
> Szymon Guz wrote:
>>
>> Different doesn't mean that the id should be greater or lower, rather
>> should be different. I'd rather do something like:
>
> indeed, my code assumed that records were only INSERT'd into table1 and
> never UPDATE or
On Sun, Feb 28, 2010 at 7:12 PM, John R Pierce wrote:
> Terry wrote:
>>
>> One more question. This is a pretty decent sized table. It is
>> estimated to be 19,038,200 rows. That said, should I see results
>> immediately pouring into the destination table while
On Sun, Feb 28, 2010 at 10:23 PM, Terry wrote:
> On Sun, Feb 28, 2010 at 7:12 PM, John R Pierce wrote:
>> Terry wrote:
>>>
>>> One more question. This is a pretty decent sized table. It is
>>> estimated to be 19,038,200 rows. That said, should I see resu
Hello all,
I am trying to do the following query but I would like to know how
many rows were deduplicated in the process:
psql -d foo -c 'SELECT DISTINCT ON (error) error,ev_text FROM
clients_event_log' -o fullfoo
For example, I would want the output to be the following where count
is the numbe
2010/3/3 Grzegorz Jaśkiewicz :
> select count(*) AS count, error, ev_text FROM clients_event_log GROUP BY
> error, ev_text;
>
> you can add 'HAVING count(*) > X'; , if you want to see only those with
> count above X, etc.
>
>
> --
> GJ
>
I was just about to reply to the group. Would this work too
2010/3/3 Terry :
> 2010/3/3 Grzegorz Jaśkiewicz :
>> select count(*) AS count, error, ev_text FROM clients_event_log GROUP BY
>> error, ev_text;
>>
>> you can add 'HAVING count(*) > X'; , if you want to see only those with
>> count above X, etc.
>
I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
query that will return all rows from dsclient_logs, insert two columns
from the customer table, and one column from backup_sets. The
relation is this:
dsclient_logs.userid = dsbox.dsbox_snum AND backup_sets.box_id =
dsbox.box_id
On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
> On 4 March 2010 17:26, Terry wrote:
>>
>> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
>> query that will return all rows from dsclient_logs, insert two columns
>> from the customer
On Thu, Mar 4, 2010 at 11:43 AM, Terry wrote:
> On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
>> On 4 March 2010 17:26, Terry wrote:
>>>
>>> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
>>> query that will return all rows fr
On Fri, Feb 26, 2010 at 4:52 PM, Scott Marlowe wrote:
> On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane wrote:
>> Terry writes:
>>> I am somewhat confused. My app is detecting it as a serial data type
>>> but describing the table shows that its an integer. What am I
&
On Thu, Mar 4, 2010 at 1:44 PM, Terry wrote:
> On Thu, Mar 4, 2010 at 11:43 AM, Terry wrote:
>> On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
>>> On 4 March 2010 17:26, Terry wrote:
>>>>
>>>> I have 4 tables: dsclient_logs,backup_sets,dsbox,custo
s, and postgresql,
even without pgadmin
iii, is far superior in MANY ways to mysql.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
>
> Jim
>
> ---(end of
> broadcast
just try it)
Yes, provided the columns are the same data types (or you can cast them to make
them the same)
>
> col1 and col3 are both DATE columns. col2 and col4 are both
> varchar(1).
>
> I want the ORDER BY to order the result of the UNION.
It does, per SQL spec. Nothing les
> wrap the whole statement in another select
Yes you can do that, but you don't need to. An order by clause explicitly
applies the sort action
AFTER the UNION action has been performed.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
hells, something which
windows servers desperately lack natively.
Terry FielderAssociate Director Software Development and
DeploymentGreat Gulf Homes / Ashton Woods
Homes[EMAIL PROTECTED]Fax: (416) 441-9085
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
Don't be afraid to read the manual:
http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTI
ONS-SQL99-REGEXP
http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTI
ONS-POSIX-REGEXP
Terry Fielder
Manager Software Development and Deployment
Great
Agreed! The sooner SCO goes bankrupt the better.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Gav
Postgres db.
Having used (still using) both Postgres and Mysql, without a doubt Postgres is
superior to Mysql,
and probably used more for back end systems then for web based db. Mysql is used for
many web site
probably because Mysql is "sufficient" for what most web sites need.
Ter
mpall > /backup/postgresdump'
Now you want to do just a specific database perhaps, in which case you likely want:
su - postgres -c 'pg_dump $database > /backup/postgresdump'
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[
, text()), text_field
That works provided your number is never negative, (a reasonable assumption I think).
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
> -Original Message-
> F
just nightly dump and restore to backup server.
Indeed the only problems I have ever had turned out to be hardware, a bad motherboard.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
> -Original
cannot be changed much, there may be other
cases where
the planner cannot change the requested plan).
I am not an expert, but this is what I recall from following the list.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416
:
add_missing_from = false
enable_implicited_join = false
But neither one of these seems to disable the functionality (I did a reload after
making the change)
Do I have to completely stop the db to make the change? Or is there something else I
should be
doing to disable it?
Thanks
Terry Fielder
select (ugh) as the only viable alternative?
Any ideas is appreciated...
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
---(end of broadcast)---
TIP 5: Have
That works perfectly, of course.
Thanks a million!
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
> -Original Message-
> From: Roger Hand [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 1
Complete, functional, full blown working
copy. You can even update it to the latest 7.3.4, which if you haven't
started using it yet, is a good idea.
ftp://ftp3.ca.postgresql.org/pub/binary/v7.3.4/RPMS/redhat-9/
Terry FielderManager Software Development and
DeploymentGreat Gulf
Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".
But I didn't perceive a "loser" until the Postgres team started squabbling
amongst themselves on a public forum about it.
Terry Fielder
Manager Software De
Not really, and still don't care either way.
Postgres *is* a superior product, I have used many different DB's, and will
continue to stick by Postgres. And THAT is what makes Postgres stand out
from the rest: let's get over it.
Terry Fielder
Manager Software Development and D
And in fact you can even do:
SELECT myfunction()
if the function does not rely on data/parameters from a table, which would
be the case if there are no parameters at all to myfunction()
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL
Certainly Postgres is capable of handling this volume just fine. Throw in
some partition rotation handling and you have a solution.
If you want to play with something different, check out Graylog, which is
backed by Elasticsearch. A bit more work to set up than a single Postgres
table, but it has b
My 2 cents:
I used to get a lot of these sharelock problems.
Users using different records, but same tables in different order.
(apparently 7.x was not as good as 8.x at row level locking)
I was advised to upgrade from 7.x to 8.x
I did, and all those sharelock problems went away.
Terry
Terry
aster
2577 root 10 -5 000 D1 0.0 22:59.43 kjournald
4949 root 15 0 12996 1336 792 S1 0.0 38:54.10 top
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416
Responses below.
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry Fielder <[EMAIL PROTECTED]> writes:
Under pg 7.x the system performed fine.
In 8.1.
the 8.2 "resolves index locking issues" was the concern for an 8.1 install.
Should I add a primary key column of serial? Will that help?
If anyone has any ideas it would be appreciated.
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great
Hello all,
I am having problems with the next postgresql version:
pg version: 8.2.4
OS: Win32 (windows xp sp2)
FS: NTFS
It is a production server, but suddenly the DB stop answering to any sql
command. It seems dead. After restart server all starts to works again.
I am looking for system e
gs.
Alvaro Herrera escribió:
Terry Yapt wrote:
I am looking for system errors and nothing is there. But I have a lot of
messages on system APP errors. The error is the same every ten seconds or
so.
This is the main error:
* FATAL: could not reattach to shared memory (key=5432001, addr
Alvaro Herrera escribió:
Terry Yapt wrote:
This is the main error:
* FATAL: could not reattach to shared memory (key=5432001, addr=01D8):
Invalid argument
It is always followed by this another system-app error:
* LOG: unrecognized win32 error code: 487
This problem has been
Tom Lane escribió:
I'm not sure if you have a specific technical meaning of "clone" in mind
here, but these processes are all executing the identical executable,
and taking care to map the shmem early in execution *before* they load
any DLLs. So it should work. Apparently, it *does* work for aw
Trevor Talbot escribió:
The environment is consistent then. Whatever is going on, when
postgres first starts things are normal, something just changes later
and the change is temporary. As vague guides, I would look at some
kind of global resource usage/tracking, and scheduled tasks. Do you
se
Hello all,
I would like to change a pg database to another server.
The source environment is: postgresql Windows v.8.2.4 (windows xp
workstation).
The target environment is: postgresql Windows v.8.2.5 (windows 2003 Server).
I would like to do migration without pg_dumpall and I think I can do
Magnus Hagander escribió:
On Sun, Sep 30, 2007 at 11:36:23PM +0200, Terry Yapt wrote:
First of all. I think this method is admisible. Isn't it ?
It is.
Glad to read it :-)
And second question: I think my problem is that some rights are wrong
after copying data folder.
Hi Magnus and all people...
And yes, it shoul dbe set on the file and all subdirs. Use the checkbox to
overwrite all permissions on subdirs, that's the fastest way.
//Magnus
Sorry my delay but I was very busy last week.
In general, giving windows Postgres user Change right do the trick bu
Bruce Momjian escribió:
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
Update:
I have installed PostgreSQL 8.2.5 and move database from old to new
server. This was 2 weeks ago.
New Server is a Windows 2003 Server running other service
Does the remote server have the relevant port opened up in its firewall?
Is postgres set to allow TCP/IP connections in the postgresql.conf?
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
FIRST out of the set, and therefore you can just
remove from the set and put before the set brackets.
or am I forced to use the (^| ) syntax?
Is it just me or are regular expressions crazy?
Complicated, not crazy.
Terry
Howard
---(end of broadcast)
(http://bsonspec.org/) as
defined for MongoDB. I've architected it so that it should play naturally
with the postgres type system, but there are still some cast functions that
need to be implemented.
Anyway, feedback is appreciated - good, bad or otherwise.
Thanks.
Terry
Thanks Tom. I wasn't aware - I did do a quick search at the beginning but
didn't turn this up. I'll post over on the hackers list.
Terry
On Sat, Oct 16, 2010 at 7:44 AM, Tom Lane wrote:
> Terry Laurenzo writes:
> > I'm a long-time postgres user but have never
thing
RETURN NEXT v_row;
END LOOP;
END;
$$ LANGUAGE plpgsql;
-- so I would like the call to be something like
select * from myanalyze(select * funct1());
or
select * from myanalyze(select * funct2());
______
Terry Kop
Database Developer
Clear Capital
o
I can't offer a whole lot of detail at this point, but I experienced a
pretty bad caching issue about 2 years ago using XFS.
We were migrating a 1TB+ Oracle database to EDB's Advanced server 9.1
(Close enough for this discussion). I normally use ext4, but decided to try
XFS for this build-out.
Thi
You have the open source version installed. Now where it was installed from
is a different story.
EnterpriseDB Advanced Server will look like:
EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-16), 64-bit
T
On Fri, Jul 7, 2017 at 7:04 AM, Krithika
give you what you want
if you want to see all SQL statements.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Dave Potts wrote:
I am using a 3rd front end to generate postgres requests
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success several
times on the same workstation.
Today I have tried to install 8.3.3 and I have stuck on the same error:
===
Service 'PostgreSQL Database Server
Raymond O'Donnell escribió:
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.
Today I have tried to install 8.3.3 and I have
Raymond O'Donnell escribió:
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.
Today I have tried to install 8.3.3 and I have
I have no idea what type of storage that you are using, but we utilize
NetApp storage and use Flexclones to create multiple read-only copies of a
"master" database. The flexclone takes seconds to configure and essentially
only consume delta space. Works great so far.
Terry
On Wed, Ma
will give you a measurement of your expected performance that
is much more meaningful then my ramble above. :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Bill Thoen wrote:
I
and then kill a specific bad query?
Maybe this is not missing functionality, it can do it and I just don't
know how. Anybody want to wisen me up? :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Home
the above O/S requirement.
Geoff M
Running 3 RHEL4 boxes in an Oracle RAC cluster, with web interfaces
(RHEL5/Apache/php) on separate VMWare ESX gear.
Sybase ASE should be on your list too.
Terry Dykstra
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Usually 5432
Its listed in postgresql.conf, which could be in
/var/lib/pgsql/data/
or
/usr/local/pgsql/data
Terry
ElayaRaja S wrote:
I am facing TCP IP connection refused.
But i enbled the tcpip as true and i like to know the port number.
becuase i like to enble the port number in my firewall
Wow, I must be missing something, because I cannot even dream up a case
where I think I might find a use for the mysql INTERVAL() function, far
less actually NEED it :)
Terry
Michael Fuhr wrote:
On Wed, Oct 12, 2005 at 04:49:59PM -0500, Scott Marlowe wrote:
On Wed, 2005-10-12 at 16:16
dity to "dumb
it down" for the weak application developer, let's not do that.
Terry
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Terry Fi
OK, I am not an expert on the SQL standard, but I thought the definition
varied by data type e.g. varchar <> bpchar
Terry
Marc G. Fournier wrote:
On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
I was referring to trailing blanks, but did not explicitly say it,
though showed it in the ex
l is converting a 'sdas' typeless string to be assumed
VARCHAR.
Hence, the different behaviour.
Terry
Dann Corbit wrote:
Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
'Dann Corbit'?
I would.
If both are considered character types by
the VARCHAR to CHAR and then does the compare
Postgres converts the CHAR to VARCHAR and then does the compare
But there isn't even enough evidence here to support that.
Terry
Dann Corbit wrote:
create table foo (col1 varchar(30))
go
create table bar (col1 char(30))
go
insert into foo v
t=# SELECT 'a '::char = 'a '::char;
?column?
--
t
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
ou may say. But consider, should:
rtrim(' ') = ''
The answer is simple: YES, the 2 are equal.
Oracle has always had the '' ==> NULL flaw
And it may have been to compensate for that flaw that they added:
' ' ==> NULL flaw
Although it may be in the
Do you have any cascading deletes that could be doing this by performing
a delete on a different table and cascading to the table in question?
Terry
Rory Browne wrote:
Hi all
What is the first thing you would do, when you find that your system
has been losing information? Information is
y, you can create a .pgpass file in the users home directory
(if ident not available, but you *need* to think about the permissions
of this file and ramifications)
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax:
r
entities are behind the transaction number?
Thanks in advance
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
7.4.3
And the records are gone from pg_locks, how much time after the
deadlock do I have before they are purged?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry
a self-contained example? The reference to "line
1" suggests that you wouldn't need the whole 20M row file, just the
first few rows ...
Unless its not seeing the end of the first record AS the end of the
first record, and hence seeing the whole file as 1 record.
Terry
Terry Yapt wrote:
> I am trying to restore from a pg_dump. Pg_restore is doing some
> strange behaviour.
>
> If I open a CMD shell console and execute pg_restore, nothing is
> showed. If I try to do a "with sense" pg_restore, nothing is showed
> in spite of
I am trying to restore from a pg_dump. Pg_restore is doing some
strange behaviour.
If I open a CMD shell console and execute pg_restore, nothing is
showed. If I try to do a "with sense" pg_restore, nothing is showed in
spite of I have put --verbose option.
This is my complete command:
pg_resto
Terry Yapt wrote:
> Terry Yapt wrote:
>
> > I am trying to restore from a pg_dump. Pg_restore is doing some
> > strange behaviour.
> >
> > If I open a CMD shell console and execute pg_restore, nothing is
> > showed. If I try to do a "with sense" p
Terry Yapt wrote:
> Terry Yapt wrote:
>
> > Terry Yapt wrote:
> >
> > > I am trying to restore from a pg_dump. Pg_restore is doing some
> > > strange behaviour.
> > >
> > > If I open a CMD shell console and execute pg_restore, nothing is
&
You may encounter many things in life which you may regret having done.
Converting from M$ SQL to PostgreSQL is probably *not* one of them.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
I would like to know if I there is a utility to take a UDP packet which
has specific information in the payload and extract the information from
the packet and place it in the Postgres data base?
Terry Martin
Timedata Corporation
VP of Network Operations
Work: (212) 644-1600 X3
Cell
I second Tom:
badblocks and memtest86 are what I use and works great on all kinds of
hardware. You don't even need a specific OS for memtest86 because you
can make a bootable floppy and test any old piece of hardware it recognizes.
Terry
--
Terry Fielder
[EMAIL PROTECTED]
Asso
SELECT id, get_category_text_path(id)
FROM category
WHERE id IN (
SELECT c.id
FROM category AS c
ORDER BY c.rank
LIMIT 5
)
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Markus
h was the goal you
requested)
3) In SQL there is almost always more then 1 way of doing something,
you have now seen 2. There may be more, possibly even better ways.
Experts care to comment? :)
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Matthew Hixson wrote:
http://www.enterprisedb.com/news_events/press_release
Is there an chance the rows are being inserted in a transaction that
fails and rolls back? Maybe look at all the lines that were inserted
with that order, and try them manually in psql, character for character,
and see if an error pops up for any of the lines?
Terry Fielder
[EMAIL PROTECTED
Hello all,
I am testing PostgreSQL 8.0 beta on a windows xp professional. In the
time when I did the install I have been working with pgadmin and so
on...
But after a few days, when I tried to continue with my tests. I
cannot start the postgresql service. I always get this message
windown when
That's right..
I have deleted postmaster.pid and all was ok now..
Thanks..
On Mon, 23 Aug 2004 10:35:00 +0200, [EMAIL PROTECTED] ("Magnus
Hagander") wrote:
>> Hello all,
>>
>> I am testing PostgreSQL 8.0 beta on a windows xp
>> professional. In the time when I did the install I have been
>For example in Oracle you can set the Localization for dates like this
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America
SET DATESTYLE TO NonEuropean;
>This example would set the Date-Localization to American but only for the actual
>session.
This one too I think so.
>Is so
>Now I want to know if it is possible (when yes the how?) in Postgresql
>To set dynamically the Localization?
>For example in Oracle you can set the Localization for dates like this
>Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America
SET DATESTYLE TO NonEuropean;
>
>This example
Does pg_dump work with BLOBs yet ?
terry
> --
> From: Rob Arnold[SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 20, 2001 9:31 PM
> To: Robert Kernell; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: copying tables
>
You will need to rewrite or cast the expression
I have tried (bit) 0, bit(0), bit 0, etc but have not found a way to do
casting. Can anyone help me to set a default value for a bit datatype
field?
Thanks
Terry Fielder
[EMAIL PROTECTED]
---(end of broadcast)---
any of the attributes of a table, but is
it a table? Is the data pulled together when one selects from the view or is
it maintained as a table all along. Guidance to the ignorant appreciated...
--
Terry Lee Tucker
tel: (336) 372-5432; cell: (336) 404-6897
te...@chosen-ones.org
--
Sent via pgs
On Thursday, November 04, 2010 15:03:49 Scott Marlowe wrote:
> On Thu, Nov 4, 2010 at 12:43 PM, Terry Lee Tucker
wrote:
> > Greetings:
> >
> > Lately, I've begun using views quite often especially when queries for
> > various reports, etc. become complicated
1 - 100 of 305 matches
Mail list logo
