now. If you decide to use the SET
method you may also want to look at the error configuration settings also.
Should there be a mistake in the SQL statement it is possible the password
would
show up in an ERROR message.
>
> Best Regards,
> Murat KOC
--
Adrian Klaver
adrian.kla...@gm
you are using plain text then you will need to supply the above to the
pg_dump command.
>
> Thank you very much in advance,
> Daniel Migowski
>
d
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
cular database.
>
> I would also like a function that does a CREATE DATABASE on restore
> automatically, but I don't want to wish for too much here.
>
> Thank you very much in advance,
> Daniel Migowski
>
> IKOffice
> UNTERNEHMENSSOFTWARE
>
> IKOffice Gmb
On Tuesday, December 20, 2011 7:02:13 am Alban Hertroys wrote:
> On 20 December 2011 15:35, Adrian Klaver wrote:
> > To elaborate on my previous answer, search_path is in postgresql.conf
> > because it is tied to the database cluster not a particular database.
>
> Not necess
fer some
> function to escape text to be used by COPY?
>
> Josh
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
allation to create template1 with et_EE.UTF-8
> collation and character type ?
>
> Andrus.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday, December 21, 2011 3:16:42 pm Josh Kupershmidt wrote:
> On Tue, Dec 20, 2011 at 7:47 PM, Adrian Klaver
wrote:
> > As far as I know you did not get an answer, which is not the same as
> > there being no answer:) I think you will find that the escaping is
> > ha
uster being created with a collation of en_US.UTF-8 when the locale is
supposed to have been set to et_EE.UTF-8?
First are you sure that dpkg-reconfigure locales is actually resetting the
locale?
Second when you connect to the cluster with psql what does \l show for encoding
and col
) is not compatible with
> LANG (et_EE.UTF-8). Disabling it.
>
Actually the interesting part would be what locale and locale -a show after
the above:)?
>
> Andrus.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>
>
> best regards,
> Wojciech
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Fetch-from-refcursor-and-transacti
> ons-tp5097158p5097158.html Sent from the PostgreSQL - general mailing list
> archive at Nabble.com.
--
A
data directory "/var/postgres/data"
>
> Any idea what could be wrong here?
Do you have more than one device mounted and if so are you sure you are working
on the right one?
>
> Thanks, Clemems
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general
lhost' port='5495' user='gls' password=''
> dbname='test_tool' ";
> // $dbh=pg_connect($options);
> if (!$dbh) {
> die("Error in connection: " . pg_last_error($dbh));
> print_r($dbh);
> }
>
> else
> {
> echo &qu
> LC_IDENTIFICATION="et_EE.UTF-8"
> LC_ALL=
>
> > and locale -a show after the above:)?
>
> locale -a
> C
> en_US.utf8
> et_EE.utf8
> POSIX
Would seem to be one of two things:
1) The initdb is being done before the locale is changed.
or
2)
gt; Thank you.
> How to re-configure Postresql db cluster so that uses Debian default system
> locale?
See Peters answer.
>
> Andrus.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/mailman/listinfo/pgrouting-users
>
>
> This message was sent using IMP, the Internet Messaging Program.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On Saturday, December 24, 2011 4:54:04 am Shankar Palaniappan wrote:
> On Dec 23, 7:51 pm, adrian.kla...@gmail.com (Adrian Klaver) wrote:
> > On Friday, December 23, 2011 1:32:49 am Shankar Palaniappan wrote:
> > > Hi John,
> > >
> > > Thanks for your respons
yte-sequence-for-
> encoding/
>
> Above link shows the above encoding schemes is in utf16 format but
> postgresql-8.4 doesn't support it.
> Is there any way to store data in different encoding in a utf-8 database.
Use iconv or recode to convert the UTF16 to UTF8 first.
>
> Ha
changing the value for listen_addresses?
2) Have you looked at the pg_hba.conf file to see if it allows remote
connections?
http://www.postgresql.org/docs/9.0/interactive/auth-pg-hba-conf.html
Jay
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql
setting?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/27/2011 11:39 AM, Jacques Lamothe wrote:
Yes I did
More guesses.
Looks like you may be running on Amazon AWS?
If so, did you change the AWS firewall to allow port 5436?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
. You need account
access for that though, so you may have to talk with the admin.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rectly.
So how are the sequences being tied to the tables? In your previous post the
table definitions did not show a SERIAL type or a default of nextval().
>
>
> Thanks.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday, December 28, 2011 7:18:01 am Greg Donald wrote:
> On Wed, Dec 28, 2011 at 9:07 AM, Adrian Klaver
wrote:
> > So how are the sequences being tied to the tables? In your previous post
> > the table definitions did not show a SERIAL type or a default of
> > n
On Wednesday, December 28, 2011 7:51:24 am Greg Donald wrote:
> On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver
wrote:
> > Wonder if it is related to this:
> > http://archives.postgresql.org/pgsql-bugs/2011-11/msg00098.php
>
> None of my sequences are named 'new
On Wednesday, December 28, 2011 8:03:34 am Greg Donald wrote:
> On Wed, Dec 28, 2011 at 9:30 AM, Adrian Klaver
wrote:
> > Might want to file bug report:
> > http://www.postgresql.org/support/submitbug/
>
> Can't, not at the moment anyway.
>
> > psql --v
On Wed, Dec 28, 2011 at 8:38 AM, Merlin Moncure wrote:
> On Wed, Dec 28, 2011 at 10:20 AM, Adrian Klaver
> wrote:
>
> >
> > I was thinking of the more generic case. The problem with 'new' in the
> above bug
> > is that it is a reserved word and th
t restore problems are occurring.
What is the pg_dump command, with options, you are using?
>
> > It's just reporting what it finds in the database.
>
> Well, not in my case. In my database my sequences do not contains
> these incorrect '1' values I s
t, it would nice to nip it in the bud sooner
rather than later.
merlin
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/29/2011 08:13 AM, Greg Donald wrote:
On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaver wrote:
What is the pg_dump command, with options, you are using?
My backup shell script contains:
/usr/bin/pg_dump cp | bzip2> $FILE
One possible issue that I see is the lack of explicit opti
primary keys on several large tables do not get created. I have read all
> the migration notes and do not see anything specific other than a pg_dump
> restore is required. Any clues for me?
Was there data already in the 9.1 database?
Post some of the error messages.
>
> Thanks,
quot;
My suspicion is that there is already data in the tables of the 9.1 server from
previous restore attempts.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
erstanding what you want, but why not:
select clock_timestamp()::text;
It gives you the format you want.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lain text dump data to see if the value is indeed
duplicated?
2) What is data type of user_id?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dless of the current
> locale and language settings?
I don't know.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(sql,mdy) resulted in:
test(5432)postgres=#select clock_timestamp()::text;
clock_timestamp
12/30/2011 08:55:48.554618 PST
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
ill try pg_dump --inserts. It is a 17G file with copy statements so...
> this should be interesting. And take a long time.
Might want to try just dumping one table to make it a little easier.
>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-gener
nd 'decimal' was the correct value but it's not
> an option in the pgAdmin3 GUI.
>
> Any tips and or advice?
My guess is it is listed as numeric which is equivalent to decimal:
http://www.postgresql.org/docs/9.1/interactive/datatype-numeric.html
--
Adr
.
Using psql do a \l at the prompt. That will show what encoding the
database was setup with.
Hagen Finley
Boulder, CO
Thanks,
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
rver_encoding;
>
>
>
> And it looks like UTF8 doesnt include the German characters I seek. Can
> someone explain how I can switch to -0FFF which looks like the Basic
> Multilingual Plane Unicode which does include the characters I want?
It should.
>
>
>
tanding you correctly?
So now we have established where it is going to. Now to find out where it is
coming from. You said the server is running on Centos and that it was
presumably
set up for a German keyboard.
From a terminal in Centos what do the below show?
locale
locale -a
>
> Hag
TE TABLE
test(5432)aklaver=>insert into x values('ä,ß,ö');
INSERT 0 1
test(5432)aklaver=>SELECT * from x ;
a
---
ä,ß,ö
(1 row)
What happens when you do the above on your machine?
>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-ge
into x values('ä,ß,ö');
SELECT * from x ;
If so can you show the result?
Also maybe tail the log file to see if anything show up there?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
nt_encoding is set to in postgresql.conf and whether
that setting is uncommented?
Is the PGCLIENTENCODING environment variable set?
So what happens when you get the beep, is the character not allowed at all or
is
changed?
Is there anything in the server logs?
--
Adrian Klaver
adrian.kla...@gmail.com
--
-o -c
> config_file="/etc/postgresql/9.0/main/postgresql.conf" : ... failed!
> failed!
This is more of the same as above. For now lets concentrate on the original
install.
>
>
> so what can i do to extract the data of that tree and feed it into the
> 9.1 tree?
Get t
On Wednesday, January 04, 2012 9:46:42 am you wrote:
> On Wed, Jan 04, 2012 at 07:41:32AM -0800, Adrian Klaver wrote:
> Hello!
>
> > Define scrambled backup.
I am CCing list so more eyes can see this.
>
> well disks on both side had block loss, without me noticing
On Wednesday, January 04, 2012 11:42:01 pm Bruno Boettcher wrote:
> On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote:
> Hello!
>
>
> ok, got it, from your lines i saw that the binaries of the server were
> removed
> so i copied them over from the othe
ot;
anyway, so it should be ok if this column was left empty!
What can I do in my COPY command to circumvent this?
http://www.postgresql.org/docs/9.0/interactive/sql-copy.html
Search for
NULL
Thanks.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgs
On 01/06/2012 03:42 PM, Phoenix Kiula wrote:
On Fri, Jan 6, 2012 at 6:20 PM, Adrian Klaver wrote:
http://www.postgresql.org/docs/9.0/interactive/sql-copy.html
Search for
NULL
Thanks Adrian.
Without examples, it's hard to predict syntax. If the value after a
pipe is missing altogeth
On Friday, January 06, 2012 4:16:09 pm Phoenix Kiula wrote:
> On Fri, Jan 6, 2012 at 6:54 PM, Adrian Klaver wrote:
> > Try:
> > copy vl from 'data.txt' WITH CSV DELIMITER '|';
>
> Doesn't work. Can't see what the different in CSV is from a
On Monday, January 09, 2012 11:16:46 am akp geek wrote:
> I am using pg_dump to back up each schema in the database and there 6
> schemas in the database.
Do you have replication set up and if so are running the above against the
master or the standby?
>
> thanks
>
--
te query:
> ERROR: syntax error at or near "EXTENSION"
> LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL
> procedural languag...
>^
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on of Postgres, or perhaps a misconfiguration of
> our installation? What would you suggest to improve performance here? We
> currently don't have administration rights for the database or login
> rights for the server machine (Linux), but I think we'll need to take
> car
On 01/11/2012 11:45 AM, Kirill Müller wrote:
Adrian,
On 01/11/2012 04:32 PM, Adrian Klaver wrote:
Would seem that they both have the same issue, namely pulling over the
table
names and the meta data is resource intensive.
The problem is that the slow part is the "connect", j
s that are
matching a 'trust' rule.
>
> Any help will be really appreciate.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
elow:
http://www.postgresql.org/docs/9.0/interactive/sql-createsequence.html
http://www.postgresql.org/docs/9.0/interactive/sql-altersequence.html
Pretty sure the dependency is tracked in the pg_depend system catalog, just not
sure how to pull it out.
>
> Andrew
--
Adrian Klaver
adrian.kla..
. .pgpass only comes into play when the connection calls
for password authentication. If the pg_hba file has rules that allow
connections without passwords they will occur with or without the
presence of a .pgpass file.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing
e you downloading the source code or one of the binary packages?
If the source code then it contains the dev files for itself. You may need to
download dev packages for libraries it links against i.e readline, ssl,
Python,etc. This depends on the compile options you choose.
> Thanks
--
Adri
formation you need?
>
> Regards
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a/Perth
Australia/West
Etc/GMT-8
Hongkong
PRC
ROC
Singapore
>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1)
>
> Would give the exact timestamp at those time zone.
Meant to add to my previous post.
If you want to use a fixed interval then the above can simplified to:
select current_timestamp at time zone interval '+8 hours'
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent v
atalog.
test=> SELECT * from pg_type where typname='test';
I am not showing the output because it does not display well.
For more information on what is being returned take a look at:
http://www.postgresql.org/docs/9.0/interactive/catalog-pg-type.html
Regards
--
Adrian Klav
$$
global x
x = x.strip() # ok now
return x
$$ LANGUAGE plpythonu;
But it is advisable not to rely on this implementation detail of PL/Python. It
is better to treat the function parameters as read-only.
"
>
> Kind regards,
> Jeroen
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
exceeds certain limits. This does not
apply to all data types.
Better description here:
http://www.postgresql.org/docs/9.0/static/storage-toast.html
Thanks
H.F.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
is covered by this:
http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-COMMENTS
"A comment is removed from the input stream before further syntax analysis and
is effectively replaced by whitespace."
>
> Best regards,
> Ralph
--
Adrian Klaver
adrian.kla...@g
h anything so
> far to shed some light on this. Any help someone could provide on how to
> figure out where this substantial amount of extra disk space is being used
> would be greatly appreciated!
>
> Thanks!
>
> Dan
> --
> Syzygy Research & Technology
> Box 83, Legal, AB T0G 1L0 Canada
> Phone: 780-961-2213
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
27;;
> ERROR: syntax error at or near "all"
> LINE 1: set log_statement = all;
>
>
> cheers,
> Jose
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/interactive/functions-admin.html
>
> Dan
> --
> Syzygy Research & Technology
> Box 83, Legal, AB T0G 1L0 Canada
> Phone: 780-961-2213
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ently?
>
> The performance is currently unacceptable when changing the from to only
> join to one row makes
I guess the primary question here is, what are you trying to achieve?
Do want a particular row to supply the values to the target table i.e the row
with the most timestamp?
What is the query
On Monday, January 23, 2012 7:32:35 am Sim Zacks wrote:
> On 01/23/2012 05:13 PM, Adrian Klaver wrote:
> > I guess the primary question here is, what are you trying to achieve?
> > Do want a particular row to supply the values to the target table i.e the
> > row with the mos
On Monday, January 23, 2012 7:32:35 am Sim Zacks wrote:
> On 01/23/2012 05:13 PM, Adrian Klaver wrote:
>
> When I throw in code to make the select only return the correct rows
> The select statement takes 9 secs by itself:
> select a.partid,a.deliverywks
> from poparts a
n startup?
>
> Any thoughts?
>
> David J.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Monday, January 23, 2012 5:00:17 pm David Johnston wrote:
> On Jan 23, 2012, at 19:38, Adrian Klaver wrote:
> > On Monday, January 23, 2012 4:24:50 pm David Johnston wrote:
> >> Immediately upon starting the server I get an "incomplete startup
> >> packet"
On Monday, January 23, 2012 10:11:00 pm Sim Zacks wrote:
> On 01/23/2012 07:10 PM, Adrian Klaver wrote:
> > On Monday, January 23, 2012 7:32:35 am Sim Zacks wrote:
> >> On 01/23/2012 05:13 PM, Adrian Klaver wrote:
> >>
> >>
> >> When I throw in co
ate_part
Its not the extract part but the at time zone part see:
http://www.postgresql.org/docs/9.0/interactive/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
epoch from now()
> at time zone 'UTC') but clearly it doesn't work.
> So what options do I have?
Isn't extract(epoch from now()) getting what you want?
>
> Best regards,
>
> depesz
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday, January 25, 2012 7:44:44 am hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 07:37:44AM -0800, Adrian Klaver wrote:
> > Its not the extract part but the at time zone part see:
> >
> > http://www.postgresql.org/docs/9.0/interactive/functions-datetim
On Wednesday, January 25, 2012 7:48:34 am hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 07:44:14AM -0800, Adrian Klaver wrote:
> > > I thought that this is what I will achieve with extract(epoch from
> > > now() at time zone 'UTC') but clearly it doesn
On Wednesday, January 25, 2012 8:08:37 am hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 08:06:42AM -0800, Adrian Klaver wrote:
> > And therein lies the problem:) Per Toms comment, extract sees these
> > timestamps without timezones and assumes they are local time and r
On Wednesday, January 25, 2012 8:30:17 am hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 08:22:26AM -0800, Adrian Klaver wrote:
> > The issue seems to be the definition of same arguments. Since epoch is
> > anchored at 1970-01-01 00:00:00 UTC the timestamp passed to extr
On 01/25/2012 08:57 AM, hubert depesz lubaczewski wrote:
On Wed, Jan 25, 2012 at 08:54:44AM -0800, Adrian Klaver wrote:
Personally, I think that extract(epoch from timestamp) should assume
that the timestamp is UTC.
What if it isn't?
then you can always correct it with "at time
On Wednesday, January 25, 2012 2:46:39 pm hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 02:07:40PM -0800, Adrian Klaver wrote:
> > Finally dawned on me. When you use 'at time zone' on a timestamp
> > with tz it strips the tz which then allows the value
usual i would discard the timezone datatype and alter the table to
> use integer instead, but this time i am wondering, since this datatype is
> present, there's surely a way to use it properly? but how?
>
> please enlighten me!
>
> ciao
> Bruno
--
Adrian Klaver
adrian.kla.
l.org/docs/9.0/interactive/functions-formatting.html
to_timestamp(double precision) timestamp with time zoneconvert Unix
epoch to time stamp to_timestamp(1284352323)
So something like the below in your query should work:
to_timestamp(int_returned_from_php)
>
> ciao
> Br
umentinfo is.
>
> neos=> \dp agenzia.documents
>Access privileges
> Schema | Name| Type | Access privileges | Column access
> privileges
> -+---+---+--+-
> - agenzia | documents | table | neos=arwdDxt/neos +|
>
> | |
mp: dumping contents of table x3
...
What could be wrong?
Same pg_dump call on the same host, but for different database dumps just
schema!?
Best regards,
depesz
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On 01/27/2012 03:05 PM, hubert depesz lubaczewski wrote:
On Fri, Jan 27, 2012 at 03:00:24PM -0800, Adrian Klaver wrote:
On 01/27/2012 02:19 PM, hubert depesz lubaczewski wrote:
hiu
I have weird situation.
pg 9.1.2, compilet by our own script from source, on 10+ machines.
on fours machines
On Saturday, January 28, 2012 1:43:43 am Bruno Boettcher wrote:
> On Fri, Jan 27, 2012 at 08:17:37AM -0800, Adrian Klaver wrote:
> > Did some digging. php-mktime returns the Unix epoch (seconds since
> > January 1 1970 00:00:00 GMT)
>
> indeed, didn't get it that pos
On Saturday, January 28, 2012 1:29:22 am hubert depesz lubaczewski wrote:
> On Fri, Jan 27, 2012 at 03:11:32PM -0800, Adrian Klaver wrote:
> > Not sure that it makes a difference, but on the chance it does, what
> > are the options and are they the same for all machines?
&
imit 5;
ts_fld2 | ?column?
+--
2011-03-25 14:16:27-07 | 310 days 01:16:04.881631
2011-03-25 14:15:13-07 | 310 days 01:17:18.881631
2010-05-20 13:13:54-07 | 619 days 02:18:37.881631
2010-05-20 12:13:28-07 | 619 days 03:19:03.881631
2010-05-20 10:13:43-07 | 619 da
xtract(epoch from '2011-03-25 14:15:25-07'::timestamptz)-extract(epoch
from ts_fld2)) limit 5;
ts_fld2 | abs
+--
2011-03-25 14:15:13-07 | 12
2011-03-25 14:16:27-07 | 62
2010-05-20 13:13:54-07 | 26701291
2010-05-20 12:13:28-07 | 267
kend) The Pass-Through offers you the
ability to construct server specific queries that get passed to the server
directly.
>
> gvim
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
avior. What is happening is covered by my second rule of life 'Easy
is difficult'. In this case it is the desire for a built in 'packaging' system
that makes extending Postgres easier for the end user. To get that leads to
more complexity in the backend and a new learning curve f
On Monday, January 30, 2012 7:39:13 am hubert depesz lubaczewski wrote:
> On Mon, Jan 30, 2012 at 07:34:49AM -0800, Adrian Klaver wrote:
> > Breaks certain cases when using pg_dump -s. Some of what you highlight
> > above is designed behavior. What is happening is covered by my sec
gards,
depesz
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 01/30/2012 09:45 AM, hubert depesz lubaczewski wrote:
On Mon, Jan 30, 2012 at 09:43:46AM -0800, Adrian Klaver wrote:
On 01/30/2012 09:23 AM, hubert depesz lubaczewski wrote:
I think I explained it in previous mails, and if not - sorry, but
I clearly can't explain good enough - the
On Monday, January 30, 2012 8:25:54 am hubert depesz lubaczewski wrote:
> On Mon, Jan 30, 2012 at 08:20:15AM -0800, Adrian Klaver wrote:
> > I am not sure I understand crippled. There is a bug that you acknowledge
> > has been dealt with. The rest is documented behavior ha
On 01/30/2012 09:53 AM, hubert depesz lubaczewski wrote:
On Mon, Jan 30, 2012 at 09:51:58AM -0800, Adrian Klaver wrote:
On 01/30/2012 09:45 AM, hubert depesz lubaczewski wrote:
On Mon, Jan 30, 2012 at 09:43:46AM -0800, Adrian Klaver wrote:
On 01/30/2012 09:23 AM, hubert depesz lubaczewski
OMMIT
DROP clause?
3) How are the stored procedures being called?
>
> Andy Nykolyn
> Northrop Grumman
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lled?
> They are usually called from a java client but I have also seen this issue
> when called from a PgAdmin session screen.
Is there a database pooler in the mix?
Are there any other errors in the logs at the same time that might pertain?
>
> > Andy Nykolyn
> > Northrop
ns are for the
extension mechanism. There is also the issue of backward compatibility
for those people that are using configuration tables in their extensions
and would like to maintain that separation. I could see adding another
function that is similar and would be used to identify strictly
1001 - 1100 of 1195 matches
Mail list logo