On Mon, Jan 02, 2006 at 11:21:40 -0800,
Mike <[EMAIL PROTECTED]> wrote:
> I am new in this field and would appreciate it if someone points me to
> the right direction.
>
> I have a website with lots of users and each have lots of data in
> multiple tables. I want to create a search box where a u
On Wed, 4 Jan 2006 21:00:25 -0800, Benjamin Smith <[EMAIL PROTECTED]> wrote:
> Is there a way to put a limit on pg_dump, so that it doesn't dump ALL data,
> but that matching a particular query?
>
> Something like:
>
> pg_dump -da --attribute-inserts -t "customers" \
> --matching-query="select
Assuming records is the name of a table...
create or replace function getrecord(int,text) RETURNS SETOF records as $$
DECLARE
row records%rowtype;
BEGIN
FOR row IN SELECT * FROM my_tbl
WHERE ...
LOOP
RETURN NEXT row;
END LOOP;
RETURN;
END;
$$ LANGUAGE plpgsql;
On 1/5/06, Matthew Peter <[EMAIL
Is there a way to put a limit on pg_dump, so that it doesn't dump ALL data,
but that matching a particular query?
Something like:
pg_dump -da --attribute-inserts -t "customers" \
--matching-query="select * from customers where id=11";
I'd like to selectively dump information from a query, bu
I'm using CentOS 4.2 on a dual-opteron, but I'd guess it'd probably work for
IA64...
Try putting this somewhere in your /etc/yum.repos.d/...
#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$releasever - Plus
baseurl=http://mirror.centos.org/centos/$
On Wed, Jan 04, 2006 at 01:36:45PM -0600, John McCawley wrote:
> I have decided that I'm going to resume working on my pgDesigner project
> ( http://www.hardgeus.com/projects/pgdesigner/ ). I haven't really
> maintained it for over a year, but I get about 200 visits a day to the
> project homep
On Wed, 4 Jan 2006, Stephan Szabo wrote:
> Which in this case hints that there's a problem with the schema.
>
> What is the final effect you're looking for? The above does let you
Err, that should be doesn't.
> lookup the DE or FR strings for a city of a member (what if two cities had
> the sa
Title: Message
unsubscribe
I'm trying to do a simple SELECT * in plpgsql that returns a set of records as a row w/ columns, not a row into a variable, w/ some conditionals. The function below is semi-pseudo with what I'm trying to... If anyone could give me an example that works by returning it as a resultset maintain
Albert Vernon Smith presumably uttered the following on 01/03/06 13:36:
I figured it out myself. Not TOO difficult. I was just having a hard
time wading through the documentation before. Giving the answer out
here, just in case any one else wants to see the solution (not using
reserved
Environment: Deployed on Debian. Test and Development on Windows.
Using pg_admin III and Postgresql 8.1 (both test and development).
I want to backup Development and restore it in test and vice-versa.
So when I do a backup of the db (in PGAdmin III), it backs it up. But
when I restore it, all pri
I found how to make it run : the ' tcpip_socket ' must be changed to
true in /etc/postgresql/7.4/main/postgresql.conf.
C. Tobini
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello,
I installed postgresql 7.4 on Ubuntu Breezy with libpq.dev and an error
occurs at postgres start (/etc/init.d/postgresql7.4 start) :
* Starting PostgreSQL 7.4 database server: main The PostgreSQL server
failed to start. Please check the log output:
/usr/lib/postgresql/7.4/bin/postmaster: T
Tom,
Thanks for the reply. That makes sense.
Do you or (or anyone else) suggest a method for moving databases from
one server to another without the time consuming dump/transfer/restore
process? Anything in the contrib directory or a good management tool?
Our databases can get large and we w
Hello,
I just installed postgresql 7.4 using Synaptic with Ubuntu Breezy
(i386) and I have a problem with my main Linux account.
I have created 3 users in postgresql: tobini (main), hadoc and postgres
(main postgresql account).
First using the postgres account I created 2 postgresql users for th
Thisis fixed this in December 2005.
Recent development snapshot does not have this problem.
This problem occurs only when Postgres returns error and VFP application
executes next statement i.e. in rare cases.
Andrus.
>There is an ODBC problem with Visual Foxpro 9. According to a Visual
>FoxP
On Wed, 4 Jan 2006, Michelle Konzack wrote:
>
> __( 'stdin' )_
> /
> | psql:omegasector.sql:125: ERROR: there is no unique constraint matchi
> | ng given keys for referenced table "cities"
> \_
On 1/4/06, Michelle Konzack <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I get the following error:
>
> __( 'stdin' )_
> /
> | psql:omegasector.sql:125: ERROR: there is no unique constraint matchi
> | ng given keys for referenced table "cities"
I have decided that I'm going to resume working on my pgDesigner project
( http://www.hardgeus.com/projects/pgdesigner/ ). I haven't really
maintained it for over a year, but I get about 200 visits a day to the
project homepage, and about two or three emails a week asking for help.
As the pro
marcelo Cortez <[EMAIL PROTECTED]> writes:
> the follow error:
> Warning: pg_query(): Query failed: ERROR: no existe
> la columna <>
> " the column oid don't exists" in english.
> CONTEXT: sentencia SQL: < public.pg_ts_cfg where locale = $1 >>
You seem to have managed to create the pg_ts_cfg t
On 1/4/06, Robert Osowiecki <[EMAIL PROTECTED]> wrote:
> Jaime Casanova napisał(a):
>
> > it exists a transaction id called XID, you can't get it via sql
> >
> >though, you need to make a c function and invoke GetTopTransactionId()
> >(or GetCurrentTransactionId() in versions prior to 8.0)
> >
> >
Jaime Casanova napisał(a):
it exists a transaction id called XID, you can't get it via sql
though, you need to make a c function and invoke GetTopTransactionId()
(or GetCurrentTransactionId() in versions prior to 8.0)
I've read a little about problems with overlapping XID and how they were
Hello,
I get the following error:
__( 'stdin' )_
/
| psql:omegasector.sql:125: ERROR: there is no unique constraint matchi
| ng given keys for referenced table "cities"
\__
On Jan 2, 2006, at 5:34 PM, SunWuKung wrote:
What do you suggest is the most effective way to insert this type of
data into the db? Issuing multiple inserts from php seems to be a
waste
of resources.
I was thinking of writing the responses into a pg array field with a
single insert and than
Hello *,
I have many tables (one per product) and the are two columns where I
put my buyed and selled pieces. Second I have a Main-Table with all
products and a summary of the stock.
What I want is, whenever I buy or sell something, the changements
(buy/sell) in the product table must triger an
On Wed, Jan 04, 2006 at 06:30:50PM +, marcelo Cortez wrote:
> Warning: pg_query(): Query failed: ERROR: no existe
> la columna <>
> " the column oid don't exists" in english.
>
> CONTEXT: sentencia SQL: < public.pg_ts_cfg where locale = $1 >>
I'd guess that you're using tsearch2 but somehow
Folks
the follow error:
Warning: pg_query(): Query failed: ERROR: no existe
la columna <>
CONTEXT: sentencia SQL: <>
using php call the pgsql.so with follow query:
COPY caratult(actuacion_car,
id_reparticion_uc,fecha_inicio,tipo_actuacion,id_extracto_car,act_extramunicipal,observaciones,c
Folks
the follow error:
Warning: pg_query(): Query failed: ERROR: no existe
la columna <>
" the column oid don't exists" in english.
CONTEXT: sentencia SQL: <>
using php4 call the pgsql.so
with follow query:
COPY caratult(actuacion_car,
id_reparticion_uc,fecha_inicio,tipo_actuacion,id_extr
There is an ODBC problem with Visual
Foxpro 9. According to a Visual FoxPro maillist:
Since VFP caches a common statement handle that it
reuses, it has to call SQLFreeStmt(SQL_UNBIND) and SQLFreeStmt(SQL_RESET_PARAMS)
to make sure the cached statement handle is in a cleared state before reusing
On 2006-01-04, Emi Lu <[EMAIL PROTECTED]> wrote:
> OK. When the column is setup as "timestamp with time zone default
> now()", the default values will be set based on the Operating System,
> right?
You have to understand that in the current implementation, pg does not
actually store the time zon
On 1/4/06, Robert Osowiecki <[EMAIL PROTECTED]> wrote:
> Apart from now() function, is there some kind of sequence that advances
> with each transaction started? If not: is it possible to implement that
> using sequences?
>
> Robson.
>
>
it exists a transaction id called XID, you can't get it via
hii have a table with 14 milion columns.structure is like this:id (serial), object_id (int8), first_id (int8), second_id (int8), counter (int8)id is primary key,(object_id, first_id, second_id) form together unique index.
i partitioned it using first_id and second_id as check params.works.but!when
In postgreSQL, the default value for timestamp is "without time zone".
That's true only because the SQL standard says so, not because it's actually
a good idea to use timestamps without time zone.
Can I say when data is used among diff time zones, timestamp with time
zone is a MUST;
On 2006-01-04, Emi Lu <[EMAIL PROTECTED]> wrote:
> In postgreSQL, the default value for timestamp is "without time zone".
That's true only because the SQL standard says so, not because it's actually
a good idea to use timestamps without time zone.
> Can I say when data is used among diff time zon
I need to know when it is better that we use "timestamp without time
zone" ? And when it is better to use "timestamp with time zone"?
In my opinion, if you want to store a timestamp, you should always
use timestamp with time zone, as the UTC offset information is
necessary to provide a un
Hi,
On Wed, 2006-01-04 at 12:04 +0100, DANTE ALEXANDRA wrote:
> Is anyone working on an 8.1.0 RPM for IA64 on Red Hat Enterprise Linux 4
> AS ?
No. This morning I would do it but I could not find a gcc to compile
it :-)
> Could someone explain me how generate this rpm ?
http://pgfoundry.org/d
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
>
> SunWuKung <[EMAIL PROTECTED]> writes:
>
> > Thank you both, I will make good use of this.
> >
> > On a side note: isn't it a pity this has to be so difficult?
>
> It doesn't have to be.
>
> Look in the contrib directory, build the i
Hello,
Is anyone working on an 8.1.0 RPM for IA64 on Red Hat Enterprise Linux 4
AS ?
On the web site :
http://www.postgresql.org/ftp/binary/v8.1.1/linux/rpms/redhat/, I have
found a "rhel-as 4" version for RHEL4 but I don't think it is a version
for IA64.
Could someone explain me how genera
Apart from now() function, is there some kind of sequence that advances
with each transaction started? If not: is it possible to implement that
using sequences?
Robson.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please se
Albert Vernon Smith wrote:
CREATE FUNCTION "return_one_id" () RETURNS "trigger" AS '
Is there any reason you force your identifiers to be case sensitive?
> CREATE TRIGGER return_one_id BEFORE INSERT OR UPDATE ON two FOR EACH
>> CREATE TABLE "one" (
>> "one_id" BIGSERIAL,
>> "text" text
40 matches
Mail list logo
