EN...
> but it does not work... every time it enter in the loop, even if it is empty
> string.
>
> where is the problem ?
Are you sure ret_email is an empty string and not a NULL value. <> won't work
on a NULL value. You will need to use IS NULL or IS NOT NULL.
>
>
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > From: "Alain Roger" <[EMAIL PROTECTED]>
> >> once to do a comparison they use :
> > IF (ret == 1) THEN ...
>
orks correctly.
> however if the session id is correct it does not return me the email address
> (even if it really exist into table tmp_newsletterreg / but not in table
> users.)
> so i think my eyes are tired, because i do not see an error...
>
> thanks.
> --
> Alain
> ---
s error to handle that way?
>
>
> Sam
Or a simpler way to do handle my previous suggestion:
IF (ret_email IS NULL ) OR (ret_email='') THEN
RETURN ('-3')
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
f I had exposure to other databases as well. I'm
> sure that I'd have the same questions about MSft's SQL server.
>
> But I thank the forum here for all the input.
>
> Regards,
> Barry Pettis
>
> CSO Atmel Corp
> Project Tech
>
> http://www.postgresql.
ry.
I am a great believer in "graphite engineering" i.e putting pencil to paper and
sketching out my ideas before tweaking software. You might want to spend some
time doodling to work out you want before getting too much into the details. As
Sam said in another post a review of terms mi
id.processes
> Where p_id.devices.number is null
> and p_id.devices.device_number = '11'
> and p_id.devices.fluid_id = p_id.processes.fluid_id
> and p_id.processes.ip_op_equipment = 'op' ;
>
> End If;
> RETURN NULL;
> End If;
Eliminate this En
hence don't even notice
> the difference between the two.
My only comment is on this assertion. Any location that has DST rules has two
time zones. For instance I live in US PST/PDT. Without timezone support
doing date/time math across time zone boundaries is asking for problems.
>
>
> Sam
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
quote]while ($l_asRow = pg_fetch_array($l_hResult)) {[/quote]
>
> [B]common.php on line 483[/B]
>
> [quote]$l_sReferer = isset($_POST['referer'])?
> trim($_POST['referer'])
>
> : base64_encode($_SERVER['HTTP_REFERER']);[/quote]
>
> Thank you!
Forgot to hit reply all.
- Forwarded Message: --
From: [EMAIL PROTECTED] (Adrian Klaver)
To: "Kerri Reno" <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] create temp in function
Date: Mon, 21 Apr 2008 23:01:53 +
>
he link I included in
the previous email you will see some examples.
>
> Thanks!
> Kerri
>
> On 4/21/08, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> >
> > Forgot to hit reply all.
> >
> > - Forwarded Message: --
> > From
' where cp_id = ' || to_char(tcp_id,'');
> > raise notice 'query: %', query;
> > execute query;
> > select into relid distinct(attrelid) from pg_attribute where
> > attrelid='schedrec'::regclass;
te(sql,(name,))
note the comma after name.
>
> What's the problem?
> thx
>
> ps: fn_pat is the column of the db, name is the string passed in the
> function parameter.
> if I type:
> "SELECT * from patient WHERE fn_pat = 'david' "
> in the psql
te to that table. Anyone have any ideas.
>
Does the table with the OID have a primary key defined?
--
Adrian Klaver
[EMAIL PROTECTED]
--- Begin Message ---
I have a linked server
on SQL server 2005. I can update or write to a table in Postgres that
does not have a OID. But the
type and not
> a serial. I think that since it sees an integer, it does not understand
> that it is a serial, and access does not recognize it as autoincrement.
>
> I'm stuck at this point...
Did you mark this field as the primary key when you linked the table?
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thursday 15 May 2008 11:44 pm, Ottavio Campana wrote:
> Adrian Klaver ha scritto:
> >> The fact is that the serial data type is in pratice an integer, and when
> >> I also try to connect with pgadminIII I see an integer data type and not
> >> a serial. I think tha
ne help?
You can use C or SQL to write a function as they are "preinstalled".
See:
http://www.postgresql.org/docs/8.3/interactive/xfunc.html
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ious integrety implications if Postgres failed
> to access/write to this table for whatever reason, or would the
> transaction be rolled back.
Previous reports of this type of intermittent behavior on Windows have been
traced back to AV software.
--
Adrian Klaver
[EMAIL PROTECTED]
gt;
> > [...]
> > Below is an example of querying a database on the same server
> > and cluster using DbLink. Note if no username and password is
> > specified, then DbLink connects with whatever account you are
> > currently using.
> >
> &g
is no longer deprecated in newer releases (specifically 8.3),
> > although I do think it would be wise to push it to numeric.
> >
> > I think the way to do it would be to backup the table and edit the table
> > definition from the file. Make the money a numeric. Then reload the
> > table from the backup.
> >
> > Sincerely,
> >
> > Joshua D. Drake
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Friday 06 June 2008 8:49 am, Adrian Klaver wrote:
> On Friday 06 June 2008 8:25 am, Ken Winter wrote:
> > Thanks, Joshua ~
> >
> > What you suggest is basically what I'm trying to do. Where I'm stuck is
> > in finding a construct (a CAST or whatever) to
On Tuesday 10 June 2008 12:41 am, Hermann Muster wrote:
>
> Adrian Klaver wrote:
> > On Friday 06 June 2008 2:32 am, Hermann Muster wrote:
> >> Does no one have any idea about that?
> >>
> >> Regards.
> >>
> >> Hermann Muster wrote:
>
on't understand how, or what to do to
> recover.
>
> Thanks,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D. | IntegrityCredibility
> Applied Ecosystem Services, Inc.|Innovation
> <http://www.appl-ecosys.com> Voice: 503
gt; thing that happened this morning is that Postgres had today as 18/06/2008
> when in fact it was 19/06/2008 and the OS reported this correctly. Restarting
> postgres sorted it, could this be the problem?
> Regards
> Garry
>
Seems like a transaction with no commit. Basically al
-- Original message --
From: Garry Saddington <[EMAIL PROTECTED]>
> On Thursday 19 June 2008 18:52, Adrian Klaver wrote:
> > -- Original message --
> > From: Garry Saddington <[EMAIL PROTECTED]>
> >
T-type SQL to run them through psql.. Is there a way one can
> specify a table structure with raw field widths and then just pass it a
> flat file?
Take a look at:
http://pgfoundry.org/projects/pgloader/
Latest version has support for fixed length records.
--
Adrian Klaver
[EMAIL PROTECT
;
> Am I missing something obvious? Seems when I specify GMT+10:00 it
> returns GMT-10:00 and vice versa. Note that column 2 & 3 are
> timestamp withOUT timezone while 1 & 4 are timestamp WITH timezone.
> But I still see this as totally wrong.
>
> Regards,
>
ee
Section 23.1.3 for more information.
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-- Forwarded Message --
Subject: Re: [GENERAL] [Postgresql 8.2.3] autovacuum starting up even after
disabling ?
Date: Friday 04 July 2008 9:51 am
From: dushy <[EMAIL PROTECTED]>
To: "Adrian Klaver" <[EMAIL PROTECTED]>
Hey,
Thanks for the quick r
-- Original message --
From: Bob Pawley <[EMAIL PROTECTED]>
> Is there a GUI for pg_dump???
>
> Bob
>
http://www.pgadmin.org/docs/1.8/backup.html
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@
e plpythonu
>
>
> test_dev-# \g
> CREATE FUNCTION
> test_dev=# select testf5i(1,2);
> ERROR: plpython: function "testf5i" failed
> DETAIL: exceptions.NameError: global name 'a' is not defined
Take a look at:
http://www.postgresql.org/docs/8.1/interact
id,table p_id,column p_id_id?
>
> You probably ought to qualify the column reference in the cursor.
>
> regards, tom lane
>
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ell you
> what your current transaction ID is?
>
> Thanks in advance.
>
> Cheers,
> Rob
>
Actually its not asking for a VACUUM FULL but a VACUUM of the full database,
instead of selected tables.
See below for complete details
http://www.postgresql.org/docs/8.3/interactive/rou
n is:
>
> SELECT my_func();
>
> ... yes? Thanks; it seems to work fine, but using SELECT here is
> causing some part of my brain to scream "counter-intuitive."
Similar to doing:
test=# SELECT 1+1;
?column?
--
2
(1 row)
--
Adrian Klaver
[EMAIL PROT
tatement:
> "SELECT col FROM schema.table"
> I like to be able to use generic SQL statement like:
> "SELECT col FROM table"
>
>
>
> --
See search_path in:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-client.html
--
Adrian Klaver
[EMAI
On Tuesday 19 August 2008 9:53:11 pm johnf wrote:
> On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote:
> > -- Original message --
> > From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]>
> >
> > > I have to
before the localhost(tcp/ip), unless localhost was specified in the connection
string.
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-- Original message --
From: [EMAIL PROTECTED] (Adrian Klaver)
> -- Original message --
> From: "Matthew Pettis" <[EMAIL PROTECTED]>
> > SOLVED.
> >
> > Yep, Restart was done.
> >
>
md5
> #hostall all 127.0.0.1/32 trust
> # IPv6 local connections:
> hostall all ::1/128 md5
> --------
> --
>
> On Wed, Aug 20, 200
.
>
>
>
> On Wed, Aug 20, 2008 at 3:48 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> >
> > -- Original message --
> > From: [EMAIL PROTECTED] (Adrian Klaver)
> >> -- Original message
connection. The first socket line is:
> > local all postgres ident sameuser
> >
> > so you would need to be logged in as the Linux user postgres to make the
> connection.
> >
> >>
> >>
> >>
> >> On
-schema dump can be
successfully restored by themselves into a clean database.
> Thanks in advance for your help,
> Laura
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
f the data to date? You have a CSV
column with text strings of format '/MM/DD' . Do you want them stored as
strings or dates? I could go on, but the point is that table data types
require some thought on the part of the DBA.
> ~
> That may/should become a RFE
> ~
>
SS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
itdb made.
test=# SHOW all;
lc_collate | en_US.UTF-8
lc_ctype| en_US.UTF-8
lc_messages | en_US.UTF-8
lc_monetary | en_US
-- Original message --
From: "Phoenix Kiula" <[EMAIL PROTECTED]>
> On 8/30/08, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> >
> > Might also be useful to do SHOW ALL from within the database cluster you
> > have
> >
On Saturday 30 August 2008 5:23:25 am Albretch Mueller wrote:
> On Thu, Aug 28, 2008 at 7:50 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> > Define easily.
>
> ~
> OK, let me try to outline the approach I would go for:
> ~
> I think "COPY FROM CSV" sho
On Saturday 30 August 2008 9:42:19 am Adrian Klaver wrote:
> On Saturday 30 August 2008 5:23:25 am Albretch Mueller wrote:
> > On Thu, Aug 28, 2008 at 7:50 PM, Adrian Klaver <[EMAIL PROTECTED]>
wrote:
> > > Define easily.
> >
> > ~
> > OK, let me
s not faster than scanning the
> table. Any thoughts on that? Is scanning the table faster than
> scanning the index? Is there a reason that it needs anything other than
> the index?
>
I may be missing something, but it would have to scan the entire table to get
all the occurr
was used to stop
Postgres?
6) If there is a startup script what does it contain?
Hope this helps,
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ropriate. "
This only applies to later versions of Postgres.
>
> In Ingres: modify site to isam unique on sta, ondate (means structure
> isam, primary key is on 2 fields - sta and ondate)
>
> Thanks in advance,
> Nina
>
> > __________
&
t null
> offdate | character varying(8) | not null
> lat | double precision | not null
> lon | double precision | not null
> elev | double precision | not null default 0
> regist_code | character(1) | not null default
width of the column.
http://docs.ingres.com/sqlref/ColumnFormats#o1232
---
> --
> Adrian Klaver
> [EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
gt; Whatever happened to pgbash? I see the last update was Feb 2003 but
> that was for Pg v7.3.
>
>
> Rod
> --
> >
> > Kevin
> >
>
>
See also:
http://www.edlsystems.com/shellsql/
http://pgfoundry.org/projects/plsh/
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
gt;
> listen_addresses = '*'
> port = 5432
>
> Is that enough to make PG listen on a port ... the docs seem to be
> saying that?
What is in the pg_hba.conf file?
Also are you connecting from a remote machine or the local machine?
--
Adrian Klaver
[EMAIL PROTECTED]
--
Sent vi
On Saturday 18 March 2006 09:15 am, Hrishikesh Deshmukh wrote:
> Hi All,
>
> Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> 10.0?
>
> Sincerely,
> Hrishi
Try this site and enter postgresql. I found rpm's for OpenSuSE .
http://rpm.pbone
ation for packages under /usr/share/doc/packages. Cd
to this directory and look for sub-directory with postgresql name. There
should be a README or other documentation in the sub-directory.
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
all with the rpms!!
>
> Thanks,
> Hrishi
>
> On 3/18/06, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> > On Saturday 18 March 2006 11:44 am, Hrishikesh Deshmukh wrote:
> > > Hi All,
> > >
> > > In downloaded the rpms and installed rpms.
> >
ables. The differences
(added,deleted,changed) were written to audit tables with a timestamp. The
'real' tables where TRUNCATED and the new data transferred into them and then
the holding tables were cleaned out. This way my 'real' tables only
contained the minim
nd set it to true, by default it is set to false. For
8.0 and above the parameter is listen_addresses and can be set to * to listen
to all IP interfaces on the server, by default it is set to localhost. This
only allows connections from the machine the server resides on.
--
Adrian K
d) from my_table?
>
select avg(my_data_field) from my_table
http://www.postgresql.org/docs/8.1/interactive/functions-aggregate.html
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wednesday 29 March 2006 02:59 am, David Bernal wrote:
>
> Any ideas? I'm fairly baffled, but then I'm a newbie.
>
Just a thought, did you restart the server after making the changes?
From the Postgres docs-
"...This parameter can only be set at server start."
gt;
> http://archives.postgresql.org
Would it be possible to post the contents of your postgresql.conf and
pg_hba.conf files?
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
o hear if there
> are examples of existing commercial/OSS products to serve the
> purpose. Appreciate any advice. Thanks.
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
>
> Rhys
>
> Peace & Love | Live Long & Prosper
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
--
Adrian Klaver
[EMAIL PROTECTED]
line options to get a user's schema, and a user's
> data?
>
> Thanks,
> Blair
>
>
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
--
Adrian Klaver
[EMAIL PROTECTED]
--
This option shows up in 7.4.
On Friday 12 May 2006 10:16 am, Blair Lowe wrote:
> On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
> > On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
> > See following-
> > -n schema
> > --schema=schema
> >
> > Du
; -->to tell the problem. At a guess though, 7.4 doesn't
> -->understand dollar-quoting.
> -->
> -->Have a nice day,
> -->--
> -->Martijn van Oosterhout
> -->http://svana.org/kleptog/
> -->> From each according to his ability. To each according to
> -->his ability
> -->> to litigate.
> -->
> -->--
> -->No virus found in this incoming message.
> -->Checked by AVG Free Edition.
> -->Version: 7.1.392 / Virus Database: 268.5.6/339 - Release
> -->Date: 14/5/2006
> -->
> -->
> -->
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
is not pg/plsql core part in postgresql?
> If not is core funcionality, is not time to be pg/plsql part off the core.
> Postgresql without pg/plsql instaled, is like a Oracle without pl/sql.
>
> Thanks for help.
>
> Alejandro MSG <[EMAIL PROTECTED]>
\z 'table_name'
Look under access privileges for r and w.
For further information see-
http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
On Saturday 20 May 2006 03:11 pm, Bob Pawley wrote:
> How can I determine if my tables are 'read only' or 'read/write&
Sorry meant to add this from the psql command line.
On Saturday 20 May 2006 04:37 pm, Adrian Klaver wrote:
> \z 'table_name'
> Look under access privileges for r and w.
> For further information see-
> http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
>
> O
he data into my database. Please guide me how to do
> this. Or if there is any another way of doing this.
>
> I am relatively new in this field so, please dont get offended if this
> problem is quite obvious.
>
> Thanks
> Parang Saraf
> [EMAIL PROTECTED]
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
s you wish to import.
7) Select Next. Here you can modify the data types of the columns.
8) Select Create. The table should be created and the data inserted.
On Friday 07 July 2006 03:41 pm, [EMAIL PROTECTED] wrote:
> > [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Klaver
> >
> >
Dates don't transfer correctly. When I try it the date moves two days ahead.
On Wednesday 12 July 2006 08:43 am, Guy Fraser wrote:
> On Fri, 2006-07-07 at 22:41 +, [EMAIL PROTECTED] wrote:
> > > [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Klaver
> > >
> > &
bpq'
> together with some Toolkit, for example 'FLTK'.
>
> Thank you very much,
> Gustavo
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
--
Adrian Klaver
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
stuff = 'bark' WHERE id = 1;
>
> id | stuff | stamp
> +---+
> 1 | bark | 2009-11-22 20:04:51.261739
>
> You can see the time hasn't changed. But I'd want that stamp column to
> update to the current
I
> imagine I'd need to test that are in plpgsql itself.
>
> Thanks
>
> Thom
As far as I know the language exists ERROR will not stop the rest of the
process
from completing. You may in search of solution to a problem that does not
exist :)
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e day is in. By definition (ISO
8601), the first week of a year contains January 4 of that year. (The ISO-8601
week starts on Monday.) In other words, the first Thursday of a year is in week
1 of that year.
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list
ing the type
time with time zone (though it is supported by PostgreSQL for legacy
applications and for compliance with the SQL standard). PostgreSQL assumes your
local time zone for any type containing only date or time. "
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
be able to keep track of its associated time zone, I
> think. Am I wrong on this? Apart from what SQL Standard may say, for
> instance.
>
I would suggest searching the archives. There has been discussions in the past
about 'tagged' fields that would track timezones independent of a
On Sunday 29 November 2009 2:38:43 pm Eduardo Piombino wrote:
> On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver wrote:
> > On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote:
> > > Hi Adrian, thanks for your answer.
> > >
> > > I see current criteria
is i.e the problem with "time with time zone". It also means an extra
level of sanity checks when trying to to do date/time math, to determine
whether the values can actually be operated on. I don't see that happening.
> >
> > --
> > Adrian Klaver
&g
mentation for spreadsheets. The trick
is to copy the formatted date not the underlying value. I know I have done that
in the past but at this point in time I cannot remember how. You might want to
Google OO base spreadsheet date conversion or something similar.
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tuesday 01 December 2009 7:40:26 am Adrian Klaver wrote:
> On Tuesday 01 December 2009 7:21:45 am Le-shin Wu wrote:
> > Hi,
> >
> > I use OpenOffice Base as the front end tool to connect a postgreSQL
> > server. It works great. But when I am trying to create a tab
- "Tom Lane" wrote:
> Adrian Klaver writes:
> >> The problem is that dates in spreadsheets are stored as days from
> some
> >> date. For a more complete answer see:
> >> http://www.lexicon.net/sjmachin/xlrd.html
>
> Somebody should f
ould change the date strings "12/01/09" to the underlying integer
40147. Any new date strings entered however would stay as "12/01/09". Hope this
helps.
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the CREATE TABLE AS command:
http://www.postgresql.org/docs/8.4/interactive/sql-createtableas.html
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ble with the encoding of the
template database (UTF8)
HINT: Use the same encoding as in the template database, or use template0 as
template.
>
> Regards,
>
> Kern
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g/docs/8.3/interactive/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION
Long term, change the queries :)
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ted is trying to use SQL_ASCII
with a non-C locale, which is dangerous, and always has been. If you've
been putting non-UTF8 data into a database that could be running under a
UTF8-dependent locale, I'm surprised you haven't noticed problems already.'
>
> Thanks for all the responses,
>
> Best regards,
>
> Kern
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
general mailing list archive at Nabble.com.
What are you transferring to/from?
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ZONE - '6'::INTERVAL)))::BIGINT
> ELSE '' END from radacct where AcctSessionId = '57fc9e4821466d86';
> ERROR: invalid input syntax for integer: ""
>
> In the else case, this fallback return value comes into PostgreSQL as
> just
> an empty stri
acts
> and data on a daily basis. The migration would be done manually.
>
> Thank you for your help!
>
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to dump rows that it shouldn't. I bet a VACUUM FULL would
> clean this up, but I have a live problem here. If I eradicate it, who knows
> when we'll see it again...
>
> --- On Wed, 12/9/09, Craig Ringer wrote:
>
>
One thing that comes to mind is to restore the dump fil
usands
of partitions."
From here:
http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html
You are not showing how you are calling the DROP and SELECT statements but I
thinking it is being done in a way that the SELECT statement still thinks the
dropped table exists. For more information see:
http://www.postgresql.org/docs/8.4/interactive/mvcc.html
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;
>
> You are not showing how you are calling the DROP and SELECT statements but
> I thinking it is being done in a way that the SELECT statement still thinks
> the dropped table exists. For more information see:
>
> http://www.postgresql.org/docs/8.4/interactive/mvcc.html
>
&
estore, with out the error
hopefully. Looking at the data restored in the file might give you a clue to
what is going on. Just one step in the process of resolving the problem.
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
A query
against pg_stat_activity might be useful.
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with the
interaction
of database encoding and locale settings.
Then I would post here again to ask about your preferred db encoding and if it
is possible with the locale information from the first step.
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rset.html
You may find you have not solved all your problems.
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
101 - 200 of 1095 matches
Mail list logo