Bob Pawley wrote:
This is the example found in the documentation to dump a database.
"Examples
To dump a database:
$ pg_dump mydb > db.out"
The following - $ pg_dump aurel > aurel.out - gives me
"ERROR: syntax error at or near "$" at character 1"
What am I missing???
Bob
The "$"
snappingturtle wrote:
It appears that in my installation of Postgres that dollaw sign quoting
is disabled. For example, the following command returns an error:
I didn't do anything (that I know of) to disable dollar quoting. Any
advice on how to enable dollar sign quoting?
Are you on pos
Scott Marlowe wrote:
On Thu, 2006-12-07 at 11:59, Tony Caduto wrote:
http://linux.inet.hr/poll_favorite_database.html
So far Firebird is in the lead :-(
Somebody just told their list earlier than anyone told us... or mysql's
list.
http://archives.postgresql.org/pgsql-general/2006-11/msg000
[EMAIL PROTECTED] wrote:
I'm trying to port an MS statement that's a bit involved with
timestamps, and I don't see anything in the docs to lead me forward.
It's basically a select statement, looking for records with a timestamp
within a certain range, where that range is calculated with one of
Marc Evans wrote:
OK, I must be missing something obvious:
c3i=> CREATE OR REPLACE FUNCTION foo_trigger() RETURNS TRIGGER AS $$
c3i$> eval { spi_exec_query('INSERT INTO FOO_BAR VALUES(1)'); } ||
c3i$> spi_exec_query('SELECT 1 as foo');
c3i$> $$ LANGUAGE plperl;
ERROR: creation of Perl funct
Jeanna Geier wrote:
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to poin
Emi Lu wrote:
HEllo,
I am looking for a psql method to get the bigger value of two numbers.
For example,
methodName(12.6, 3.8)
select greatest(12.6,3.8);
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropr
Bradley Kieser wrote:
I hope that someone has cracked this one because I have run into a brick
wall the entire week and after 3 all-nighters with bad installations, I
would appreciate hearing from others!
I am looking for a decent OpenSource CRM system that will run with
Postgres. SugarCRM se
Joshua D. Drake wrote:
Martijn van Oosterhout wrote:
No difference whatsoever from PostgreSQL's point of view. Use whichever
distribution is easiest for you to administer. After all, there's no
point installing Postgres on a machine you don't know how to maintain
or tune :)
Actually there is a d
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
>time), controlData->blcksz,
controlData->relseg_size, controlData->nameDataLen,
#
Obviously, the bottom 3 chunks aren't very useful, but a cursory examination of
the relevant headers
didn't make it obvious what these s
Tom Lane wrote:
Bricklen Anderson <[EMAIL PROTECTED]> writes:
Feb 1 11:17:50 dev94 postgres[4959]: [472-1] 2005-02-01 11:17:50 PST> ERROR:
xlog flush request
972/FC932854 is not satisfied --- flushed only to 73/86D2640
Hmm, have you perhaps played any games with pg_resetxlog in this
Tom Lane wrote:
Bricklen Anderson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I would have suggested that maybe this represented on-disk data
corruption, but the appearance of two different but not-too-far-apart
WAL offsets in two different pages suggests that indeed the end of WAL
was up
Bricklen Anderson wrote:
Tom Lane wrote:
Bricklen Anderson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I would have suggested that maybe this represented on-disk data
corruption, but the appearance of two different but not-too-far-apart
WAL offsets in two different pages suggests that inde
Alban Hertroys wrote:
Bricklen Anderson wrote:
Any ideas on what I should try next? Considering that this db is not
in production yet, I _do_ have the liberty to rebuild the database if
necessary. Do you have any further recommendations?
I recall reading something in this ML about problems with
Tom Lane wrote:
Bricklen Anderson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
But anyway, the evidence seems pretty clear that in fact end of WAL is
in the 73 range, and so those page LSNs with 972 and 973 have to be
bogus. I'm back to thinking about dropped bits in RAM or on disk.
Karl O. Pinc wrote:
4. Can I query an object in another database, like in Oracle's dblink?
I'm no expert. I don't believe so. You can query across scheams
in the same database but not across databases. You could do
something (anything!) by writing an external function in C or
whatever, but I c
Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make the
> report using a database manager application, and it requires me to make
> my own report by typing the SQL command
Ubence Quevedo wrote:
A friend of mine has created this simple accumulating
loop query for MS SQL 2k5 Express Edition. I am
trying to reproduce the same results with PostgreSQL
8.1, but am not able to find much useful help on how
to properly set up a variable of both int and char.
The PostgreSQ
Pandurangan R S wrote:
To get rid of ^M characters you could use
cat file | tr -d ^M
you need to type ^V before you type ^M in the preceeding command. But
^V will not be displayed on the screen.
Or you can use dos2unix/unix2dos, if installed. I believe they are in
the sysutils package.
---
Jim C. Nasby wrote:
I would highly recommend taking a look at how Oracle is handling
encryption in the database in 10.2 (or whatever they're calling it).
They've done a good job of thinking out how to handle things like
managing the keys.
I know that Oracle magazine did an article on it recently
Kleynhans, Hendrik wrote:
___
“The information contained in this e-mail is confidential and may contain
proprietary information.
It is meant solely for the intended recipient. Access to this e-mail
Bob Pawley wrote:
Hi Folks
I have three triggers and associated functions that fire on one insert
and moves row ID information to five different tables..
I am getting an error message "stack depth limit exceeded".
Is this normal for, what I consider, a small amount of information transfer?
[EMAIL PROTECTED] wrote:
The problem was fixed by initializing the array before giving it a
value. Not surprising Postges isnt as popular as it should be. I was by
luck that I found this out - the manual says nothing about init arrays.
Instead of flippant comments like that, submit docs a patch
Steve Crawford wrote:
How can I dump a function definition with pg_dump?
Background: We often need to create objects that are all relevant to
only a specific project. Sometimes it is a single table. Other times
there are many tables, indexes, views, rules, triggers and functions.
All the obje
Hrishikesh Deshmukh wrote:
Hello All,
Suppose there 3 users red, green, blue. How can the user green know what
tables he has created?!
From psql command line \dt lists every table in the DB!!!
Thanks in advance.
Hrishi
If you mean that the owner of the table(s) is the user "green", then tr
Michael Trausch wrote:
Hey guys,
I'm having a slight problem with this database that I'm trying to setup
on PostgreSQL 8.1.3... What I've got is a stored procedure that refuses
to get itself into the system, and I'm not sure why. It is throwing a
syntax error on DECLARE, but I don't see it. I
Dino Vliet wrote:
Hi guys,
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax error at
or near at character 17
QUERY: copy cancel TO $1 with delimiter as ',' null
as '.'
CONTEXT: SQL statement in PL/PgSQL f
Dino Vliet wrote:
Nope:-(
I added it just now and still the same error message!!
Have you tried it with your "copy" command executed dynamically?
eg. execute 'copy cancel to location ...';
---(end of broadcast)---
TIP 1: if posting/reading throu
Emi Lu wrote:
No. It is not for select.
I have tens of tables with very clean structure. For example, username,
application_code, last_modified_by, etc in specific orders.
Since the business model is changed, I have to add some columns to
serveral tables.
I prefer columns orders followin
sergey kapustin wrote:
Hi all!
can anybody say me what's wrong with this query. I just try to take
unique values from table column and print them in random order
select distinct num from (select 1 as num union select 2 as num union
select 1 as num union select 3) t order by random();
ERROR: for
There was a thread last November entitled "Transitive closure of a
directed graph" on the [HACKERS] list. There may be some information of
use there.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Anton de Wet wrote:
One problem I see the postresql at the moment (and I'm porbably touching
a can of worms here) is the lack of some sort of certification.
One thing linux (or Red Hat) is doing well is supplying the things that
corporates are looking for. And the first thing they look for w
201 - 233 of 233 matches
Mail list logo
