Thank you all for your help.
Let me summer what I'm trying to do:
I have an empty database that I want to populate it with data.
I created SQL text files, categories.sql, books.sql
As I'm a Java guy, I use Apache Ant SQL taks to run those SQL text files.
So, I run categories.sql file first,
On Tue, Feb 19, 2008 at 07:58:20PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
when i try to uninstall tsearch2 i get this error,
Hmm, maybe you originally put tsearch2 into some other schema than
public? If so, try setting search_path to point to that schema
before
On 20 févr. 08, at 08:57, HHB wrote:
Thank you all for your help.
Let me summer what I'm trying to do:
I have an empty database that I want to populate it with data.
I created SQL text files, categories.sql, books.sql
As I'm a Java guy, I use Apache Ant SQL taks to run those SQL text
Hello
Anybody got any ideas/experiences/links for 'longest prefix match'
solution in PostgreSQL ?
Basically,put some telephone prefices in some kind of trie,and be able
to perform fast lookups ?
Sincerely
Dragan Zubac
---(end of broadcast)---
a final question: why does this syntax do a seq scan + filter:
select * from tablea where fielda = fielda -or- select * from
tablea where fielda in (fielda)
while this syntax results in no filter, seq scan only
select * from tablea where 1 = 1
it seems that both where clauses should be
On Feb 19, 2008 12:12 AM, Alvaro Herrera [EMAIL PROTECTED] wrote:
Mikko Partio escribió:
Now, I was wondering if a c function would be faster, and with the help
of
the manual I have written a function that can insert tuples from one
table
to another. As the manual states (
On Wed, Feb 20, 2008 at 12:56:54AM -0800, Postgres User wrote:
a final question: why does this syntax do a seq scan + filter:
select * from tablea where fielda = fielda -or- select * from
tablea where fielda in (fielda)
while this syntax results in no filter, seq scan only
select *
Postgres User wrote:
im trying to allow the client to pass a varchar param into my
function, and want to avoid any parsing of the parameter inside the
function, or code to build a sql string.
if the function can use this code, it will be compiled and optimized
(unlike a dynamic sql stirng)
Em Wednesday 20 February 2008 05:55:07 Dragan Zubac escreveu:
Anybody got any ideas/experiences/links for 'longest prefix match'
solution in PostgreSQL ?
Basically,put some telephone prefices in some kind of trie,and be able
to perform fast lookups ?
Prefix or suffix?
For prefix you can
Em Wednesday 20 February 2008 03:56:37 Scott Marlowe escreveu:
On Feb 19, 2008 11:39 PM, Tom Lane [EMAIL PROTECTED] wrote:
http://www.postgresql.org/docs/8.3/static/plpgsql-cursors.html
section 38.7.3.5. But then I go to the index page for plpgsql at
On Wed, 20 Feb 2008, Jorge Godoy wrote:
Em Wednesday 20 February 2008 05:55:07 Dragan Zubac escreveu:
Anybody got any ideas/experiences/links for 'longest prefix match'
solution in PostgreSQL ?
Basically,put some telephone prefices in some kind of trie,and be able
to perform fast lookups ?
Tino,
My users are developers and the goal was to accept a simple
comma-delimited list of string values as a function's input parameter.
The function would then parse this input param into a valid regex
expression.
I was trying to write a function that lets me avoid using Execute
string and
So, we are trying to track down some problems we're having with an
implementation of slony on our database. I've posted to the slony list
about this issue, but I wanted to get a more generic response from the
perspective of postgresql.
Is it a 'bad thing' to have a unique key on a field that
On 20/02/2008, Geoffrey [EMAIL PROTECTED] wrote:
So, we are trying to track down some problems we're having with an
implementation of slony on our database. I've posted to the slony list
about this issue, but I wanted to get a more generic response from the
perspective of postgresql.
Is it
I always hope that somebody might have something similar but
generic - eg. create those columns automatically and just treat them all
as text.
I came up with this amateurish one based on
http://www.ledscripts.com/tech/article/view/5.html.
Maybe someone can use it:
takes
- a select statement
Peter Childs wrote:
On 20/02/2008, Geoffrey [EMAIL PROTECTED] wrote:
So, we are trying to track down some problems we're having with an
implementation of slony on our database. I've posted to the slony list
about this issue, but I wanted to get a more generic response from the
perspective of
Postgres User [EMAIL PROTECTED] writes:
My users are developers and the goal was to accept a simple
comma-delimited list of string values as a function's input parameter.
The function would then parse this input param into a valid regex
expression.
Why are you fixated on this being a regex?
Hermann Muster [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I encountered something I can't really explain. I use the following
statement in my application:
COALESCE(UPPER(SUBSTR(Y.Firma,1,7)),'')
This returns ERROR: syntax error at end of input
However, using the
When performing a select ... into ... an app crashed out with the error
'duplicate key violates unique constraint pg_type_typname_nsp_index'
I looked in the mail lists and I see this error associated with TEMPORARY
tables, but the into table is not a temp table. A previous
Tom,
I was looking for another approach but didn't come across that array
syntax in my searches (perhaps because it's newer. Thanks for a
solution.
Now to end my fixation, one last item. What about the case of a null
or empty param value- is there a way to assign a condition value that
Hi List !
I have a problem with defining an array in pl/pgsql using an already defined
column in a table.
Is it possible to define an array ( v_var1 ) as in my example below:
If it is not possible now it would be really nice to have in a future
release , maybe something for 8.4 wishlist ?
Hi. I've written a Unix shell (zsh) script to streamline the process of
duplicating a database. At the heart of this script I have the following
pipeline:
pg_dump -U $OWNER -Fc $FROM | pg_restore -U $OWNER -d $TO
As far as the shell is concerned, this pipeline fails, due to three errors
I really need some input:
In a system that handles money transfers I have a table to store each
money transfer. A number of different events can result in a money
transfer but the events are so different that each event type is stored
in its own table.
So we have a schema of the form:
On 2/20/08, Kynn Jones [EMAIL PROTECTED] wrote:
Alternatively, is there a better way to streamline the duplication of a
database?
How about:
CREATE DATABASE newdb TEMPLATE olddb;
(don't remember the exact syntax, but it'll be in the docs for CREATE
DATABASE). I think the 'createdb' program
HHB wrote:
Thank you all for your help.
Let me summer what I'm trying to do:
I have an empty database that I want to populate it with data.
I created SQL text files, categories.sql, books.sql
As I'm a Java guy, I use Apache Ant SQL taks to run those SQL text files.
So, I run categories.sql
cluster wrote:
I really need some input:
In a system that handles money transfers I have a table to store each
money transfer. A number of different events can result in a money
transfer but the events are so different that each event type is stored
in its own table.
So we have a schema of
Kynn Jones [EMAIL PROTECTED] writes:
As far as the shell is concerned, this pipeline fails, due to three errors
emitted by pg_restore. All these errors are vacuous, as far as I can tell.
They're hardly vacuous --- they're telling you that the destination
database will be missing plpgsql, which
On Feb 20, 8:12 pm, [EMAIL PROTECTED] (Douglas McNaught) wrote:
On 2/20/08, Kynn Jones [EMAIL PROTECTED] wrote:
Alternatively, is there a better way to streamline the duplication of a
database?
How about:
CREATE DATABASE newdb TEMPLATE olddb;
Do these methods also recreate the schema
Hi All,
I am using PlPython procedure to insert data in a table:
plan = plpy.execute(insert into test(id,name) values(1 , 'test_py'))
I am getting error:
ERROR: invalid input syntax for integer: PLyResult object at 0x374a5a70
In fact preparing a plan and passing a list of values for columns
I am a bit puzzled by the output of ts_headline (V8.3) for different queries.
I have one record in a test documentation table and am applying different
queries against that table to check out the ts_headline outputs.
The document in question has 2553 words which generate 519 tokens in the
mars_osrp wrote:
Hi All,
I am using PlPython procedure to insert data in a table:
plan = plpy.execute(insert into test(id,name) values(1 , 'test_py'))
I am getting error:
ERROR: invalid input syntax for integer: PLyResult object at 0x374a5a70
In fact preparing a plan and passing a list of
Hi. This is my first post to this list. So please let me know if my question
is in the wrong area.
I am trying to install version 8.3.0.1 on an old windows 2000 box I inherited.
Firewall s/w is installed but disabled. I am logged in as a user with
Administrative rights. When the
On Feb 20, 2008, at 5:53 PM, mars_osrp wrote:
Hi All,
I am using PlPython procedure to insert data in a table:
plan = plpy.execute(insert into test(id,name) values(1 , 'test_py'))
I am getting error:
ERROR: invalid input syntax for integer: PLyResult object at
0x374a5a70
In fact
My php code is creating temporary table named mytemp,but when I run a
selec * from mytemp I cannot see the table.How can I see the table
from postgresql command prompt?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi, Scott Marlowe:
You said that As for processing them in order versus randomly,that's a
common problem.
do you know why? how postgres work in this scenario.
On Wed, Feb 20, 2008 at 3:07 PM, Scott Marlowe [EMAIL PROTECTED]
wrote:
On Feb 19, 2008 9:38 PM, hewei [EMAIL PROTECTED] wrote:
pc wrote:
My php code is creating temporary table named mytemp,but when I run a
selec * from mytemp I cannot see the table.How can I see the table
from postgresql command prompt?
temp tables are automatically deleted when the connection is closed.
make it a non-temp table :)
--
Postgresql
On Wed, Feb 20, 2008 at 7:30 PM, pc [EMAIL PROTECTED] wrote:
My php code is creating temporary table named mytemp,but when I run a
selec * from mytemp I cannot see the table.How can I see the table
from postgresql command prompt?
Got a code sample that shows this problem? I.e. create table
On Thu, Feb 21, 2008 at 1:07 AM, hewei [EMAIL PROTECTED] wrote:
Hi, Scott Marlowe:
You said that As for processing them in order versus randomly,that's a
common problem.
do you know why? how postgres work in this scenario.
Pretty much the same way any database would. it's likely that your
38 matches
Mail list logo